What’s inside
- Assumptions tab with every input in one place, inputs in blue
- Customer build: starting customers, new customers, churn
- Revenue, cost of revenue, gross margin, marketing and operating costs
- Operating profit, tax, net profit and closing cash for five years
- Revenue and net profit chart
How to use it
- Start on Assumptions and replace each blue figure with your own numbers.
- Read the Model tab year by year and check the margins look realistic.
- Change one assumption at a time to see which ones move the result most.
- Use the chart and summary lines in your pitch deck or business plan.
FAQ
Is this model detailed enough for investors?
It covers the core logic investors look for: customers, pricing, margins and cash. For a funding round you will usually add hiring plans, working capital and a monthly view for the first year.
Why does closing cash equal opening cash plus net profit?
The model keeps cash simple on purpose and leaves out working capital and capital spending. If those are large in your business, add them as separate lines.
Can I model a non-subscription business?
Yes. Treat revenue per customer as average yearly spend and set churn to the share of customers who do not come back.
