Finxora Logo
Sign In
3-Statement Financial Model: Three-Way Cash Flow Guide
Back to Blog

3-Statement Financial Model: Three-Way Cash Flow Guide

FINXORA
7 min read
financial modeling
finance
forecasting
excel

Link profit and loss, balance sheet and cash flow in a three-statement model. See how a three-way forecast supports an Indian bank loan proposal.

What a three-statement financial model is

A three-statement financial model links the profit and loss account, balance sheet and cash flow in one forecast. A three-way cash flow forecast commonly describes this same linked approach: it forecasts profit, financial position and cash together. It is more than a cash receipts-and-payments list.

A simple link to check in a three-way forecast

Suppose a business makes an additional credit sale of Rs 1,00,000 and the customer has not paid by year-end. Record the sale and its related costs in profit and loss, and carry the unpaid invoice into receivables. Cash should not rise merely because sales rose. Collections in the next period reduce receivables and increase cash.

Apply the same discipline to assets, borrowings and taxes. A loan receipt increases cash and debt; a principal payment reduces both. Depreciation reduces profit and the carrying amount of fixed assets but is not a fresh cash payment. Check the links before extending the forecast across more years.

A three-statement financial model is a single model in which the income statement, the balance sheet and the cash flow statement are built from one set of assumptions and kept linked to each other. Change a driver such as sales growth or the collection period, and every statement updates, so the model shows not only the profit for a year but the cash the business needs and the position it ends the year in.

The three statements answer three different questions. The income statement shows whether the business earns a profit over a period. The balance sheet shows what it owns and owes on the last day of that period. The cash flow statement shows where cash came from and where it went. A model that presents all three together, and keeps them agreeing, is what an investor, a board or a bank wants when the question is whether a plan is fundable.

How the three statements link

The value of the model lies in the links, not in the statements themselves. Each figure is entered once and then carried to every other place it belongs.

  • Net profit flows from the income statement into retained earnings on the balance sheet and into the opening line of the cash flow statement.
  • Depreciation is charged in the income statement, added back in the cash flow statement and accumulated as a reduction of fixed assets on the balance sheet.
  • Working capital — debtors, stock and creditors — uses or releases cash, so a change in any one of them moves both the cash flow statement and the current assets or current liabilities on the balance sheet.
  • Borrowings bring in cash, carry interest into the income statement and reduce through repayment, leaving the closing loan balance on the balance sheet.
  • Capital expenditure leaves the cash flow statement as an investing outflow and appears as an addition to fixed assets.
  • Tax is provided on profit, paid in cash over the year and carried as a liability until it is settled.

Because of these links, the balance sheet becomes the test of the whole model. If assets do not equal liabilities plus equity, a link is broken or a figure has been entered twice.

Why a linked model matters in Indian lending

When a business approaches a bank for a term loan or a working capital limit, the appraisal turns on the relationships the model captures. The credit team reads the projected profit to estimate repayment capacity, the projected balance sheet to check net worth and gearing, and the cash flow to see whether the debt can be serviced in the months the instalments fall due. DSCR, the ratio of receipts to repayments for each year, is calculated from these statements rather than on its own.

A bank's own projection pack is itself a linked statement set. A CMA report for working capital carries an operating statement, a projected balance sheet, a fund flow statement, a cash flow statement and a DSCR analysis, all from the same inputs. A project report for a new unit carries a projected profit and loss account, a projected balance sheet, a cash flow statement, a depreciation chart and month-wise EMI schedules. In both cases a change in one assumption has to move through every statement, which is exactly the discipline a three-statement model imposes.

Steps to build a three-statement model

The order matters, because each statement feeds the next.

  1. Collect the history. Gather three to five years of audited accounts — profit and loss accounts, balance sheets and, where available, cash flow statements — and reconcile them before entering anything, since every projection starts from the last audited closing position.
  2. Set the drivers. Identify what actually moves the business: volume growth, price, gross margin, salary and overhead inflation, debtor and creditor days, stock holding and the interest rate on borrowings. Keep the assumptions in one driver block instead of burying them inside formulas.
  3. Build the income statement. Project sales, direct costs and operating expenses, then interest, depreciation and tax to reach net profit for each year.
  4. Build the balance sheet. Carry fixed assets forward after depreciation and capital expenditure, compute working capital from the debtor, stock and creditor assumptions, and roll borrowings and equity forward with the profit retained.
  5. Build the cash flow statement. Start from profit, add back non-cash items, adjust for working capital movement, then show investing and financing flows to arrive at closing cash.
  6. Balance and test. Confirm the balance sheet ties, then flex the drivers — a slower collection period, a thinner margin, a higher interest rate — and check whether the business still services its debt.

Mistakes that break a model

  • Typing the same figure twice. A hard-coded number in one statement breaks the link to the other two and hides the effect of a change.
  • Interest that ignores the loan balance. Interest has to be worked from the opening and closing borrowings for the year; a flat figure understates the cost in a year with heavy repayment.
  • Ignoring working capital. Growth absorbs cash through debtors and stock, so a plan that shows profit without funding the operating cycle is usually incomplete.
  • No balance check. Without a line that flags the difference, a broken link can sit in the model unnoticed until someone adds the two sides by hand.
  • Uncontrolled versions. Circulating several copies of the file makes it hard to say which assumptions are current.

Excel or dedicated software

Excel remains the common starting point, and for a one-off internal exercise it can be enough. Its cost is maintenance: a new year or a corrected assumption has to be carried through by hand, and every shared copy risks a broken link. Software that builds the statements from one set of inputs takes over the linking, the recalculation and the carry-forward, so the numbers agree by construction rather than by careful checking.

Finxora works this way. The project report software derives the projected profit and loss account, the projected balance sheet, the cash flow statement, the depreciation chart, the EMI repayment schedules, DSCR, the ratio analysis, break-even and the turnover-method working from the project cost and revenue inputs, for each year of the report. The CMA report software does the same for a working capital file, and the same data can seed both. For a single working, such as an amortisation or EMI comparison, the financial calculators cover it without a full model.

Where to start

Begin with the historical closing position and one year of projections, and check that the balance sheet ties before extending the model to five or more years. If the purpose is a bank submission rather than an internal plan, start from the format the credit team expects: a CMA report for working capital limits or a project report for a term loan. The sample documents show how the statements and the debt service working are laid out before any figures are entered.

Frequently Asked Questions

Published on February 14, 2026

Updated on November 18, 2026

Back to Blog

Need bank-ready financials? Create a CMA report or a project report with Finxora in minutes.