SaaS Financial Excel Model Template
  • SaaS Financial Excel Model Template
  • SaaS Financial Excel Model Template
  • SaaS Financial Excel Model Template
  • SaaS Financial Excel Model Template
  • SaaS Financial Excel Model Template
  • SaaS Financial Excel Model Template
  • SaaS Financial Excel Model Template
  • SaaS Financial Excel Model Template
Originally published: 27/02/2019 17:44
Last version published: 25/11/2019 22:53
Publication number: ELQ-31865-2
View all versions & Certificate
certified

SaaS Financial Excel Model Template

In the Excel file you will find a model of a SaaS business model.

Description
In the Excel file you will find a model of a SaaS (Software as a Service) business model. I start by modeling the number of customers, taking into account the churn rate.

Then using the 3 different pricing plans I model revenues and margins. Using the cost of acquisition we move to net margin and profit & loss statements.

In a separate sheet I also model the head office and development costs. All calculations are done for separate cohorts, so you can see how improvement in a specific period can impact the whole business. By cohort we mean here customers that were recruited in the same period.

The model will enable you to estimate the profit of the business model, LTV, payback time etc. You can also model the Cash Flow for the SaaS business using the data in the model. Churn rate can be modified for every cohort and period. In this way you can check the sensitivity of your model when it comes to improvements of churn rate or increase in the number of acquired customers. The model can be easily modified by changing the assumptions that are in blue.

The model will automatically recalculate the result for the new set of parameters.

You're welcome to check my Eloquens channel for other startup business models and other tools.
- Asen

This Best Practice includes
1 Excel SaaS Financial Model

Asen Gyczew offers you this Best Practice for free!

download for free

Add to bookmarks

Discuss

Reviews

keyboard_arrow_downShow all


keyboard_arrow_leftkeyboard_arrow_right

More Best Practices from Asen Gyczew

See all
keyboard_arrow_leftkeyboard_arrow_right

Any questions on SaaS Financial Excel Model Template?

The user community and author are here to help. Go ahead!


4.3 / 5 (13 votes)

please wait...