A financial model connects business assumptions to financial results. It helps you answer a question: will the business generate cash, how much funding might it need, or what happens if sales fall?
Start with a small model you can explain. You do not need to begin with an acquisition, a complicated valuation or hundreds of spreadsheet rows. This introduction shows how a simple operating model works, where it falls short and how to move on to a three-statement model.
What a financial model does
A useful model has four parts: a question, inputs, calculations and outputs. The inputs might include sales volume, prices and costs. Formulas connect them. The outputs show the consequences of the assumptions you entered.
The model is a way to test your reasoning. Its forecast is conditional: if these assumptions hold, these are the calculated results. A spreadsheet cannot remove uncertainty about customers, competitors or future costs.
- Business planning: estimate cash needs before hiring or expanding.
- Investment analysis: compare a purchase price with estimated future cash flows.
- Budgeting: turn operating targets into revenue, expenses and funding requirements.
- Transactions: examine how financing or an acquisition could affect a business.
Build a small operating model
Consider a fictional business that sells one product. Use the same currency throughout. These figures are teaching assumptions, not market benchmarks.
| Item | Assumption or calculation | Monthly amount |
|---|---|---|
| Units sold | Input | 1,000 |
| Price per unit | Input | 50 |
| Variable cost per unit | Input | 30 |
| Fixed operating costs | Input | 15,000 |
| Revenue | 1,000 × 50 | 50,000 |
| Variable costs | 1,000 × 30 | 30,000 |
| Contribution | 50,000 − 30,000 | 20,000 |
| Operating result in this simplified example | 20,000 − 15,000 | 5,000 |
This example leaves out depreciation, interest, tax and several other items. The 5,000 is therefore neither net income nor cash flow. Its purpose is to show the relationship between volume, price and costs.
Put the example into Excel
In column A, enter the labels below. In column B, enter the inputs or formulas. Store assumptions in their own cells so you can change them without rewriting formulas.
| Cell | Label | Enter |
|---|---|---|
| B2 | Units sold | 1000 |
| B3 | Price per unit | 50 |
| B4 | Variable cost per unit | 30 |
| B5 | Fixed operating costs | 15000 |
| B7 | Revenue | =B2*B3 |
| B8 | Variable costs | =B2*B4 |
| B9 | Contribution | =B7-B8 |
| B10 | Simplified operating result | =B9-B5 |
Test the assumptions
Change units sold from 1,000 to 800. Revenue becomes 40,000, variable costs become 24,000 and the operating result becomes 1,000. Sales volume fell 20%, but the operating result fell 80% because fixed costs stayed unchanged.
The break-even volume is fixed costs divided by contribution per unit: 15,000 ÷ (50 − 30) = 750 units. This assumes the selling price, variable cost and fixed-cost level remain constant over the volume range being considered.
Try it: restore volume to 1,000, then increase variable cost per unit to 32. The operating result should be 3,000. Explain the change before checking the spreadsheet.
Why profit and cash are different
The example records sales and costs. It does not say when customers pay, when suppliers receive payment or whether the business must buy equipment.
A business can record a sale this month and collect the cash next month. It may also purchase inventory before selling it. To forecast cash, you need assumptions about timing, working capital, capital expenditure, borrowing and repayments. That is why the next major step is learning to connect the financial statements.
Understand the main model types
- Three-statement model: connects the income statement, balance sheet and cash flow statement.
- Discounted cash flow model: estimates value from forecast cash flows and a discount rate consistent with those cash flows.
- Acquisition model: examines a transaction’s financing and financial effects.
- Leveraged buyout model: follows acquisition financing, debt repayment and investor returns.
- Operating or startup model: focuses on business drivers, spending, cash needs and funding.
Learn the foundations before adding specialist transaction mechanics. An IPO, property or bank model has requirements that a simple operating example does not cover.
What to learn next
- Explain how the three financial statements connect.
- Practise formulas, cell references and consistent units in Excel.
- Build revenue and cost schedules from operating assumptions.
- Add working capital, investment and financing schedules.
- Connect the statements and test whether the results make sense.
Use the financial modeling study plan for the full learning sequence. Check your starting point with the skills checklist, then use the practice-time guide to plan your sessions.
For a valuation example, work through the enterprise-to-equity value bridge. For a specialist application, try the worked rental-property model.
Check your understanding
- Can you identify every input without opening a formula?
- Can you explain why the 800-unit case earns 1,000?
- Can you explain why the operating result is not a cash forecast?
- Can another person change an assumption and understand the result?
If you can answer those questions, you have understood the basic purpose of a financial model. Next, build the example again from a blank sheet without copying the formulas.
Further reading
The ICAEW Financial Modelling Code provides guidance on clear, reviewable models. For spreadsheet references, see Microsoft’s explanation of relative and absolute references.


