SmartHelping / Subscription Business Model / Excel
Subscription Box
Build a financial forecast around the economics of acquiring, retaining and serving subscribers. Connect pricing, promotions, customer costs and inventory timing to cash flow, funding needs and investment returns.
Immediate download after purchase. By purchasing, you agree to the Terms of Service.
See the model in action
Follow subscribers through the financial forecast.
Watch the walkthrough to review customer acquisition, pricing, promotions, retention and operating assumptions. Open the screenshots below for a closer look at the workbook.
What the model includes
Build the business from subscriber-level assumptions.
Model a subscription box business where customers pay a monthly fee for one or more deliveries of curated products.
6 paid acquisition channels
Configure up to six advertising channels using spending and cost-per-acquisition inputs to drive new subscriber growth.
Organic customer acquisition
Use monthly traffic and conversion-rate assumptions to model customers acquired through organic channels.
6 subscription levels
Set monthly pricing and total monthly cost per customer for each of up to six subscription levels.
Retention and introductory promotions
Set retention assumptions for each level and define the percentage of the full price paid in each customer month, including first-month-free or other introductory offers.
Fixed operating costs with start dates
Build a fixed-cost schedule for managers, rent and other operating expenses that are separate from subscription box delivery costs. Each cost item has a start-month selection.
Inventory purchase timing
Use the inventory purchase offset based on buying frequency to reflect the timing of inventory purchases in the forecast.
Customer cohorts, contract terms and promotions
Model how subscribers stay and pay over time.
Each pricing tier includes a contract term and retention assumptions for the monthly cohorts of new customers joining that tier.
Define the retention curve
Enter the percentage of customers retained over the life of each monthly cohort. Use an exponential-decay pattern, a linear pattern or another curve that matches your expected customer retention.
Keep billing monthly
The model assumes customers pay their subscription price each month, including when the contract term is longer. A 12-month contract is modeled with monthly payments over those 12 months.
Apply promotions by customer month
For each subscription level, define the percentage of the regular price collected in month one, month two, month three and so on. Use these inputs to reflect introductory discounts and free-month offers.
Financial outputs and investment analysis
Connect the operating plan to funding needs and returns.
The financial projections update from your assumptions across a forecast period of up to 72 months.
Integrated three-statement model
Review monthly and annual income statements, balance sheets and cash flow statements, plus pro forma detail showing EBITDA and cash flow.
Subscriber performance metrics
Track average customer acquisition cost (CAC), lifetime value (LTV), LTV-to-CAC, monthly churn, annual recurring revenue (ARR) and average revenue per account.
Equity investment requirement
Estimate the minimum equity needed to maintain a positive cash position under the entered assumptions, based on startup costs, capital expenditures and operating cash burn.
Optional debt financing
Include debt and review its effect within the financial forecast alongside the operating cash inflows and outflows.
DCF, IRR and optional exit value
Evaluate discounted cash flow and internal rate of return. The optional exit value uses a multiple of trailing 12-month subscription revenue.
Annual executive summary
Use the annual summary and detailed monthly and annual reports to communicate the financial plan and compare alternative assumptions.
How to use the model
Test the plan before committing to the next stage of growth.
Set the acquisition plan
Enter advertising spend and cost per acquisition for up to six paid channels, then add organic traffic and conversion assumptions.
Configure the subscription levels
Set prices, monthly cost per customer, contract terms, retention curves and introductory promotions for up to six tiers.
Build the cost and funding plan
Enter fixed expenses and start months, inventory purchasing timing, startup costs and capital expenditures. Configure debt if it is part of the plan.
Compare financial scenarios
Review cash needs, statements, KPIs, DCF and IRR. Vary pricing, customer costs, ad spending, acquisition costs, traffic and conversions to compare downside, base and upside cases.
Who this model is for
For businesses built around recurring product deliveries.
Subscription box founders
Evaluate the economics of a curated product offering for an audience such as beauty enthusiasts, food lovers, readers or pet owners. Test the relationship between acquisition, retention, pricing and delivery costs.
Operators planning expansion
Review whether growth assumptions, introductory offers, purchasing frequency and operating costs support the cash flow and funding plan for the next stage of the business.
Business planning considerations
Build assumptions around the customer experience.
Consider the product, marketing and operating choices behind the numbers when developing your scenarios.
Audience and ongoing value
Define the interests your boxes serve, the value of the curated selection and how personalization or a surprise element fits the offer. Reflect expected customer retention in the model.
Marketing and customer relationships
Consider targeted campaigns, community engagement, referrals and potential cross-selling or upselling when developing the broader business plan. Test the acquisition and retention assumptions that support it.
Inventory and brand partnerships
Plan the buying cycle, bulk purchases and supplier or brand collaborations needed to curate boxes. Review how the timing of those purchases affects cash requirements.
Growth and consistent delivery
Evaluate whether fulfillment processes, product curation and operating capacity can support the planned subscriber base while maintaining the expected cost and customer experience.
Also available in these bundles
Need more recurring-revenue modeling tools?
This template is included in the SaaS / Recurring Revenue bundle and the Super Smart Bundle.
SaaS / Recurring Revenue Models
Explore financial models and analysis tools for SaaS, subscriptions and recurring-revenue businesses.
View the SaaS bundleSuper Smart Bundle
Access the complete public SmartHelping template collection across industries and financial-analysis needs.
View the Super Smart BundleQuestions before you buy
A few useful details.
How many subscription levels and advertising channels are included?
Configure up to six subscription levels and six paid advertising acquisition channels. Organic customer acquisition is modeled separately using traffic and conversion assumptions.
How long is the forecast?
The model supports up to 72 months, or six years, with monthly and annual financial reports.
Can I model a first-month-free offer?
Yes. Each subscription level includes a promotion schedule based on the percentage of the regular price paid in each customer month.
How are longer subscription contracts billed?
Payments are modeled monthly, even when the contract term is longer. A 12-month contract uses the tier’s monthly subscription price over 12 months, with discounts reflected through the promotion inputs.
Can each tier have a different retention pattern?
Yes. Each pricing tier has its own contract term and retention assumptions for monthly cohorts. Enter the curve that reflects your expected customer behavior.
Does the model estimate the equity needed?
Yes. It estimates the minimum equity requirement to maintain a positive cash position under the model assumptions, based on startup costs, capital spending and operating burn. Debt is optional.
How is the optional exit value calculated?
The exit value is based on a multiple of trailing 12-month subscription revenue. DCF and IRR analysis are also included.
Build the financial plan behind the box
Connect subscriber growth to cash flow and returns.
Get the Subscription Box Financial Model for $125 and test acquisition, pricing, retention, promotions and costs across a six-year forecast.
