5-Year SaaS Startup Model in Excel: Includes CAC Payback and Valuation

Understanding and making use of SaaS startup models in Excel or Google Sheets can be difficult and end up wasting user's a bunch of time. For this reason, I have tried to make a template that has very clear assumptions for subscribers, revenue, costs, and financing.

Latest Overview and Upgrades: Cap Table; Financial Statements, Contribution/Distribution Summary, Formatting Conventions

$45.00 USD

The template will be available to download immediately after purchase. This is also included in the SaaS financial model template bundle. 


saas art

What this SaaS Financial Model Can Do?
  • Monthly and Annual Income Statement, Balance Sheet, Cash Flow Statement
  • Cap Table
  • DCF Analysis / IRR
  • Executive summary, revenue per tier updates to annual summary, cash flow/tax effect manual adjustment, LTV, LTV to CaC ratio.
  • Pick start month of revenue per stream and financing month.
  • Logic for one-time revenue per sign-up and can change each year.
  • Run rate valuation and 4 separate pricing tiers.
  • CAC by month, CAC payback by month
  • Sub growth by month and vary rate per year.
  • Sub churn by month and vary rate per year.
  • Revenue growth by month and vary rate per year.
  • COGS is listed as a % of revenue.
  • All operating costs (Sales staff, Executive, Research and Development, General and Administrative, etc...) can be input as a $ amount on the cost tables.
  • Financing that runs off a built-in amortization schedule.
  • Corporate tax that allows adjustment based on year.
  • Debt service
  • Cash flow after tax
  • Adds non-interest debt service back into tax calculation
  • All financing variables do dynamically effect the SaaS values per the dates of your business model and the length of time financing occurs or no financing at all.
  • This can be transferred to Google Sheets no extra charge.
Charts
  • Visualizations have been built to demonstrate financial flows over time, bank balance over time (including financing effects), subscriber and recurring revenue changes by year, LTV, LTV to CaC ratio, CAC, and CAC Payback (months).
An annual summary sheet has also been built that dynamically runs off the initial 5 year model and pulls subscriber, revenue, cost, and cash flow values.

The point of this tool is for a startup or early-stage business to get some goals on numbers they want to hit and see the effect of hitting those numbers. 

There is plenty of valuation and growth metrics that are available as add-ons if you need such as LTV/CAC and valuation types. The one I did add is a run rate multiple that shows a value for each year of operation.

There is also a nice add-on I could explain and implement for you included in the initial cost that helps plan out your AE (account executive) hiring based on a given MRR target and their yearly % of goal rate.

Disclaimer: I am not liable for any financial gain/loss that results in the use of this SaaS financial model template.

More Subscription / Membership Recurring Revenue Financial Models: