SaaS Financial Model Template: 5 Free Excel Versions
The SaaS financial model template is a free Excel download that forecasts subscription revenue, churn and cash over 60 months. Choose from five versions by how you bill.
Which of the five SaaS models should you pick?
Pick by how the customer pays, not by how you’d like to be paid. The billing pattern decides when cash arrives, and that is the thing lenders check.
| If your customers… | Use |
|---|---|
| Pay each month and can leave any month | Monthly subscriptions |
| Pay for the year up front | Annual subscriptions |
| Sign for a year but pay monthly, plus a set-up fee | Annual contract, billed monthly |
| Pay by seat, user or licence, every month | Per-unit, monthly |
| Buy yearly licences by the seat (a school buying per student) | Per-unit, annual |
Mixed billing is common. Choose the model for the plan that produces most of your revenue and handle the rest as a separate assumption.
How does the model turn leads into revenue?
The model turns leads into revenue in a chain: leads times conversion rate gives new customers, churn removes some, and active subscriptions times price gives revenue. Every cell downstream depends on that chain, so errors early on get multiplied.
On the Assumptions tab you set the top of the funnel. Leads come from ten channels, each set on its own. Paid ads take a monthly budget and a cost per click. Affiliates, influencers, partnerships, email and content each take a volume and a yield per unit.
Then you set conversion rate and sales cycle. Then churn. Then price.
The monthly models track monthly churn, active subscriptions and price. The annual models track bookings, billed subscriptions, renewals and annual churn. The per-unit models add units per subscription.
What does each input actually mean?
Each input is a claim you will have to defend. These are the ones that need a plain-English reading.
- Conversion rate. The share of leads that become paying customers. Count it from the point you count the lead, not from a friendlier stage.
- Sales cycle. How long passes between a lead arriving and the first payment. Leave it at zero and revenue shows up earlier than it will.
- Churn rate. The share of subscriptions lost in a period. Monthly in the monthly models, annual in the annual ones. Don’t mix the two.
- Price. What one subscription pays. In the per-unit models, it is price per unit times units.
- Onboarding fee (annual billed monthly only). A one-off charge at signup, booked as its own revenue.
- Annual upgrade rate (annual billed monthly only). The share of customers who move to a higher tier on renewal.
- Revenue share and payment processing. Costs that scale with revenue, so they belong in cost of goods sold, not in overhead.
Why do annual contracts create deferred revenue?
Annual contracts create deferred revenue because you collect cash for twelve months on day one but earn it one month at a time. The cash arrives immediately. The revenue is recognised monthly.
On the balance sheet, the unearned part sits as a liability called deferred revenue. It shrinks as each month passes. Bookings, meaning the value of contracts signed, will therefore run ahead of revenue while you grow.
Founders get this wrong in both directions. Some report the whole annual payment as revenue in month one. Others forget that annual-up-front cash makes the early cash position look healthier than the business is. The annual models separate the two so you can see both.
What does a lender or investor question first in a SaaS model?
Expect churn, the cost of winning a customer, and the gap between bookings and cash. Optimistic models tend to break at these three.
Churn set too low. A model with no churn, or a churn rate far under what comparable products see, is the quickest way to lose a reader. Use your own data if you have it. If you don’t, say so and pick a cautious number.
Acquisition cost that ignores salaries. Paid ads are easy to count. A direct sales team is not. If you switch on direct sales, put the salaries in the 25-row people plan and include them when you work out what a customer costs.
Cash that follows bookings. Annual billing flatters cash early. Show what happens in the month renewals are missed.
Our guides on what investors look for and what SBA lenders look for cover the wider test.
How do you fill in the SaaS model?
Work through the Assumptions tab from the top, then check the Financials tab last.
- Overwrite every placeholder number.
- Switch on only the channels you will actually use.
- Add your people and salaries to the 25-row plan.
- Enter starting cash, fixed assets and any equity rounds.
- Set the income tax rate.
- Open the Financials tab and read the cash flow. Look for the month cash runs lowest.
If the lowest cash balance is negative, you have found your funding need. That’s the number a plan should state.
Want someone to check it?
If you’d like a second pair of eyes on churn and cost assumptions before anyone else sees them, you can book a free consultation. For the written side of a SaaS plan, look at the technology sample business plans.
Sample business plans that fit this model
These are 6 of 17 sample plans for businesses that earn money the way this model does. Every sample plan is a fictional example, so use it for structure, not for figures.
- ASP B2B Technology Business Plan
- Business Software Development Company Business Plan
- Electronic Filing Storage Business Plan
- Industry-Specific Software Business Plan
- Internet ASP Business Plan
- Inventory Control Software Business Plan
Browse more: Technology business plans
SaaS financial model: common questions
What is the difference between the five SaaS models?
They differ in billing. Two charge a flat price (monthly or annual), two charge per unit (monthly or annual), and one is an annual contract billed monthly with an onboarding fee.
Does the SaaS model calculate MRR and churn?
It tracks active subscriptions, churn and price, and builds revenue from them. The annual versions also track bookings, billed subscriptions and renewals.
Does it handle deferred revenue?
The annual versions do. They separate cash collected from revenue recognised, so the balance sheet carries deferred revenue.
Can I import the SaaS template into Google Sheets?
Yes. Import the .xlsx with File > Import in Google Sheets, or open it in Excel.