How long does it take to build a three statement model?

For a simple business, 4-8 hours for a competent modeler. Complex businesses with multiple revenue streams, debt instruments, and working capital dynamics can take 20-40 hours.

What software is best for three statement models?

Microsoft Excel is the industry standard. Google Sheets works for simpler models. Specialized tools like Mosaic, Jirav, or Runway provide automated model building but less flexibility.

Three Statement Financial Model: Complete Guide

Updated March 2026 · 20 min read · 720 monthly searches

Bottom Line: A three statement model links the income statement, balance sheet, and cash flow statement into a single integrated financial model. It's the foundation of all financial modeling — every DCF, LBO, and merger model starts here. For fractional CFOs, it's your most versatile tool for strategic planning, fundraising, and scenario analysis.

📋 Table of Contents

What Is a Three Statement Model?
Why It Matters for Advisory Work
How to Build One (Step by Step)
How the Statements Link Together
Key Assumptions to Model
Scenario Analysis
Best Practices & Common Errors
FAQ

What Is a Three Statement Model?

A three statement model is a financial model that dynamically links the three core financial statements:

Income Statement: Revenue, expenses, and profit over a period
Balance Sheet: Assets, liabilities, and equity at a point in time
Cash Flow Statement: How cash moves in and out during the period

The key word is linked. When you change a revenue assumption on the income statement, it automatically flows through to the balance sheet (AR, retained earnings) and cash flow statement (operating cash flow). Change one input, and the entire model updates.

Why It Matters for Advisory Work

As a fractional CFO or advisor, a three statement model lets you:

📊 Strategic Planning

"If we hire 3 more people, what happens to cash flow in 6 months?" Answer it in seconds.

💰 Fundraising

Investors and lenders want projections. A three statement model is the standard they expect.

🎯 Scenario Analysis

Bull case, base case, bear case — show clients the range of outcomes, not just one guess.

⚠️ Cash Forecasting

Profitable companies go bankrupt from cash crunches. This model catches problems before they hit.

How to Build One: Step by Step

Step 1: Set Up the Structure

In Excel or Google Sheets, create four tabs:

Assumptions: All inputs in one place (growth rate, margins, CapEx, working capital)
Income Statement: Revenue through net income
Balance Sheet: Assets, liabilities, equity
Cash Flow Statement: Operating, investing, financing

Column structure: 3-5 years of historical data (actuals) → 3-5 years of projections. Color-code: blue for inputs, black for formulas, green for links to other sheets.

Step 2: Build the Income Statement

Start with revenue and work down:

Revenue (from assumptions — growth rate or bottom-up)

- COGS (as % of revenue from assumptions)

= Gross Profit

- SG&A (fixed + variable component)

- R&D (if applicable)

- D&A (from balance sheet PP&E schedule)

= Operating Income (EBIT)

- Interest Expense (from debt schedule)

+ Interest Income (from cash balance)

= Pre-Tax Income

- Taxes (effective tax rate)

= Net Income

Step 3: Build the Balance Sheet

Key sections and how to model them:

Accounts Receivable: Revenue × (AR Days / 365)
Inventory: COGS × (Inventory Days / 365)
PP&E: Prior period PP&E + CapEx - Depreciation
Accounts Payable: COGS × (AP Days / 365)
Debt: Prior period + new borrowings - repayments
Retained Earnings: Prior period + Net Income - Dividends

The balance sheet must balance (Assets = Liabilities + Equity). If it doesn't, you have an error somewhere — usually in the cash flow statement linkage.

Step 4: Build the Cash Flow Statement

Operating Activities:

Net Income (from income statement)

+ D&A (non-cash expense, add back)

- Increase in AR (cash tied up in receivables)

- Increase in Inventory

+ Increase in AP (delaying payments = more cash)

= Cash from Operations

Investing Activities:

- CapEx

= Cash from Investing

Financing Activities:

+ New Debt

- Debt Repayments

- Dividends

+ Equity Issuance

= Cash from Financing

Net Change in Cash = Operating + Investing + Financing

Ending Cash = Beginning Cash + Net Change

Critical check: Ending cash on the cash flow statement must equal cash on the balance sheet. This is how you know the model is integrated correctly.

How the Statements Link Together

Income Statement → Balance Sheet:

Net Income flows to Retained Earnings
D&A reduces PP&E (net book value)
Interest expense ties to debt balance

Balance Sheet → Cash Flow Statement:

Changes in working capital (AR, AP, inventory) flow to operating section
CapEx flows from PP&E schedule to investing section
Debt changes flow to financing section

Cash Flow Statement → Balance Sheet:

Ending cash balance flows back to the balance sheet cash line
This creates the "circular reference" — the model closes the loop

Key Assumptions to Model

Category	Assumptions	How to Estimate
Revenue	Growth rate, price, volume	Historical trends, market data, management guidance
Margins	Gross margin %, SG&A %	Historical averages, industry benchmarks
Working Capital	AR days, AP days, inventory days	Historical patterns, payment terms
CapEx	Maintenance vs. growth CapEx	% of revenue, or specific projects planned
Depreciation	Useful life, method	Existing schedule + new assets
Debt	Interest rate, repayment schedule	Loan agreements, planned refinancing
Taxes	Effective tax rate	Historical effective rate, current tax law

Scenario Analysis

The power of a three statement model is running scenarios instantly. Set up a scenario toggle in your assumptions tab:

Bull Case: Revenue grows 25%, margins expand 2 points, AR days improve
Base Case: Revenue grows 12%, margins stable, working capital stable
Bear Case: Revenue grows 3%, margins compress 1 point, AR days deteriorate

Present all three to clients. This transforms the conversation from "here's what will happen" to "here's the range of what could happen, and here's what we need to do to land on the right end."

Best Practices & Common Errors

Best Practices

Separate inputs from calculations — all assumptions in one place, color-coded
One formula per row — don't hardcode exceptions; if a year is different, handle it in assumptions
Balance sheet must balance — if it doesn't, fix it before doing anything else
Document assumptions — add comments explaining why you chose each number
Build checks — add a check row that shows 0 if the balance sheet balances, an error if it doesn't

Common Errors

Circular reference errors: Interest income depends on cash, which depends on interest income. Use Excel's iterative calculation setting or a cash sweep mechanism.
Sign convention confusion: Be consistent — is CapEx positive or negative? Pick one convention and stick to it.
Forgetting depreciation: If you add CapEx, you need corresponding depreciation. PP&E can't grow without limit.
Working capital mismatch: AR should move with revenue, AP should move with COGS — not the other way around.
Missing the balancing item: Usually cash or a revolver (line of credit) is the "plug" that makes the balance sheet balance.

Learn Financial Modeling for Advisory Work

Fractional CFO School teaches practical financial modeling skills — build three statement models, DCFs, and scenario analyses that clients will pay premium rates for.

See Our Programs →

Frequently Asked Questions

What is a three statement model?

It links the income statement, balance sheet, and cash flow statement so changing one assumption automatically updates all three statements.

How long does it take to build one?

4-8 hours for a simple business. 20-40 hours for complex businesses with multiple revenue streams and debt instruments.