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
AdvancedBusiness Combination: Purchase Price Allocation (PPA)
Drafts the technical logic for allocating a purchase price to identifiable assets.
Claude 3.5 SonnetGPT-4o
0
0
75
Advisory & Consulting
IntermediateAudit Strategy & Materiality Planner
Calculates overall and performance materiality based on financial benchmarks and sets the scope for the engagement.
GPT-4oClaude 3.5 Sonnet
0
0
72
Advisory & Consulting
IntermediateModel audit checklist: errors, consistency, and presentation
Creates a model audit checklist to catch formula errors, circularity issues, and presentation problems. Useful for final review before sharing with clients/investors.
GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
93