SaaS Monthly Recurring Revenue Model With 3 Offerings Monthly & Annually Billed

SaaS Monthly Recurring Revenue Model 3 Offerings Highlights

Five-year SaaS Monthly Recurring Revenue Excel for SaaS startups to forecast monthly recurring revenue, churn, bookings, billings, recurring revenue, and cost of sales for subscription-revenue businesses with up to three monthly subscription plans Prebuilt three financial statements– income statement, balance sheet, and cash flow statement — and key SaaS metrics spreadsheet, SaaS finance, summaries, and valuation forecasts. Unlocked — use in Excel or Google Sheets.

Overview

SaaS template for SaaS business plan that helps to calculate the SaaS revenue model based on the future behavior of newly acquired customers powered with flexible SaaS pricing models. The model provides calculations of monthly recurring revenues and expenses, salaries and wages, debt and cap-table and more.

Key features

  • Designed for flexibility in monthly recurring revenue planning.
  • Developed informative reports of the SaaS finance and subscriber metrics.
  • Functional dashboard as well as built-in break-even, SaaS finance summary and SaaS valuation reports.
  • Switch output currency, churn and upgrade/downgrade features with immediate operations results included.
  • Creates core three financial statements as well as SaaS financial charts and SaaS finance metrics reports open for editing, saving in PDF, printing and use in presentations.

Used by

Made for investors, founders, managers — CEO, CFO, COO, VP of Finance — or financial consultants and advisors that want to calculate exact revenue and expenses forecasts for subscription-revenue startup businesses, enhance SaaS business plan with the SaaS financial model.

Easy to use

Explicit and thorough tables and charts tested by experienced businessmen and designed for various periods and SaaS business sizes.

Edit anything

Unlocked for editing. Detailed formatting and color scheme instructions given. Used in Microsoft Excel or Google Sheets. Add and calculate your own figures.

Personal support

All day available personal support: online and on the phone services along with an instruction video for comfortable use. Built by professional financial modelers and businessmen.

“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 finance model with 3 Monthly and Annually billed Offerings?

  1. Plan SaaS finance! Because if you don’t, you going to run out of cash and fail with a 50% chance. A good SaaS model will show your ability to understand and manage startup finance.
  2. Validate the viability of a SaaS business plan with best practice and industry specific SaaS Monthly Recurring Revenue model. Make sure your idea financially sustainable.
  3. Raise debt and/or capital from finance guys with ease. SaaS Monthly Recurring Revenue model will help you prove that you are sharing common same concerns and looking at the same SaaS finance metrics.

With help of SaaS finance model, you’ll be ready:

  1. To measure the impact of your strategical moves on your recurring revenue and cash flows. With SaaS template, you will see where there is room for improvement.
  2. To set quantitative and financial goals for your newborn SaaS startup. Track your progress and SaaS finance metrics accurately with SaaS template!
  3. To analyze and track down your expense structures and resources allocation as well as monthly recurring revenue streams from up to 3 SaaS pricing plans.

Core SaaS Features And Metrics
from SaaS pricing models to SaaS metrics

In particular, it focuses on such critically important aspects as the following:

SAAS FINANCE & OPERATIONAL METRICS

That is the most essential SaaS finance metrics regarding the overall financial performance of your business. SaaS Monthly Recurring Revenue model predicts how your business should operate within a forecasted time period.

SaaS Finance Graphs Productivity and Revenue Break down Shows you Productivity and Revenue Break Down both in long-term and short-term perspective, demonstrating data for 5 years and 24 months respectively
SaaS Financial Graphs EBITDA and EBIT Shows you EBITDA and EBIT both in long-term and short-term perspective, demonstrating data for 5 years and 24 months respectively
SaaS metrics Monthly Recurring Revenue Break down and movement Shows you Monthly Recurring Revenue Break down and movement both in long-term and short-term perspective, demonstrating data for 5 years and 24 months respectively
SaaS Metrics Magic Number and Average Revenue Per User Shows you Magic Number and Average Revenue Per User both in long-term and short-term perspective, demonstrating data for 5 years and 24 months respectively

SaaS Startups Reports

Reports gives you important information you can use to make business decisions and presents information in the form of business tables, graphs and charts. This template gives main data for investors and creditors.

SAAS DASHBOARD WITH CORE SAAS FINANCE METRICS

SAAS DASHBOARD GRAPHS

This tab is a snapshot of your business’ financial viability 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 Financial Model Dashboard. This tab consists of key inputs and outputs for you to create assumptions, check them, and develop different financial scenarios at no time

SAAS FINANCE AND OPERATIONAL METRICS

SAAS MODEL OPERATIONAL METRICS

Operational metrics, that used in business processes help to track the performance of a company. Business can grow the operational efficiency and decrease costs if you set valuable indicators.

SaaS Financial Model Customer Charts Customer Breakdown and Movement

SAAS FINANCE METRICS

This tab provides financial analysis of your business. These SaaS finance metrics show you monthly financial data divided into the: EBIT data, EBITDA data, operating cash flow etc. for 5 years and 24 months respectively.

SaaS Finance Graphs Productivity and Revenue Break down Shows you Productivity and Revenue Break Down both in long-term and short-term perspective, demonstrating data for 5 years and 24 months respectively
SAAS revenue model Operating Cash Flow Cash Balance & Operating Cash flow
SaaS Financial Graphs EBITDA and EBIT Shows you EBITDA and EBIT both in long-term and short-term perspective, demonstrating data for 5 years and 24 months respectively

SAAS FINANCIAL SUMMARY: INCOME STATEMENT, CASH FLOW AND BALANCE SHEET

SAAS FINANCE SUMMARY & THREE STATEMENTS

This tab provides an in-depth analysis of the overall financial state of your company.

SAAS finance summary profit and Loss Statement
SAAS finance summary Cash Flow Statement
SAAS finance summary Balance Sheet Statement
SAAS finance detailed Profit and Loss Statement
SAAS finance detailed Cash Flow Statement
SAAS finance detailed Balance Sheet

SAAS MONTHLY RECURRING REVENUE MODEL TOP REVENUE AND TOP EXPENSES REPORTS

SAAS TOP REVENUES

This tab shows off the financial information regarding each of your offerings. In particular, the model demonstrates annual data on your expenses, including even revenue depth and revenue bridge.

SaaS revenue model model Top Revenue Summary
SaaS revenue model model Top Revenue Depth
SaaS revenue model model Top Revenue Bridge

SAAS TOP EXPENSES

This tab demonstrates your annual expenses, both total and those grouped by category. In fact, this SaaS Monthly Recurring Revenue model template provides the overview of annual expenses on customer acquisition, COSS placeholders, wages & salaries, fixed and variable expenses, and all other expenses.

SaaS revenue model Top Expenses Summary
SaaS revenue model Top Expenses Depth
SaaS revenue model Top Expenses Bridge

SAAS VALUATION AND BREAK EVEN LEVEL REPORT

SAAS BREAK-EVEN ANALYSIS & CASH BURN RATIO

The breakeven analysis helps to find the profit point in business — determine revenue needed to cover total costs (fixed and variable costs).
The Cash Burn Ratio calculates the time left to a complete cash burn.

SaaS business plan excel Break Even Analysis. Defining a Break Even point is quite helpful because it helps your investors look into long-term profits
SaaS business model template Cash Burn Ratio

SAAS DISCOUNTED CASH FLOW METHOD VALUATION

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

SaaS financial model for Startups Valuation. On the Valuation tab, the net present value (NPV) of future cash flows is calculated for investment purposes. In addition, here in this section, the discount factor (WACC) is calculated

SAAS Finance Model inputs and assumptions

This tab help for you to enter assumptions, check them, and develop different financial scenarios at no time. To make model alive you should use yellow cells to input assumptions

SAAS NEW CUSTOMER ACQUISITION AND SEASONALITY INPUTS

SAAS DASHBOARD SALES FUNNEL

This tab consists of key inputs and outputs for you to create assumptions, check them, and develop different financial scenarios at no time.

SaaS Revenue Model — Marketing Budget & Visitors section where you have online and offline marketing channels ready to be entered to estimate annual site visitors
SaaS Revenue Model — Visitors Conversion Rates section on 3 different conversion stages up to the moment of deal
SaaS Revenue Model — On the Deals Allocation by Offerings section, you can break up all of your contracts sold into 3 groups based on the offering chosen by a customer. Also, here you may split each offering into monthly and annual billings

SAAS MARKETING SEASONALITY ASSUMPTIONS

Here at this tab, you may spread the marketing budget across the 12 months. Entered allocation will be applied to all of 5 years in the model. Enter no more than 100% in total. You have a check feature to the right of seasonality inputs.

SaaS Revenue Model — marketing expenses will change the different seasons. Seasonality assumptions help to spread the marketing expenditure across the year

SAAS PRICING MODEL & BILLING INPUTS

SAAS MODEL PRICING & BILLING INPUTS

The SaaS model has two SaaS pricing models built in monthly and annual contract lengths. This means you can apply discounts for annual billings paid upfront. Using Upsell you can increase the regular price for $$$ applied to some % of your customers.

SaaS pricing model 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

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 CHURN & UPGRADE

SAAS CHURN & UPGRADE INPUTS

Considering changes in your clients’ base, the startup financial model takes into account the following assumptions:
- churn rate — average monthly rate of lost customers.
- upgrade from / to plan — rate will be applied every month to upgrade/downgrade the customer base for each offering.

SaaS Revenue Model — Churn rate is essential! Check how churn rate affects your monthly recurring revenue

Monthly contracts churn

For monthly contracts, 5% of churn means that 95 out of 100 new clients will sign up an agreement the next month.

Annual contracts churn

For annual contracts, everything works somewhat different. You don’t lose the number of customers during the year, as your customers have already paid upfront. However, some customers might churn next year.

SAAS EXPENSES AND WAGES INPUTS

SAAS WAGES INPUTS

The wages tab allows to easily calculate salaries for staff categories, to have a staff plan and to evaluate wages expenses.

SaaS model Use 1 line per employee/category, and simply type in the hire date, fire date, and annual salary. Next, use the staff numbers section to type in FTE count for each year individually. An increase of FTEs means that you are going to hire additional FTE’s. In case of decrease FTEs means you fired some FTEs. New FTEs will be hired/fired on Jan of the relevant year
SaaS model If there are raises or changes in salaries, simply type in the annual Salary raise per position in the appropriate columns. The model will automatically calculate this cost going forward until the fire date. Finally, Monthly bonus as a % of monthly salary can be applied to every line as well as personal tax can be applied on top of that

SAAS FIXED EXPENSES INPUTS

This tab is all about the expenses do not vary depending on sales or number of customers. ou can specify the name of a certain expense, a sum of money, and the frequency for the sum to be charged

SaaS model Fixed Expenses. Enter in the list of fixed expenses (i.e.)

SAAS VARIABLE EXPENSES INPUTS

This tab helps to calculate the costs, that increase or decrease depending on a company’s production volume.

SaaS model You have 3 different ways to manage your variable expenses: As % of Total Revenues — when you pay % percent from all revenues as an expense As $ per Active Customer — when you pay X dollars per each active client As $ per New Customer — when you pay X dollar per each new client

SAAS CAPEX INPUTS

SAAS ASSETS

Capital costs or investments are the business development expenditures (i.e. equipment etc.) that are to be amortized.

SaaS model excel Assets inputs. You may purchase some assets on a specific date and depreciate them across the entered amount of years using this tab.

SAAS FINANCE MODEL DEBT AND CAPITAL INPUTS

SAAS MONTHLY RECURRING REVENUE MODEL DEBT & CAPITAL ASSUMPTIONS

These Saas Startup Business Plan Assumptions are used to determine the cost of capital. Capital Assumptions enables you to work with asset information of your startup and Debt Assumptions is a form of debt refinancing

Saas Recurring Revenue Model template debt assumptions. Here you can enter up to 3 different loans and a grant
Saas Subscription Model Capitalization Table inputs

--

--

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