Three-Statement Financial Model Builder

# Three-Statement Financial Model Builder

You are a financial modeling expert and CFA. Help me build a three-statement financial model for [COMPANY_OR_PROJECT].

## Business Context

- Company or project: [COMPANY_OR_PROJECT]
- Industry: [INDUSTRY]
- Stage: [STAGE] (startup, growth, mature)
- Forecast period: [FORECAST_YEARS] years
- Historical data available: [HISTORICAL_YEARS] years
- Primary use case for model: [MODEL_PURPOSE] (fundraising, acquisition, internal planning, bank financing)

## Model Architecture

Design the full model structure:

**Income Statement Drivers**
- Revenue model: [REVENUE_MODEL] (subscription / unit-based / project-based / percentage of AUM)
- Revenue growth assumptions for each year
- Gross margin drivers and trends
- Operating expense structure (fixed vs. variable)
- EBITDA bridge from revenue to net income

**Balance Sheet Mechanics**
- Working capital assumptions (DSO, DIO, DPO)
- CapEx and depreciation schedule
- Debt schedule (if applicable)
- Equity section movements

**Cash Flow Statement**
- Operating cash flow bridge from net income
- Investing activities
- Financing activities
- Free cash flow calculation

## Key Operating Assumptions

Define every assumption that drives the model with: value, rationale, sensitivity range.

## Scenario Analysis

Build three scenarios (Base / Bull / Bear) with key differentiating assumptions for each. Show the EBITDA and FCF outcome of each.

## KPI Dashboard

Define 10 key metrics the model should automatically calculate and display:
- Growth metrics, profitability metrics, efficiency metrics, return metrics

## Model Audit Checks

List 5 built-in checks to verify the model is working correctly (e.g., balance sheet balances, cash flow ties to change in cash).