Most small business owners can tell you how much money is in their bank account today. Far fewer can tell you what that balance will be in eight months — and almost none can show their work. That gap is exactly what a three-statement financial model closes.
A three-statement model is not a spreadsheet of guesses. It is a connected system that links your income statement, balance sheet, and cash flow statement so that one set of assumptions flows through all three. Change your revenue growth rate, and profit, retained earnings, receivables, and your ending cash balance all update together. Done right, it answers the only two questions that keep founders awake: Are we profitable? and When do we run out of cash?
This guide walks through what each statement does, how they connect, the order to build them, and the mistakes that quietly break models built by smart people.
Why Three Statements, Not One
It is tempting to forecast with a single cash projection: cash in, cash out, ending balance. That works until it doesn't. A cash-only forecast misses the timing problems that sink real businesses.
Consider a company that lands a large contract. The income statement shows a profitable month. But the customer pays on net-60 terms, the company paid suppliers upfront, and payroll is due Friday. The business is profitable and broke at the same time. A single statement cannot show that. Three linked statements can.
Each statement answers a different question:
- The income statement asks: Did we make money? It records revenue and expenses over a period, ending in net income.
- The balance sheet asks: What do we own and owe? It is a snapshot at a point in time — assets on one side, liabilities and equity on the other.
- The cash flow statement asks: Where did the cash actually go? It reconciles net income (an accounting figure) to the real change in your bank balance.
Profit is an opinion shaped by accounting rules. Cash is a fact. The three-statement model is what lets you hold both in view at once.
How the Three Statements Link Together
The power of the model is in the connections. Three links matter most.
Net income ties the income statement to the balance sheet. The bottom line of your income statement flows into retained earnings in the equity section of the balance sheet. Earn $40,000 in profit and pay no dividends, and retained earnings rises by $40,000.
Net income also starts the cash flow statement. The cash flow statement begins with net income, then adjusts it. It adds back non-cash expenses like depreciation, and it adjusts for changes in working capital — receivables, inventory, payables. The result is cash from operations.
The cash flow statement closes the loop back to the balance sheet. The ending cash balance from the cash flow statement becomes the cash line on the balance sheet. This is the connection that makes the model balance. If every change in every balance sheet account is properly reflected in the cash flow statement, the balance sheet balances automatically — assets equal liabilities plus equity, with no manual nudging.
A useful rule to memorize: every change in a balance sheet account must appear somewhere on the cash flow statement. Accounts receivable went up $5,000? That is $5,000 of cash you earned but have not collected — a use of cash. Inventory dropped $3,000? You sold goods without buying replacements — a source of cash. When a balance sheet movement has no matching cash flow line, the model breaks.
Building the Model: The Right Order
Building the statements in the wrong order creates a tangle of broken formulas. Follow this sequence.
Step 1: Gather Historical Data
Start with two to three years of actual results, or as much as you have. Historicals do two things: they reveal real patterns — your true gross margin, how fast you collect, your seasonal swings — and they give you something to sanity-check forecasts against. A forecast that bears no resemblance to history needs a written explanation.
Step 2: Set Your Assumptions
This is the heart of the model, and it deserves its own clearly labeled section. Core drivers include:
- Revenue growth — by month or quarter, ideally broken into units sold and price rather than a single blended rate
- Gross margin — cost of goods as a percentage of revenue
- Operating expenses — which costs are fixed and which scale with revenue
- Working capital terms — days to collect receivables, days of inventory on hand, days to pay suppliers
- Capital expenditures — equipment or asset purchases and how they depreciate
- Financing — loan draws, repayments, and interest rates
Keep every assumption in one place, color-coded, so anyone can find and adjust the inputs without hunting through formulas. A model where assumptions are buried inside calculations is a model nobody will trust or maintain.
Step 3: Build the Income Statement Down to Operating Income
Project revenue from your drivers, subtract cost of goods sold to reach gross profit, then subtract operating expenses to reach operating income (EBITDA). Stop there for now — interest and depreciation depend on schedules you have not built yet.
Step 4: Build the Supporting Schedules
Two schedules feed back into the statements:
- The depreciation / fixed asset schedule tracks property and equipment. It takes the opening balance, adds capital expenditures, subtracts depreciation, and produces the closing balance. Depreciation flows into the income statement; the closing asset balance flows into the balance sheet.
- The debt schedule tracks loans. It takes the opening balance, adds new borrowing, subtracts repayments, and calculates interest expense. Interest flows into the income statement; the closing debt balance flows into the balance sheet.
Step 5: Complete the Income Statement
With depreciation and interest now calculated, finish the income statement: subtract them from operating income, apply taxes, and arrive at net income.
Step 6: Build the Balance Sheet — Except Cash
Project every balance sheet line. Receivables, inventory, and payables come from your working capital assumptions. Fixed assets come from the depreciation schedule. Debt comes from the debt schedule. Retained earnings is last period's balance plus this period's net income. Leave the cash line blank — it is the final piece.
Step 7: Build the Cash Flow Statement and Solve for Cash
Build the three sections — operating, investing, financing. Start with net income, add back depreciation, adjust for working capital changes, subtract capital expenditures, and add or subtract financing activity. The net change in cash, added to last period's cash, gives this period's ending cash. Drop that figure into the balance sheet's cash line.
If you built every link correctly, the balance sheet now balances on its own.
Forecasting Runway: The Model's Most Important Output
For an early-stage or cash-tight business, the single most valuable number the model produces is runway — how many months you can operate before cash runs out.
Runway has two inputs: your cash on hand and your monthly burn rate (the net cash you lose each month). The basic version is simple: $120,000 in the bank and $15,000 of monthly burn means roughly eight months of runway.
But a three-statement model gives you something a back-of-the-envelope calculation cannot: a runway that changes over time. Real burn is not flat. It rises when you hire, drops when a big invoice clears, and shifts with seasonality. Because the model forecasts cash month by month, you can see the exact month the balance turns negative — and how a new hire or a delayed customer payment moves that date.
This is also where scenario planning earns its keep. Build three versions of your assumptions:
- Base case — your honest expectation
- Downside case — revenue 25% lower, collections slower
- Upside case — growth lands and a funding round closes
In an environment where interest rates and demand can shift quickly, knowing your runway under the downside case is what separates a calm decision from a panicked one. The point of the downside case is not pessimism — it is to know your fallback before you need it.
Common Mistakes That Break Models
A few errors account for most broken models.
Forcing the balance sheet to balance. If you ever type a number to make the two sides match, stop. The balance sheet should balance by construction. A forced plug hides a real error and produces numbers you cannot trust.
A missing working capital item. The most frequent cause of an imbalance is a balance sheet account that changed without a matching line on the cash flow statement. Audit every balance sheet line and confirm its movement appears in the cash flow.
Misunderstanding circular references. Interest expense depends on the debt balance, which depends on cash, which depends on net income — which includes interest expense. That loop is inherent to the model, not a bug. Excel handles it with iterative calculation enabled, or you break the loop by calculating interest on the prior period's debt balance. Either is fine; panicking and deleting formulas is not.
Over-relying on the revolver plug. Many models include a revolving credit line that automatically grows to cover any cash shortfall. It is a useful mechanism, but it can also paper over a business that simply does not generate enough cash. If your revolver climbs every month, the model is telling you something — listen instead of admiring the balanced sheet.
Too many tabs. Spreading the model across a dozen worksheets multiplies linking errors. A tighter, well-organized structure with grouped sections is easier to audit and far less error-prone.
Forecasts disconnected from history. If your model shows 40% margins when you have never cleared 25%, you need a documented reason. Unexplained optimism is the most expensive line in any model.
Why Clean Books Make the Model Work
A financial model is only as good as the data feeding it. Garbage historicals produce garbage forecasts — and you will not know the difference until a decision based on the model goes wrong.
This is where disciplined bookkeeping pays off. If your revenue is categorized consistently, your expenses are split cleanly between fixed and variable, and your receivables and payables are current, building the model is mostly assembly. If your books are a pile of uncategorized transactions, you will spend more time cleaning data than forecasting — and the forecast you produce will rest on a shaky base. Accurate, well-structured records are not just a compliance task; they are the raw material of every projection you will ever make.
Keep Your Finances Organized from Day One
A three-statement model turns scattered numbers into a forward-looking plan — but it only works when the underlying records are clean and trustworthy. Beancount.io provides plain-text accounting that gives you complete transparency and version control over your financial data, so the historicals feeding your model are accurate and auditable rather than a black box. Get started for free and build your forecasts on a foundation you can actually trust.