Overview

This is a very simple-to-use and understandable SaaS financial model. It has four basic pricing tiers. The user can configure subscriber assumptions and OpEx in a way that anyone can figure out and input accurately without messing up much. COGS is defined as a percentage of total revenue only per year.

The model does drive down to EBITDA and cash flow as well as has a basic DCF Analysis and terminal value.

Subscriber Inputs:

  • Up to 4 tiers
  • Start month
  • Starting sub count
  • Average monthly value per subscriber per tier
  • Monthly CAGR of subscribers per tier
  • One-time setup fee per tier
  • Average monthly churn rate per year per tier


Advanced KPI metrics are derived from the pro forma on a monthly basis. This is possible because the total Sales and Marketing costs per year are definable and measuring that against the total added subscribers per month results in a CaC. Also, the churn rate allows for an average life of a subscriber and the resulting revenue in that time to be calculated as well as the LTV to CaC ratio.

This is a very simplified model that was built to be a quick tool to use for any business that has month-to-month subscriber pricing tiers. One sensitivity analysis that is shown is the valuation per a given run rate based on final year run rate x a sales multiple.


Reviews Add a review
No reviews yet

More From smarthelping

Browse our top rated business templates. See All
SaaS Rolling Revenue Forecasting Template
56
0
 Performing regular revenue and customer count forecasts for a SaaS company can be difficult and chaotic. This is for a…
Gordon Growth Valuation Model
259
0
This template is designed for valuation. It uses DCF Analysis but without a terminal value. Oftentimes you will see a…
Account Executive Performance Driven Financial Model
287
0
 This is a full 5-year monthly, quarterly and annual financial model that uses unique quota attainment revenue logic to drive…
Driving Range: Startup Financial Model
336
0
 This is a bottom-up financial model that goes up to a period of 10 years. It is for anyone that…
DCF Analysis with Sensitivity Analysis
312
0
 DCF Analysis templates are very useful for those trying to figure out the present value of future cash flows, the…
Franchise Ramping Financial Model: Up to 12 Locations
247
0
 This template lets the user do some financial planning for opening up to 12 franchise locations. The model goes out…
See All