Aug 24, 2016

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 3 - Updated to Have 4 Pricing Tiers and Run Rate Valuation + Updated Charts



Pricing

Delivery of this template will be done via e-mail after payment has been received. So, make sure to put the e-mail into the checkout process that you want me to send the sheet to.


What this SaaS Financial Model Can Do?
  • *Newly Added: Run rate valuation and 4 separate pricing tiers.
  • *Newly Added: 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, marketing, salaries, administrative, R&D, etc...expenses listed as a % of revenue and varies by year.
  • 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 2 - Adding Customer Acquisition Cost, CAC Payback, and Valuation




Edition 1




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

If you want, I can add in up to 2 more pricing levels and show movement between those levels based on assumptions that you adjust. Also, there is plenty of valuation and growth metrics that are available as add-ons if you need such as LTV/CAC and valuation types.

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.

No comments:

Post a Comment