Financial model and numbers
How to build a financial model investors trust
Short answer
Investors trust a model when revenue is built from drivers such as customers, price and retention; every input sits on one assumptions sheet; the three statements tie together; and the assumptions match your history. They test three or four assumptions, not the totals, so know which ones your forecast depends on.
Seven rules
- Build revenue from drivers. New customers, churn, price, order frequency. Never a typed-in growth percentage on last month's revenue with nothing behind it.
- One assumptions sheet. Every input in one place, clearly marked. No numbers hidden inside formulas.
- Tie costs to activity. Hiring to a headcount plan, marketing to customers acquired, servers to usage.
- Link the three statements. Profit and loss, cash flow and balance sheet, with a check row that reads zero.
- Start from actuals. The first forecast month should follow naturally from the last real month.
- Include scenarios. Base, downside and upside, switched from one cell.
- Keep it readable. Monthly columns, clear labels, no macros, no colour codes that need a legend.
What investors actually do with it
They open the assumptions sheet first. They find the growth rate, the churn rate, the acquisition cost and the hiring plan. They change one and watch what happens to cash. Then they ask you why your number is what it is.
So the real work is not the spreadsheet. It is being able to say: "Churn is 2.5% a month because that is the average of our last nine cohorts; here they are."
The assumptions that matter
| Assumption | Evidence to have ready |
|---|---|
| New customers a month | Pipeline, channel tests, sales capacity |
| Retention or repeat | Cohort table |
| Price | Signed contracts, price tests |
| Acquisition cost | Spend ÷ customers, by channel |
| Hiring pace | Roles, salaries, start months |
| Gross margin | Supplier quotes, hosting bills |
Signs of a weak model
- Revenue grows faster every year with no change in sales capacity
- Costs grow more slowly than revenue for no stated reason
- Cash never falls below the opening balance
- The balance sheet is missing
- The deck's numbers do not match
Getting started
Download the free template, or use Model Builder for a 36-month, three-statement version. If you would rather have it built around your business, see the financial model service.
Quick answers
How many years should the model cover?
Three years by month is standard at seed. Add a five-year annual summary only if investors ask.
Should I build it in Excel or Google Sheets?
Either. Excel is what most investors and advisers open; Sheets is easier to share. Avoid tools that lock the formulas.
How optimistic can the projections be?
Ambitious but explainable. Every growth rate should trace to something you have observed or a named comparable.