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
- Be the first to review this Downloadable Tool
Write a review
People using this Best Practice also downloaded
Heat Exchangers Excel WorkbookHeat Exchangers Excel Workbook made to align with Chapter 12 of textbook "Rules of Thumb for Engineers" by Stephen Hallexcelspreadsheetengineeringworkbookheat exchangers153add_shopping_cartfreeby Stephen Hall
Subscription E-Commerce Fundraising Financial ModelCombining an e-commerce product sales model & a subscription model to make one subscription e-commerce fundraising modelplanningfinancial modelstartupfundraisingsubscription1,054add_shopping_cart$369.00by Alexander Jarvis
Recipe Cost GeneratorChef's Recipe Costing Template Linked with Inventory and Reorder Guidetemplateexcelspreadsheetrestaurantchef90add_shopping_cart$29.00by Steve Lindsey
Powerful and Customizable Debt Module Excel ModelPowerful, highly customization and free debt calculations module.debtinterestexcelspreadsheetprincipal1,029add_shopping_cart$19.00by Alex Martyanov
Hotel Investment Appraisal Excel Model TemplateDownload this read-to-use Hotel Investment Appraisal to help assess the viability of an investment into a hotel.investmentfinanceexcelspreadsheethotel825add_shopping_cart$49.00by Mahender K. Punhani
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 carlo833add_shopping_cartfreeby Prof. Ed Bodmer
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 modelingexcel536add_shopping_cart
Excel Custom Format Cheat SheetTeaching you how to do excel custom format so that you're able to improve your spreadsheets with handy tips and tricks.excelspreadsheetcustom formattips and tricks355add_shopping_cart
Pump Efficiency Calculation ToolCalculation tool to work out the energy efficiency and performance of water pumping facilities.calculatorexcelspreadsheetengineeringcalculations253add_shopping_cart
Co-Founder Equity Split TemplateSpreadsheet containing 5 calculators and a box that takes the average of everything among all 5.equitycalculatorexcelspreadsheetco-founders899add_shopping_cartfreeby Al Bsharah
Any questions on M/M Growth Calculator?
The user community and author are here to help. Go ahead!