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
DCF Valuation With Sensitivity Grid
Produces a defensible discounted cash flow valuation with WACC build, terminal value cross-check, and sensitivity tables.
Read prompt
Month-End Close Checklist Builder
Generates a sequenced, owner-assigned month-end close checklist with cutoffs, dependencies, and review gates.
Read prompt
Variance Analysis Narrative Writer
Turns budget-versus-actual numbers into a crisp executive variance narrative with drivers, materiality, and actions.
Read prompt
Journal Entry Reviewer And Anomaly Flagger
Reviews journal entries for accuracy, GAAP treatment, and red flags before posting or audit sampling.
Read prompt