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 4 - Operational Costs are now input as $ amounts instead of % of revenue.





Pricing
Delivery of this template will be done via e-mail after payment has been received.


What this SaaS Financial Model Can Do?
  • *Newly Added: Logic for one-time revenue per sign-up and can change each year.
  • *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 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 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





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. 

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.

You will probably want to take a look at the individual SaaS planning model.

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

Another template has been made with a bit deeper insight and summary additions as well as more precise forecasting that is based on traffic and conversion of that traffic to gain free/paid users: http://www.smarthelping.com/2017/06/website-app-financial-model-with.html

No comments:

Post a Comment