5-Year SaaS Startup Model in Excel: Highly Flexible and Easy to Understand
Get this SaaS template:
This initial version is included in the purchase as well as the most recent version.
Update 1- (4 pricing tiers):
Update 2- (CAC):
Update 3-
Update 4- (dynamic start months):
*New web / app recurring revenue build:
Explore all of smarthelping's financial models:
A Recent update also included one-time fees upon sign-up that can vary each year as well as adjustable start months for each stream and financing.
This is one of the more complex financial models I have done, but still, it shows the basic assumptions/projects that a SaaS business needs to forecast. I believe I have built in some highly innovative and useful structures so that this can be used in a highly efficient way for planning/presentation based on whatever assumptions you have.
Twitter:
This is a masterpiece! Bravo!
Very nice! I’ll be back for this!
awesome!
My SaaS has five tier-level of subscription plans. How do I get this computed in the template? Do I need to add another column for each plan?
Just making sure you saw my comment response, and if further clarification is needed, just e-mail jason@smarthelping.com
you can change currency, but not globally, you would need to highlight all cells that you can at once and change currency, and so on.
@smarthelping checking this today. By the way, is there a way to change the currency? Thx!
You would have to add logic to include the 5th tier. It would be doable for an average to intermediate excel user I would say. Otherwise, I have two other saas models that have 5 tiers here: https://www.smarthelping.com/2017/06/website-app-financial-model-with.html and here: https://www.smarthelping.com/2020/05/mobile-app-5-year-startup-financial.html
Thank you so much! Great video, lots of hard work put in! Thank you!!
How did you come up with the numbers for growth rate and churn? Did you assume or are they industry-specific avg?
Completely arbitrary, churn/growth will be different for all businesses. It will depend on a wide range of variables, some industry specific and some organization specific. The template is designed to work as you put in your own assumptions, whatever they may be.
How did you get the figure for net cash in on the first month, doesnt seem right
It may not be. This was the first build I ever did and there have been 10 to 12 major updates to it since this video came out originally. I wish the other ones that show a more complete template had more views! but it is likely because the logic needed fixed. It has all been hashed out through many hours of QA and diligence.
Who sets employee salaries as a % of revenue? lol
You would if you are just trying to model after other companies that list all their expenses as a % of revenue. I have updated this as there were many queries about making it work differently so you can get this version still but there are more recent versions that work in a more standard style. They all come in the purchase package for the single price of $45.
Says gross margin at 30%. I think that is cost of sales as % of revenue.
Yes, I see what you are talking about. This is one of the many things that has been updated since the making of the video.
Amazing work. Very well explained
is this not a free model ?
$45
@smarthelping how much?
I charge a one-time price for it.
1) Are you accounting for tax shield ? Seems you are inflating the corporate tax by applying your rate on EBITDA rather than net income 2) Your bank debt and cash balance should not both turn negative and so it seems that your cash flow waterfall doesn’t work properly
For tax calculations, the model has been updated so that the net tax effect is a manual annual entry. This is because there are too many things to try and account for and it is out of the scope of the general purpose of the model to try and automate that calculation. But, it does have a space to enter something into. The cash position can turn negative. This means you don’t have enough money to begin with based on the expected burn. In my more recent models there is better logic for calculating expected cash requirements but still here the job of the model is done by displaying the cash flow and allowing the cash position to be negative. Also, the exit value has recently been added to this and incorporated in the DCF valuation / and general cash flow.
Can you please tell your formula for churn?
churn is just the % that leave monthly, so value of beginning customers in a month x churn rate assigned to that month.