Last version published: 04/11/2016 14:30
Publication number: ELQ-71849-2
View all versions & Certificate
SaaS Model - Net Present Value for Simple Web Business
A simple NPV model for you to evaluate the likelihood of success for your business
"Use Excel, not Magic, to Calculate Success"
Almost all software is now available online as "Software as a Service', more commonly known as "SaaS". If you are in the process of building a SaaS business model, you can expect recurring revenue and high profit margins...if you've hit the nail on the head of course. However, the gist to developing a successful SaaS business is to have numerous paying customers while keeping your costs of sales low.
[Please note that all the facts in this model are linked to ANY high-growth subscription business model. Software as a Service is only one illustration of a subscription based business model.]
Many entrepreneurs and VCs use a "Magic Number" to evaluate the likelihood of success for a SaaS company. The theory says that you are successful only if your annual revenue for a client is at least 75% of your cost of sales (the money needed to acquire a paying customer).
Or in other words. Invest 1$ today to make 75 cents in the year to come.
Excerpt from Scale Venture Partners blog:
“Looking at SaaS deals over the past ten year at Scale, we have found that a simple calculation is highly predictive of which companies have a profitable subscription business model and which ones do not. Take the change in subscription revenue between two quarters, annualize it (multiply by four), and divide the result by the sales and marketing spend for the earlier of the two quarters. A result greater than 1x, has proven to be a compelling business investment, a result below .5x is a company that still has not figured out it’s model, and a result in between, is a deal that will probably get to success and cashflow breakeven but only in a relatively capital in-efficient way. Trying to be cute, we called this the Magic Number.“
A rule like this of course doesn't need to be right 100% of the time to be valid, but it however has to be more often right than incorrect. Sadly, this "Magic Number" used in SaaS is too simple and quite honestly ambiguous when you try to understand it.
David Brode, a friend of mine, actually found that this so called "Magic Number" can give you "False Negatives" (it says that you've got a good business when actually its the opposite) and also "False Positives" (it says that you've got a really bad business, when it's actually pretty decent).
How can this be? There a few things that such a rule cannot bare in mind such as timing of customer payments (monthly, quarterly, annually) and also the churn rate among your customers (number of customers dropped out and were replaced by new ones). Actually, an NPV, Net Present Value Model, is the only way to know the what your SaaS business is truly worth.
Fortunately, its actually straightforward to create a decent SaaS Business Model Excel File which computes Net Present Value (NPV).
The file attached for download here is for you to download, learn from and play with.
The file a free NPV model for a SaaS business and i'd be more than wiling to adapt it to your needs. You can reach out to me to get a FUSE Finance CFO to do this for you.
[With thanks to my friend David Brode, a business valuation and financial modeling expert in Boulder, Colorado and online at at www.BrodeGroup.com!]
- David Worrell
This business tool includes
1 Excel Model
David Worrell offers you this business tool for free!
download for free
Add to bookmarks
- Jolly Chen(last updated: 11/10/2018 07:31)
- Mark Israelsen(last updated: 19/06/2018 07:43)
- Saurabh Gupta(last updated: 23/05/2018 08:52)
- Vivian Lee(last updated: 05/05/2018 15:31)
- Øyvind Ludvigsen(last updated: 26/10/2017 07:11)
People using this tool also downloaded
Early Stage SaaS Financial ModelGet up to speed on a SaaS Financial Model with a template and its step by step instructionsfinancefinancial modelentrepreneurshipstartupsearly-stageraising capitalbusiness modelingsaasseedseries a3,643 remove_red_eye
NPV and IRR CalculationA model for calculating Net Present Value and Internal Rate of Return.financenpvirrfinancial modelnet present valuecalculationinternal rate of return2,709 remove_red_eye
Simplified Monthly vs Annual Pricing Effects on Cash FlowWhat is better for you in your SaaS Business, monthly or annual payment options?financefinancial modelstartupscash flow managementearly-stagesaasmonthlyannualpayment optionsbiling1,602 remove_red_eye
SaaS Financial Model Excel Template - Simple Version - First 100 Downloads are Free!The First 100 downloads are FREE! A full SaaS (Software as a Service) Financial model to back-up your business plan.financial modelstartupsraising capitalsaassoftware as a servicesaas financial modelstartup financial modelsaas cash flowsaas startup financial modelsaas financialsaas metricssaas kpissaas business plan241 remove_red_eyefreeby Henry Sheykin
SaaS Excel Financial Plan TemplateA SaaS financial plan that allows you to create your own financial forecast. Suitable for startups and SMB's.financial modelstartupssaasfinancial planexcelfinancial forecastsmbsoftware as a startup1,084 remove_red_eyefreeby Ben Murray
Freemium Business ModelCustomize a ready-made financial model for your Freemium Web Services Businessfinancemodelingfinancial modelstartupsventure capitalraising capitalfreemiumuser acquisitionuser activationentrepreneur3,005 remove_red_eye
Startup Financial Model TemplateA simple financial model for an early-stage startup/anyone building a model for a companyfinancefinancial modelentrepreneurshipstartupsearly-stageend-to-endstandard financial statementsventure capitalkey operating metricsraising capital5,508 remove_red_eyefreeby David Teten
Startup Financial ModelA very simple financial model template that can be used to project website revenue.revenuefinancial modelstartupsearly-stageinternetwebsiteonline businesskey drivers2,147 remove_red_eyefreeby Brian Livtack
SaaS Financial PlanA financial plan template for SaaS startups based on a model created for Zendeskroadmapsalesmarketingfinancemodelstartupsraising capitalsaaschartsfinancial plan5,797 remove_red_eye
Sample Financial ModelTemplate for determining cost realities and financial projections for potential investors' demands.financesimplefinancial modelinvestorsstartupsearly-stageraising capital20,840 remove_red_eye
Any questions on SaaS Model - Net Present Value For Simple Web Business?
The user community and author are here to help. Go ahead!