A profitable forecast can still leave a business short of cash. A three-statement financial model shows why by linking net income to operating cash flow, balance sheet cash and any revolver borrowing needed to cover a shortfall. The key is to connect each schedule so changes in revenue, working capital or debt flow consistently through the forecast.
This guide explains how the income statement, balance sheet and cash flow statement connect, and how to build the model in a clear sequence. You’ll see how net income flows into cash flow, how cash reconciles across the statements and how a revolver can respond when cash falls below the required level. You’ll then learn how to extend the foundation into valuation and other decision-making models. Build the links carefully, and the model becomes a practical tool for understanding performance, funding needs and the assumptions behind both.
Key Takeaways
- Map how each statement’s key accounts connect so forecast changes flow through the model consistently.
- Separate non-cash adjustments and working capital movements to understand why profit and cash flow differ.
- Set clear cash and revolver logic, then test whether the resulting balances reconcile.
- Use the linked model as a foundation for advanced analysis, including DCF valuation and LBO modelling.
What is a 3-Statement Model?
A three-statement financial model links the income statement, balance sheet and cash flow statement in one forecast. Build the schedules so that changes in profit, assets, liabilities and financing flow through consistently.
-
Integrate the Three Financial Statements
Start by laying out the income statement, balance sheet and cash flow statement for matching periods. The income statement records revenue, costs and expenses; the balance sheet shows assets, liabilities and equity at a point in time; and the cash flow statement explains changes in cash. Link net income to retained earnings and interest expense to debt assumptions. Avoid hardcoding figures that should flow from supporting schedules.
-
Link Cash Across Statements
Carry ending cash from the cash flow statement into cash on the balance sheet for the same period. Begin with opening cash, add or subtract the period’s net cash movement, and calculate closing cash. That closing figure becomes the next period’s opening cash. Common mistakes include misaligned periods, omitted cash flows and links to the wrong cells. Excel templates and examples can provide a starting layout, but inspect their formulas before relying on them.
-
Connect PP&E, Depreciation, and Capital Expenditures
Build a property, plant and equipment (PP&E) schedule to track capital assets. Calculate closing PP&E as opening PP&E plus capital expenditures, less depreciation. Capital expenditures represent cash invested in assets, so include them in investing cash flow. Record PP&E on the balance sheet and depreciation expense on the income statement. Add depreciation back in operating cash flow because it reduces accounting income without being a current-period cash payment.
-
Reconcile Cash Flow From Balance Sheet Changes
Compare opening and closing balances for working capital items such as receivables, inventory and payables. Translate each change into its cash flow effect: an increase in receivables uses cash, while an increase in payables provides cash. Check the sign of every movement and confirm that closing cash agrees across both statements. A three-statement model often forecasts several years, so a broken link can distort multiple periods and undermine later analysis.
Net income as the starting point of the cash flow statement
Start the cash flow forecast with net income, then adjust for non-cash items and changes in operating assets and liabilities. Forecast revenue, expenses, working capital and capital expenditures from operating assumptions, not unsupported plugs.
-
Identify Non-Cash Income Statement Items
Identify each income statement item that changes profit without using or generating cash in the period. Depreciation is a key example: it reduces net income but is added back in cash flow from operations. Link the depreciation assumption to the PP&E schedule, and don’t add back a cash expense as though it were non-cash. This keeps reported income distinct from cash generated by operations.
- Forecast revenue using a relevant operating driver, such as units sold multiplied by price, or an appropriate growth assumption. Forecast expenses through drivers such as cost per unit, operating margin or headcount. Choose assumptions that explain the business rather than extending every line by the same growth rate.
- Project working capital items from their operating drivers. Receivables depend on sales and collection timing; inventory depends on demand and stock requirements; payables depend on purchases and payment timing. Forecast capital expenditures through the investment plan, then link them to the PP&E schedule. Each assumption should affect the related balance sheet account and cash flow line.
-
Link Net Income to Retained Earnings
Carry net income from the income statement into retained earnings on the balance sheet. Use the roll-forward formula: closing retained earnings equals opening retained earnings plus net income, less dividends. Keep periods aligned, and model dividends separately so they don’t reduce operating cash flow. If retained earnings doesn’t roll forward, inspect the net income link and any distributions before changing other balance sheet assumptions.

Using cash and revolver accounts as model plugs
Set the cash and revolver logic after completing the forecast cash flow statement. These accounts show whether operating cash funds the business or borrowing covers a shortfall.
- Define the minimum cash balance required by the forecast and use it as the liquidity threshold. If pre-financing cash exceeds that threshold, apply the excess according to the model’s financing assumptions. If cash falls short, calculate the revolver draw needed to restore the minimum. Don’t use cash and revolver balances as simultaneous plugs: that can conceal a funding gap or create inconsistent debt.
-
Reconcile the Cash Flow Statement
Complete the operating, investing and financing sections before calculating the cash plug. Begin with opening cash, then add the net movement from all three sections to derive closing cash. Link that closing balance to the balance sheet and carry it forward to the next forecast period. Check that each borrowing or repayment appears in financing cash flow, rather than being entered only as a balance sheet adjustment.
-
Check Model Balance and Errors
Check that total assets equal total liabilities plus equity in every forecast period. Confirm that cash agrees between the balance sheet and cash flow statement, then trace any difference to its source. A three-statement model isn’t error-free just because the balance sheet balances: a hardcoded adjustment can hide a broken link. Review formulas, signs and period references when a balance changes unexpectedly.
- Calculate the revolver draw as the shortfall between minimum cash and pre-financing cash, subject to the facility’s available capacity. When cash exceeds the minimum, model repayments only up to the outstanding revolver balance. This prevents negative debt and repayments that push cash below the threshold. Keep draw and repayment logic explicit so liquidity changes are easy to trace.
- Test the completed forecast by changing an operating assumption, such as revenue growth, and tracing its effect on cash. A template can speed up setup, but inspect its accounting links rather than assuming they fit your business. Review how working capital and capital expenditures affect liquidity, and check whether interest expense changes when revolver debt changes.
Building advanced financial models
Start with historical financial results, then extend the statement links into forecasts and decision tools. Use this sequence to create a reliable foundation for DCF valuation, LBO analysis and other advanced models.
- Set the timeline and format before entering assumptions. A three-statement financial model may include three years of historical results and a five-to-ten-year forecast, but these are starting points, not fixed requirements. Choose the periods that fit the business, available data and modelling purpose. For an annual model with recent interim results, use a three-, six- or nine-month stub period where it fits. Keep each period aligned across the income statement, balance sheet and cash flow statement.
- Enter historical financial statements and check how they relate before forecasting. Confirm that each period’s balance sheet balances, cash agrees with the cash flow statement, and retained earnings reflects net income and distributions. A single worksheet can help reduce formula mis-links when periods sit in the same columns. Clear formatting also makes historical inputs easier to distinguish from forecast formulas.
- Build assumptions around measurable business drivers. Forecast revenue from price, volume or growth; link margins to operating costs; and calculate working capital from receivable days, payable days or inventory turns. Connect capital expenditures and depreciation to a PP&E schedule. Change one assumption at a time to see whether its effect flows through all three statements as expected.
- Extend the linked forecast for its intended decision. An annual DCF valuation does not have a universal minimum number of explicit forecast years before terminal value. Choose a forecast period long enough to represent the business’s expected cash flows and reach a suitable basis for terminal value; the period depends on the business and modelling purpose. A leveraged buyout model adds debt schedules, interest expense and repayment logic to assess financing and returns. Keep these analyses connected to the operating forecast instead of rebuilding assumptions independently. The DCF and valuation course covers this next modelling application.
- Test the model with scenarios and trace the outputs back to their drivers. For example, lower revenue growth can reduce profit, change working capital needs and tighten cash availability. Check balance sheet balance, cash reconciliation and debt movement under each scenario. The model is ready for decision-making when its outputs remain traceable to historical inputs, operating assumptions and supporting schedules.
A well-built three-statement financial model can provide an operating foundation for decisions beyond the forecast. Test how changes in business drivers affect liquidity, borrowing needs and valuation, then tailor the model to the decision at hand. This discipline turns spreadsheet outputs into analysis you can explain and defend.
For a structured next step, Financial Modelling University offers online training in LBO Financial Models and DCF & Valuation, with a Real Estate Models course upcoming. Choose the path that matches the model you want to build, and practise applying its techniques to realistic financial modelling problems. Explore the available financial modelling courses and keep developing your Excel skills with purpose. Each well-tested model builds a stronger foundation for the next.
Frequently Asked Questions
How to Handle a Circularity in Excel?
First identify which formulas depend on one another, then decide whether the circular link reflects the financing logic. Revolver interest, for example, may depend on average debt, while debt depends on cash available after interest. Break the loop with an explicit assumption or use Excel’s iterative calculation settings. Document the method and test whether the model converges consistently when key assumptions change.
SEC EDGAR: How to Gather Data for Financial Modeling?
Use SEC EDGAR filings to collect a company’s reported financial statements and supporting disclosures. Start with annual reports, then review interim filings for more recent performance. Before importing figures into Excel, record the filing period, units and accounting basis. Read the notes for segment definitions, one-off items and debt terms. This context helps prevent misleading comparisons across periods or between companies with different reporting presentations.
What Skills are Required in Financial Modeling?
Financial modelling requires accounting knowledge, Excel proficiency and the ability to translate business assumptions into formulas. Build your skills by explaining what each key output means, not just by writing formulas. Practise tracing formula precedents, using scenario analysis and documenting assumptions. Clear documentation matters: another analyst should be able to follow your logic, understand your inputs and reproduce the result without relying on unexplained hardcodes.
What Can an Integrated Financial Forecast Help Assess?
An integrated forecast helps assess how changing business conditions could affect decisions. For example, compare a base case with a downside case where customer demand weakens, then examine whether planned investment or financing remains viable. Use scenario analysis to isolate the assumptions driving the difference. The forecast is most useful when decision-makers can connect each scenario’s output to a clear operating assumption.
How Do Links Between Financial Statements Help Test a Forecast?
They let you trace an assumption through the forecast instead of reviewing isolated outputs. In Excel, select a key result and inspect its formula precedents to see which inputs drive it. Then change one assumption and observe whether the affected schedules respond as intended. If an output doesn’t change, look for a missing formula link or hardcoded value in that calculation path.
What Historical Financial Data Is Needed to Build a Forecast?
Collect comparable reporting periods and supporting details that explain material movements, such as segment performance, debt terms, asset additions and unusual expenses. Include notes that clarify changes in accounting presentation or fiscal period length. These details help distinguish a lasting operating trend from a one-off event. Keep source references beside inputs so you can trace each historical figure back to its filing during review.




