How to Build a Financial Model in Excel

Key takeaway

A practical guide to building a linked Excel financial model with assumptions, revenue, costs, statements, valuation and checks.

A financial model is a linked set of Excel schedules that turns a handful of assumptions into a full picture of a company's future — its profit, its cash and its value. A professional model shares one non-negotiable trait: every output traces back to a visible input a reviewer can challenge. There are no hard-coded numbers buried inside formulas. This guide walks through the exact build order a finance professional follows, the formulas behind each layer, and how to generate the whole structure automatically.

The build order that keeps a model linked

Models break when they are built in the wrong sequence. Follow the dependency order below and every schedule has what it needs before it is built, so the three statements reconcile the first time instead of after days of debugging.

#	Layer	What it produces	Key inputs
1	Assumptions	The single source of every driver	Growth %, inflation %, margins, days, tax rate, WACC
2	Revenue	Top line by stream and period	Price, volume, growth rate
3	Costs	Operating expense lines	COGS %, fixed costs, cost inflation
4	CAPEX & depreciation	Asset base and non-cash charge	Capex spend, useful life
5	Working capital	Cash timing adjustment	DSO, DIO, DPO days
6	Debt & tax	Interest, repayments, tax	Loan terms, rate, tax %
7	Statements & valuation	P&L, cash flow, balance sheet, DCF	All of the above, linked

The seven layers of a linked financial model, in build order.

1. Put every input on one assumptions sheet

Start with a dedicated assumptions tab holding revenue drivers, cost ratios, working-capital days, financing terms, the tax rate and your discount rate. Colour-code inputs so reviewers can see instantly what is an assumption and what is a formula. This one discipline is what makes a model auditable — and it is exactly what banks and investors look for.

2. Build revenue from drivers, compounded correctly

Model revenue as Price × Volume, then grow it. The critical detail over a long horizon is that growth compounds geometrically: Revenue in year n = Revenue base × (1 + growth rate)^n. Applying a flat rate to a fixed base instead — the single-rate shortcut most templates take — quietly understates or overstates the top line more every year. Give each stream its own growth rate rather than one blended number.

3. Layer in costs, CAPEX and depreciation

Split costs into variable (a percentage of revenue, such as COGS) and fixed (a monthly or annual amount that inflates each year). CAPEX creates assets that depreciate: Annual depreciation = Cost of asset ÷ Useful life (straight-line). Depreciation is a non-cash expense — it reduces profit and tax but not cash — which is precisely why the cash flow statement adds it back.

4. Adjust for working-capital timing

Profit is not cash. Receivable days (DSO), inventory days (DIO) and payable days (DPO) determine when profit becomes cash. The movement in working capital each period is a cash inflow when it falls and an outflow when it rises — the step that separates a real model from a profit projection.

5. Link the three statements

Net income flows from the income statement into both the cash flow statement (as the starting line) and the balance sheet (into retained earnings). Closing cash from the cash flow statement becomes the cash line on the balance sheet. When assets equal liabilities plus equity in every period, the model is internally consistent.

The one check that proves a model works

If the balance sheet balances in every single period without a plug, the three statements are correctly linked. A model that needs a manual 'plug' to balance has a broken link somewhere — find it before trusting a single output.

6. Add valuation and integrity checks

With unlevered free cash flow in hand, discount it at WACC and add a terminal value to reach enterprise value, then bridge to equity value. Finish with integrity checks — balance-sheet balance, cash-flow tie-outs and sign checks — that flag errors automatically instead of leaving them to be found by an investor.

Values in $000s. Geometric compounding, not a flat add-on — the gap widens every year.

Common mistakes to avoid

Three errors sink most first models: hard-coding numbers inside formulas so no one can trace them; applying a single growth or inflation rate to a fixed base instead of compounding year on year; and forecasting cash on the sale date rather than the collection date. Building from visible, compounding drivers with explicit working-capital days avoids all three.

Skip the manual build

Wiring seven linked schedules by hand is slow and error-prone. EasyFinancialModels generates the entire structure — assumptions, revenue, costs, CAPEX, working capital, debt, tax, three linked statements, a DCF and integrity checks — as a fully formula-linked Excel workbook, with growth and inflation compounded band by band. It is free for a 3-year model, with just your email: enter your assumptions, preview the output, and download an editable workbook.

Frequently asked questions

What are the steps to build a financial model?

Set assumptions, build revenue drivers, add costs, model CAPEX and depreciation, apply working capital, add debt and tax, then link the three statements and a DCF with integrity checks.

How long does it take to build a financial model?

A simple model takes a few hours; an investor-grade three-statement model with valuation can take days. A generator produces a linked workbook in minutes.

What makes a financial model professional?

Visible, colour-coded assumptions; no hard-coded numbers inside formulas; three linked statements that balance every period; and integrity checks that flag errors automatically.

→ Build your financial modeling model free with the Financial Model tool

More Financial Modeling guides

Quarterly Financial Model: When to Use Quarterly Forecasts Instead of Annual Models · Industry Financial Model Templates: How to Choose the Right Revenue Drivers · How to Build a Startup Financial Model for Investors · The Three-Statement Financial Model Explained · SaaS Financial Model: MRR, Churn, CAC & LTV Explained

About the author

Every model is built and reviewed by the project's Financial Advisor — a Fellow Chartered Accountant (FCA) of the Institute of Chartered Accountants of Pakistan (ICAP), Chartered Global Management Accountant (CGMA) and Associate Chartered Management Accountant (ACMA) with around two decades of corporate finance, audit and accounting experience, designing investor-grade financial models across industries. Full credentials and background are available on LinkedIn. More about the author →

← All guides · WACC calculator · DCF calculator · IRR calculator · Inside the 16-sheet model