Creating a Three Statement Model in 7 Easy Steps
Financial Modeling

Creating a Three Statement Model in 7 Easy Steps

Written by
Varun Chopra
Published2026-11-10
Updated2026-11-17

Three Statement Model: How to Build One in Excel (With Example) A three statement model is a single Excel workbook that forecasts a company's income statement, balance sheet and cash flow statement together, with every line linked by formulas. Change one assumption, such as revenue growth, and all three statements update. Because the balance sheet must always balance, the model checks itself. It is the base on which DCF, LBO and M&A models are built. This guide explains how the three statements connect, walks through the 7 steps to build the model, and shows a worked example in ₹ crore that you can rebuild in Excel.

Three Statement Model – SEO/GEO Audit & Rewrite

What Is a Three Statement Model?

A three statement model (also called a 3-statement model or an integrated financial model) projects a company's profit, assets, liabilities and cash for the next 3 to 5 years. It starts from historical figures and a short list of assumptions. Formulas then carry each number to wherever it belongs in the other two statements.

Analysts use it to answer questions a single statement cannot. Can the company fund its expansion from its own cash? How much debt can it take on? What happens to cash if customers pay 15 days later? A profit forecast alone hides these answers, because profit is not cash.

The Three Financial Statements Explained

Each statement answers a different question. The model only works once you see how each one feeds the next.

Income Statement

The income statement (profit and loss account) shows whether the company earned more than it spent over a period. It runs from revenue, through cost of goods sold and operating expenses, to EBITDA, then subtracts depreciation, interest and tax to reach net income. Net income is the first number that leaves this statement for the other two.

Balance Sheet

The balance sheet is a snapshot of what the company owns and owes on one date. It must always satisfy one equation: Assets = Liabilities + Shareholders' Equity. If the two sides differ by even ₹1, a link in the model is broken.

Cash Flow Statement

The cash flow statement explains why cash changed between two balance sheet dates. It has three sections: operating activities (cash from running the business), investing activities (mainly capital expenditure) and financing activities (debt, equity and dividends). Its closing cash becomes the cash line on the balance sheet.

How the Three Statements Are Linked

These seven links do most of the work in any three statement model. Build them correctly and the balance sheet balances on its own.

Line item Comes from Goes to

Net income

Income statement

Top of cash flow from operations; added to retained earnings

Depreciation

PP&E schedule

Income statement expense; added back in cash flow; reduces PP&E

Change in working capital

Balance sheet (receivables, inventory, payables)

Cash flow from operations

Capital expenditure

Assumptions / PP&E schedule

Cash flow from investing; increases PP&E

Debt raised or repaid

Debt schedule

Cash flow from financing; changes debt on balance sheet

Dividends paid

Assumptions

Cash flow from financing; reduces retained earnings

Closing cash

Cash flow statement

Cash on the balance sheet

The rule of thumb: every change in a balance sheet item, other than cash, must show up somewhere in the cash flow statement.

How to Build a Three Statement Model in 7 Steps

Build the model in this order. Each step uses the output of the one before it, so skipping ahead is the most common reason links break.

Step 1: Gather Historical Data

Collect 3 to 5 years of income statements, balance sheets and cash flow statements. For listed Indian companies, the annual reports on the company website, BSE or NSE are the usual sources. Enter them in a consistent layout, one column per year, and confirm each historical balance sheet balances before you go further.

Step 2: Set the Forecast Assumptions

Put every assumption on one input sheet. Typical drivers are revenue growth, gross margin, operating expenses as a percentage of revenue, receivable, inventory and payable days (or percentages of revenue), capex, depreciation rate, interest rate and tax rate. Base each one on the historical trend and the company's guidance, and note the source next to it.

Step 3: Forecast the Income Statement Down to EBITDA

Project revenue first, then cost of goods sold and operating expenses using your assumptions. This gives you EBITDA. Stop here for now: depreciation and interest need their own schedules first.

Step 4: Build the Supporting Schedules

The PP&E schedule starts with opening PP&E, adds capex and subtracts depreciation to reach closing PP&E. The working capital schedule forecasts receivables, inventory and payables from your days or percentage assumptions. Supporting schedules keep the main statements short and easy to audit.

Step 5: Build the Debt Schedule and Finish the Income Statement

The debt schedule tracks opening debt, new borrowing, repayments and closing debt, and calculates interest. Link depreciation and interest back to the income statement, apply the tax rate, and you have net income.

Step 6: Forecast the Balance Sheet (Except Cash)

Link each balance sheet line to its source: PP&E and debt from their schedules, working capital items from the working capital schedule, and retained earnings as last year's balance plus net income minus dividends. Leave cash blank. It is the last number in the model.

Step 7: Build the Cash Flow Statement and Check the Balance

Start cash flow from operations with net income, add back depreciation, and adjust for changes in working capital. Add investing and financing flows. Opening cash plus net cash flow gives closing cash, which you link to the balance sheet. Finally, add a balance check row: total assets minus total liabilities and equity. It must show zero in every forecast year.

IIM SKILLS

Get Expert Career Guidance

Attend A Free 1 Hour Financial Modelling Master Class

Faculty

Three Statement Model Example (₹ Crore)

Here is a one-year forecast for a hypothetical manufacturing company. Year 1 is actual; Year 2 is forecast. All figures are in ₹ crore.

Assumptions: revenue growth 10%; cost of goods sold 60% of revenue; operating expenses ₹40 crore; depreciation 10% of opening PP&E; capex ₹15 crore; interest 8% on opening debt; tax rate 25%; receivables 15%, inventory 12.5% and payables 10% of revenue; debt repayment ₹10 crore; dividends ₹5 crore.

Income Statement

₹ crore Year 2 (forecast)

Revenue

220.0

Cost of goods sold

(132.0)

Gross profit

88.0

Operating expenses

(40.0)

EBITDA

48.0

Depreciation

(10.0)

EBIT

38.0

Interest

(4.8)

Profit before tax

33.2

Tax at 25%

(8.3)

Net income

24.9

Cash Flow Statement

₹ crore Year 2 (forecast)

Net income

24.9

Add: depreciation

10.0

Increase in receivables

(3.0)

Increase in inventory

(2.5)

Increase in payables

2.0

Cash from operations

31.4

Capex

(15.0)

Cash from investing

(15.0)

Debt repaid

(10.0)

Dividends paid

(5.0)

Cash from financing

(15.0)

Net change in cash

1.4

Opening cash

20.0

Closing cash

21.4

Balance Sheet

₹ crore Year 1 (actual) Year 2 (forecast)

Cash

20.0

21.4

Receivables

30.0

33.0

Inventory

25.0

27.5

PP&E (net)

100.0

105.0

Total assets

175.0

186.9

Payables

20.0

22.0

Debt

60.0

50.0

Share capital

50.0

50.0

Retained earnings

45.0

64.9

Total liabilities and equity

175.0

186.9

Balance check

0.0

0.0

Trace the links: net income of ₹24.9 crore opens the cash flow statement and lifts retained earnings from ₹45 crore to ₹64.9 crore (after ₹5 crore of dividends). PP&E moves from ₹100 crore to ₹105 crore (plus ₹15 crore capex, minus ₹10 crore depreciation). Closing cash of ₹21.4 crore lands on the balance sheet, and both sides equal ₹186.9 crore.

In a real model, an Indian company under the new tax regime would use an effective rate of about 25.17% instead of a flat 25%.

How to Lay Out a Three Statement Model in Excel

A clean layout makes the model faster to build and easier for someone else to check.

Formatting

Use one colour convention throughout: blue for hard-coded inputs, black for formulas, and green for links to other sheets. Never type a number inside a formula. Keep units (₹ crore, ₹ lakh) in the header of every sheet.

Periodicity

Choose annual, quarterly or monthly periods based on the purpose. Valuation and equity research models are usually annual. Budgeting and cash planning models are often monthly or quarterly, because seasonality matters.

Structure

Separate the workbook into inputs, calculations and outputs. A common structure is: Assumptions → Income Statement → Supporting Schedules → Balance Sheet → Cash Flow Statement → Checks. Some modellers keep all three statements on one sheet; others give each its own tab. Either works if formulas run left to right and top to bottom.

How to Test the Model: Sensitivity and Scenario Analysis

Once the model balances, use it to test decisions.

  • Sensitivity analysis changes one or two inputs and watches one output. For example, how does closing cash move if revenue growth ranges from 5% to 15%? Excel's Data Table feature builds this grid in seconds.
  • Scenario analysis changes several assumptions together into named cases, such as base, upside and downside. A scenario switch on the assumptions sheet (using CHOOSE or INDEX) lets you flip all three statements between cases with one cell.

Common Mistakes in a Three Statement Model

  • Hard-coding numbers in formulas. It hides assumptions and breaks when inputs change.
  • Plugging cash or equity to force a balance. A plug hides the real error. Find the broken link instead.
  • Wrong signs on working capital. An increase in receivables or inventory reduces cash; an increase in payable adds cash.
  • Forgetting dividends or depreciation in one place. Each must appear in two statements.
  • Unmanaged circular references. Calculating interest on average debt creates a loop between interest, net income, cash and debt. Either use opening debt (as in the example above) or enable iterative calculation with a circuit-breaker switch.
IIM SKILLS

Book a Call with career Counsellor

Gain practical financial modelling skills through real-world projects, hands-on Excel sessions, industry-relevant case studies, and expert-led training to prepare for a successful finance career

Faculty

Three Statement Model vs DCF Model

Three statement model DCF model

Purpose

Forecast profit, financial position and cash

Estimate what the business is worth today

Main output

Linked income statement, balance sheet and cash flow

Enterprise value and value per share

Built from

Historical statements and assumptions

Free cash flows taken from the three statement model

Order

Built first

Built on top of it

In practice, a DCF is only as reliable as the three statement model underneath it.

Who Uses a Three Statement Model?

Investment bankers use it as the base for valuation, M&A and LBO models. Equity research analysts use it to forecast earnings and cash. Corporate finance and FP&A teams use it for budgets, funding plans and loan covenants. Startup founders use it to show investors how long their cash will last. It is also one of the most common tests in financial modelling interviews.

Learn to Build Financial Models With IIM SKILLS

Reading about a three statement model is the easy part; building one that balances under deadline is the skill employers test. The IIM SKILLS Financial Modelling Course takes you from Excel basics to integrated three statement, DCF and valuation models through hands-on Excel practice. [Confirm: add the course's real duration, case studies and placement details here.]

New to the subject? Start with why companies use financial models and who uses financial models.

Frequently Asked Questions

What is a three statement model in simple words?

It is one spreadsheet that forecasts a company's profit, its assets and debts, and its cash, all linked together. Change one number and the rest update automatically.

Which statement do you build first in a three statement model?

Start with the income statement, because net income feeds the other two. Build the balance sheet next (except cash) and the cash flow statement last, since it produces closing cash.

Why doesn't my balance sheet balance?

Usually a balance sheet change is missing from the cash flow statement, or a sign is wrong. Check working capital signs, dividends, depreciation and debt movements first. Compare the size of the difference to each line; it often matches the missing item exactly.

How many years should a three statement model forecast?

Most models forecast 3 to 5 years, built on 3 to 5 years of history. Longer forecasts are common for infrastructure or long-contract businesses.

Is a three statement model the same as a DCF?

No. A three statement model forecasts the financial statements. A DCF uses the free cash flows from that forecast to calculate the value of the business.

Can I build a three statement model in Google Sheets?

Yes. The logic is the same. Excel remains the standard in banks and finance teams, mainly for its speed, shortcuts and Data Tables.

What Excel skills do I need to build one?

You need cell referencing, SUM, IF, INDEX/MATCH or XLOOKUP, and Data Tables for sensitivity analysis. Keyboard shortcuts save hours on larger models.

Conclusion

A three statement model links the income statement, balance sheet and cash flow statement so that one set of assumptions drives all three. Build it in order, from historical data and assumptions through the supporting schedules to the cash flow statement, and prove it works with a balance check that reads zero. Master this model and DCF, LBO and M&A models become extensions of what you already known.

Varun Chopra
Written by

Varun Chopra

Founder, The Algebra Group · Ex-PwC, TresVista & Moody's

Seasoned valuation specialist with 10+ years across PwC, TresVista, and Moody's Analytics. Focuses on building institutional-grade models completely from a blank sheet.

Tushar Bharadwaj
Reviewed by

Tushar Bharadwaj

Senior M&A & Infrastructure Investments Specialist, Cube Highways

Over a decade of hands-on transaction advisory experience with Cube Highways, EY, and Macquarie. Expert in complex multi-currency cash flow forecasting and project feasibility.

Raj Arora, CFA
Reviewed by

Raj Arora, CFA

M&A Professional, Wodehouse Capital Advisors · FMVA

Chartered Financial Analyst (CFA) and FMVA certified expert. Leads transaction mandates at Wodehouse Capital Advisors, with prior research tenure at SG Analytics.

Free Download

Get Course Brochure

Detailed curriculum, placement report & fee structure.

Phone

100% Privacy Protected. No Spam Guarantee.

phone
Call
WhatsApp
We are here to help you.
phone
Call
WhatsApp
We are here to help you.