Building a Simple Three-Statement Model

Define the measure and its boundaries

A three-statement model links forecast income statements, balance sheets, and cash-flow statements so operating assumptions and financing decisions flow through all three. Supporting schedules drive revenue, costs, working capital, fixed assets, debt, taxes, equity, and cash, while retained earnings and ending cash close the links. Label the entity, period, currency, basis, and source so the boundary is clear before making comparisons.

A model that balances is mechanically consistent, but its assumptions can still be incomplete, biased, or unsupported. Compare like with like, connect movements to transactions, and separate observed facts from assumptions.

Build a reviewable process

Standardize historical statements, build driver schedules, forecast income, roll balance-sheet accounts, derive cash flow, calculate ending cash, and run balance and sign checks. Preserve a reference beside each important input and name the preparer and reviewer so another person can reproduce the work.

Use one source for each assumption, avoid hidden constants, separate inputs from formulas, prohibit unexplained plugs, review circularity, and compare forecast behavior with operating logic. Investigate differences rather than forcing agreement, and keep actual records separate from forecast assumptions.

Calculate and interpret carefully

In a hypothetical cash bridge, $20 net income plus $5 depreciation minus a $4 receivable increase, minus a $2 inventory increase, plus a $1 payable increase equals $20 operating cash flow. Show formulas, signs, units, and rounding, and label every estimate instead of implying unsupported precision.

Integrated formulas do not make revenue, margin, collection, investment, financing, or tax assumptions more likely to occur. Funds, bonds, diversification, and rebalancing can still lose value, and none assures safety or profit.

Document the decision and revisit it

Retain historical mappings, assumption sources, schedules, formula checks, scenario definitions, change log, reviewer notes, and unresolved model limitations. Identify the owner, review date, open questions, and trigger for updating the analysis when facts change.

Building a Simple Three-Statement Model does not produce a universal answer. Keep the work educational and scenario-based, and seek a qualified professional for advice about a specific person or organization.

Hypothetical worked example: three-statement model

A fictional company builds one forecast period to test the links among earnings, operating cash, investing, financing, and ending cash. Every figure is invented for teaching and is not a forecast, benchmark, recommendation, or description of market behavior.

1. Start with hypothetical net income of $20, add $5 depreciation, subtract receivable and inventory increases of $4 and $2, and add a $1 payable increase.
2. Calculate operating cash as $20 plus $5 minus $4 minus $2 plus $1, which equals $20.
3. Record a $30 equipment purchase as investing cash outflow and $15 borrowing as financing inflow, producing a $5 net cash increase.
4. Roll equipment, debt, working capital, retained earnings, and cash onto the balance sheet, then verify assets equal liabilities plus equity.

Three-statement model control sheet

Reuse this review record when applying building a simple three-statement model to a new period or hypothetical scenario.

• Historical layer: source statements, account mapping, normalization, periods, units, and reconciliation differences.
• Driver layer: operating assumptions, evidence, owner, scenario, effective period, and confidence.
• Schedules: working capital, fixed assets, debt, equity, tax inputs, and retained earnings.
• Model checks: balance-sheet balance, cash rollforward, retained earnings, signs, subtotals, and circularity status.
• Review record: sensitivity cases, limitations, formula reviewer, decision use, version, and update date.

Common mistakes

• Forcing the balance sheet to balance with an unexplained cash, debt, or other plug.
• Typing forecast values directly into statements instead of linking them to reviewable operating schedules.
• Assuming mechanical balance proves the forecast is realistic or complete.

Try one

Sources

• Investor.gov financial statement guidanceSEC investor education on researching public companies and understanding market information.
• IRS small business recordkeeping guideIRS guidance on records supporting income, expenses, property basis, returns, and financial statements.