Of all the new kinds of enterprise solutions made available by the advent of the internet, one of the most disruptive, most useful, and most recent has been the software as a service (SaaS) business model. SaaS is a delivery model in which centrally hosted software is licensed to customers via a subscription plan. Any company that leases its software through a central, cloud-based system can be said to be a SaaS company.
So, if you are interested in investing in a SaaS business or you are running an operating SaaS business, this Financial Model is a flexible tool to calculate financial and operating activities (MRR, COGS, Payroll, Expenses, etc.), project customers’ new subscriptions and return rates and forecast a company’s growth.
The model includes assumptions and calculations of Initial Investment Costs, Paid and Organic Customers Acquisition, 2 different revenue sources (Monthly Subscriptions and Annual Enterprise License), 4 different subscription options, subscriptions upgrades & downgrades, Direct & Indirect Payroll, Operating Expenses, Fixed Assets & Depreciation, Financing through Debt & Equity and Exit Valuation assumptions in case of a potential sale of the business.
Outputs of the template include various financial reports, key SaaS metrics (CAC, ARPU, LTV, IRR, NPV, Payback), a sophisticated Dashboard analyzing business performance, and an Investors’ Executive Summary.
The model follows Financial Modeling Best Practices principles, is fully customizable, and has a dynamic functionality allowing users to select the desired forecasted Years (1 to 10).
Detailed instructions for the functionality of the model are included in the Excel file.
Model Structure:
Customer Acquisition
• Revenue is calculated based on the number of subscribers.
• Customer new sign-ups come from 2 different sources of traffic – Paid and Organic
Revenue Assumptions
• 3 Pricing Tiers (Monthly Subscriptions packages)
• Enterprise License sold with an annual (12-month) contract
• 5 different subscription periods with the corresponding prepayment discounts (applied to Monthly Subscriptions)
• Upgrades or Downgrades between Subscription and Enterprise License Packages
• Non-recurring Revenue calculation (Set up fees per New Customer)
Revenue Calculation
Model calculates revenue per Service package and subscription period.
Analysis for each package includes:
•Total customers (new, expanded, upgraded, downgraded, churned)
• Customers per subscription period
• Renewal waterfall per subscription period
• Monthly Recurring Revenue (MRR) and Monthly Cash Basis Revenue per subscription period
• Monthly Deferred Revenue calculation
Cost Assumptions
• Cost of Services per Customer (Recurring & Non-Recurring)
• Payroll per Department supported by Cohort analysis for Starting Date and Year for each employee
• Operating Expenses
Financing & Capex
• Uses & Sources of Cash analysis – Financing through Equity & Debt
• Fixed Assets Analysis with the corresponding Depreciation Schedule.
Output Reports:
• Monthly Profit & Loss Statement Summary per Year
• Monthly Budget and Actual Reports
• Budget vs. Actual Variance Analysis
• Dynamic 10-Year Forecast (3 Statement Model)
• Annual Direct Cash Flow
• Breakeven Analysis
• KPIs and Financial Ratios (Revenue & Cost Metrics, ROE, ROIC, Profit Margins, etc.)
• Dynamic Dashboard with key metrics & charts analyzing business performance on an annual basis.
• Business Valuation (incl. Enterprise & Equity Value, DCF, Terminal Value, Unlevered & Levered Cash Flow, Project Return Metrics & Sensitivity Analysis)
• PE Distribution Waterfall Model, including an 80/20 split and a GP catch-up assumption.
• Exit Year Executive Summary
The Model is available in 2 Versions (Standard and Premium)
Standard Version Includes:
• All Input Reports
• Monthly Budget and Actual Reports
• Monthly Profit & Loss Statement Summary per Year
• Annual Financial Statements (3 Statement model)
• Annual Direct Cash Flow
• Financial Ratios
• Performance Dashboard
Premium Version includes all features of the Standard Version plus:
• Budget vs. Actual Variance Analysis
• Break-even Analysis
• Business Valuation, including DCF Model, Return Metrics (NPV, EV, IRR, MOIC, ROI, etc.), and Sensitivity Analysis
• Investors Returns Waterfall Model
• Executive Summary
A PDF Free Demo of the Premium Version is provided if you wish to view all model worksheets before your purchase.
Help & Support
Committed to high quality and customer satisfaction, all our templates follow best-practice financial modeling principles and are thoughtfully and carefully designed, keeping the user’s needs and comfort in mind.
Whether you have no experience or are well-versed in finance, accounting, and the use of Microsoft Excel, our professional financial models are the right tools to boost your business operations!
If you experience any difficulty while using this template and cannot find the appropriate guidance in the provided instructions, please feel free to contact us for assistance.
If you need a template customized for your business requirements, please e-mail us and provide a brief explanation of your specific needs.
Similar Products
Other customers were also interested in...
Subscription Business – 10 Year Financial Model
Financial Model providing a 10-year financial plan for a startup or operating Subscription Business.... Read more
Online Business Financial Models Bundle
A collection of six Online Business Financial Models offered at a discounted price you can’t miss!... Read more
5-Year Enterprise SaaS Financial Model – 3 C...
A dynamic financial model to forecast monthly and annual customers/revenues/expenses for a SaaS comp... Read more
SaaS Financial Model
The SaaS financial model template offers a framework in preparing a 5 to 10-year financial plan for ... Read more
Subscription Box Financial Model – Up to 72 ...
Test many variables in this financial model for a subscription box company. Includes up to six prici... Read more
SaaS Financial Model Bundle
This is a bundle of Financial Model Templates for SaaS businesses and their related sectors such as ... Read more
Ratio-Based SaaS Model – Smarter Scaling Log...
This model makes it easier to forecast the scaling out of a SaaS model that is dependent on Account ... Read more
Data-as-a-Service Financial Feasibility Study
This model is built for data-as-a-service startups. If you have valuable data to monetize, this temp... Read more
Website / App Financial Model (Recurring Revenue S...
A great tool to model out any recurring revenue service that acquires users through a website or app... Read more
Product-as-a-Service (PaaS) Financial Model
This is a true PaaS model with flexible build-out assumptions, capacity sanity checks, and direct sa... Read more
Reviews
This is the perfect model for a suscription based saas model is perfect for it and the its very simple to use more over if you have any questions Giorgos responds and provide feed and support in a incredible fast way
453 of 875 people found this review helpful.
Help other customers find the most helpful reviews
Did you find this review helpful?
Nicely laid out model. The instructions are limited, as such make it difficult to determine what effect inputs have on the outcomes.
Could improve monthly costs to be more flexible.
Otherwise I am happy to recommend for a startup SAAS business.
488 of 926 people found this review helpful.
Help other customers find the most helpful reviews
Did you find this review helpful?
-
Hi Andrew,
Thank you for the review and the feedback on the model. We value our customers’ opinion and will try to improve the model by adding more detailed instructions and adjust the monthly costs to be more flexible.
Kind Regards
Giorgos Lampropoulos
Founder & CEO432 of 844 people found this review helpful.
Help other customers find the most helpful reviews
Did you find this review helpful?
You must log in to submit a review.