If you are building a subscription commerce startup, there is no model like this on the internet. Combines both subscription and traditional ecommerce product sales in one model. Features highly granular revenue forecasting with monthly cohort level modeling. A full stack of marketing options from paid to social and email drive sales. 3 years (36 months) of detailed P&L for actual, forecast and combined, as well as cash based analysis. Manually plan out your hiring of staff and automate support staff depending on how you scale. Charts, KPIs, all your COGS mapped out. Unique source and use sheet illustrates your plan for your pitch deck. And a lot more…
Are you the next Dollar Shave Club or Birchbox? I was asked multiple times by founders for a model that could meet their needs, that was neither a pure ecommerce model nor SaaS model. So I combined elements of both together to build a highly versatile model to meet your needs. This is one of the larger models available. Enjoy impressive results without months of modeling.
The 50Folds subscription commerce financial model is the most comprehensive and powerful excel model available for founders. Nothing else comes close. If you are looking to impress investors with a thoughtful plan, this is it.
As the CEO or CFO (or sole founder…) are you wondering how the hell you can model all this for your fundraising?
You should be concerned… because it’s hard as hell. Trust me. Sure, you might find a free template (I’m happy to send you links to the free models online), but something actually complete and useful that just works? Forget it.
I know, because I had to do it myself.
Well, to be clear I’ve had to do this myself multiple times over the years. I’ve been involved with a lot of startups and so I’ve had to build a number of models. Each time they’ve gotten better, but the process has been no less painful!
Whether you’re raising for your startup, or needing to develop an operational plan to understand how you are going to grow and not run out of cash, you need an excel model. The problem is that they’re really hard to build. You don’t have time to spend 2 months building one, you need to be executing. Paying someone smart to build one can cost $10k+ which is crazy. There has to be a better way!
I’m an ex-M&A banker and VC, and I’ve literally spent months of 100 hour weeks modelling to be able to make this model available to you. Feel free to ask your M&A buddy to build something for you for a few grand. I’ve been sent those models (as I’ve been asked to make a new one after). They’re not terrible, but they don’t make sense as they don’t understand how startup works.
The 50Folds subscription ecommerce financial model is the most comprehensive and powerful fundraising excel model available for founders. Nothing else comes close. If you are looking to impress investors with a thoughtful plan, this is it.
If you truly want to understand your operations in detail, then download it now.
Are you growing like a rocket and don’t have the time to fill out the model, but want the results? No stress. We’ll build it for you.
This model comes with 20 minutes of consulting to help you get the most out of it.
Below we will look at the high level features of the model, screen shots on each sheet and some further descriptions.
Kindly note this price is low just for founders raising. If you need models for a professional reason, please reach out regarding licensing at [email protected]
If you have questions about the model, feel free to ask.
Details on the model
The subscription model is available through SSL secured purchase via a startup called Gumroad (Support startups). This took months and is priced at 45 mins of my consulting time. The model will be immediately emailed to you.$169
The sheets in the model
|Formatting||Input the start dates for the actuals and forecasts to start. These are key to align actual and forecast in the model output sheets|
|P&L Actual||This is the P&L of your actual numbers. These can feed into the combined P&L and they are used to connect your actuals to forecasts (e.g. customers to get recurring income)|
|P&L Forecast||Detailed forecast P&L of your startup. This mainly pulls in all the numbers fromother sheets, with only a few assumptions to input|
|P&L Combined||This combines the forecast and actual sheets together. There are no assumptions|
|P&L for Deck||This combines the summary forecast and actual sheets together for the first 12 months and for 3 years annual to insert in your pitch deck. Change to whatver you want|
|Source and Use||Use this to figure out how much to raise and to present your ‘sources and use’ of money you raise in your ‘ask’ slide|
|KPI – Subs||Some KPIs for your subscription side of the business (A bit more SaaS like)|
|KPI||A detailed summary of all your KPIs|
|Charts||Summary of charts from across sheets|
|Staff||Forecasts for all staff (Other than warehouse, photography and customer care staff). All the related staff and G&A costs|
|Expense calcs||Logistics including shipping, photography, customer care, payments and stock purchasing assumptions/calculations|
|D&A – Tax||Calculate your depreciation (there is no amortization) and your tax simply|
|Sub – Pricing||Input your subscription pricing and discount rate if you sell annual packages with discounts|
|SKU||Forecast your SKU and the revenue and cost basis per SKU. This is for the product part of the business (not subscription)|
|Product – Cohort Build||Orders and revenue are forecasted by cohort in detail for non-subscription part of business. All assumptions are at the top. Mechanics are below|
|Conversion assump||All the assumptions that drive your revenue calculations. This sheet is key, takes marketing users and you divide them into product/subscription users and other key assumptions|
|Sub – Calcs – Monthly||Calculate the monthly portion of your subscription users. There are NO assumptions on this sheet|
|Sub – Calcs – Annual||Calculate the annual portion of your subscription users. There are NO assumptions on this sheet|
|Sub – MRR & Cust Summary||A summary of your subscription calculations (The calculations in the monthly and annual sheets are long)|
|Marketing||Centralizes the marketing data and applies conversion rates to create ‘registered users’ of your site (Which then buy, or you can simplify with one conversion rate, depending on your funnel)|
|Paid & organic||Organic growth and paid traffic to the site. Feeds to the traffic build in ‘Marketing’|
|Calculates the sign ups to your email database. Feeds to the traffic build in ‘Marketing’|
|Blog & Social||Calculates the traffic that comes from promotion activities by blogging and social media. Feeds to the traffic build in ‘Marketing’|
Video training course
The subscription commerce model is available through SSL secured purchase via a startup called Gumroad (Support startups). This took months and is priced at 45 mins of my consulting time. The model will be immediately emailed to you.$169