Block · BLQ-014 · v1.0
Scenarios and sensitivity
Which assumptions move profit most.
Instructions for your AI; check sections, output files and controls before copying.
What it includes
5 sections, in this order
- 01Action title with the assumption that moves profit most
- 02Scenario table: assumptions, revenue, contribution margin, fixed costs, profit and source
- 03Tornado of sensitivity to ±10%, from largest to smallest
- 04Margin of safety in volume and price
- 05Downside scenario bridge and model note
Controls 5/5
What it checks before writing a single figure
C1Complete data: base-case revenue and costs, numeric figures, variable share between 0 and 100 and scenarios with unique names.
C2The base case ties: the reported subtotals (gross profit, EBITDA, operating profit, profit before tax and for the period) equal those computed from their lines.
C3Signs: revenue, costs and expenses in positive.
C4Coherent scenarios: each assumption between −50% and +50%; the downside does not improve the base case and the upside does not worsen it (N/A without scenarios).
C5Traceable figures: every figure in the text exists in calculo.json with the same rounding.
If the script ran
Repporti controls 5/5 · BLQ-014 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 paste your filesFixed487
- 1Role, audience and business context621
- 2Parameters664
- 3Repporti standard334
- 4Data contract863
- 5Questions first435
- 6Validation with a stop435
- 7Calculation by code363
- 7-bisNo-code modeFixed415
- 8Formulas720
- 9Structure1,135
- 10Writing without “AI slop” or inventions544
- 11Notation and accessibility485
- 12QA, traceability and seal745
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 block
What do I need for the base case?
The income statement for the base period (budget, forecast or last 12 months) line by line and, for each cost, what percentage moves with volume. If you do not know, the prompt assumes cost of sales is 100% variable and the rest fixed, and says so.
What if I have no approved scenarios?
The section comes out with the ±10% sensitivity only. If you ask for scenarios, the prompt proposes one with its rationale in the data, labelled «Preparer's proposal», and waits for your approval.
What is the interaction in the bridge?
It is the effect of moving several assumptions at once (for example, lower volume at a lower price). It is shown separately so the bridge ties exactly to the scenario's difference.
Profitability and costs