How to Build a Three-Statement Financial Model

By Kevin Fernando · Sep 17, 2026 · 12 min read

A three-statement financial model integrates a company's income statement, balance sheet, and cash flow statement by projecting each one forward based on historical data and assumptions, then verifying that retained earnings, cash balances, and debt tie correctly across all three statements.

A three-statement financial model connects a company's income statement, balance sheet, and cash flow statement into a single integrated system. You forecast each statement forward based on historical data and explicit assumptions, then verify that the three statements tie together correctly: net income flows to retained earnings, changes in working capital affect cash from operations, and cash balances reconcile across all three.

This guide walks through the mechanical work of building that system. It assumes you can read a 10-K, understand basic accounting, and have access to a spreadsheet. The goal is a model that works, one where every number links to its source, where the balance sheet balances in every period, and where you can change a single assumption and watch the effect ripple through all three statements.

What you will build and what you need first

You will build a spreadsheet that projects three financial statements forward, typically three to five years. The model takes historical data as input, applies your assumptions about revenue growth and operating margins, and produces a complete set of pro forma statements. The payoff is a system where you can test "what if" scenarios: what if revenue grows at one rate instead of another, or what if the company spends more on capital equipment?

You need four things to start. First, access to the company's filed financial statements, typically the most recent 10-K and 10-Q, which provide audited annual statements and unaudited quarterly statements. Second, a spreadsheet application. Third, a clear understanding of what you are trying to model: are you projecting five years, or one? Are you assuming the company maintains its current capital structure, or does it raise debt? Fourth, a list of explicit assumptions written down before you build: revenue growth rate, operating margin, tax rate, capital expenditure as a percentage of revenue, and any other driver that changes the forecast.

Gather four quarters of historical financial statements

Pull the company's most recent 10-K and 10-Q filings from the SEC's EDGAR database or the company's investor relations website. Extract the consolidated income statement, consolidated balance sheet, and statement of cash flows from each filing. Organize them in your spreadsheet in chronological order, left to right, with the oldest quarter on the left and the most recent on the right.

For each statement, copy the full line items, not just the totals. You will need revenue, cost of goods sold, each operating expense category, interest expense, taxes, and net income from the income statement. From the balance sheet, you will need cash, accounts receivable, inventory, property plant and equipment, accumulated depreciation, accounts payable, accrued expenses, debt, and shareholders' equity. From the cash flow statement, you will need operating cash flow, capital expenditures, and financing activities.

Check that your historical data is accurate by comparing your spreadsheet totals to the filed statements. If net income does not match, you have a data entry error. Find it and fix it before you move forward. This step takes time, but it is the foundation for everything that follows.

Set up your income statement forecast

The income statement is the starting point for your model because it produces net income, which flows to retained earnings on the balance sheet and serves as the first line of the cash flow statement. You will project it in order from top to bottom: revenue, cost of goods sold, operating expenses, operating income, interest and taxes, and finally net income.

Project revenue and cost of goods sold

Start with the revenue line. Calculate the historical growth rate by dividing the most recent quarter's revenue by the prior quarter's revenue, or the most recent year by the prior year, depending on your forecast horizon. If you have four quarters of data, you can calculate four growth rates and average them, or you can calculate the compound annual growth rate over the full period. Write down your assumption: "Revenue grows at a specified rate annually" or "Revenue grows at a specified rate per quarter."

Apply that growth rate to the most recent historical revenue to project the next period. Continue that forward for each period you are forecasting.

Next, project cost of goods sold. Calculate the historical gross margin: (Revenue minus Cost of Goods Sold) divided by Revenue. If you have four quarters of data, calculate the margin for each quarter, then average them or note whether the margin is trending up or down. Apply that margin to your projected revenue.

Common error: applying the most recent quarter's margin to all future periods when the margin has been trending. If gross margin has improved every quarter, assume it continues to improve, but at a slowing rate. If it has been flat, flat is reasonable. If it has been declining, ask yourself why before you assume it stabilizes.

Calculate operating expenses and operating income

Operating expenses typically include sales, general and administrative (SG&A), research and development (R&D), and other operating costs. Calculate each as a percentage of revenue using historical data. If SG&A has averaged a certain percentage of revenue over the past four quarters, project it as that percentage of your forecasted revenue going forward. If R&D is more stable in absolute dollars, project it as a fixed amount.

Subtract projected operating expenses from projected gross profit to get operating income (also called earnings before interest and taxes, or EBIT). This is the profit the company earns from its core business, before financing decisions and taxes.

Common error: assuming operating expenses stay flat in absolute dollars when revenue is growing. If revenue grows but you keep SG&A at last year's level, you are implicitly assuming the company gets more efficient. That is possible, but write it down as an assumption. Do not let it happen by accident.

Forecast interest, taxes, and net income

Interest expense depends on the company's debt level and interest rate. For now, use the historical average interest expense as a percentage of total debt, or calculate it as a fixed amount if the company's debt is stable. You will refine this when you forecast debt on the balance sheet.

Subtract projected interest expense from operating income to get earnings before taxes (EBT). Then apply a tax rate. Calculate the historical effective tax rate by dividing total income tax expense by earnings before taxes for each historical period. Average those rates. If the company has not paid taxes in recent years, use a normalized tax rate for your industry rather than the historical rate, which may not reflect forward-looking reality.

Multiply EBT by your tax rate to get tax expense. Subtract tax expense from EBT to get net income. This is your bottom line for the period.

Check: Does your net income make sense relative to revenue and margins? If your calculated net income seems disproportionate to revenue, you have an error.

Build your balance sheet forecast

The balance sheet projects assets, liabilities, and equity forward. It must balance in every period: Assets = Liabilities + Equity. You will project each major category using historical ratios or assumptions, then verify that the equation holds.

Project current assets and working capital

Current assets include cash, accounts receivable, inventory, and other short-term assets. Start with accounts receivable. Calculate days sales outstanding (DSO): (Accounts Receivable / Revenue) times 365. If DSO has averaged 45 days, then for every dollar of daily revenue, the company has 45 cents sitting in receivables. Apply that ratio to your projected revenue.

Project inventory the same way. Calculate days inventory outstanding (DIO): (Inventory / Cost of Goods Sold) times 365. Apply it to projected cost of goods sold.

Project accounts payable using days payable outstanding (DPO): (Accounts Payable / Cost of Goods Sold) times 365.

Cash is the balancing item on the balance sheet. You will calculate it last, after you have projected everything else and verified that assets equal liabilities plus equity. For now, leave it blank.

Common error: using the same DSO, DIO, and DPO for every forecast period when the company is changing how it operates. If the company is automating its supply chain, DIO might decline. If it is expanding into markets with longer payment terms, DSO might rise. Adjust these ratios if you have reason to believe they will change.

Project fixed assets and depreciation

Fixed assets are property, plant, and equipment (PP&E). The balance sheet shows net PP&E: gross PP&E minus accumulated depreciation. To project it forward, you need to know how much the company is spending on capital expenditures and how much it is depreciating existing assets.

Calculate the historical ratio of capital expenditures to revenue. Assume it continues at that rate. Multiply your projected revenue by that percentage to get projected capex.

Depreciation expense comes from the income statement and reduces accumulated depreciation on the balance sheet. Calculate the historical ratio of depreciation expense to gross PP&E. Apply that rate to your projected gross PP&E.

Project net PP&E as: Prior Period Net PP&E + Capex - Depreciation Expense.

Common error: forgetting that capex increases gross PP&E but depreciation reduces accumulated depreciation, not gross PP&E. The two work in opposite directions. If you add capex and subtract depreciation from net PP&E, you get the right answer. If you subtract both, you will understate assets.

Project liabilities and equity

Liabilities include accounts payable (which you already projected), accrued expenses, and debt. For accrued expenses, calculate the historical ratio to revenue or to operating expenses, and apply it forward. For debt, you have two choices: assume it stays constant, or assume it changes based on your financing assumptions.

If you assume debt is constant, use the historical level. If you assume the company maintains a target debt-to-equity ratio, or a target debt-to-EBITDA ratio, calculate what debt needs to be to hit that target, given your projected equity and EBITDA.

Equity consists of common stock, retained earnings, and other comprehensive income. Common stock typically stays constant unless the company issues new shares. Retained earnings grow by net income and shrink by dividends. Assume a dividend payout ratio based on historical practice. Retained earnings in the forecast period = Prior Retained Earnings + Net Income - Dividends.

Once you have projected all assets, liabilities, and equity except cash, calculate cash as the balancing item: Cash = Total Assets - (Total Liabilities + Equity without Cash). If this number is negative, the company needs to raise cash or reduce spending. If it is very large, the company is accumulating cash faster than it is deploying it.

Build your cash flow statement forecast

The cash flow statement has three sections: operating cash flow (cash generated from running the business), investing cash flow (cash spent on or received from assets), and financing cash flow (cash from or paid to creditors and shareholders). You will derive each section from the income statement and balance sheet changes.

Calculate operating cash flow

Start with net income from the income statement. Add back non-cash expenses: depreciation and amortization. These reduced net income but did not use cash, so you add them back to get to cash earnings.

Then adjust for changes in working capital. If accounts receivable increased, the company tied up additional cash waiting for customers to pay. That is a use of cash, so subtract it. If accounts payable increased, the company delayed paying suppliers. That freed up cash, so add it. The rule: increases in current assets are uses of cash (subtract them); increases in current liabilities are sources of cash (add them).

Operating Cash Flow = Net Income + Depreciation and Amortization - (Change in Receivables) - (Change in Inventory) + (Change in Payables) + (Change in Accrued Expenses).

Common error: forgetting to adjust for working capital changes. A company can be profitable on an accrual basis but run out of cash if it is financing a rapid expansion of receivables or inventory. The working capital adjustment catches this.

Calculate investing and financing cash flows

Investing cash flow is straightforward: it is negative capex (cash spent on capital expenditures) plus any proceeds from selling assets. In most cases, it is just negative capex.

Financing cash flow includes debt issuance or repayment, equity issuance, and dividends paid. If debt increases, the company issued net debt (positive financing cash flow). If debt decreases, that is a use of cash (negative financing cash flow). Dividends paid are a use of cash (negative financing cash flow).

Financing Cash Flow = (Change in Debt) - Dividends Paid.

The sum of operating, investing, and financing cash flows equals the net change in cash for the period. This should match the change in the cash balance on the balance sheet.

Link the three statements together

Now verify that the three statements tie together. This is where errors surface. If retained earnings does not match, or if the balance sheet does not balance, or if cash does not reconcile, you have a broken link.

Reconcile net income to retained earnings

Net income from the income statement should flow to retained earnings on the balance sheet. Specifically: Retained Earnings in Period T = Retained Earnings in Period T-1 + Net Income in Period T - Dividends in Period T.

Check this formula in your spreadsheet for each forecast period. If retained earnings does not match, either your net income is wrong, your dividend assumption is wrong, or your formula is broken. Find and fix it.

Reconcile balance sheet changes to cash flow

The net change in cash on the balance sheet should equal the sum of operating, investing, and financing cash flows on the cash flow statement. Specifically: Cash in Period T = Cash in Period T-1 + Operating Cash Flow + Investing Cash Flow + Financing Cash Flow.

If this does not match, you have an error in one of the three cash flow components. Work backward: calculate what the net change in cash should be from the balance sheet, then check each cash flow section to find the discrepancy.

Check that the balance sheet balances

In every period, Assets must equal Liabilities plus Equity. Create a formula that checks this: Assets - (Liabilities + Equity) should equal zero. If it does not, you have either a data entry error or a missing link. Common culprits: you projected assets but forgot to project a liability, or you are missing the cash balancing item.

Test your model and identify common errors

Before you use the model to test scenarios, verify that it works correctly on historical data and that your assumptions are reasonable. This section teaches you how to spot the most common errors.

Verify historical periods match actual reported results

In the columns where you entered historical data, your model should reproduce the company's actual net income, cash flow, and balance sheet totals exactly. If your historical net income does not match the 10-K, you have a data entry error or a formula error in your income statement. Find it now, because if your model does not work on actual data, it will not work on forecasts.

Check each of the three statements: income statement net income, cash flow statement net change in cash, and balance sheet totals. All three should match the filed statements.

Check for circular references and broken links

A circular reference is a formula that depends on itself, directly or indirectly. For example, if your cash forecast depends on debt, and your debt forecast depends on a debt-to-cash ratio, you have created a circular reference. Most spreadsheet applications will warn you about direct circular references, but indirect ones can hide.

A broken link is a formula that references a cell that is empty or contains an error. If your operating cash flow formula references a depreciation cell that is blank, the result will be wrong or show an error.

Go through each formula in your model and trace its inputs. Make sure every input is either a historical number you entered, an assumption you wrote down, or a formula that depends only on cells upstream of it. If a formula depends on something downstream, or on itself, you have a broken link.

Sense-check forecast assumptions

Review each assumption you made and ask whether it is reasonable. Is revenue growth at your assumed rate? Look at the historical growth rate. If the company has grown at a higher rate for the past five years, your assumption is conservative. If it has grown at a lower rate, your assumption assumes acceleration, write down why you believe that will happen. Is operating margin at your assumed level? Look at the historical trend. If margin has been trending upward, your assumption is reasonable. If margin has been declining, do not assume it stabilizes without a reason.

Common assumptions to question: revenue growth that accelerates indefinitely, margins that improve without investment, capital intensity that declines as the company grows, and tax rates that are much lower than the historical rate. None of these are impossible, but all of them require justification. If you cannot articulate why an assumption is reasonable, change it.

Do this automatically

Building a three-statement financial model manually requires extracting historical data from SEC filings, calculating growth rates and expense ratios across multiple line items, and then projecting those assumptions forward across income statements, balance sheets, and cash flow statements, a process that typically consumes 8 to 12 hours for an analyst to complete accurately for a single company. Software can automate the data extraction from financial filings, apply consistent formulas across all three statements, and recalculate projections instantly when assumptions change. IMBeacon.ai runs this kind of analysis end to end and cites every figure back to its original source, across as many subjects as you need, with Mimir attaching a citation to every figure. It will not tell you whether to buy the stock. That judgment stays yours, and deliberately so. Every plan includes it, including the free one.

Start your first report and run it on something you already know well.

This article is general research and information about financial concepts. It is not investment advice, and it does not account for your circumstances or objectives. Nothing here is a recommendation to buy, sell, or hold any security.