Financial modelling is building a spreadsheet that represents a business's finances to forecast performance and support decisions. Beginners should understand the three financial statements, separate assumptions from calculations, build a simple linked model (revenue, costs, profit, cash and balance sheet), add scenarios, and check that the model balances and is easy to follow.
What financial models are used for
- Budgeting and forecasting.
- Valuing a business or project.
- Deciding whether to invest or borrow.
- Planning a startup's funding needs.
- Testing "what if" scenarios.
Foundations: the three statements
- Income statement: revenue, costs and profit over a period.
- Balance sheet: assets, liabilities and equity at a point in time.
- Cash-flow statement: cash coming in and going out.
In a good model, these are linked so changes flow through consistently.
Structure
- Inputs and assumptions: growth rates, prices, costs, tax rates.
- Calculations: revenue build, cost schedules, depreciation, working capital, debt.
- Outputs: statements, key metrics, charts.
A simple first model
Model a small tutoring business:
- Revenue: students per month × fee.
- Costs: tutor pay, marketing, tools, rent.
- Profit: revenue minus costs, minus tax.
- Cash: profit adjusted for timing of payments.
- Scenarios: best, base and worst cases for student numbers.
Best practices
- Keep inputs in one place, clearly marked.
- One formula per row, consistent across columns.
- Avoid hard-coded numbers in formulas.
- Add checks, such as balance sheet balancing.
- Keep it as simple as possible.
Common mistakes
Circular references without control, inconsistent time periods, hidden assumptions and overly complex models.
Next steps
Learn valuation basics (discounted cash flow), sensitivity analysis and presenting results. Our finance and financial modelling tutoring teaches this step by step. See also Excel for accountants.
Frequently asked questions
Do I need an accounting background?
Basic understanding of financial statements helps a lot; it can be learned alongside.
Which software is used?
Excel is the standard; some teams also use specialised tools and Google Sheets.
Is financial modelling useful outside finance jobs?
Yes, for founders, managers and anyone making financial decisions.
