What it means
A model is not a forecast, it is the machine that produces forecasts. The forecast is one set of outputs from one set of assumptions, while the model is the structure that lets you produce a hundred of them and compare them fairly.
Most business models share a common architecture. Inputs sit in one clearly marked area, calculations happen in a middle layer, and outputs appear in summary schedules, with no hard-coded numbers buried inside formulas.
That separation is what makes a model auditable by someone other than its author. The workhorse in corporate finance is the three-statement model, which links the profit and loss account, balance sheet and cash flow statement so that they stay consistent.
Change the sales assumption and receivables move, cash moves, and the balance sheet still balances. If it does not balance, something in the logic is wrong, which is why the check row exists.
Beyond that sit specialised structures: discounted cash flow models for valuation, leveraged buyout models for private equity, project finance models for infrastructure, and operating models for budgeting. They differ in output but share the same discipline of transparent inputs, consistent time periods and visible checks.
The nuance that separates useful models from decorative ones is sensitivity. The point of building the structure is to ask what happens if churn doubles, if the launch slips a quarter, or if input costs rise 12%, and to see which assumptions actually move the answer.
Detail is not accuracy, and a model that nobody can challenge is worse than a simpler one that everyone understands.
In practice
Real-world examples.
Example
A founder building a seed pitch constructs a model linking marketing spend, cost per acquisition, churn and average revenue per user. Investors change the churn assumption from 2% to 4% a month during the meeting, and the model shows the runway shortening from eighteen months to eleven.
Example
A manufacturer evaluating a $2,400,000 automation project builds a discounted cash flow model comparing labour savings against maintenance costs over eight years. The payback period and net present value together decide whether the investment proceeds.
Example
A private equity team modelling the acquisition of a veterinary chain links the purchase price, debt schedule, clinic-level revenue and exit multiple. The model shows the deal only meets the fund's return target if two additional clinics are opened in the first three years.
Think of it
“Financial modeling is like building a flight simulator for business decisions. You can test scenarios before committing real resources.
Formula
Calculation
There is no single formula, but a simple driver-based operating model shows the mechanics. Start with the revenue build, apply gross margin, subtract operating costs.
Revenue = Customers x Monthly Fee x 12
Gross Profit = Revenue x Gross Margin %
EBITDA = Gross Profit - Operating Costs
A subscription software business has 2,500 customers paying $200 a month, a gross margin of 70% and annual operating costs of $3,000,000.
Revenue = 2,500 x $200 x 12 = $6,000,000
Gross Profit = $6,000,000 x 0.70 = $4,200,000
EBITDA = $4,200,000 - $3,000,000 = $1,200,000
Now run the sensitivity the model exists for. If customer numbers come in 10% lower at 2,250, revenue falls to 2,250 x $200 x 12 = $5,400,000, gross profit becomes $5,400,000 x 0.70 = $3,780,000, and EBITDA drops to $3,780,000 - $3,000,000 = $780,000. A 10% shortfall in customers cuts EBITDA by 35%, because the operating cost base is fixed, and that is precisely the insight a decision maker needs.Case study
Seen in the real world.
Calderfield Learning is a fictional online training company invented to illustrate financial modelling. Its founders had a spreadsheet with revenue typed directly into each month, no visible assumptions and formulas that referenced cells three tabs away, and when an investor asked what would happen if enrolment slipped by 20%, nobody could answer within the meeting.
They rebuilt the model over two weeks with a strict layout: a single input tab holding thirty-one named assumptions, a calculation tab per business line, and three linked statements with a balance check. Every input cell was colour coded, and no number was hard-coded inside a formula anywhere in the file.
The rebuilt model changed the conversation rather than the business. It showed that course completion rate, not new enrolment, was the assumption the outcome was most sensitive to, because completion drove renewals and referrals. The founders redirected roughly $180,000 of planned advertising spend into tutor support, and in this illustrative example that decision came directly from being able to test assumptions quickly.
Watch out
Common mistakes.
- Hard-coding numbers inside formulas rather than keeping every assumption in a clearly marked input section, which makes the model impossible to test or audit.
- Confusing detail with accuracy, since a model with four hundred rows built on three shaky assumptions is no more reliable than a short one built on the same assumptions.
- Building the model and never running downside scenarios, when identifying which assumptions actually move the answer is the main reason to build it at all.
Questions
People also ask.
What software should be used?
Spreadsheets remain the standard because they are transparent and universally readable, with specialist planning tools taking over when many people need to contribute at once.
How long should a model project into the future?
Three to five years is usual for business planning and valuation, since anything beyond that is closer to guesswork than analysis.
What is a three-statement model?
It is a model that links the profit and loss account, balance sheet and cash flow statement so that a change in any assumption flows correctly through all three and the balance sheet still balances.
From the founder's library
Take it further with the book.
Build your financial confidence beyond this definition. Shihan's full-length guide, Accounting Fundamentals, takes the same plain-English approach and turns it into a complete, practical playbook for non-finance managers, business owners and students - with chapter-end quiz answers and presentation slides included.
25% off with code MMHQ25, applied at checkout. Priced in USD - checkout may show the equivalent in your local currency.
View the book and save 25%