Saved Me Hours Weekly
Building the houseplant subscription model by hand would’ve eaten my week, but this template got me to a working forecast in under an hour. I saved about 8 hours and had numbers ready for my meeting the same day.
Building the houseplant subscription model by hand would’ve eaten my week, but this template got me to a working forecast in under an hour. I saved about 8 hours and had numbers ready for my meeting the same day.
I was stuck staring at a blank spreadsheet and didn’t know where to begin. This gave me a clear starting point, and I had a full draft ready for review by the end of the afternoon.
I’m not strong with advanced Excel, so I was worried this would be too technical. The layout and formulas were easy to follow, and I could explain the assumptions without getting lost in the sheet.
This editable XLSX workbook for creating models of five-year subscription plans with monthly and annual detail, three scenarios and basic financial statements.
Plan of subscribers of acquisition, trial conversion, churn, mix of levels, subscription prices, use, configuration fees, and optional field or additional income in one forecast.
The operational assumptions are made by means of revenue, costs, wages, capital schedules, cash flows, balance sheet and management reporting.
Revenues are consistent with the CAC registration cohorts driven by tests, paid activation, level allocation, churn, MRR subscription and included usage, setting, field and additional layers.
Marketing expenses divided by CAC sets the registers and then divides them between trials and directly paid off takeoffs.
Earlier test cohorts convert after the trial period, while the directly paid cohort starts to activate immediately.
Paid activations are distributed at different levels of subscription using a editable set of client plans.
Active subscribers develop with new activations less pronounced or derived from life.
The level of MRR plus the enabled usage, setting, field and additional layers become monthly recognised revenues.
The revenue card combines acquisition, sample, paid activation, mixing plan, churn, prices, use and configuration of fees to subscribers' revenues.
REVENUE
The COGS & OPEX card separates direct costs, variable costs and fixed overhead costs, allowing the operational assumptions to flow to margins and cash planning.
COGS & OPEX
The Scenarios compared low, base and high results in terms of revenue, gross margin, premium margins and EBITDA in terms of forecasts.
SCENARIOS
The table includes configuration checks, scenario multipliers, basic finances, profitability, cash flow, revenue mix, key metrics and return prospects.
DASHBOARD
The ready model fits the cohort subscription companies using the delivered acquisition, conversion, churn, level and logic of the monetization; material different structures may require custom modelling.
The template is the starting point of planning, not a guarantee of performance.
The financial models of Lab can build or adapt a model when the revenue logic, work schedules or reporting requirements differ from the final structure.
ORDER A CUSTOM FINANCIAL MODELAfter the order you will receive a five-year financial model XLSX with monthly and annual forecast, analysis of scenarios, statements and reporting opinions.
Update of assumptions, operational factors, costs, personnel, capital and financial outlays.
Review of monthly and annual forecasts over the five-year forecast period.
Compare low, base and high cases using the model scenario framework.
Review of Income Statement, Cash Flow Statement, Balance Sheet, Summary, Dashboard and Other Reports from the Workbook.
The basic answers are visible in their entirety, without clicking on the accordion.
Change the CAC registration cohorts in paid subscribers by trying or direct start, then apply plan prices, chrun, and included monetization layers. Monthly recognised revenue combines the level of MRR with appropriate use, configuration, field and additional revenue.
You can edit start time, marketing expenses, CAC, mix of trial and duration, conversion, mix of plan, subscribers starting business, churn or lifetime, level prices, use, configuration fees, shipping and ad-on assumptions, and returns if possible.
You can compare alternative revenues, gross margin, premium margin and EBITDA paths in the case of low, base and high. The scenario view shows how the selected assumptions change the five-year results.
The product presents income statement, cash flow statement, balance sheet, navigation desk, summary, scenarios, valuation, break-even, ROIC, charts, KPIs, Ratios and additional management reports. These outputs combine with the monthly model calculation engine.
Yes. Financial Models Lab offers custom financial modelling when you need different revenue logic, operating schedules, calculations, or reporting from the ready structure.
This is a forecast built on the assumptions to be edited, not a guarantee of business results. Results change when operating and financial data of the model changes.
This pre-written financial model for plant subscription box contains everything you need to build a comprehensive financial plan, from initial cost estimates to a full five-year forecast and business valuation.
Core inputs and core outputs
Three scenario analysis
Presentation ready
DuPont analysis
Researched revenue assumptions
Lender-friendly financial outputs
Revenue stream detailed view
Performance metrics benchmark