Chart · GRF-010 · v1.0
Sensitivity tornado chart
Assumptions ranked by financial impact.
Instructions for your AI; check sections, output files and controls before copying.
What it includes
5 sections, in this order
- 01Action title: the assumption that moves the metric most, its range and the figure
- 02Vertical axis at the base case, labeled with its value
- 03One bar per assumption: the end that lowers the metric on the left and the one that raises it on the right
- 04At each end, Δ and Δ % with sign, and the assumption range
- 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.
What the prompt contains, block by block
Prompt outline
- 0Before you pasteFixed309
- 1Role, audience and business context467
- 2Parameters337
- 3Repporti standard264
- 4Data contract684
- 5Questions first267
- 6Validation with a stop499
- 7Calculation and drawing by code470
- 7-bisNo-code modeFixed299
- 8Formulas356
- 9Chart structure461
- 10Title and texts336
- 11Notation and accessibility218
- 12QA, traceability and seal482
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 StandardHow to use it
From the trial balance to the report in three steps
- 01Configure and copy
- 02Paste into your AI
- 03Review and deliver
Anonymize before pasting
- Company → alias; tax identifier → ID-XX.
- People → codes. Keep the mapping on your device.
- Use business AI, API or disable training.
Made for whoever delivers the report
Who it is for
- Area
- Profitability and costs
- Frequency
- Whenever you need it
- Industry
- All
Which AI it works with
Compatibility
| Level | AI | |
|---|---|---|
| With code execution | ChatGPT · Claude | Requires file analysis and Python execution for cuadre.py. |
| No-code mode | Copilot · Gemini | Excel 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.
Profitability and costs