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 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.

Edition 5 - Added Dynamic Start Month and Financing Variables + YoY% Growth


The template will be sent to you after purchase via your PayPal/purchasing e-mail. This is included in the SaaS financial model template bundle.

What this SaaS Financial Model Can Do?
  • Added: 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.

Edition 4 - Operational Costs are now input as $ amounts instead of % of revenue.

Edition 3 - Updated to Have 4 Pricing Tiers and Run Rate Valuation + Updated Charts

Edition 2 - Adding Customer Acquisition Cost, CAC Payback, and Valuation

Edition 1

  • Visualizations have been built in to demonstrate financial flows over time, bank balance over time (including financing effects), subscriber and recurring revenue changes by year, 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.

Latest Screenshots of Current Version:
basic SaaS revenue assumptions for multiple pricing tiers

simple cost schedule for SaaS forecast

SaaS combo charts in excel

CaC SaaS charts in Excel

LTV to CaC ratio line chart

5 year financial summary SaaS model and visualizations for lifetime value

simple annual SaaS P&L

annual pro forma SaaS

monthly P&L saas

monthly cash flow summary for SaaS pro forma

valuation sensitivity for SaaS forecast

More SaaS Financial Models: