SmartHelping / Product + Subscription / Excel
Product + Service 5-Year Financial Model
Forecast a business that sells a physical product for a one-time fee and offers a paid subscription alongside it. Connect production, product sales, subscription uptake, operating costs, and funding in one five-year Excel model.
The template is available to download immediately after purchase. By purchasing, you agree to the Terms of Service.
Video walkthrough & spreadsheet preview
See the model's financial statements and cap table upgrades.
Product sales & recurring revenue
Connect the product purchase with the subscription opportunity.
Model businesses such as fitness equipment with a paid training service or a security product with monitoring. Set the percentage of product sales that also convert into paid subscriptions.
Annual production and units sold
Define the number of units produced each year and the percentage of those units that are sold. Adjust the manufacturing assumptions behind the product.
Year-specific sales seasonality
Set the percentage of annual product sales occurring in each month. Each year has its own monthly sales distribution so seasonal patterns can change over the forecast.
Product-to-subscription conversion
Use the percentage of product sales that also purchase the service to drive subscriber onboarding.
Up to three pricing tiers
Test subscription pricing tiers and review how the pricing assumptions affect revenue, subscriber economics, and the path to break-even.
Customer acquisition & lifetime value
Review the economics of building the subscriber base.
The template includes the core acquisition and lifetime value metrics used to evaluate a subscription service.
Customer acquisition cost
Review customer acquisition cost (CAC) as part of the subscription forecast.
Customer lifetime value
Review the modeled lifetime value (LTV) of a customer under your assumptions.
LTV-to-CAC ratio
Compare modeled lifetime value with customer acquisition cost using the included ratio.
Months to recover CAC
Review the modeled number of months needed to pay back customer acquisition cost.
Operating costs, investment & funding
Build the cost and capital plan around your revenue assumptions.
Dynamic operating cost schedule
Plan sales and marketing, research and development, general and administrative expenses, and cost of goods sold categories with fixed and variable drivers.
CapEx, inventory, and startup costs
Use the dynamic capital expenditure schedule and inventory purchasing schedule, together with inputs for one-time startup costs.
Debt and equity funding
Set debt and equity assumptions. Equity can come from investors, owners, or a combination of both.
Distributions and IRR
The distribution and internal rate of return calculations update from the results of your revenue, cost, and funding assumptions.
Integrated reports & ownership
Review the forecast from monthly detail to executive summary.
The model includes integrated monthly and annual financial statements, a capitalization table, and visual outputs.
Three connected financial statements
Review the income statement, balance sheet, and cash flow statement in both monthly and annual views.
Investor and owner cap table
Use the capitalization table's investor and owner areas to review the equity structure.
Monthly and annual detail
Follow the detailed operating and financing results across the five-year forecast.
Executive summaries and visuals
Review the main financial line items in high-level summaries, with visuals showing the results of your assumptions.
One product sale, an ongoing service relationship
Evaluate product economics and subscription economics together.
Use the model to test how production volumes, seasonal sales, subscription uptake, service pricing, and costs affect the same business. Review the resulting financial statements, capital requirements, and returns.
Bundle inclusion & more templates
Also included in the SaaS financial model bundle.
Questions before you start
A few useful details.
What business model does this template cover?
It covers a physical product sold for a one-time fee with a paid subscription service offered alongside it. A percentage of product sales is used to drive subscription signups.
How long is the forecast?
The model covers five years, with monthly and annual detail, financial statements, executive summaries, and visuals.
Can I account for seasonal product sales?
Yes. Define annual production, the percentage of units sold, and the monthly distribution of those sales. Each forecast year has its own monthly sales mix.
How many subscription pricing tiers can I test?
The template supports up to three pricing tiers.
Which customer economics metrics are included?
The model includes customer acquisition cost (CAC), customer lifetime value (LTV), the LTV-to-CAC ratio, and months to pay back CAC.
Does it include financial statements and a cap table?
Yes. It includes integrated monthly and annual income statements, balance sheets, and cash flow statements, plus a capitalization table with investor and owner areas.
Can I model investor funding and owner funding together?
Yes. Equity can come from investors, owners, or both, alongside debt assumptions. The model also calculates distributions and IRR from the forecast results.
Is this included in a bundle?
Yes. This template is included in the SaaS financial model template bundle.
How do I receive the template?
The Excel template is available to download immediately after the $75 USD one-time purchase. Contact SmartHelping if you have a question before purchasing.
Product sales + recurring service revenue
Build a five-year plan for the complete business.
Connect production, subscriptions, costs, funding, and financial statements in one Excel forecast.
