Skip to content

Report guide · REP-024 · v1.0

Fomalhaut · Break-even and contribution margin

Sales needed to break even.

PaidGlobal standardStandard 2026.10Controls 7/7MonthlyXLSXDOCXPPTX
Meridian Coffee Co. (Demo) · Break-even and contribution margin · October 2026REP-024 · p. 1/2
FICTITIOUS DATA · USD thousands · RS2026.10Prepared with Repporti
Meridian Coffee Co. (Demo) · Break-even and contribution margin · October 2026REP-024 · p. 2/2
FICTITIOUS DATA · USD thousands · RS2026.10Repporti checks 7/7 · REP-024 v1.0
FICTITIOUS DATA · Meridian Coffee Co. (Demo)Checks 7/7
01 / 02
REP-024 · Break-even and contribution margin · October 2026 · illustrative example with fictitious data
  • Word (.docx), 4 A4 pages, ready to export to PDF
  • Excel (.xlsx) with Data, editable Classification, Calculation, Sensitivity, Control and Charts sheets, with live formulas
  • Optional PowerPoint (.pptx) with 1 slide of revenue against break-even

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

What it includes

6 sections, in this order

  1. 01In 30 seconds: revenue against break-even and 4 cards (contribution margin, break-even point, margin of safety and operating leverage)
  2. 02Cost structure: fixed and variable against budget and prior year, with the classification used
  3. 03Each month's revenue against its break-even point (with 12 months of data)
  4. 04Levers: price, volume, variable cost and fixed cost sensitivity, ranked by effect
  5. 05Contribution by line and each line's share of break-even (if you attach margin by line)
  6. 06Decisions, assumptions, limitations, controls and glossary

Controls 7/7

What it checks before writing a single figure

  • C1Complete data: headers, numeric figures, no duplicate lines and valid units (cuadre.py).

  • C2Income statement subtotals reconcile: gross profit, EBITDA and operating profit with their lines (cuadre.py).

  • C3Consistent sign convention: costs and expenses with a single sign (cuadre.py).

  • C4Complete classification: 100% of operating costs and expenses is classified as fixed or variable (Control sheet = 0).

  • C5Break-even identity: contribution margin − fixed costs = operating profit per the income statement, in every scenario (Control sheet = 0).

  • C6Break-even × contribution margin (%) = fixed costs, and margin by line adds up to the total (Control sheet = 0).

  • C7Traceable figures: every figure in the Word file exists in calculo.json with the same rounding (cuadre.py verificar).

If the script ran

Repporti controls 7/7 · REP-024 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 paste your filesFixed688
  2. 1Role, audience and business context765
  3. 2Parameters683
  4. 3Repporti standard504
  5. 4Data contract1,243
  6. 5Questions first412
  7. 6Validation with a hard stop1,521
  8. 7Calculation by code329
  9. 7-bisNo-code modeFixed467
  10. 8Formulas1,282
  11. 9Structure1,382
  12. 10Writing without «AI slop» and without invention1,000
  13. 11Theme and notation1,231
  14. 12QA, traceability and seal1,156
The licensed prompt is provided when copied.≈ 34,883 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 / CFOAccountant / firm
Area
Profitability and costs
Frequency
Monthly
Industry
Retail and wholesale, Manufacturing, Services

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 report guide

What if I don't know which costs are fixed and which are variable?

The AI proposes a classification from the line names, marks it as an assumption and asks you to confirm before calculating. In the Excel file you change a percentage and everything recalculates.

Does it work for a business with several products or channels?

Yes. With margin by line it calculates each one's contribution and splits break-even by the current mix. If the mix changes, so does break-even, and the report says so.

Why doesn't a drop in volume change the break-even point?

Because break-even depends on fixed costs and the contribution margin percentage. Selling less only reduces the margin of safety and operating profit.

What if my AI cannot run code?

The prompt switches to no-code mode: it builds the Excel file with formulas and a Control sheet, and the Word footer says «NOT VERIFIED». You can run cuadre.py on your computer and get the seal later.