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
 Performing regular revenue and customer count forecasts for a SaaS company can be difficult and chaotic. This is for a…
Gordon Growth Valuation Model
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
 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
 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
 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
 This template lets the user do some financial planning for opening up to 12 franchise locations. The model goes out…
See All