asgard-ai-platform / fin-modeling

Three-Statement Financial Modeling

Framework

IRON LAW: The Three Statements Must Balance

Assets = Liabilities + Equity (Balance Sheet identity)
Net Income flows from IS to BS (retained earnings)
Cash flow bridges IS and BS through working capital and capex

If your model doesn't balance, there's an error. Check the cash line on
the BS against the ending cash on the CF statement. They MUST match.

Model Architecture

[Assumptions Page] → drives everything
    ↓
[Income Statement] → Revenue, costs, taxes → Net Income
    ↓
[Balance Sheet] → Assets, liabilities, equity → must balance
    ↓
[Cash Flow Statement] → Start cash + Operating + Investing + Financing = End cash
    ↓
[Outputs: DCF, Returns, Scenarios]

Revenue Forecasting Methods

Key Assumptions to Document

Building Steps

Phase 1: Assumptions

1. Document all assumptions on a dedicated page
2. Color code: blue = input, black = formula, green = linked from another sheet
3. Each assumption must have a source or rationale

Phase 2: Income Statement

1. Build revenue line from assumptions
2. COGS and gross profit
3. Operating expenses by category
4. EBITDA, depreciation, EBIT
5. Interest, taxes, net income

Phase 3: Balance Sheet

1. Working capital items from IS drivers (DSO × Revenue/365, etc.)
2. Fixed assets: prior period + capex - depreciation
3. Debt schedule: prior period + new borrowing - repayment
4. Equity: prior period + net income - dividends + equity raises
5. CHECK: Assets = Liabilities + Equity

Phase 4: Cash Flow

1. Start with net income
2. Add back non-cash items (depreciation, amortization)
3. Working capital changes (from BS period-over-period)
4. CapEx (investing)
5. Debt and equity changes (financing)
6. CHECK: Ending cash = BS cash line

Phase 5: Scenarios

1. Base case (most likely assumptions)
2. Bull case (optimistic — higher growth, better margins)
3. Bear case (pessimistic — lower growth, margin pressure)

Output Format

# Financial Model: {Company} — {Projection Period}

## Key Assumptions
| Assumption | Y1 | Y2 | Y3 | Y4 | Y5 | Source |
|-----------|-----|-----|-----|-----|-----|--------|
| Revenue growth | {%} | {%} | {%} | {%} | {%} | {basis} |
| Gross margin | {%} | ... | ... | ... | ... | ... |
| OpEx growth | {%} | ... | ... | ... | ... | ... |

## Projected Income Statement
| | Y1 | Y2 | Y3 | Y4 | Y5 |
|---|-----|-----|-----|-----|-----|
| Revenue | ${X} | ... | ... | ... | ... |
| Gross Profit | ${X} | ... | ... | ... | ... |
| EBITDA | ${X} | ... | ... | ... | ... |
| Net Income | ${X} | ... | ... | ... | ... |

## Scenario Comparison
| Metric (Y5) | Bear | Base | Bull |
|-------------|------|------|------|
| Revenue | ${X} | ${X} | ${X} |
| Net Income | ${X} | ${X} | ${X} |
| FCF | ${X} | ${X} | ${X} |

## Balance Check
- BS balances: ✓/✗
- CF ending cash = BS cash: ✓/✗

Gotchas

• Revenue is the most sensitive assumption: A 2% difference in growth rate compounds enormously over 5 years. Always present a range, not a point estimate.
• Working capital is often forgotten: Fast-growing companies consume cash in working capital (building inventory, extending credit). A profitable company can run out of cash if working capital isn't modeled.
• Circular references with interest: Interest expense depends on debt balance, which depends on cash (which may require more debt). Break the circularity with an iterative calculation or prior-period debt balance.
• Granularity should match certainty: Model Year 1 monthly, Year 2 quarterly, Years 3-5 annually. Detailed monthly projections for Year 5 are false precision.
• Assumptions page is the most important page: Nobody should need to dig into formulas to understand what drives your model. All assumptions visible, documented, and changeable in one place.

References

• For DCF valuation built on the three-statement model, see the biz-dcf skill
• For spreadsheet best practices, see references/modeling-best-practices.md