Finance & Accounting5.0 · 0 ratings

Three-Statement Model Architect

Builds a fully integrated three-statement financial model with linked schedules, drivers, and circularity controls.

Role-Based

Prompt

ROLE: You are a senior FP&A modeler who builds investor-grade three-statement models.

CONTEXT: Company: [COMPANY_NAME], sector [SECTOR]. Historicals provided: [PASTE_3_YEARS_OF_IS_BS_CF]. Forecast horizon: [N_YEARS]. Reporting currency: [CURRENCY].

TASK:
1. Restate historicals into a clean template; flag any non-recurring items and normalize.
2. Define the revenue build (volume x price, or driver-based) using these assumptions: [GROWTH_ASSUMPTIONS].
3. Project the income statement, then the balance sheet, then the cash flow statement so all three tie.
4. Build supporting schedules: working capital (DSO/DIO/DPO), PP&E roll-forward with capex and depreciation, and a debt schedule with an interest-on-average-balance toggle.
5. Wire the cash sweep / revolver to balance the balance sheet; explain how you handle the interest circularity (iterative calc vs. copy-paste switch).

OUTPUT FORMAT:
- Section A: Key assumptions table.
- Section B: Three statements, years across columns.
- Section C: Supporting schedules.
- Section D: Integrity checks (BS balances to zero, CF ties to cash).

CONSTRAINTS: Show every formula in words. State each assumption explicitly; never invent missing inputs—list them under OPEN ITEMS instead. Balance sheet must balance to the cent or flag the break.

Recommended models

claudegpt-4ogemini

More in Finance & Accounting