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
AdvancedMaster Service Agreement (MSA) for Consulting
A long-term legal framework for ongoing advisory relationships.
GPT-4oClaude 3.5 Sonnet
0
0
143
Advisory & Consulting
IntermediateReal Estate: Fair Value of Investment Properties (IAS 40)
Values commercial real estate holdings based on capitalization rates and net operating income.
GPT-4oClaude 3.5 Sonnet
0
0
135
Advisory & Consulting
AdvancedRestructuring & Turnaround: 13-Week Cash Flow
A critical tool for distressed companies to manage daily liquidity and prioritize payments.
Claude 3.5 SonnetGPT-4o
0
0
171