If your forecast is a single spreadsheet of monthly revenue minus monthly expenses, you do not have a financial model. You have a budget. And a budget will not tell you whether you can survive a slow quarter, whether your next hire will starve the bank account in month seven, or whether the inventory build you are planning for the holidays will quietly turn into a credit line emergency in February.
A three-statement model will. It links the income statement, the balance sheet, and the cash flow statement into one connected forecast, so the consequences of every decision—hiring a salesperson, extending net-60 terms, financing a delivery truck—flow through to the only number that ultimately matters: cash on hand.
This guide walks through what a three-statement model is, how to build one without an investment-banking background, and how to use it to answer the questions that keep founders awake at 2 a.m.
Why a Single-Sheet Forecast Is Not Enough
A profit-and-loss forecast on its own hides three things that can sink a profitable business.
Working capital. A growing company that sells on net-30 terms and pays its suppliers on net-15 needs more cash every month, even as the income statement shows record profits. The P&L celebrates the sale; the bank account feels the lag.
Capital expenditure. Buying a $40,000 piece of equipment shows up as a $5,714 annual depreciation expense on the income statement but as a $40,000 cash hit on the day you write the check. A P&L-only forecast will smooth the pain across seven years. Your bank account will not.
Financing. Loan principal payments do not appear on the income statement at all (only interest does). If you are paying down a term loan, your cash will drop by thousands every month that your P&L cannot explain.
The three-statement model captures all three. It treats the income statement as the story of earnings, the balance sheet as the inventory of what the business owns and owes at a point in time, and the cash flow statement as the bridge that reconciles them. When the three are linked correctly, no decision can be analyzed in isolation.
How the Three Statements Link Together
Before building anything, understand the wiring. A three-statement model is not three separate forecasts; it is one forecast viewed through three lenses.
The income statement feeds two destinations
Net income—the bottom line of the income statement—shows up in two places. It is added to retained earnings on the balance sheet, increasing equity. And it is the starting line of the cash flow statement, where you adjust it back into actual cash by removing non-cash items.
The balance sheet stores the cumulative state
Every period's activity changes the balance sheet. Sales on credit increase accounts receivable. Inventory purchases increase inventory. New debt increases the loan balance. The balance sheet is the running tally; the income statement and cash flow statement explain why it changed.
The cash flow statement is the reconciler
The cash flow statement starts with net income, then walks through every change on the balance sheet to convert accrual profit into cash. Depreciation, an expense on the income statement that did not actually consume cash, gets added back. An increase in accounts receivable—a sale you made but have not collected—gets subtracted. The ending cash number it produces flows back to the balance sheet as the new cash balance.
If the model is wired correctly, the balance sheet balances on its own. You should never plug a number to force it.
A concrete example: depreciation
Suppose you buy a $50,000 truck with a five-year life. In year one:
- The income statement shows $10,000 of depreciation expense, reducing net income by roughly $7,500 after tax.
- The balance sheet reduces the truck's net book value from $50,000 to $40,000 and reduces retained earnings by the $7,500 of after-tax income.
- The cash flow statement starts with the lower net income, then adds back the $10,000 depreciation because it did not consume cash. The original $50,000 cash purchase appears once, in the investing section, in the year you bought it.
One transaction, three statements, all linked. This is the muscle the model exercises across hundreds of line items.
The Eight-Step Build
Here is the order that works. Resist the urge to start with revenue and barrel forward—each step builds on the prior one.
Step 1: Enter the historical data
Three years of monthly or annual history is enough for most small businesses. Pull the income statement, balance sheet, and cash flow statement from your accounting software and lay them out side by side. Use one column per period.
A formatting tip that will save you hours of debugging: use one color (traditionally blue) for inputs and historical numbers, and another (traditionally black) for formulas. When something breaks six months from now, you will know at a glance which cells are assumptions and which are calculations.
Step 2: Calculate the historical drivers
Do not forecast revenue as "$X next year." Forecast the things that produce revenue: growth rate, units sold, average price, customers, churn. For each line item, compute the historical ratio that you will use to project the future.
Common drivers to extract:
- Revenue growth rate (year-over-year)
- Gross margin (cost of goods sold as a percent of revenue)
- Operating expenses as a percent of revenue, or fixed dollar amounts that grow with inflation
- Days sales outstanding (accounts receivable divided by daily revenue)
- Days inventory on hand (inventory divided by daily cost of goods sold)
- Days payable outstanding (accounts payable divided by daily cost of goods sold)
- Capital expenditure as a percent of revenue
- Depreciation as a percent of gross property, plant, and equipment
These historical ratios are your starting point. You can then adjust them for what you expect to change.
Step 3: Project the income statement (almost)
Use your drivers to forecast revenue, cost of goods sold, and operating expenses. Stop short of interest expense and taxes. You cannot calculate interest yet because you have not built the debt schedule, and you should not calculate taxes until you know what other deductions apply.
You will come back and finish this statement once the supporting schedules are done.
Step 4: Build the capital asset schedule
Project property, plant, and equipment as a roll-forward: beginning balance plus new purchases minus depreciation equals ending balance. The capital expenditure forecast is an assumption you control; depreciation is calculated based on the useful life you assign. The depreciation number you produce here flows back into the income statement.
Step 5: Build the debt schedule
A similar roll-forward for each debt instrument: beginning balance plus new draws minus principal payments equals ending balance. Multiply the average balance by the interest rate to compute interest expense, which flows back to the income statement.
This is also where the model's only intentional circularity lives. Interest expense reduces net income, which reduces cash, which may change how much debt you need to draw, which changes interest expense. Most modelers either enable iterative calculation in Excel or break the loop by calculating interest on the prior-period debt balance. For a small business model, prior-period is almost always good enough.
Step 6: Finish the income statement
With depreciation and interest in place, you can compute pre-tax income, apply a tax rate, and arrive at net income.
Step 7: Complete the balance sheet (except cash)
Project every balance sheet line except cash:
- Accounts receivable equals days sales outstanding times daily revenue.
- Inventory equals days inventory on hand times daily cost of goods sold.
- Accounts payable equals days payable outstanding times daily cost of goods sold.
- Property, plant, and equipment comes from the capital asset schedule.
- Debt comes from the debt schedule.
- Retained earnings equals prior retained earnings plus net income minus dividends.
Step 8: Build the cash flow statement and plug cash back into the balance sheet
Start with net income. Add back depreciation and other non-cash items. Add or subtract the change in each working capital account (an increase in receivables uses cash; an increase in payables provides it). Subtract capital expenditure. Add net debt issuance. The result is the change in cash, which you add to the prior cash balance to get the new cash balance, which you drop into the cash row of the balance sheet.
If you built every other line correctly, the balance sheet now balances automatically. If it does not, you have a wiring error somewhere—do not plug it. Find it.
Accurate inputs are the bedrock of all of this. A model built on messy books will produce confident-looking nonsense. Whether you keep your records in spreadsheets, in a traditional accounting package, or in plain-text accounting software, the discipline of clean, reconciled, regularly updated books is what makes a forecast worth running. Treat your bookkeeping as the source data layer for every model you will ever build.
Using the Model to Forecast Cash Runway
Once the model runs, the cash row on the balance sheet is your runway. You no longer need a separate runway calculation; the model produces one every month for as far as you forecast.
For early-stage and pre-profit businesses, watch the cash trajectory week by week, not month by month. Averaging the last three months of burn and dividing into the bank balance is a starting point, but a forward-looking model that incorporates known timing—payroll on the fifteenth, a customer payment due on the twentieth, a tax estimate due next month—is dramatically more accurate.
Benchmarks worth knowing:
- Early-stage startups typically target 12 to 18 months of runway, enough time for product and go-to-market work to produce results without forcing a rushed fundraise.
- Service businesses with recurring contracts can operate safely at four to six months of runway when collections are predictable.
- Venture-backed companies raising on milestones generally want at least 12 months between rounds.
If the model shows runway shrinking below your threshold, the answer is rarely a single big cut. It is a sequence of small actions: tighten collections (lower days sales outstanding by a week), stretch payables (raise days payable outstanding by a week), delay a hire by a quarter, defer a capital expenditure. Run each in the model and watch the runway extend.
Pressure-Testing Growth Plans
A forecast that runs only the base case is a fairy tale. The real value of a three-statement model is the ability to ask "what if?" and see every consequence at once.
Build three scenarios
At minimum, build a base case, a downside case, and an upside case. Some firms estimate that running scenario analysis can cut liquidity risk meaningfully versus a single-point forecast—not because the future becomes more predictable, but because the company is no longer caught flat-footed by foreseeable outcomes.
Keep the scenarios honest. A downside that assumes 20 percent growth instead of 30 is not a downside. A real downside contemplates a flat year, a major customer leaving, or a 90-day payment from a key account stretching to 150 days.
Run sensitivity tables
Pick the two or three assumptions that move the model the most—usually revenue growth, gross margin, and days sales outstanding—and build a table that shows how cash at year-end changes as each one varies. This tells you which variables to watch most closely and which to negotiate hardest.
Stress-test the working capital cycle
A growth plan that doubles revenue often doubles working capital needs. Walk through the model with revenue 50 percent higher than base and ask: does the line of credit cover the receivables build? Does the inventory ramp fit within supplier credit terms? A company can grow itself into insolvency, and the three-statement model is where you catch it before it happens.
Common Mistakes That Break the Model
Most three-statement models that "don't balance" fail for a small number of reasons.
Plugging cash or equity to force a balance. If the balance sheet doesn't balance, there is a logic error. Plugging it hides the error and corrupts every downstream number. Find the missing or duplicated link instead.
Linking the same balance sheet item to the cash flow statement twice—or not at all. Every balance sheet item must show up exactly once in the cash flow statement, with the correct sign. A missed item or a sign error is the single most common cause of imbalance.
Using a beginning balance where you need an ending balance. Retained earnings, accumulated depreciation, and other cumulative accounts must always reference the prior period's ending balance plus the current period's activity. A subtle reference to the wrong column can produce errors that compound over years of forecast.
Hardcoding numbers inside formulas. A "0.21" tax rate buried in a calculation cell instead of pulled from a clearly labeled assumption row will haunt you. Every assumption belongs in one place, clearly marked.
Building the entire model in a single sheet. Even a small business model benefits from separating assumptions, calculations, and outputs. Reviewers should be able to find the inputs without hunting.
Forgetting circular references are sometimes intentional. Interest expense calculated on the average debt balance creates a deliberate loop. This is fine if iterative calculation is on and you understand what is happening. It is a disaster if you stumble into it accidentally and the model starts producing infinite chains.
A Note on Tooling
You can build a three-statement model in Excel, Google Sheets, or any of the modern small-business planning tools (Jirav, Cube, Planful, and others ship pre-built three-statement templates). The tool matters less than the discipline.
What matters more is the quality of the historical data flowing in. If your books close late, miscategorize transactions, or rebuild themselves every time someone exports a report, your model will inherit every flaw. A model is a leveraged version of your accounting—it makes good books powerful and bad books actively misleading.
Keep Your Finances Organized from Day One
A three-statement model is only as honest as the bookkeeping behind it. Maintaining clean, reconciled, version-controlled financial records is what turns a forecasting exercise from guesswork into decision-making. Beancount.io provides plain-text accounting that gives you complete transparency and control over your financial data—no black boxes, no vendor lock-in, and books that diff cleanly so you always know what changed. Get started for free and see why developers and finance professionals are switching to plain-text accounting.