Publication number: ELQ-10949-1
View all versions & Certificate
M/M Growth Calculator
A simple tool to improve your 2020 planning!
I have previously written about the problem with month-over-month growth rates. One of the issues I talked about was that when your revenue plan numbers are based on a constant m/m percentage growth figure (i.e. you’re projecting to grow exponentially), your short-term objectives are likely too low relative to your longer-term goals.
As an example, I showed a (fictional) SaaS startup that wants to grow from $1,000 in MRR to ~$85,000 in MRR within one year. If that company projects exponential growth, it will have to add less than $7,000 in net new MRR in the first half of the year in order to be on track … but to stay on track, it needs to add more than 10x that amount in the second half of the year!
To follow-up on the topic, I’ve put together a very simple (Google Sheets based) calculator which startup founders might find useful when they work on their plan for 2016. The purpose of this simple sheet is not to replace a thorough bottom-up planning which is based on the key drivers of your business. Instead, the idea is that it might be a useful input or cross-check for a more detailed plan. Click the link in the attached Word Document to access the tool. Here’s what it does:
• You enter your start MRR in the orange field at the top left
• You enter your target growth for the year in the orange field in the middle
• The sheet will then calculate three alternative paths to your target MRR for the end of the year
The first one is based on linear growth. It just takes the total net new MRR that you want to add throughout the year and assumes that you’re adding 1/12th of it each month.
The second one is based on an exponential growth assumption, i.e. it assumes that you’re growing at a constant percentage growth rate every month.
The third alternative, which I’ve called “Happy Medium”, has a growth curve that sits between the linear and the exponential option. You can see that well if you take a look at the charts below the numbers. I think most early-stage startups should project a trajectory which, like the “Happy Medium” path”, is somewhere between the linear and the exponential option.
This Best Practice includes
1 Word document
Point Nine Capital offers you this Best Practice for free!
download for free
Add to bookmarks
- Rate this Downloadable Best Practice
Write a review
- irsyad elzaman281(last updated: 08/06/2021 05:07)
- UDOKA OZURUMBA(last updated: 25/03/2021 20:49)
- Vasile Popovici the Excel guru(last updated: 29/12/2020 04:51)
People using this Best Practice also downloaded
Fractionators Excel WorkbookFractionators workbook in Excel made to align with Chaper 3: Fractionation from textbook "Rules of Thumb for Engineers."excelspreadsheetworkbookfractionatorsmccabe-thiele122add_shopping_cart
Absorbers Excel WorkbookAbsorbers Excel Workbook created to align with Chapter 4: 'Absorbers' of textbook "Rules of Thumb for Engineers."excelspreadsheetengineeringabsorbershenrys law328add_shopping_cart
Subscription E-Commerce Fundraising Financial ModelCombining an e-commerce product sales model & a subscription model to make one subscription e-commerce fundraising modelplanningfinancial modelstartupfundraisingsubscription2,298add_shopping_cart$369.00by Alexander Jarvis
Hotel Investment Appraisal Excel Model TemplateDownload this read-to-use Hotel Investment Appraisal to help assess the viability of an investment into a hotel.investmentfinanceexcelspreadsheethotel1,147add_shopping_cart$49.00by Mahender K. Punhani
Powerful and Customizable Debt Module Excel ModelPowerful, highly customization and free debt calculations module.debtinterestexcelspreadsheetprincipal2,185add_shopping_cart$19.00by Alex Martyanov
How to Make Your Financial Model Look ProfessionalThis tool provides Before and After examples to show you how you can make your models look professional.modelinginvestorsfundraisingfinancial modelingexcel795add_shopping_cartfreeby Alexander Jarvis
Commodity Price Risk and Monte Carlo Simulation - Project Finance Excel ModelA commodity price risk model with Monte Carlo simulation within a project finance excel model.modelexcelspreadsheetexcel modelmonte carlo1,370add_shopping_cart$5.00by Prof. Ed Bodmer
Effective Lease Rate Rent Calculations with Various TermsAn excellent tool for adjusting uneven rent payments.excelspreadsheetrent paymentsdiscount rateslandlords244add_shopping_cartfreeby Norm Miller PhD
Cash Flow Statement - Excel Model TemplateThis is a highly professional Cash Flow Statement to use for valuing a company.valuationequityassetscash flow statementshareholders431add_shopping_cartfreeby Wall Street Oasis
Co-Founder Equity Split TemplateSpreadsheet containing 5 calculators and a box that takes the average of everything among all 5.equitycalculatorexcelspreadsheetco-founders1,799add_shopping_cartfreeby Al Bsharah
Any questions on M/M Growth Calculator?
The user community and author are here to help. Go ahead!