SaaS Business Model Single Offering Template
SaaS business model with flexible SaaS pricing model and detailed SaaS metrics and more features in our SaaS financial model ready to be a part of SaaS business plan
Saas Business Model Highlights
Five year SaaS business model template to forecast monthly recurring revenue, ltv calculator, churn, bookings, billings, recurring revenue, and cost of sales for subscription-revenue businesses with single subscription plan, and monthly / annually contract lengths. Prebuilt three financial statements — income statement, balance sheet, cash flow statement, key SaaS metrics spreadsheet, SaaS revenue model, summary, and valuation ready to enhance your SaaS Business Plan. Unlocked — use in Excel or Google Sheets.
Overview
SaaS business model template to enhance SaaS business plan looking to forecast monthly recurring revenue and cost of sales from single subscription plan, or contract lengths.
Key features
This SaaS financial model forecast monthly recurring revenue, operating expenses, hiring plans, cash and runway, SaaS metrics and financial statements, funding needs, cap table, valuation, and more.
Used by
Made for investors, founders, executives — CEO, CFO, COO, VP of Finance — or advisors, mentors, or consultants that need to create detailed saas pricing models for saas business model for an idea-stage, pre-seed, seed, A, or B stage company.
Easy to use
Based on SaaS Best Practice, preciselly tested and used by hundreds of companies and individuals across the globe and wide variety of business types, saas revenue model, and needs.
Edit anything
Use in Microsoft Excel or Google Sheets; all input cells are unlocked for editing and transparency. And all formulas are locked with no password for you safety. You can unlock each tab whenever you need to adjust formulas.
Personal support
Built by a professional financial modeler with 10 + years of experience. Responsive, personal support — chat, call, or email — and available for custom services.
“Finmodelslab team did a great job building a quite complex, but easy to use, SaaS Financial Model for one of our USA based SaaS companies. Generally speaking, I recommend Finmodelslab highly.”
– John Howell, Software and technology investor
100+ users
of this model type from 2017 to today.
97% of users
say Finmodelslab models will help them accomplish their goals.
2 hours or less
is how long it takes to build a complete model, on average.
Why do you need a SaaS business model for a startup?
- SaaS financial model will help for all those, who are just at the very beginning of their business life-cycle — startups
- SaaS metrics help you gain a deeper insight into the benefits of SaaS revenue model
- SaaS financial model with help of SaaS metrics will show you its cash flow strengths and weaknesses
With help of the SaaS financial model, you’ll be ready to:
- Pitch investors and lenders with great SaaS metrics to raise capital
- Build up a SaaS revenue model and test the impact on SaaS financial model
- Enhance your SaaS business plan with great SaaS metrics
Core SaaS Metrics and Features: from SaaS revenue model to SaaS Financial Model
In particular, it focuses on such critically important aspects as the following:
SAAS METRICS
This tab shows you different SaaS metrics both in long-term and short-term perspective, demonstrating data for 5 years and 24 months respectively.
Customer Charts
Due to to this tab, you can see how active customers influence your revenue, as well as how their preferences change through the years.
Therefore, understanding the factors encouraging your customer’s movement is a shortcut to success, that’s the reason this tab is important.
CUSTOMER BASE GROWTH CHARTS
The first chart shows you active customers who use your offering. The second one breaks down active customers by monthly and annual contract duration. Special attention should be paid to the third chart, as not only does it show you the monthly movement of your active customers, as it also provides you with a detailed, month-to-month information on your churn & new customers movement.
SaaS metrics
This tab provides an in-depth analysis of the overall financial state of your company. In particular, it shows you different financial charts both in long-term and short-term perspective. Also, it demonstrates data for 5 years and 24 months respectively.
SAAS FINANCIALS
This tab provides an in-depth analysis of the overall financial state of your company. In particular, it shows you different SaaS metrics both in long-term and short-term perspective, demonstrating data for 5 years and 24 months respectively.
Reports and SaaS metrics
Finally, after building up SaaS revenue model with SaaS pricing model assumptions and expense assumptions you are ready to dive into the SaaS metrics
DASHBOARD WITH CORE SAAS METRICS
This tab is a snapshot of your SaaS metrics at a particular point of time. On the dashboard, you can see your core SaaS financials, active customers breakdown per year, cash flow data, profitability forecasts, and cumulative cash flow.
SUMMARY FINANCIALS
The Summary sheet is a Summary of the key SaaS metrics reports of the model.
VALUATION
This tab of SaaS financial model evaluates your company’s estimated value based on two methods — Discounted Cash Flow and Perpetuity Annual.
DETAILED SAAS FINANCIALS BY MONTH
Detailed Income Statement, Balance Sheet and the Cash Flow Statement built automatically based on SaaS financial model assumptions
TOP REVENUE
This tab shows off the financial information regarding each of your offerings. In particular, the SaaS Startup model demonstrates annual data on your expenses, including even revenue depth and revenue bridge.
TOP EXPENSES
This tab demonstrates your annual expenses, both total and those grouped by category. In fact, this SaaS financial model template provides the overview of annual expenses on customer acquisition, COSS placeholders, wages & salaries, fixed and variable expenses, and all other expenses.
BREAK EVEN ANALYSIS
Break Even Analysis tab predicts when your company is supposed to move to a whole new level — when its overall revenues become significantly bigger than expenses.
CASH BURN RATE
This is one of the tabs your future investors may be very interested in. This tab calculates the time left to a complete cash burn. This cash burn rate template shows cash burn ratio. The calculation is based on your average annual cash balance and average monthly operating cash out.
SaaS Business model inputs and assumptions
To make model alive you should use yellow cells to input assumptions.
Customer Acquisition Inputs
As you can see, the Dashboard tab consists of core inputs and SaaS metrics for you to create assumptions, check them, and develop different financial scenarios at no time.
The top left side of the SaaS business model designed for the SaaS sales-funnel assumptions. Therefore, entering assumptions step by step, you will get the sales count for the particular year.
In addition, in this section of SaaS business model, you can see your customer base. There is the number of new deals sold over the years, calculated through the marketing budget spent and conversion stages up to the moment of the deal.
SALES FUNNEL ASSUMPTIONS
Marketing assumptions
Marketing Budget & Visitors section where you have online and offline marketing channels ready to be entered to estimate annual site visitors.
Conversion rates
Visitors Conversion Rates section on 3 different conversion stages up to the moment of deal.
Deal allocation
On the Deals Allocation by-products section, you can break up all of your contracts sold into 3 groups based on the offering chosen by a customer.
MARKETING BUDGET & VISITORS
Marketing Budget & Visitors section where you have online and offline marketing channels ready to be entered to estimate annual site visitors.
CONVERSION RATES TO DEALS
After, you can see visitors Conversion Rates section on 3 different conversion stages up to the moment of the deal
DEALS ALLOCATION
You should set up the allocation of monthly vs annual deals using this section. Consequently, data from here will be used to calculate monthly recurring revenue and annually recurring revenue. In other words, this is one of the main inputs of the SaaS revenue model.
SINGLE OFFERING CONTRACT LENGTH
Short term contracts only
If some of your offerings are month-long only, you should set 100 percentage of 1-month-long contracts, and the model will set 0 % of 12-month-long contracts itself.
Long-term and Short-term contracts
In any other case by changing the allocation % of 1-month-long contracts model you will change the 12-month-long contracts allocation automatically.
The last but not least
So, after you fill out this block of SaaS business model assumptions, you can immediately see the number of new clients based on inputs from above on the chart.
BTW, marketing costs spent for reaching out one new customer will be the key element of customer acquisition costs (CAC)calculation.
Therefore, now you’re ready for tuning up your SaaS pricing model as a part of SaaS startup business model.
SaaS Business Model & Billing Inputs
On this tab of a Single Offering SaaS business model, prices for your offering becomes SaaS pricing model. So, you can manage prices year over year.
Annual payments are exceedingly important and beneficial for SaaS revenue model and your cash flow, as your clients pay once and at the very beginning of the billing cycle, what provides you with countless opportunities for investing those funds in your business growth. Just because cash is the king.
CUSTOMER PRICING BY OFFERINGS
Flexible SaaS pricing model impacts SaaS revenue model dramatically. For example, play with the numbers to see the changes on SaaS metrics.
Pricing tiers
You have 2 lines for specifying the price of monthly (1) and annual (2) deals.
This makes it easier for you to see, how your client’s booking price changed depending on any shifts in your SaaS pricing model.Discounts
Discount for annual payments considers lower price for annual packages paid upfront.
Simply set the annual price cheaper than monthly so you can see the discount % calculated by the SaaS pricing model.
SaaS Business Model: Customer Churn tab
This part of Single Offering SaaS startup model is responsible for predicting changes in your customer base and calculating the monetization (Monthly Recurring Revenue — MRR).
Considering changes in your clients’ base, the Single Offering SaaS business model takes into account the customer churn rate assumptions.
CUSTOMER CHURN
Not depending on the length of the contract in time, the % of churn is critical.
As you can see, churn rate is really essential! It makes you see how significantly churn affects your monthly recurring revenue as well as how it changes over the years. Besides, one of the main benefits provided by this SaaS startup business model is that you can adjust and manage the churn % every year individually for each of your offerings.
Short-term contracts
For short-term contracts, 5% of churn means that 95 out of 100 new clients will sign up an agreement the next month.
Long-term contracts
For long-term contracts, everything works somewhat different. You don’t lose the number of customers during the billing cycle, as your customers have already paid upfront. However, in the next billing cycle, you will lose some percent entered here from the cohort of new clients acquired 12 months ago. Given this, for annual contracts, 5% monthly churn means that 95 out of 100 new clients are left at the end of the year.
SaaS Financial Model: Wages & Staff
On this single tab, you can enter all needed assumptions about your company staff. Thus, all you need to do is to start from the left and move to the right, filling the information line by line:
WAGES & STAFF COUNT ASSUMPTIONS
According to the entered info, the staff plan will be built and the wages expenses will be calculated immediately.
Staff numbers are the core thing
That’s why you should be careful here. Note that you may hire more than 1 full-time equivalent (FTE) for each position. Therefore, all you need is just to change the SaaS financial model assumptions at the junction of a year and a line. Once you do it, the needed numbers will be added or subtracted to reach the entered FTEs figure.
SaaS Financial Model: Fixed Expenses
This tab is all about the costs that have the nature of fixed costs. Also, these expenses do not vary depending on sales or number of customers — and they may be included in our fixed costs tab.
It’ very flexible. Just tune it up and everything will be calculated right away.
Just take a look at this comprehensive list of accrual frequency options.
Literally, everything can be found here — from daily to annual accrual options.
FIXED EXPENSE ASSUMPTIONS
You can specify the name of a certain expense, a sum of money, and the frequency for the sum to be charged: every day / week / month / quarter / six months, etc.
SaaS Financial Model: Cost Of Service Sold
Certainly, every business owner knows that all the expenses have their one-of-a-kind purpose: some are dedicated to the acquisition of new customers, while the other offer your existing clients some unique opportunities or services.
Thus, this Single Offering SaaS startup model template breaks your expenses into groups based on their purpose. As a result, it makes it easier for you to see the percent of the total revenue you spend for your different business purposes.
COSS — ASSUMPTIONS
You have up to 5 placeholders of different Cost Of Services Sold (COSS) — related expenses, like expenses on hosting, customer support, etc.
Also, these expenses change depending on their total revenue driver.
SaaS Financial Model: Variable expenses
Unlike fixed costs, these expenses change depending on as % of Total Revenue driver.
This driver is predefined. Thus, you won’t be able to change the mechanics of that calculation.
VARIABLE EXPENSES — ASSUMPTIONS
Just specify what expenses you’re going to have and what’s the % of Total Revenue you a going to spend.
The last thing that matters is Customer Acquisition Cost — the gray line. Hence, do not change these cells. This is a predefined name, so you know for sure how your marketing-related costs are called, entered by you on the dashboard in the marketing budget section.
SaaS Financial Model: Capitalization Table — CapTable
The Cap Table takes you through multiple rounds of financings.
Showing how issued shares to new investors and price per share impact the investment received.
- 4 rounds of investment built in
- Share Dilution affect shareholders ownership after each round
- 20 Placeholders for shareholders broken down by investment rounds
- Dilution. After each round the ownership, % changes.
