Trusted by 25,000+ startup founders, investors and CPAs
Saved Hours On Forecasting
Megan Carter, TX
This template cut out the manual build so I could finish the numbers in one afternoon instead of spending days in Excel. It saved me at least 8 hours on the first pass.
No More Formula Stress
Daniel Brooks, NC
I liked having the formulas already set up, because one bad cell can ruin a model fast. It kept the assumptions clear and helped me review the box without second-guessing every line.
A Clear Start Point
Lauren Mitchell, FL
Starting from zero always slowed me down, and this gave me a clean place to begin. I went from blank-sheet hesitation to a working draft before lunch.
Model review
What does the financial model of a product called Build Your Own Subscription Box include?
This editable workbook Excel models the acquisition of subscribers, tests, mix of plans, churn, repeating revenue, add-ons and five-year financial statements with monthly details for two years.
Use it to translate marketing spending, CAC, conversions, pricing plans, subscriber retention, and optional box economy into an organized subscription forecast.
The editable assumptions flow through the revenue engine, cost schedules, scenarios and related financial statements so that operational changes can be reviewed throughout the model.
Constructed for cohort planningModel trials, paid activations, mix of levels, churn, revenue from subscription and optional use or revenue associated with boxes in one forecast.
revenue engine of the subscription cohort
How does financial model calculate the revenue from a business called Build Your Own Subscription Box?
This model converts marketing expenditure into registration cohorts, paid subscribers, tiered revenue and additional revenue enabling while maintaining the ARR as the current KPI.
01
Get the registration
The new registrations are equal to marketing expenditure divided by CAC and then divided by test launches and paid directly.
02
Change the sample
After the expiry of the trial time, the previous trial groups multiply by converting the trial into a paid one and link directly to the current paid activations.
03
Build subscribers
Payable activations are allocated to individual plans and active subscribers go forward without a clear or full-year refund.
04
Revenue from prices
Subscriber assets are multiplied by monthly plan prices, adding enabled usage, configuration, boxes and additional layers.
05
Recognize the revenue
The monthly recognised revenue is the sum of all the updated layers; the annual revenue is the sum of the months, whereas the ARR is 12 × MRR only as a KPI.
Where does the revenue from subscriptions go into the model?
Worksheet revenue assumptions combines marketing, CAC, testing, mix of plans, lifetime, price, usage and subscriber group with forecast revenue.
Revenue assumptions
Check the revenue, customer groups, subscription prices, usage assumptions and related subscriber metrics.
02 / COGS & operating expenses
What is the structure of production and operating costs?
Worksheet COGS and operational expenditure shall separate direct product costs, variable costs and fixed costs over the forecast period.
COGS and operating expenses
Check direct costs, variable operating expenses, fixed costs, time and projected monthly expenses.
03 / Analysis of the scenario
What can be compared with low things, basic things, and high things?
In terms of scenario analysis, it compares the Low, Base, and High results for revenue, gross margin, contribution margin and EBITDA over five years.
Analysis of scenarios
Check the low, base and high trajectories to obtain the revenue and main profitability measures of forecast.
04 / Dashboard
What Does the Dashboard Bring Together?
You can use dashboard to view configuration controls, scenario multipliers, KPI results, basic finances, mixtures of revenue, cash flow, profitability and return on investment charts.
Dashboard
Model control, scenario results, financial summaries, mix of revenue, cash flow, profitability and return visualizations.
Product adjustment
Is the financial model "Build Your Own Subscription Box" right for you?
The ready-made structure is suitable for companies with a subscription box using the acquisition of a cohort, testing, level pricing, churn and optional additional revenue; substantially different mechanics may require individual modelling.
Model ready
It fits perfectly
You get subscribers through marketing spending and CAC companies.
You're using a free trial, a paid launch, or both before you activate a paid one.
Pricing for recurring plans according to the level and tracking of subscriber retention or retention.
You can add use layers, configurations, shipments, boxes or additional revenue layers.
Order structure
Think about the model
Your basic revenue is not dependent on recurring subscriber companies or pricing plans.
Your operating model requires a completely different fulfillment, capability, or inventory schedule.
Your reporting structure requires results that go beyond the workbook architecture shown here.
Recognition of revenue or customer lifecycle requires a different computational sequence.
The indicator is the starting point for planning, not a guarantee of performance.
Financial modelling service for orders
Do you need a pattern that meets your requirements?
Financial Models Lab may build or adapt a model where requirements require a different revenue logic, operational schedule or reporting structure.
After purchase, you will receive an editable financial model Excel with five-year forecasts, scenario analysis and related financial statements.
01
Editable workbook
Download the editable Excel workbook and replace the planning assumptions with your own inputs.
02
forecast 5-year
Review of monthly details for the first two years and annual summaries for the third to fifth years.
03
Analysis of scenarios
Compare Low, Base, and High cases through the model scenario framework.
04
Financial statements
Use the related income statement, cash flow, balance sheet, dashboard and supplementary reports.
Before purchase
Build your own Financial model FAQ subscription box
The basic answers are visible in their entirety, without the need to click on the accordion.
01
How does financial model calculate the revenue from a business called Build Your Own Subscription Box?
It converts marketing and CAC spending into registration cohorts, uses trial conversion and a mix of plans, moves subscribers forward without flow, and active plan prices plus enabled additional revenue.
02
Which assumptions can I change?
You can change the launch time, marketing expenses, CAC, test settings, conversion, mix of plans, initial subscribers, usage time or lifetime, prices, usage costs, configuration fees, shipping settings, add-ons, and returns or refunds.
03
What can I compare between Low, Base, and High scenarios?
You can compare the Low, Base, and High options for revenue, gross margin, contribution margin and EBITDA in the Scenario Analysis view.
04
What financial results are taken into account?
In workbook you will find income statement, the report from cash flow, the balance sheet, dashboard, the summary, scenario analysis and additional financial statements.
05
Can the Financial Models Lab adapt the model to individual requirements?
Yes. the Financial Models Lab offers personalised financial modelling for different revenue logics, operational schedules or reporting requirements.
06
Is this workbook a prediction or a guarantee?
This is a financial forecast based on edited assumptions, not a guarantee of business results or financial results.
What Does the Build Your Own Subscription Box Financial Model Contain?
This comprehensive subscription box revenue forecast Excel spreadsheet includes everything you need to build a robust financial plan, from detailed revenue models and cost breakdowns to automated financial statements and a dynamic performance dashboard.
All-in-one Dashboard
Core inputs and core outputs
Low/Base/High
Three scenario analysis
Professional Charts
Presentation ready
ROE Components
DuPont analysis
Revenue Inputs
Researched revenue assumptions
Bank-Ready Reports
Lender-friendly financial outputs
Revenue Breakdown
Revenue stream detailed view
KPI Dashboard
Performance metrics benchmark
Choosing a selection results in a full page refresh.
Revenue assumptions
COGS and operating expenses
Analysis of scenarios
Dashboard
