3 statement financial model linking the income statement, balance sheet and cash flow statement
Financial Modeling

3 Statement Financial Model: How to Build One in Excel (2027 Guide)

Written by
Varun
Published2026-11-10
Updated2026-11-18

A 3 statement financial model is an Excel model that forecasts a company's income statement, balance sheet and cash flow statement together. Formulas link the three, so changing one assumption, such as revenue growth, updates all of them. Analysts use it as the base for valuation, budgeting, lending and fundraising decisions.

This guide shows you how to build one step by step, with a fully worked three-year example in which every number ties out. It also covers a 2027 change most guides have not caught up with yet: IFRS 18, and India's proposed Ind AS 118, change the line the cash flow statement starts from.

Key takeaways

  • The income statement shows performance, the balance sheet shows position, and the cash flow statement shows where cash came from and went.
  • Five links hold the model together, and net income is the most important one.
  • Build in this order: historical data, assumptions, income statement, supporting schedules, balance sheet, cash flow statement, then checks.
  • A model works when total assets equal liabilities plus equity in every year, and cash on the cash flow statement matches cash on the balance sheet.
  • Under IFRS 18 (effective for annual periods beginning on or after 1 January 2027), the indirect cash flow statement starts from operating profit, not net profit.
IIM SKILLS

Attend a Free 1-Hour Financial Modelling Master Class

Learn key financial modelling concepts, tools and career opportunities.

Faculty

What Is a 3 Statement Financial Model?

A 3 statement financial model links a company's income statement, balance sheet and cash flow statement in one Excel file. It is also called a three-statement model, an integrated financial model or a three-way forecast. Historical years sit on the left, forecast years on the right, and every forecast number comes from an assumption or a formula, never a typed-in figure.

Linking is the whole point. If you raise revenue growth, receivables and inventory rise with it, cash falls for a while, and the balance sheet still balances. Three separate forecasts cannot show you that chain of effects.

The 3 statement model is also the foundation for most other models. A discounted cash flow (DCF) valuation takes its free cash flow from it, and leveraged buyout (LBO) and merger models are built on top of it.

What Questions Does a 3 Statement Model Answer?

  • Will the business have enough cash over the next three to five years?
  • How much debt can it take on, and how fast can it repay it?
  • What happens to profit and cash if sales grow 5% instead of 15%?
  • How much free cash flow is available for a valuation, a dividend or an expansion?
  • Do the founder's or management's targets hold up once cash and working capital are included?

The Three Financial Statements Explained

Each statement answers a different question, and a model needs all three because none of them tells the full story alone. A company can report a profit and still run out of cash.

Statement

Question it answers

Time basis

Key lines you forecast

Income statement (P&L)

Did the business earn more than it spent?

A period (e.g. FY 2026-27)

Revenue, cost of goods sold, operating expenses, depreciation, interest, tax, net income

Balance sheet

What does it own and owe?

A point in time (e.g. 31 March 2027)

Cash, receivables, inventory, PP&E, payables, debt, share capital, retained earnings

Cash flow statement

Where did cash come from and where did it go?

A period

Cash from operating, investing and financing activities, net change in cash

Income Statement

The income statement, called the Statement of Profit and Loss in Indian financial statements prepared under Schedule III of the Companies Act, 2013, starts with revenue and ends with net income. It follows accrual accounting, so it records sales when they are earned, not when the customer pays.

Balance Sheet

The balance sheet lists assets, liabilities and equity on a single date. It must always satisfy one equation: total assets = total liabilities + shareholders' equity. In a model, this equation is your main error check.

Cash Flow Statement

The cash flow statement explains the change in cash between two balance sheets. Most models use the indirect method: start from a profit figure, add back non-cash items such as depreciation, adjust for working capital, then add investing and financing cash flows.

How Are the Three Financial Statements Linked?

The three statements are linked through net income, non-cash items, working capital, capital spending, financing and cash. If you understand these links, you understand the model.

#

Link

From

To

What it means

1

Net income

Income statement

Retained earnings (balance sheet)

Closing retained earnings = opening + net income − dividends

2

Net income

Income statement

First line of cash from operations

The indirect cash flow starts from profit (from 2027 under IFRS 18, from operating profit)

3

Depreciation

Income statement

Cash flow statement and PP&E

Added back as a non-cash cost; it also reduces PP&E on the balance sheet

4

Working capital

Balance sheet

Cash from operations

A rise in receivables or inventory uses cash; a rise in payables releases cash

5

Capex

Cash flow statement

PP&E (balance sheet)

Closing PP&E = opening + capex − depreciation

6

Debt and equity

Cash flow statement

Balance sheet

Borrowing, repayments, share issues and dividends change debt and equity balances

7

Ending cash

Cash flow statement

Cash (balance sheet)

Opening cash + net change in cash = closing cash on the balance sheet

Why Net Income Matters Most

Net income is the only number that touches all three statements. It closes the income statement, it increases retained earnings on the balance sheet, and it is the starting point for operating cash flow in most models.

Why Cash Is Calculated Last

Cash is an output, not an input. You never forecast cash directly. You forecast everything else, and cash is what is left after the cash flow statement adds up every inflow and outflow. If you type a cash figure into the balance sheet, the model will not balance for long.

Image suggestion: a simple flow diagram of the seven links above. Alt text: "How the income statement, balance sheet and cash flow statement are linked in a 3 statement financial model".

How to Build a 3 Statement Financial Model in Excel: 9 Steps

You build a 3 statement model in a fixed order: set up the file, enter historical data, set assumptions, forecast the income statement, build supporting schedules, finish the income statement, forecast the balance sheet, build the cash flow statement, and check the result. Each step uses the output of the step before it.

Step 1: Set Up the Workbook

Choose One Sheet or Several Tabs

A small model fits on one sheet, with the three statements stacked one below the other. Larger models use separate tabs for assumptions, the income statement, the balance sheet, the cash flow statement, schedules and checks. Either works if the flow runs one way: inputs feed calculations, and calculations feed outputs.

Set the Timeline

Put years across the columns: three to five historical years, then five forecast years. Label the historical columns "A" (actual) and the forecast columns "F" or "E" (estimate). Use the company's fiscal year; most Indian companies report for April to March.

Colour-Code Your Cells

Use blue font for hard-coded inputs and historical data, black for formulas, and green for links to other sheets. Anyone checking your model can then see at a glance what is an assumption and what is a calculation.

Step 2: Enter Historical Financial Data

Where to Find the Data

For listed Indian companies, use the annual report on the company's investor relations page or the filings on the BSE and NSE websites. For private companies, use audited accounts shared by management or filings on the MCA portal.

Clean and Standardise the Numbers

Group line items into a consistent format across years. Separate one-off items, such as an asset sale or a write-off, so they do not distort your ratios. Check that each historical balance sheet balances before you go further.

Step 3: Calculate Ratios and Set Assumptions

Work out the historical drivers, then choose forecast values for each one. Keep all assumptions in one block so they are easy to change.

Revenue Assumptions

The simplest driver is annual growth. Better models break revenue into volume × price, stores × revenue per store, or customers × average order value.

Cost Assumptions

Forecast cost of goods sold and operating expenses as a percentage of revenue, and separate fixed costs such as rent where you can.

Working Capital Assumptions

Use days, which are easier to sense-check than raw balances:

  • Receivables = Revenue × Receivable days ÷ 365
  • Inventory = Cost of goods sold × Inventory days ÷ 365
  • Payables = Cost of goods sold × Payable days ÷ 365

Capex and Depreciation Assumptions

Set capex as a percentage of revenue or as planned project amounts. Set depreciation as a rate on opening PP&E, or by asset class using useful lives.

Financing and Tax Assumptions

List planned borrowings and repayments, the interest rate, the dividend payout ratio and the effective tax rate. In India, check whether the company has opted for the concessional 22% corporate tax regime, which works out to an effective rate of about 25.17% after the 10% surcharge and 4% cess (Section 115BAA of the Income-tax Act, 1961; check the matching provision of the Income-tax Act, 2025 for years from April 2026).

Step 4: Forecast the Income Statement Down to Operating Profit

Apply your assumptions to forecast revenue, cost of goods sold, gross profit, operating expenses and EBITDA. For example, if revenue for FY 2025-26 is in cell C10 and growth is in D5, forecast revenue is =C10*(1+D5). Leave depreciation, interest and tax for now, because they come from the schedules.

Step 5: Build the Supporting Schedules

PP&E Schedule

Closing PP&E = Opening PP&E + Capex − Depreciation. Depreciation flows to the income statement; closing PP&E flows to the balance sheet; capex flows to cash from investing.

Working Capital Schedule

Calculate receivables, inventory and payables from the days assumptions. The year-on-year change in each feeds cash from operations.

Debt Schedule

Closing debt = Opening debt + New borrowing − Repayment. Interest expense = Interest rate × Opening debt (or the average balance, which creates a circular reference; see the section on checks below).

Equity Schedule

Closing retained earnings = Opening retained earnings + Net income − Dividends. Add any new share issues to share capital.

Step 6: Complete the Income Statement

Bring depreciation from the PP&E schedule and interest from the debt schedule. Calculate profit before tax, apply the tax rate, and arrive at net income.

Step 7: Forecast the Balance Sheet (Except Cash)

Link every line to a schedule: receivables, inventory and payables from the working capital schedule, PP&E from the PP&E schedule, debt from the debt schedule, and equity from the equity schedule. Leave cash blank for now.

  1. Cash from operations: net income + depreciation − increase in receivables − increase in inventory + increase in payables.
  2. Cash from investing: minus capex (plus any asset sale proceeds).
  3. Cash from financing: new debt − repayments + share issues − dividends.
  4. Closing cash = Opening cash + Net change in cash. Link this to cash on the balance sheet.

Step 9: Check, Stress-Test and Run Scenarios

Add a balance check row (total assets − total liabilities and equity) that should show zero in every year. Then change key assumptions and watch cash, debt and profit respond. The section on checks below covers what to do when the model does not balance.

3 Statement Financial Model Example: A Worked 3-Year Forecast

This example forecasts three years for a fictional company, Aarav Home Products Pvt Ltd, and every number ties out. In the first forecast year, net income is ₹127 lakh, yet cash falls by ₹19 lakh. That gap is exactly what a 3 statement model is built to show.

All figures are in ₹ lakh and rounded to the nearest lakh. FY26 means FY 2025-26 (April 2025 to March 2026). To keep the example simple, tax paid equals tax expense, interest is charged on opening debt, and there is no deferred tax.

Step 1: The Assumptions

Assumption

FY27

FY28

FY29

Revenue growth (FY26 revenue: 1,000)

15%

12%

10%

Cost of goods sold, % of revenue

60%

60%

60%

Operating expenses, % of revenue

20%

20%

20%

Depreciation, % of opening PP&E

10%

10%

10%

Capex, % of revenue

8%

8%

8%

Receivable days (on revenue)

45

45

45

Inventory days (on COGS)

60

60

60

Payable days (on COGS)

40

40

40

Interest rate on opening debt

10%

10%

10%

Debt repayment per year

40

40

40

Tax rate

25%

25%

25%

Dividend payout, % of net income

20%

20%

20%

Step 2: The Income Statement

₹ lakh

FY27F

FY28F

FY29F

Revenue

1,150

1,288

1,417

Cost of goods sold

(690)

(773)

(850)

Gross profit

460

515

567

Operating expenses

(230)

(258)

(283)

EBITDA

230

257

284

Depreciation

(40)

(45)

(51)

Operating profit (EBIT)

190

212

233

Interest expense

(20)

(16)

(12)

Profit before tax

170

196

221

Tax at 25%

(43)

(49)

(55)

Net income

127

147

166

Step 3: The Supporting Schedules

₹ lakh

FY27F

FY28F

FY29F

PP&E: opening

400

452

510

+ Capex

92

103

113

− Depreciation

(40)

(45)

(51)

Closing PP&E

452

510

572

Debt: opening

200

160

120

− Repayment

(40)

(40)

(40)

Closing debt

160

120

80

Retained earnings: opening

130

232

350

+ Net income

127

147

166

− Dividends

(25)

(29)

(33)

Closing retained earnings

232

350

483

Step 4: The Balance Sheet

₹ lakh

FY26A

FY27F

FY28F

FY29F

Cash

80

61

59

69

Trade receivables

120

142

159

175

Inventory

100

113

127

140

PP&E (net)

400

452

510

572

Total assets

700

768

855

956

Trade payables

70

76

85

93

Debt

200

160

120

80

Share capital

300

300

300

300

Retained earnings

130

232

350

483

Total liabilities and equity

700

768

855

956

Balance check (should be 0)

0

0

0

0

Step 5: The Cash Flow Statement

₹ lakh

FY27F

FY28F

FY29F

Net income

127

147

166

+ Depreciation

40

45

51

− Increase in receivables

(22)

(17)

(16)

− Increase in inventory

(13)

(14)

(13)

+ Increase in payables

6

9

8

Cash from operating activities

138

170

196

Capex

(92)

(103)

(113)

Cash from investing activities

(92)

(103)

(113)

Debt repayment

(40)

(40)

(40)

Dividends paid

(25)

(29)

(33)

Cash from financing activities

(65)

(69)

(73)

Net change in cash

(19)

(2)

10

Opening cash

80

61

59

Closing cash (links to balance sheet)

61

59

69

What the Example Shows

  • Profit is not cash. In FY27 the company earns ₹127 lakh but cash falls by ₹19 lakh. Growth ties up ₹29 lakh in extra working capital, capex (₹92 lakh) is more than double depreciation, and ₹65 lakh goes out in repayments and dividends.
  • Every link holds. Net income feeds retained earnings and operating cash flow; depreciation reduces PP&E and is added back; closing cash on the cash flow statement equals cash on the balance sheet.
  • The balance check is zero in every year. That is the proof the three statements are linked correctly.

Download suggestion: offer this example as a free Excel template in exchange for the course brochure form. Suggested file name: 3-statement-financial-model-template-iim-skills.xlsx.

How to Check That Your 3 Statement Model Balances

A 3 statement model is correct when total assets minus total liabilities and equity equals zero in every period, and closing cash on the cash flow statement equals cash on the balance sheet. Build both checks before you share the model.

Add a Balance Check Row

Below the balance sheet, add a row: =Total assets − Total liabilities and equity. Format it so any non-zero value turns red. Add a master check at the top of the model that flags if any year fails.

Handle the Interest Circular Reference

If you calculate interest on the average of opening and closing debt or cash, you create a loop: interest affects net income, net income affects cash, and cash affects interest. Excel flags this as a circular reference.

You have three options:

  1. Use opening balances for interest, as in the worked example above. There is no loop, and the result is close enough for most annual models.
  2. Turn on iterative calculation. In Excel for Windows, go to File > Options > Formulas and tick "Enable iterative calculation". By default, Excel stops after 100 iterations or when values change by less than 0.001 (Microsoft Support).
  3. Add a circuit breaker: a switch cell (1 or 0) that multiplies the interest formula. Set it to 0 to break the loop if the model shows errors, then set it back to 1.

Why Your Model Does Not Balance: Common Causes

Symptom

Likely cause

Fix

Difference is the same in every year

An error in the historical (opening) balance sheet

Check the last actual year balances first

Difference grows each year

A balance sheet item that changes but is missing from the cash flow statement

Make sure every balance sheet line (except cash and retained earnings) has a matching cash flow line

Difference equals depreciation

Depreciation not added back, or PP&E not reduced

Check both ends of the PP&E link

Difference equals twice a number

A sign error: an outflow entered as an inflow

Check the signs of working capital changes and capex

Difference equals dividends

Dividends deducted from retained earnings but not from cash, or the reverse

Check the equity schedule against cash from financing

Cash goes negative

Not an error, but a funding gap

Add a revolving credit line that draws when cash falls below a minimum

Never Plug the Balance Sheet

Do not force the model to balance by typing a number into cash or equity. A plug hides the error and every output that depends on it. Find the source using the table above.

What Changes in 2027: IFRS 18 and Ind AS 118

IFRS 18 Presentation and Disclosure in Financial Statements replaces IAS 1 for annual periods beginning on or after 1 January 2027 (IFRS Foundation). It does not change how much profit a company makes. It changes how the income statement is laid out and where the cash flow statement starts, and both affect how you structure a model.

What IFRS 18 Changes in the Three Statements

Area

Before 2027 (IAS 1 practice)

From 2027 (IFRS 18)

Income statement structure

No required categories; "operating profit" defined differently by each company

Five categories: operating, investing, financing, income taxes and discontinued operations

Required subtotals

None beyond profit for the year

Operating profit, and profit before financing and income taxes

Indirect cash flow starting point

Not specified; most companies started from net profit or profit before tax

Operating profit or loss

Interest paid (non-financial companies)

Operating or financing, by policy choice

Financing

Interest and dividends received (non-financial companies)

Operating or investing, by policy choice

Investing

Dividends paid

Operating or financing, by policy choice

Financing

Company-specific measures such as "adjusted EBITDA"

Disclosed loosely, if at all

Disclosed in one note, reconciled to an IFRS subtotal

The cash flow changes come from IFRS 18's amendments to IAS 7, as summarised by KPMG. Companies must also restate the comparative year when they first apply the standard.

The Worked Example Under IFRS 18

Here is the same company's operating cash flow, starting from operating profit instead of net income. Tax paid stays in operating activities, and interest paid moves to financing.

₹ lakh

FY27F

FY28F

FY29F

Operating profit (EBIT)

190

212

233

+ Depreciation

40

45

51

− Net increase in working capital

(29)

(22)

(21)

− Income tax paid

(43)

(49)

(55)

Cash from operating activities

158

186

208

Cash from investing activities

(92)

(103)

(113)

Interest paid

(20)

(16)

(12)

Debt repayment

(40)

(40)

(40)

Dividends paid

(25)

(29)

(33)

Cash from financing activities

(85)

(85)

(85)

Net change in cash

(19)

(2)

10

The net change in cash is identical. Only the split changes: operating cash flow rises by the interest paid, and financing cash flow falls by the same amount. This matters for any ratio built on operating cash flow, such as cash conversion or debt service coverage.

IIM SKILLS

Download IIM SKILLS Financial Modelling Brochure

Get complete course information offered by IIM SKILLS

Faculty

What This Means for Indian Companies

India's version, Ind AS 118, is converged with IFRS 18 without carve-outs, and the National Financial Reporting Authority (NFRA) has recommended it to the Central Government for notification (Uniqus). The proposed effective date is 1 April 2027, which means FY 2027-28 accounts, with FY 2026-27 restated as the comparative year (Grant Thornton Bharat).

As of 26 October 2026, Ind AS 118 was still awaiting notification by the Ministry of Corporate Affairs, matching changes to Schedule III were expected, and a one-year deferral was reportedly under consideration (CAalley). Check the latest MCA notification before you rely on a date.

How to Update Your Model for IFRS 18

  1. Add an operating profit subtotal and tag every income and expense line as operating, investing or financing.
  2. Start the indirect cash flow from operating profit, and show income tax paid as a separate operating line.
  3. Move interest paid and dividends paid to financing, and interest and dividends received to investing.
  4. Keep a switch to show the old layout, because historical years and peer companies may still use it until they restate.
  5. Reconcile any "adjusted EBITDA" you use to the new operating profit subtotal.

Annual vs Quarterly vs Monthly vs Weekly: Choosing the Model Period

Choose the period based on the decision the model supports: annual for valuation and long-term planning, quarterly for tracking results, monthly for budgets and startups, and weekly for short-term cash management.

Period

Typical forecast horizon

Best for

Who uses it

Annual

5–10 years

Valuation (DCF), long-term strategy, fundraising

Investment bankers, equity research analysts, investors

Quarterly

2–3 years

Comparing forecasts with reported quarterly results

Equity research, listed company finance teams

Monthly

12–36 months

Budgets, startup runway, seasonal businesses

FP&A teams, founders, CFOs

Weekly

Usually 13 weeks

Short-term liquidity and cash crises

Treasury, restructuring advisers, lenders

When Annual Is Enough

An annual model is the standard for valuation and for most interview case studies. It smooths out seasonality, which is fine when the question is what the business is worth.

When You Need Monthly or Weekly

Use monthly periods when cash swings within the year, for example a retailer that builds inventory before Diwali. A 13-week cash flow model tracks receipts and payments week by week, and lenders often ask for one when a company is under financial pressure.

Mixing Periods

Many models forecast monthly for the first year and annually after that. If you do this, make sure working capital days and depreciation rates are converted to the right period length, or your balance sheet will drift.

3 Statement Model Formatting Best Practices

A good model is one another person can check in 10 minutes. These habits make that possible.

Practice

What to do

Why it matters

Separate inputs from formulas

Keep every assumption in one block or tab

You change a number in one place, not twenty

Colour-code consistently

Blue for inputs, black for formulas, green for links to other sheets

Reviewers see what is hard-coded at a glance

No hard-coded numbers in formulas

Write =C10*(1+$D$5), never =C10*1.15

Hidden numbers are the most common source of errors

One formula per row

Use the same formula across all forecast columns

Inconsistent formulas break silently when you extend the model

Flow in one direction

Left to right in time, top to bottom from inputs to outputs

The logic is easy to follow and audit

Label units everywhere

Put ₹ lakh, ₹ crore, % or days in a units column

Mixing lakh and crore is a classic error in Indian models

Build checks in

Balance check, cash check and a master error flag

Errors show up the moment they appear

Keep it as simple as the decision allows

Add detail only where it changes the answer

Big models are slow to build, check and update

For a deeper list, see our guide to financial modeling best practices.

3 Statement Model vs DCF vs LBO vs Budget

A 3 statement model forecasts the financial statements; a DCF, an LBO and a merger model are built on top of it to answer a specific question. A budget is usually a simpler, shorter plan that may not include a full balance sheet.

Model

Main question

Built on a 3 statement model?

Key output

Typical horizon

3 statement model

What will the company's profit, position and cash look like?

It is the base

Linked income statement, balance sheet and cash flow

3–10 years

DCF model

What is the business worth today?

Yes: takes free cash flow from it

Enterprise value, equity value per share

5–10 years plus terminal value

LBO model

What return does a buyer earn if it funds the deal mostly with debt?

Yes: adds deal debt and repayment schedules

IRR and money multiple for the investor

3–7 years

Merger (M&A) model

Does the deal raise or lower the buyer's earnings per share?

Yes: combines two companies' models

Accretion or dilution, pro forma statements

2–5 years

Budget

What will we earn and spend this year?

Not always

Monthly revenue and cost targets

12 months

How a DCF Uses the 3 Statement Model

Free cash flow to the firm is operating profit after tax, plus depreciation, minus capex, minus the increase in working capital. Every one of those numbers comes straight from the 3 statement model. In the worked example, FY27 free cash flow is 190 × (1 − 25%) + 40 − 92 − 29 = ₹61.5 lakh.

Learn the next step in our guide to valuation methods in finance.

Common Mistakes Beginners Make in a 3 Statement Model

Most broken models fail for the same few reasons:

  1. Forecasting cash directly. Cash must come from the cash flow statement, never a typed number or a growth rate.
  2. Forgetting a balance sheet line in the cash flow statement. Every balance sheet item that changes needs a matching cash flow line.
  3. Treating profit as cash. Growth needs working capital and capex, so a growing, profitable company can still run short of cash.
  4. Unrealistic assumptions. Margins that jump with no reason, or working capital days far from history and peers. Always compare forecasts with the last three to five years.
  5. Sign errors. An increase in receivables reduces cash. Getting this backwards is the most common cash flow mistake.
  6. Hard-coding numbers inside formulas. They are invisible and do not update when assumptions change.
  7. Plugging the balance sheet. A plug hides the error instead of fixing it.
  8. Ignoring the 2027 layout change. Comparing a company that reports under IFRS 18 with one that does not, without adjusting operating cash flow, distorts cash-based ratios.

Who Uses a 3 Statement Financial Model?

User

What they use it for

Investment bankers

The base for DCF, LBO and merger models in deals

Equity research analysts

Forecasting earnings and cash flow to set target prices

FP&A and corporate finance teams

Budgets, long-range plans and "what if" scenarios

Bank credit analysts

Testing whether a borrower can service its debt; Indian banks often ask for projected financials in CMA (Credit Monitoring Arrangement) format for working capital loans

Startup founders

Showing investors how much cash the company needs and when

Finance students and job seekers

Building one is a standard test in finance interviews and case studies

Read more about the uses of financial modeling and why companies use financial models.

How to Learn 3 Statement Financial Modelling

The fastest way to learn is to build one yourself. Start with the worked example above, then repeat it with a real listed company's annual report.

  1. Revise accounting basics: how the three statements are prepared and how a transaction affects each. Our glossary of financial modeling terms is a good starting point.
  2. Build a simple model: three historical years, five forecast years, no circular references.
  3. Add detail: a debt schedule with average-balance interest, a revolver, and scenario switches.
  4. Build on it: turn it into a DCF valuation, then try an LBO.
  5. Get feedback: have a trainer or experienced analyst review your model.

If you want guided practice, the IIM SKILLS Financial Modelling Course includes a hands-on 3 statement model project for a retail or manufacturing company, along with other industry modelling projects.

IIM SKILLS

Not Sure Which Course Is Right for You?

Get Expert Guidance to Choose the Right Course for Your Career Goals.

Faculty

Frequently Asked Questions

What Is a 3 Statement Financial Model in Simple Words?

It is a spreadsheet that forecasts a company's profit, what it owns and owes, and its cash, all at once. The three forecasts are linked by formulas, so when you change one assumption, such as sales growth, all three statements update together and stay consistent.

What Are the Three Statements in a 3 Statement Model?

The income statement (profit and loss), the balance sheet and the cash flow statement. The income statement shows performance over a period, the balance sheet shows the financial position on a date, and the cash flow statement explains how cash moved between two balance sheet dates.

How Are the Three Financial Statements Linked?

Net income flows into retained earnings and starts the cash flow statement. Depreciation is added back to cash flow and reduces PP&E. Changes in working capital, capex, debt and equity move through the cash flow statement, and closing cash links back to the balance sheet.

How Do You Build a 3 Statement Financial Model in Excel?

Enter three to five years of historical data, set assumptions, forecast the income statement to operating profit, build PP&E, working capital, debt and equity schedules, complete the income statement and balance sheet, then build the cash flow statement and link closing cash. Finish with a balance check.

Why Doesn't My 3 Statement Model Balance?

Usually a balance sheet item changes without a matching line in the cash flow statement, or a sign is reversed. If the gap is the same every year, check the opening balance sheet. If it equals a single number such as depreciation or dividends, check that item's two links.

What Is the Difference Between a 3 Statement Model and a DCF Model?

A 3 statement model forecasts the financial statements. A DCF model uses the free cash flow from those forecasts, discounts it at the cost of capital and adds a terminal value to estimate what the business is worth today. You need the first to build the second.

How Many Years Should a 3 Statement Model Forecast?

Most annual models show three to five historical years and five forecast years. Valuation models for stable businesses may go to ten years. Monthly models usually cover 12 to 36 months, and weekly liquidity models usually cover 13 weeks.

Does IFRS 18 Change the 3 Statement Model?

It changes the layout, not the logic. From annual periods beginning on or after 1 January 2027, the indirect cash flow starts from operating profit, interest paid moves to financing, and the income statement uses defined categories and subtotals. India's Ind AS 118 is proposed from 1 April 2027, subject to MCA notification.

Is the 3 Statement Model Asked in Finance Interviews?

Yes. Questions such as "walk me through how a ₹10 increase in depreciation affects the three statements" are standard in investment banking, equity research and FP&A interviews. Many firms also give a timed modelling test where you build or complete a 3 statement model.

Can I Build a 3 Statement Model in Google Sheets?

Yes. The logic and formulas are the same as in Excel. Excel is still the norm in banks and finance teams, and it handles large models, iterative calculation and keyboard shortcuts better, so practise in Excel if you are preparing for a finance job.

What Is a 3 Way Financial Model?

It is another name for a 3 statement financial model, used often in Australia, the UK and in accounting software. A 3 way forecast links profit and loss, balance sheet and cash flow, exactly as described in this guide.

Conclusion

A 3 statement financial model links profit, position and cash so you can see the full effect of any business decision. Build it in order, let cash be the last number you calculate, and check that the balance sheet balances in every year. From 2027, also update the layout for IFRS 18 and, once notified, Ind AS 118.

Once your 3 statement model works, you have the base for a DCF, an LBO or a merger model, which is why it is the first model every finance professional learns.

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.

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.

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.

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.