Skip to content

Chart · GRF-010 · v1.0

Sensitivity tornado chart

Assumptions ranked by financial impact.

PaidGlobal standardStandard 2026.10Controls 4/4XLSXDOCXPPTX
Meridian Coffee Co. (Demo) · Sensitivity tornado chart · October 2026GRF-010 · Chart · 16:9
FICTITIOUS DATA · USD thousands · RS2026.10Repporti checks 4/4 · GRF-010 v1.0
Meridian Coffee Co. (Demo) · Sensitivity tornado chart · October 2026GRF-010 · Chart · 16:9
FICTITIOUS DATA · USD thousands · RS2026.10Repporti checks 4/4 · GRF-010 v1.0
FICTITIOUS DATA · Meridian Coffee Co. (Demo)Checks 4/4
01 / 02
GRF-010 · Sensitivity tornado chart · October 2026 · illustrative example with fictitious data
  • Excel (.xlsx) with base, assumptions, ranges, metric at each end, Δ and Δ % in formulas, a native chart and a Control sheet
  • PNG (2×, 16:9) and SVG for Word or PowerPoint
  • Alt text (alt.txt) ready to paste

Instructions for your AI; check sections, output files and controls before copying.

What it includes

5 sections, in this order

  1. 01Action title: the assumption that moves the metric most, its range and the figure
  2. 02Vertical axis at the base case, labeled with its value
  3. 03One bar per assumption: the end that lowers the metric on the left and the one that raises it on the right
  4. 04At each end, Δ and Δ % with sign, and the assumption range
  5. 05Note with where the ranges come from, variable costs, source and seal

Controls 4/4

What it checks before writing a single figure

  • C1Complete data: recognized headers, numeric figures, no repeated assumptions or lines and valid units.

  • C2The base case ties: gross profit, operating profit, EBITDA, profit before tax and for the period with their lines.

  • C3Sign convention: costs and expenses with a single sign.

  • C4Figures in the title, subtitle, note and alt text traceable to calculo.json (base, ends, ranges and variable %).

If the script ran

Repporti controls 4/4 · GRF-010 v1.0 · RS2026.10 · {fecha} · fingerprint {hash}

If it did not run

UNVERIFIED: code not run. Review Control in Excel.

On failure, instructions require a stop and an explanation.

What the prompt contains, block by block

Prompt outline

  1. 0Before you pasteFixed309
  2. 1Role, audience and business context467
  3. 2Parameters337
  4. 3Repporti standard264
  5. 4Data contract684
  6. 5Questions first267
  7. 6Validation with a stop499
  8. 7Calculation and drawing by code470
  9. 7-bisNo-code modeFixed299
  10. 8Formulas356
  11. 9Chart structure461
  12. 10Title and texts336
  13. 11Notation and accessibility218
  14. 12QA, traceability and seal482
The licensed prompt is provided when copied.≈ 27,279 characters + cuadre.py (1,124 lines)

Core available in: Spanish · English

It comes out adapted to your report profile

Repporti Standard

Your profile sets country, framework, language, currency, scale and year-end.

See the Repporti Standard

How to use it

From the trial balance to the report in three steps

  1. 01Configure and copyCheck profile and period before copying.
  2. 02Paste into your AIPaste the prompt and attach anonymized files in your AI.
  3. 03Review and deliverCheck controls and seal before sharing.

Anonymize before pasting

  • Company → alias; tax identifier → ID-XX.
  • People → codes. Keep the mapping on your device.
  • Use business AI, API or disable training.

Files and figures go to your AI; Repporti does not receive them.

Made for whoever delivers the report

Who it is for

Finance manager / CFOFounder
Area
Profitability and costs
Frequency
Whenever you need it
Industry
All

Which AI it works with

Compatibility

LevelAI
With code executionChatGPT · ClaudeRequires file analysis and Python execution for cuadre.py.
No-code modeCopilot · GeminiExcel with Control sheet; UNVERIFIED until cuadre.py runs.

Questions

About this chart

How is it different from scenario analysis?

The tornado moves one assumption at a time and keeps everything else equal: it is for prioritizing. A scenario moves several at once; that is what BLQ-014 Scenarios and sensitivity is for.

Who defines the ranges?

You do: the prompt asks for them and the note says where they come from (history, market or plan). The AI does not invent them.

Can I use the impacts my model already calculated?

Yes. With the «direct» type you enter the Δ at each end and the chart draws it without recalculating.

Does it work for profit for the period or for cash?

Yes. For after-tax profit it asks you to confirm the effective tax rate; if you do not, it uses EBITDA or profit before tax.