Intermediate
Three-statement model build plan (P&L, BS, CF) with checks
Outlines a clean three-statement model build with common integrity checks and best practices. Useful for analysts and consultants creating reliable models.
Create a three-statement financial model build plan for {company_name}.
Inputs:
- Historical financials: {historical_financials}
- Forecast drivers: {forecast_drivers}
- Debt and equity schedules: {capital_structure}
- Capex and depreciation assumptions: {capex_dep_assumptions}
- Working capital assumptions: {wc_assumptions}
Deliver:
1) Model architecture (inputs, calculations, outputs) and tab list.
2) Key schedules (revenue, COGS, opex, WC, capex, debt).
3) Integrity checks (balance sheet balancing, cash rollforward, circularity handling).
4) Output tables and scenario switch design.
Write it so a junior analyst could implement.Related Prompts
Advisory & Consulting
AdvancedDCF valuation model blueprint with assumptions checklist
Outlines a DCF model structure, key assumptions, and validation checks. Useful for valuation analysts producing defensible valuations for boards, investors, or disputes.
GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
28
Advisory & Consulting
AdvancedOperating model: unit economics to financial statements
Connects unit economics (volume, pricing, conversion) to full financial statements and cash. Useful for SaaS/e-commerce and growth-stage models.
GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
25
Advisory & Consulting
BeginnerRetail: Inventory Turnover by Category
Identifies the 'hero' and 'zero' products based on velocity.
GPT-4oGemini 1.5 Pro
0
0
19