A business can report strong revenue growth and still be heading toward a cash problem.
Imagine a company that expects sales to rise from $10 million to $11.2 million next year. That sounds positive. But higher sales may also mean more unpaid invoices, more inventory purchases, more staff, and more borrowing. If the company only forecasts revenue and profit, management may miss the cash strain until it is too late.
A three statement financial model solves that problem.
A three statement model links a company’s income statement, balance sheet, and cash flow statement into one connected forecast. It shows how changes in revenue, expenses, working capital, debt, capital expenditure, and taxes affect profit, cash, assets, liabilities, and shareholder equity.
It is one of the most widely used financial models in corporate finance, investment banking, equity research, private equity, business planning, lending, and startup fundraising.
The model does not predict the future perfectly. Its purpose is to show what the future may look like if your assumptions are right, and what happens if they are wrong.
Key Takeaways
- A three statement financial model links the income statement, balance sheet, and cash flow statement.
- The income statement shows profitability, the balance sheet shows what the business owns and owes, and the cash flow statement shows where cash actually moves.
- Revenue growth does not automatically improve cash flow. Rising accounts receivable, inventory, debt payments, and capital expenditure can absorb cash quickly.
- The best way to build a model is to start with historical financial statements, create a clean assumptions section, forecast the income statement, build supporting schedules, then link the balance sheet and cash flow statement.
- A properly built model should always balance. Total assets must equal total liabilities plus equity.
- Excel remains the standard choice for advanced models, but Google Sheets and LibreOffice Calc can work for simpler business planning.
- A basic three statement model can be built for free, but paid spreadsheet software, training, data subscriptions, and outside review can raise the cost.
What Is a Three Statement Financial Model?
A three statement financial model is a spreadsheet that connects the three main financial statements of a business:
- Income statement
Shows revenue, cost of goods sold, operating expenses, interest expense, taxes, and net income. - Balance sheet
Shows assets, liabilities, and shareholder equity at a specific point in time. - Cash flow statement
Shows cash generated or used by operating activities, investing activities, and financing activities.
The model links those statements using formulas and operating assumptions.
For example, a projected increase in revenue affects the income statement. It may also increase accounts receivable because more customers owe the company money. That increase in receivables reduces operating cash flow. Lower cash then affects the balance sheet.
This is why three statement models are more useful than a basic profit-and-loss forecast.
A simple income statement may tell you that profit will increase from $750,000 to $945,000. A three statement model tells you whether the company will actually have enough cash to pay suppliers, employees, lenders, and tax authorities.
Why a Three Statement Model Matters
The biggest value of a three statement model is that it forces financial logic.
A revenue forecast alone is easy to build. You can type in “15% growth” and calculate the next year’s sales.
The harder questions are:
- Will customers pay on time?
- How much extra inventory is needed to support sales growth?
- Will the business need more debt?
- How much interest expense will that debt create?
- Does higher profit create more cash, or does it create more working-capital pressure?
- Can the company afford capital expenditure?
- Will the balance sheet still be healthy after growth?
A well-built model answers all of these questions in one connected file.
For public companies, historical financial data often comes from SEC Form 10-K and Form 10-Q filings. Form 10-K filings contain annual financial information, while Form 10-Q filings are submitted for the first three fiscal quarters and include unaudited financial statements.
For private companies, the starting point is usually the accounting system, tax returns, bank statements, payroll reports, loan statements, management accounts, and inventory reports.
The Three Financial Statements Explained
| Financial Statement | What It Shows | Main Question It Answers |
|---|---|---|
| Income Statement | Revenue, expenses, profit, taxes, net income | Is the business profitable? |
| Balance Sheet | Cash, receivables, inventory, assets, debt, payables, equity | What does the business own and owe? |
| Cash Flow Statement | Cash generated from operations, investments, and financing | Is the business producing enough cash? |
The Income Statement
The income statement shows financial performance over a period such as a month, quarter, or year.
A typical structure looks like this:
| Income Statement Item | Example |
|---|---|
| Revenue | $10.0 million |
| Cost of Goods Sold | $6.0 million |
| Gross Profit | $4.0 million |
| Operating Expenses | $2.5 million |
| EBITDA | $1.5 million |
| Depreciation and Amortization | $300,000 |
| EBIT | $1.2 million |
| Interest Expense | $200,000 |
| Pre-Tax Income | $1.0 million |
| Income Tax | $250,000 |
| Net Income | $750,000 |
The income statement is usually where the model begins because revenue drives many other line items.
The Balance Sheet
The balance sheet records the company’s financial position at a specific date.
The main equation is:
Assets = Liabilities + Equity
Assets include cash, accounts receivable, inventory, equipment, property, and investments.
Liabilities include accounts payable, bank loans, taxes payable, lease obligations, and other debt.
Equity represents the ownership interest remaining after liabilities are deducted from assets.
A balanced balance sheet is not optional. If total assets do not equal total liabilities plus equity, the model contains an error.
The Cash Flow Statement
The cash flow statement explains why the cash balance changed.
It has three main sections:
| Cash Flow Section | Typical Items |
|---|---|
| Operating Activities | Net income, depreciation, receivables, inventory, accounts payable |
| Investing Activities | Equipment purchases, property purchases, acquisitions |
| Financing Activities | Debt borrowings, debt repayments, dividends, share issuance, share buybacks |
The cash flow statement is often the most important part of the model for owners and lenders.
A company can show a net profit but still lose cash because it is buying inventory, waiting for customer payments, making loan repayments, or investing in equipment.
What You Need Before Building the Model
Do not start by opening a blank spreadsheet and typing random formulas.
Start with reliable historical data.
For a private company, try to collect at least three years of annual financial statements. For a growing company, monthly or quarterly information may be more useful.
You should gather:
- Income statements
- Balance sheets
- Cash flow statements, if available
- Bank balances
- Accounts receivable aging reports
- Inventory reports
- Accounts payable reports
- Debt schedules
- Fixed asset schedules
- Payroll data
- Tax rates
- Revenue forecasts
- Hiring plans
- Capital expenditure plans
For a public company, SEC EDGAR filings can provide 10-K and 10-Q reports, including financial statements and management discussion of operating performance. The SEC’s EDGAR search system allows users to search filings by company, form type, date, and keyword.
The cleaner the historical data, the better the model.
A three statement model cannot repair weak bookkeeping. If inventory, debt, cash, or receivables are wrong in the source data, the forecast will also be unreliable.
Step 1: Set Up the Workbook Structure
A clean workbook should separate assumptions, historical data, calculations, and output.
A practical file structure may include:
| Worksheet | Purpose |
|---|---|
| Assumptions | Revenue growth, margins, tax rate, debt rate, working-capital days |
| Historical Financials | Actual income statement, balance sheet, and cash flow data |
| Income Statement | Historical and forecast profit and loss |
| Working Capital Schedule | Receivables, inventory, and payables forecast |
| Fixed Assets Schedule | Capital expenditure, depreciation, and net property balance |
| Debt Schedule | Borrowings, repayments, interest expense, ending debt |
| Cash Flow Statement | Cash generated or used during each period |
| Balance Sheet | Forecast assets, liabilities, and equity |
| Dashboard or Summary | Key outputs, ratios, charts, and downside scenarios |
Keep hardcoded assumptions separate from formulas.
For example, do not write this formula:
=Revenue*1.12
Instead, create an assumption cell for revenue growth and link to it:
=Prior_Year_Revenue*(1+Revenue_Growth_Rate)
This makes the model easier to review and update.
Many analysts use different cell colors to distinguish inputs, formulas, and links. The exact color system is less important than consistency.
Step 2: Enter Historical Financial Statements
Your model should include historical actuals before forecasts.
A simple model may use one historical year and three forecast years. A stronger model often uses three years of history and three to five years of forecasts.
For example:
| Fiscal Year | 2024A | 2025A | 2026E | 2027E | 2028E |
|---|---|---|---|---|---|
| Revenue | $8.8m | $10.0m | $11.2m | $12.4m | $13.5m |
| EBITDA | $1.1m | $1.5m | $1.8m | $2.0m | $2.2m |
| Net Income | $520k | $750k | $945k | $1.1m | $1.2m |
“A” means actual. “E” means estimated.
Historical results help you identify patterns.
For example:
- Has revenue grown consistently?
- Is gross margin rising or falling?
- Are receivables increasing faster than sales?
- Is debt declining?
- Is cash flow weaker than net income?
- Is the company becoming more efficient?
You should calculate historical margins and ratios before forecasting. That gives you a realistic starting point.
Step 3: Build the Assumptions Section
The assumptions section is the engine of the model.
It should include every major input that drives the forecast.
| Assumption | Historical Level | Forecast Assumption |
|---|---|---|
| Revenue Growth | 13.6% | 12.0% |
| Gross Margin | 40.0% | 40.0% |
| Operating Expenses | 25.0% of revenue | 24.1% of revenue |
| Tax Rate | 25.0% | 25.0% |
| Days Sales Outstanding | 43 days | 44 days |
| Inventory Days | 49 days | 48 days |
| Accounts Payable Days | 37 days | 36 days |
| Capital Expenditure | $400,000 | $500,000 |
| Debt Interest Rate | 10.0% | 10.0% |
| Debt Repayment | $250,000 | $300,000 |
A good model includes a base case, upside case, and downside case.
For example:
| Scenario | Revenue Growth | Gross Margin | DSO |
|---|---|---|---|
| Upside Case | 18% | 42% | 40 days |
| Base Case | 12% | 40% | 44 days |
| Downside Case | 3% | 37% | 55 days |
This allows management to see what happens if sales slow, customers pay late, or margins decline.
Step 4: Forecast the Income Statement
Start with revenue.
Revenue can be forecast as a percentage growth rate, but driver-based forecasting is usually better.
For example:
Revenue = Customers × Average Revenue Per Customer
For an ecommerce company:
Revenue = Website Visitors × Conversion Rate × Average Order Value
For a SaaS company:
Revenue = Active Customers × Average Monthly Subscription Revenue × 12
For a manufacturer:
Revenue = Units Sold × Average Selling Price
In this example, assume a company generated $10 million in revenue last year and expects 12% growth.
Forecast Revenue = $10.0 million × 1.12 = $11.2 million
Assume the company maintains a 40% gross margin.
Gross Profit = $11.2 million × 40% = $4.48 million
Cost of goods sold equals:
Revenue − Gross Profit
$11.2 million − $4.48 million = $6.72 million
Assume operating expenses rise to $2.70 million.
The projected EBITDA becomes:
$4.48 million − $2.70 million = $1.78 million
Assume depreciation and amortization of $350,000.
EBIT = $1.78 million − $350,000 = $1.43 million
Assume interest expense of $170,000.
Pre-Tax Income = $1.43 million − $170,000 = $1.26 million
At a 25% assumed tax rate:
Income Tax = $1.26 million × 25% = $315,000
Net Income = $1.26 million − $315,000 = $945,000
That completes the forecast income statement.
Step 5: Build the Working Capital Schedule
Working capital is where many first-time financial models fail.
Revenue growth often increases accounts receivable and inventory. That can consume cash even when profit rises.
The three main working-capital accounts are:
- Accounts receivable
- Inventory
- Accounts payable
Accounts Receivable
Accounts receivable are invoices owed by customers.
The usual formula is:
Accounts Receivable = Revenue ÷ 365 × Days Sales Outstanding- Using forecast revenue of $11.2 million and 44 DSO:
$11.2 million ÷ 365 × 44 = approximately $1.35 million
Inventory
- Inventory is often forecast using inventory days.
Inventory = Cost of Goods Sold ÷ 365 × Inventory Days- Using cost of goods sold of $6.72 million and inventory days of 48:
$6.72 million ÷ 365 × 48 = approximately $884,000
Accounts Payable
- Accounts payable are amounts owed to suppliers.
Accounts Payable = Cost of Goods Sold ÷ 365 × Accounts Payable Days- Using 36 payable days:
$6.72 million ÷ 365 × 36 = approximately $663,000- The working-capital movement affects the cash flow statement.
- If receivables increase, cash decreases.
- If inventory increases, cash decreases.
If payables increase, cash increases because the company is taking longer to pay suppliers.
Step 6: Build the Fixed Asset and Depreciation Schedule
A company may need to buy equipment, software, property, vehicles, or other long-term assets.
Capital expenditure, usually called capex, appears on the cash flow statement because it uses cash.
The asset is then depreciated over its useful life.
A simplified fixed asset schedule looks like this:
| Fixed Asset Item | Amount |
|---|---|
| Beginning Net PP&E | $2.40 million |
| Capital Expenditure | $500,000 |
| Depreciation Expense | $(350,000) |
| Ending Net PP&E | $2.55 million |
The formula is:
Ending Net PP&E = Beginning Net PP&E + Capex − Depreciation
The $500,000 capital expenditure reduces cash in the current period. The $350,000 depreciation expense reduces accounting profit but does not directly reduce cash during the year.
That is why depreciation is added back in the operating section of the cash flow statement.
Step 7: Build the Debt and Interest Schedule
Debt affects three areas of the model:
- Balance sheet debt balance
- Interest expense on the income statement
- Borrowings and repayments on the cash flow statement
A basic debt schedule may look like this:
| Debt Item | Amount |
|---|---|
| Beginning Debt | $2.00 million |
| New Borrowing | $0 |
| Debt Repayment | $(300,000) |
| Ending Debt | $1.70 million |
| Average Debt Balance | $1.85 million |
| Interest Rate | 9.2% |
| Interest Expense | Approximately $170,000 |
The formula is:
Ending Debt = Beginning Debt + New Borrowing − Debt Repayment
Interest expense is often calculated using average debt.
Interest Expense = Average Debt × Interest Rate
Using average debt of $1.85 million and a 9.2% interest rate:
$1.85 million × 9.2% = approximately $170,000
A more advanced model may include multiple loans, revolving credit facilities, fixed-rate debt, floating-rate debt, mandatory repayments, and debt covenants.
Step 8: Build the Cash Flow Statement
The cash flow statement usually begins with net income and uses the indirect method.
The core operating cash flow formula is:
Operating Cash Flow = Net Income + Noncash Expenses − Increase in Operating Assets + Increase in Operating Liabilities
Using the example:
| Operating Cash Flow Item | Amount |
|---|---|
| Net Income | $945,000 |
| Add: Depreciation | $350,000 |
| Less: Increase in Working Capital | $(171,000) |
| Net Cash From Operating Activities | $1.12 million |
The increase in working capital is calculated as:
Change in Receivables + Change in Inventory − Change in Payables
Assume the company begins with:
- Accounts receivable of $1.20 million
- Inventory of $800,000
- Accounts payable of $600,000
Beginning net working capital equals:
$1.20m + $800k − $600k = $1.40 million
Forecast net working capital equals:
$1.35m + $884k − $663k = approximately $1.57 million
That is a cash outflow of about $171,000.
Next, add investing activities:
| Investing Activities | Amount |
|---|---|
| Capital Expenditure | $(500,000) |
| Net Cash Used in Investing Activities | $(500,000) |
Then add financing activities:
| Financing Activities | Amount |
|---|---|
| Debt Repayment | $(300,000) |
| New Equity Raised | $0 |
| Dividends Paid | $0 |
| Net Cash Used in Financing Activities | $(300,000) |
The complete cash flow statement looks like this:
| Cash Flow Statement | Amount |
|---|---|
| Net Cash From Operating Activities | $1.12 million |
| Net Cash Used in Investing Activities | $(500,000) |
| Net Cash Used in Financing Activities | $(300,000) |
| Net Increase in Cash | Approximately $324,000 |
| Beginning Cash | $700,000 |
| Ending Cash | Approximately $1.02 million |
This ending cash balance must link directly to the cash line on the balance sheet.
Step 9: Complete the Balance Sheet
Now link the forecast balance sheet.
Using the example:
| Balance Sheet Item | Forecast Amount |
|---|---|
| Cash | $1.02 million |
| Accounts Receivable | $1.35 million |
| Inventory | $884,000 |
| Net PP&E | $2.55 million |
| Total Assets | Approximately $5.81 million |
| Accounts Payable | $663,000 |
| Debt | $1.70 million |
| Total Liabilities | Approximately $2.36 million |
| Shareholder Equity | Approximately $3.45 million |
| Total Liabilities and Equity | Approximately $5.81 million |
The equity calculation must also roll forward.
Ending Equity = Beginning Equity + Net Income − Dividends + New Equity Issued
If beginning equity is $2.50 million and net income is $945,000:
$2.50 million + $945,000 = $3.445 million
The balance sheet balances because:
$5.808 million Assets = $2.363 million Liabilities + $3.445 million Equity
Rounded figures may cause small differences in presentation. In the actual model, the balance check should equal zero.
Step 10: Add a Balance Check
Every three statement model should include a visible balance check.
Use:
Balance Check = Total Assets − Total Liabilities − Total Equity
The result should be zero.
| Balance Check Result | Meaning |
|---|---|
| $0 | Model is balanced |
| Small rounding difference | Check decimal settings and formula references |
| Large positive or negative number | Model contains a broken link, missing formula, or incorrect sign |
A balance check will not prove every assumption is correct. It only proves that the statements are mathematically linked.
You should also add error checks for:
- Negative cash balances
- Debt maturity dates
- Interest coverage
- Gross margin changes
- Working-capital movements
- Unusual tax rates
- Revenue growth assumptions
- Circular references
Circular References: The Common Modeling Problem
Circular references happen when two calculations depend on each other.
For example:
- Interest expense depends on debt.
- Debt may depend on how much cash the company needs.
- Cash depends on interest expense.
That creates a loop.
Beginner models often avoid this by calculating interest expense using beginning debt rather than average debt. This is less precise but easier to manage.
More advanced models may use average debt, a cash sweep, iterative calculations, or a dedicated revolver facility.
For a first three statement model, simplicity is better than unnecessary complexity.
Common Three Statement Modeling Mistakes
Forecasting Revenue Without Forecasting Working Capital
A company may project 20% revenue growth but ignore receivables and inventory.
That creates an unrealistic cash flow forecast.
Always link revenue growth to accounts receivable and cost of goods sold to inventory and accounts payable.
Hardcoding Numbers Into Formulas
Avoid formulas such as:
=Revenue*1.12
Use an assumption cell instead:
=Revenue*(1+Growth_Rate)
This makes the model auditable and easy to update.
Using the Wrong Sign Convention
Cash flow models often break because expenses, repayments, and increases in working capital are entered with inconsistent signs.
Choose a consistent convention.
For example:
- Revenue and cash inflows: positive
- Expenses and cash outflows: negative
- Debt borrowings: positive
- Debt repayments: negative
- Capex: negative
Forgetting Depreciation
Capex affects cash immediately, but depreciation affects profit over time.
If you include capex without depreciation, net income and fixed assets will be wrong.
Forgetting Retained Earnings
Net income increases shareholder equity unless it is paid out through dividends or otherwise distributed.
A balance sheet will not balance if retained earnings are ignored.
Treating the Model as a Guarantee
A model is a structured assumption, not a promise.
Management should review the base case, downside case, and upside case. The downside case is often where the most valuable decisions appear.
What Does It Cost to Build a Three Statement Model?
A three statement model does not have a fixed purchase price. You can build one for free in LibreOffice Calc or Google Sheets. Costs rise when you need desktop software, structured training, paid templates, business data, outside review, or enterprise planning systems.
The pricing below reflects public list prices available on July 7, 2026. Taxes, promotions, currency conversion, and regional pricing can change the total paid.
| Cost Item | Published Price | What You Get | Extra Cost to Watch |
|---|---|---|---|
| LibreOffice Calc | Free | Desktop spreadsheet tool for Windows, macOS, and Linux | No paid support or formal modeling training included |
| Microsoft 365 Business Basic, no Teams | ₹130 per user per month, paid yearly | Web and mobile Excel access | GST extra; desktop Excel is not included |
| Microsoft 365 Apps for Business | ₹830 per user per month, paid yearly | Desktop Excel, Word, PowerPoint, Outlook, and 1 TB cloud storage | GST extra; annual subscription renews automatically |
| Google Workspace Business Starter | ₹270 per user per month on annual billing | Google Sheets, collaboration tools, business email, and 30 GB storage per user | Taxes, larger storage plans, and additional user licenses |
| CFI FMVA India | ₹12,000 per year | Financial modeling and valuation training | Spreadsheet software and business data are separate costs |
| External model review | Quote-based | Accountant, CFO, lender, or valuation specialist review | Cost depends on model complexity and business size |
| Paid financial data | Quote-based or subscription-based | Market data, industry benchmarks, transaction data | Not needed for a basic operating model, but often needed for investment analysis |
LibreOffice describes Calc as part of its free office suite. Microsoft lists Microsoft 365 Apps for Business at ₹830 per user per month on annual billing, plus applicable GST, and includes desktop Excel. Google lists Business Starter in India from ₹270 per user per month on annual billing. CFI lists FMVA India at ₹12,000 annually.
There is no transaction fee attached to a standard three statement model. The hidden cost is usually time. A finance manager may spend hours fixing broken formulas, updating imported data, and reconciling version-controlled files if the model is poorly designed.
Excel vs Google Sheets vs LibreOffice Calc
| Tool | Starting Cost | Best For | Collaboration | Offline Work | Advanced Model Suitability |
|---|---|---|---|---|---|
| Microsoft Excel | ₹830 per user per month for Microsoft 365 Apps for Business on annual billing | Professional financial modeling, investment analysis, debt schedules, large files | Good with OneDrive and SharePoint | Excellent | Excellent |
| Google Sheets | ₹270 per user per month for Google Workspace Business Starter annual billing | Startup budgets, shared forecasts, operating plans | Excellent | Limited compared with desktop Excel | Good for standard models |
| LibreOffice Calc | Free | Individual users, small businesses, basic offline modeling | Limited | Excellent | Good for simple to mid-level models |
Excel is usually the strongest choice for detailed three statement models because it is widely used in corporate finance and supports advanced modeling workflows.
Google Sheets is often the better option for small teams that need multiple people to edit a budget or cash forecast at the same time.
LibreOffice Calc is the best fit for someone who needs a free offline spreadsheet tool and does not need enterprise collaboration features.
CFI’s FMVA program is not a spreadsheet competitor. It is a training option for people who want structured practice in building three statement models, discounted cash flow valuations, scenario analysis, and finance presentations.
Final Strategic Verdict
A three statement financial model is perfect for business owners, startup founders, finance students, analysts, lenders, investors, and managers who need to understand how operational decisions affect profit, cash, debt, and business value.
It is especially useful before major decisions such as hiring, borrowing, buying equipment, raising capital, opening a new location, acquiring another business, or changing prices.
A small business does not need a 20-tab investment banking model. A clean annual model with monthly cash flow, working-capital assumptions, debt payments, and downside scenarios can be enough to prevent serious mistakes.
Avoid building a complex model when your underlying accounting data is unreliable. Fix bookkeeping, reconcile cash, review receivables, and understand debt obligations first.
The best three statement model is not the one with the most formulas.
It is the one that clearly shows how a change in sales, margins, collection periods, inventory, capex, or debt affects the cash available to keep the business moving.