
3 Statement Financial Model: How to Build One in Excel (2027 Guide)
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.
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.
Step 8: Build the Cash Flow Statement and Link Cash
- Cash from operations: net income + depreciation − increase in receivables − increase in inventory + increase in payables.
- Cash from investing: minus capex (plus any asset sale proceeds).
- Cash from financing: new debt − repayments + share issues − dividends.
- 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:
- 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.
- 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).
- 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.
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
- Add an operating profit subtotal and tag every income and expense line as operating, investing or financing.
- Start the indirect cash flow from operating profit, and show income tax paid as a separate operating line.
- Move interest paid and dividends paid to financing, and interest and dividends received to investing.
- Keep a switch to show the old layout, because historical years and peer companies may still use it until they restate.
- 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 | 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:
- Forecasting cash directly. Cash must come from the cash flow statement, never a typed number or a growth rate.
- Forgetting a balance sheet line in the cash flow statement. Every balance sheet item that changes needs a matching cash flow line.
- Treating profit as cash. Growth needs working capital and capex, so a growing, profitable company can still run short of cash.
- 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.
- Sign errors. An increase in receivables reduces cash. Getting this backwards is the most common cash flow mistake.
- Hard-coding numbers inside formulas. They are invisible and do not update when assumptions change.
- Plugging the balance sheet. A plug hides the error instead of fixing it.
- 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.
- 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.
- Build a simple model: three historical years, five forecast years, no circular references.
- Add detail: a debt schedule with average-balance interest, a revolver, and scenario switches.
- Build on it: turn it into a DCF valuation, then try an LBO.
- 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.
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.

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

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

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.
Get Course Brochure
Detailed curriculum, placement report & fee structure.
100% Privacy Protected. No Spam Guarantee.



