SaaS Business Model Single Offering Template

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?

  1. SaaS financial model will help for all those, who are just at the very beginning of their business life-cycle — startups
  2. SaaS metrics help you gain a deeper insight into the benefits of SaaS revenue model
  3. 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:

  1. Pitch investors and lenders with great SaaS metrics to raise capital
  2. Build up a SaaS revenue model and test the impact on SaaS financial model
  3. 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.

SaaS Business Model SaaS metrics MRR and MRR Movement
SaaS Business Model SaaS metrics Average Revenue Per Customer and Magic Number
SaaS Business Model SAAS metrics Customer Lifetime Value
SaaS Business Model SaaS financial metrics Customer Acquisition Cost and Magic Number

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 Customer Charts Active Customers and Contract length BreakDown
SaaS Metrics Customer Charts Customer BreakDown and 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.

SaaS Financial Model Financial Performance charts EBIT and EBITDA
SaaS Financial Model Financial Performance charts Operating Cash Flow and Cash Balance
SaaS Financial Model Financial Performance charts Productivity KPIs and Revenue Breakdown

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.

SaaS Model Dashboard with core inputs and core outputs
SaaS Financial Model Dashboard Graphs

SUMMARY FINANCIALS

The Summary sheet is a Summary of the key SaaS metrics reports of the model.

SaaS Model Summary Financials Income Statement
SaaS Model Summary Financials Cash Flow Statement
SaaS Financial Model Summary Financials Balance Sheet

VALUATION

This tab of SaaS financial model evaluates your company’s estimated value based on two methods — Discounted Cash Flow and Perpetuity Annual.

SaaS Business Model Discounted Cash Flow Valuation

DETAILED SAAS FINANCIALS BY MONTH

Detailed Income Statement, Balance Sheet and the Cash Flow Statement built automatically based on SaaS financial model assumptions

SaaS Business Model SaaS financials Detailed Income Statement
SaaS Business Model SaaS financials Detailed Cash Flow Statement
SaaS Business Model SaaS financials Detailed Balance Sheet

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.

SaaS Business Model Top Revenue Summary
SaaS Business Model Top Revenue Depth
SaaS Business Model Top 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.

SaaS Business Model Top Expenses Summary
SaaS Business Model Top Expenses Depth
SaaS Business Model Top Expenses Bridge

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.

SaaS Business Model Break Even Analysis

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 Burn chart

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.

SaaS Business model inputs and assumptions

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 section, Conversion Rates section, Deals Allocation by products section

MARKETING BUDGET & VISITORS

Marketing Budget & Visitors section where you have online and offline marketing channels ready to be entered to estimate annual site visitors.

Marketing Budget & Visitors section

CONVERSION RATES TO DEALS

After, you can see visitors Conversion Rates section on 3 different conversion stages up to the moment of the deal

Conversion Rates section

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.

Deals Allocation by products

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.

Customer Pricing by offerings

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.

SaaS startup business model Customer Churn Rare Chart

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.

SaaS Business Model Wages Hire Fire dates and Annual Base
SaaS Business Model Wages FTE count
SaaS Business Model Wages Annual salary raise
SaaS Business Model Wages Monthly Bonus and Tax rate

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.

SaaS Financial Model Fixed Expenses Assumptions

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 Business Model Fixed Expenses Timing and Amount
SaaS Business Model Fixed Expenses Growth Rates

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 Cost Of Services Sold (COSS)

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 Variable expenses

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.

  1. 4 rounds of investment built in
  2. Share Dilution affect shareholders ownership after each round
  3. 20 Placeholders for shareholders broken down by investment rounds
  4. Dilution. After each round the ownership, % changes.
SaaS Financial Model Capitalization Table

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store