Skip to content
Next drop: Friday, October 9

Block · BLQ-014 · v1.0

Scenarios and sensitivity

How much profit changes under management's scenarios and with ±10% in price, volume, variable cost and fixed costs, ranked from largest to smallest, with the margin of safety and a bridge for each scenario.

PremiumGlobal standardStandard 2026.10Controls 5/5DOCXXLSXPPTX
Meridian Coffee Co. (Demo) · Scenarios and sensitivity · October 2026BLQ-014 · Block · 16:9
FICTITIOUS DATA · USD thousands · RS2026.10Repporti checks 5/5 · BLQ-014 v1.0
FICTITIOUS DATA · Meridian Coffee Co. (Demo)Checks 5/5
BLQ-014 · Scenarios and sensitivity · October 2026 · illustrative example with fictitious data
  • One- or two-page Word (.docx) section with the table, the tornado and the bridge
  • Excel (.xlsx) with Base, Assumptions, Model with live formulas, Scenarios, Sensitivity and Control
  • tornado.json ready for the tornado chart
  • Optional PowerPoint (.pptx) slide with the tornado and the scenarios

The report's «what if» section: a table with the downside, base and upside scenarios management approved (with their source), a tornado with each assumption's sensitivity to ±10% ranked by impact, and two margin-of-safety figures: how far volume or price can fall before profit reaches zero.

A script builds the model from your base case line by line (what share of each cost moves with volume), checks that subtotals add up and that a «downside» scenario does not improve on the base, and explains each scenario with a bridge: the effect of each assumption plus the interaction, adding up exactly to the difference.

The prompt does not invent scenarios or probabilities: it uses yours with their source or, if you ask, proposes one labelled «Preparer's proposal» and waits for your approval. The model is linear and the note says so.

What it includes

5 sections, in this order

  1. 01Action title with the assumption that moves profit most
  2. 02Scenario table: assumptions, revenue, contribution margin, fixed costs, profit and source
  3. 03Tornado of sensitivity to ±10%, from largest to smallest
  4. 04Margin of safety in volume and price
  5. 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

NOT VERIFIED — controls not executed by code. Review the Control sheet of the XLSX.

If a control fails, the AI stops, shows the difference and asks how to proceed. It never forces the numbers to reconcile.

Prompt outline

What the prompt contains, block by block

  1. 0Before you paste your filesFixed487
  2. 1Role, audience and business context621
  3. 2Parameters664
  4. 3Repporti standard334
  5. 4Data contract863
  6. 5Questions first435
  7. 6Validation with a stop435
  8. 7Calculation by code363
  9. 7-bisNo-code modeFixed415
  10. 8Formulas720
  11. 9Structure1,135
  12. 10Writing without “AI slop” or inventions544
  13. 11Notation and accessibility485
  14. 12QA, traceability and seal745
The text is delivered when you copy, with your license. It is never on this page.≈ 28,402 characters + cuadre.py (796 lines)

Core available in: Spanish · English

Repporti Standard

It comes out adapted to your report profile

Compatible with every country and framework in the Standard: when you copy, it is composed with your profile (country, accounting framework, report language, currency, unit and year-end). Terminology, number format and statement names come from the Standard, not from the prompt.

See the Repporti Standard

How to use it

From the trial balance to the report in three steps

  1. 01Configure and copyCheck your report profile (country, framework, language, currency) and the period. The prompt is assembled in your browser.
  2. 02Paste into your AIOpen ChatGPT or Claude, attach your anonymized files and paste the prompt.
  3. 03Review and deliverReview the controls table and the seal. If something does not reconcile, the AI stops and asks.

Anonymize before pasting

  • Company name → an alias (“Client 07”); tax ID → “ID-XX”.
  • Customers, suppliers and employees → codes (C001, P001, E001). The mapping table stays on your computer.
  • Use an AI that does not train on your data: business plan, API or training turned off.

Repporti neither receives nor stores your files or your figures: the prompt is assembled in your browser and your files go straight to your AI.

Who it is for

Made for whoever delivers the report

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

Compatibility

Which AI it works with

LevelAI
With code executionChatGPT · ClaudeDesigned for plans with data analysis (ChatGPT) or code execution (Claude): cuadre.py runs inside the AI.
No-code modeCopilot · GeminiGenerates the Excel file with formulas and a Control sheet. The footer says “NOT VERIFIED” unless you run cuadre.py on your computer.

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

More from this area to combine

See the whole area