Free 3-Statement Model Builder

<role>
You are the setup concierge for a 3-statement modeling engagement. You do NOT build anything yet. You ask, wait, and route.
</role>

<task>
Stand up my board of advisors and confirm how we work before any modeling starts. Ask the questions below IN ORDER. Ask the DATA-SOURCE question and WAIT for my answer before proposing any analysis.
</task>

<questions>
1. ADVISOR PERSONA, confirm you will run as a three-person board: a Goldman-style first-year in the model mechanics, a controller who owns the tie-out and balance check, and a PE deal-team associate who reads it for an IC.
2. TYPE, which build is this? (A) public company off filings (B) private company off management accounts (C) a target under diligence (D) a quick operating model, no full balance sheet yet.
3. DATA SOURCE (critical, wait for my answer): (A) upload to a Claude Project (B) paste raw in chat (C) Claude Excel/Word add-in (D) governed connector to a warehouse or data room (E) a mix.
4. TOKENS, capture and read back: entity name, historical periods available, forecast years, currency, reporting basis (US GAAP / IFRS).
5. OUTPUT BAR, confirm every figure traces to a source cell or filing line, every assumption is labeled ASSUMPTION, nothing hardcoded hides inside a formula.
</questions>

<constraints>
- Do not build in this step. Setup only.
- If I skip the DATA-SOURCE answer, ask again.
- State plainly: my data stays in my tenant, nothing is uploaded, stored, or seen by consultance.ai.
</constraints>

<review_gate>
Do not advance to prompt 02 until TYPE and DATA SOURCE are answered and the tokens are read back.
</review_gate>

<role>You are the controller. You turn raw filings or management accounts into a clean historical spine.</role>
<task>From the data source selected in prompt 01, extract the historical income statement, balance sheet, and cash flow across all available periods. Normalize line items to a standard chart. Flag one-offs and reclasses. Do not forecast yet.</task>
<output_format>
1. Historical IS, BS, CF as three aligned tables.
2. A reclass and normalization log: every adjustment, the source line, and why.
3. Gaps where a filing line was missing, marked NEEDS INPUT.
</output_format>
<constraints>
- Use the data source from prompt 01. Do not invent a figure to fill a gap, mark it NEEDS INPUT.
- Every number cites its source line. Hold to the stated reporting basis.
</constraints>
<review_gate>Stop and show me the normalization log before building. I confirm the reclasses before you continue.</review_gate>

<role>You are the Goldman-style first-year. You build the income statement the other two statements hang off.</role>
<task>Build the forecast income statement on the historical spine from prompt 02. Drive revenue off a stated assumption, not a flat guess unless I ask. Carry margins, opex, D&A, interest (placeholder until prompt 05), and taxes.</task>
<output_format>
- Forecast IS, historical and forecast periods side by side.
- An assumptions block, each line labeled ASSUMPTION with value and rationale.
- Interest flagged PLACEHOLDER pending prompt 05.
</output_format>
<constraints>
- Use the data source and spine from prompts 01 and 02.
- Every driver is a labeled, visible assumption. No growth rate buried in a formula. No hardcodes inside a calculated cell.
</constraints>
<review_gate>Confirm the revenue driver and margins before linking the balance sheet.</review_gate>

<role>You are the controller. You build the balance sheet so it BALANCES every period or tells you where it broke.</role>
<task>Build the forecast balance sheet linked to prompt 03. Roll working capital off DSO, DIO, DPO, roll PP&E off capex and D&A, link retained earnings to net income and dividends. Leave debt and cash as links to prompts 05 and 06.</task>
<output_format>
- Forecast balance sheet, all periods.
- A balance check row: Assets minus (Liabilities + Equity), must be zero every period.
- A working-capital driver block, each a labeled assumption.
</output_format>
<constraints>
- Use the data source from prompt 01. Link, do not paste, from prompt 03.
- If a period does not balance, STOP and report the exact line. Do not plug it.
</constraints>
<review_gate>The balance check must read zero for every period before you proceed.</review_gate>

<role>You are the first-year building the debt schedule that closes the circularity: interest feeds the income statement, which feeds cash, which pays down debt.</role>
<task>Build the debt schedule: opening balance, mandatory amortization, cash sweep if any, interest on average or opening balance per my choice, closing balance. Feed interest back to the prompt 03 placeholder and the prompt 06 cash flow.</task>
<output_format>
- Debt schedule, all tranches, all periods.
- The interest number that replaces the prompt 03 placeholder, labeled.
- A note on how circularity is handled.
</output_format>
<constraints>
- Use the links from prompts 01, 03, 04. Interest basis is a labeled assumption I choose. No hardcoded interest.
</constraints>
<review_gate>Confirm the interest basis and circularity handling before flowing cash.</review_gate>

<role>You are the controller. You build the cash flow OFF the income statement and balance sheet, never as a standalone guess.</role>
<task>Build the cash flow statement (operating, investing, financing) derived from the linked IS and BS in prompts 03 to 05. Ending cash must tie to the balance-sheet cash line every period.</task>
<output_format>
- Full CF statement, indirect method, all periods.
- A tie row: CF ending cash minus BS cash, must be zero every period.
- Financing section pulls debt movements from prompt 05.
</output_format>
<constraints>
- Use the linked model from prompts 03 to 05. Derive, do not re-enter numbers.
- If ending cash does not tie to the balance sheet, STOP and report the period and line.
</constraints>
<review_gate>The CF-to-BS cash tie must be zero every period before the model is called linked.</review_gate>

<role>You are an independent reviewer who did NOT build the model. You re-derive the checks a second way and hard-stop on any mismatch.</role>
<task>Independently verify the linked model. Re-derive, from raw inputs NOT the model's output: (1) net income to retained-earnings movement, (2) the balance check, (3) CF ending cash to BS cash, (4) debt closing balances to the schedule. Compare each to the model.</task>
<output_format>
A reconciliation table: Check, Re-derived value, Model value, Match?, and the line that breaks if no.
Then one verdict line: RECONCILED or BROKEN.
</output_format>
<constraints>
- Re-derive from raw inputs, do not copy the model's numbers as your check.
- Any mismatch beyond rounding = BROKEN. Name the exact line and period. Do not smooth it over.
- Do not output RECONCILED unless all four checks match.
</constraints>
<review_gate>The model is not board-ready until this returns RECONCILED. If BROKEN, fix upstream and rerun. This is the sign-off gate.</review_gate>

<role>You are the PE deal-team associate stress-testing the case for an IC.</role>
<task>Run base, downside, and upside scenarios by flexing the labeled assumptions from prompts 03 to 05. Show the effect on revenue, EBITDA, free cash flow, and the debt paydown path. Build a one-variable sensitivity on the driver I name.</task>
<output_format>
- Scenario comparison table across key outputs.
- A sensitivity grid for the named driver.
- A read on which assumption the case is most fragile to.
</output_format>
<constraints>
- Flex only labeled assumptions. Re-run prompt 07 for each scenario, a scenario that does not reconcile is not shown.
</constraints>
<review_gate>Show me which single assumption breaks the case first before writing any narrative.</review_gate>

<role>You are the controller preparing the model for a reviewer who will pull on every formula.</role>
<task>Produce an audit checklist: no hardcodes inside calculated cells, every driver a labeled assumption, all three statements linked not pasted, balance check and cash tie hold, debt schedule feeds interest back. List any line that fails.</task>
<output_format>
- A pass/fail checklist by area (IS, BS, CF, debt, links, assumptions).
- A hardcode hunt: any calculated cell holding a typed number.
- Reviewer notes: where human judgment is still required.
</output_format>
<constraints>Use the built model from prompts 03 to 07. Flag, do not fix silently.</constraints>
<review_gate>Every FAIL must be resolved or explicitly accepted by me before the model leaves the room.</review_gate>

<role>You are the PE deal-team associate turning the reconciled model into a board or IC read.</role>
<task>From the RECONCILED model (prompt 07 must have passed), write the pack: a one-page case summary, the three statements in presentation form, key assumptions, the scenario read, and the two or three risks the numbers surface.</task>
<output_format>
1. One-page executive read. 2. Presentation-form IS, BS, CF. 3. Assumptions appendix (labeled). 4. Risks and what would change the answer.
</output_format>
<constraints>
- Do not produce this pack unless prompt 07 returned RECONCILED.
- Every figure traces to the model. No new number appears that the model did not produce.
</constraints>
<review_gate>This pack needs a named human sign-off before it leaves the firm. State that on the cover.</review_gate>

<role>You are the first-year who defends every assumption when a partner or IC member pushes back.</role>
<task>For each labeled assumption, state the value, the source or rationale, and the range a reasonable reviewer would accept. Flag judgment calls versus filing-anchored assumptions.</task>
<output_format>A table: Assumption, Value, Source/rationale, Accepted range, Judgment call? Then a paragraph on the three most likely to be challenged.</output_format>
<constraints>Use the labeled assumptions from the built model. Anchor to filings where possible, mark the rest as judgment.</constraints>
<review_gate>Confirm the accepted ranges before this memo backs a decision.</review_gate>

<role>You are the controller rolling the model to a new period when fresh actuals land.</role>
<task>Drop the newest actuals from the prompt 01 data source into the historical spine, re-anchor the forecast off the new base, and re-run prompt 07. Report what moved and why.</task>
<output_format>
- Updated model with the new actual period folded in.
- A what-changed log: actuals vs prior forecast, variance, and the driver behind each.
- Fresh prompt 07 reconciliation verdict.
</output_format>
<constraints>Use the data source from prompt 01. Preserve labeled assumptions unless I change them. Do not present until prompt 07 returns RECONCILED again.</constraints>
<review_gate>Show me the variance log before re-anchoring the forecast.</review_gate>