SmartHelping / Product-as-a-Service / Excel
PaaS Financial Model
Compare subscription access, direct product sales, or a mix of both. Build a 10-year forecast connecting product deployments and customer usage to capacity, cash requirements, financial statements, and investment returns.
Immediate download after purchase. By purchasing, you agree to the Terms of Service.
See the model in action
Walk through the product, customer, and cash-flow assumptions.
See how product availability and subscription demand connect to the 10-year financial forecast. Open the screenshots below for a closer look at the workbook.
Compare the business models
Sell access to the product, sell the product, or combine both.
Run a subscription-only plan, a direct-sales plan, or a blended business. Both revenue streams connect to the same monthly and annual financial statements.
Product-as-a-Service
Charge recurring subscription fees for access to products or the benefits they provide. In this model, deployed products remain fixed assets on the balance sheet and their cost flows through depreciation.
Direct product sales
Model units purchased and sold using a separate sales and inventory schedule. Product costs flow through cost of goods sold as the units are sold.
Product deployments and recurring revenue
Build the forecast from the operating drivers.
Replace the example assumptions with your deployment schedule, pricing, customer growth, retention, and expected product usage.
Schedule up to 176 deployment tranches
For each tranche, enter its name, deployment month, number of units, cost per unit, useful life, and maximum monthly usage minutes per product.
Choose when customers start joining
Set the first onboarding month, then build new customer acquisition from paid advertising and organic growth.
Model paid and organic acquisition
Use advertising spend and cost per acquisition for one channel. Use a compound annual growth rate (CAGR) to forecast the organic channel.
Configure up to three subscription tiers
Set the monthly subscription fee and share of new customers entering each tier. Adjust the pricing mix to compare recurring revenue outcomes.
Enter a monthly retention curve
Use the monthly retention input area to define how customers remain active over time. Connect the retention assumptions with customer counts, revenue, and product demand.
Connect usage to product availability
Define the average monthly minutes used by a customer in each tier. The capacity schedule compares total demand with the minutes supplied by deployed products.
Capacity across all 120 months
Check whether the deployed products can support the customers.
The model puts available product capacity beside demanded customer capacity for every month of the forecast. Use that comparison to review the timing and scale of product deployments.
Available product minutes
Build supply from the products you deploy and the maximum monthly minutes of access available from each product.
Customer usage demand
Build demand from active subscribers and the average monthly usage minutes for each tier. A capacity ratio above 100% means demand exceeds the products available to serve it.
One product per customer
For a dedicated-product arrangement, set monthly minute capacity per product equal to monthly minute usage per customer in each tier. This creates a one-to-one relationship, and the capacity table shows whether enough products are deployed.
Direct sales alongside subscription access
Plan when inventory arrives and how quickly it sells.
Use the direct-sales schedule on its own or together with the PaaS forecast. Match inventory purchases and sales timing to the business you are evaluating.
Up to 176 purchase tranches
Define the month each tranche becomes available to sell and the number of units in that tranche.
Costs and prices by tranche
Enter a separate unit cost and selling price for each tranche so the forecast can reflect changing product economics.
Monthly sell-through assumptions
Choose the percentage of a tranche sold in each month. For example, sell 25% per month over four months, or 50% in each of the first two months.
Tranche-level sales and COGS
Dynamic matrices calculate sales and product costs by tranche over time, then aggregate the results into monthly detail, cash flow, and the financial statements.
Running costs and capital spending
Include the costs of serving customers and building the business.
Operating and fixed expenses
Use three expense categories with multiple input slots. Name each cost, choose its start month, and set its monthly amount in each of the 10 forecast years.
Subscription service costs
Enter a monthly cost per active customer for each subscription tier. Customer counts drive the related costs as the subscriber base changes.
Additional fixed assets
Add other capital expenditures with purchase timing and useful lives. The schedule calculates their depreciation and also incorporates the products deployed for subscribers.
Startup costs and contingency
Include one-time startup costs that are not entered elsewhere, plus a reserve or contingency amount where needed.
Timing, funding, and exit controls
See the cash required to support the plan.
Global assumptions
Use the global control tab for forecast timing, debt funding, the exit month, and a valuation multiple applied to trailing 12-month sales.
Equity requirements
The model solves for the minimum equity needed to keep forecast cash above zero based on startup costs, product deployments, other capital spending, and operating cash burn.
Equity injections
Use the updated equity injection inputs to model the capital going into the business.
Sources and uses
Review the sources and uses summary alongside the operating forecast and capital requirements.
Financial reports and investment analysis
Follow the assumptions through to performance and returns.
Monthly and annual financial statements
Review connected income statements, balance sheets, and cash-flow statements across the 10-year forecast.
Detailed operating results
See monthly and annual customer-tier activity, sales, costs, EBITDA, cash flow, and key metrics.
Subscription KPIs
Analyze customer acquisition cost and lifetime value, months to recover CAC, and the LTV-to-CAC ratio for the recurring-revenue side of the business.
12 visualizations
Use the financial and KPI charts to review the results and explain the effect of changes in the assumptions.
Annual executive summary and DCF
Review the main financial and cash-flow line items. Analyze discounted cash flow for the overall project, the investor pool where applicable, and the owner pool.
Cap table and investment returns
Use the general cap table and IRR calculations to review each investment and compare the capital requirements and return profile of different business plans.
Updated May 5, 2026
Recent improvements are included.
The latest update improves the funding inputs, reporting, and customer-retention assumptions. Watch the update video for the changes.
Easier equity injections
Updated inputs make equity injections easier to model.
Sources and uses summary
A dedicated summary brings the funding sources and uses together.
Clearer formatting and wording
Formatting and terminology were improved throughout the workbook.
Monthly retention inputs
The customer retention curve now uses a monthly input area for greater flexibility.
How to use the template
Move from an operating plan to a financial comparison.
Set the business mix and timing
Choose subscription access, direct sales, or a combination. Define the forecast timing, funding assumptions, and exit inputs.
Build product supply and customer demand
Enter product deployment tranches, available usage minutes, acquisition assumptions, tier pricing, retention, and customer usage.
Add sales, expenses, and capital costs
Configure any direct-sales tranches, monthly sell-through, operating expenses, customer service costs, additional CapEx, and startup costs.
Review capacity, cash, and returns
Check whether demand exceeds available products. Review sources and uses, the three statements, KPIs, DCF analysis, and investment IRRs; then change assumptions to compare plans.
Also available in these bundles
Need more recurring-revenue and financial modeling tools?
SaaS & Recurring Revenue Bundle
Get this PaaS model alongside templates for subscriptions, memberships, SaaS businesses, marketplaces, and recurring-revenue analysis.
View the SaaS bundleSuper Smart Bundle
Explore the complete public SmartHelping financial model collection across operating forecasts, valuation, accounting, and more.
View the Super Smart BundleQuestions before you buy
A few useful details.
What does PaaS mean on this page?
PaaS means Product-as-a-Service: customers pay a subscription for access to products or the benefits those products provide.
Can I model direct sales and subscriptions together?
Yes. The workbook supports subscription access, direct product sales, or a combination. Both activities flow into the same financial statements and cash-flow forecast.
How many deployments and subscription tiers can I model?
The subscription side supports up to 176 product deployment tranches and three pricing tiers. The direct-sales side has a separate schedule for up to 176 purchase tranches.
What does a capacity ratio over 100% mean?
It means forecast customer demand exceeds available product capacity in that month. Review the deployment plan or customer usage assumptions before relying on that operating scenario.
Can each customer have a dedicated product?
Yes. Set monthly available minutes per product equal to monthly usage minutes per customer in each tier. The resulting one-to-one relationship lets you check whether enough products are available for the active customer base.
Does the model include financial statements and investment analysis?
Yes. It includes monthly and annual income statements, balance sheets, and cash-flow statements; detailed operating reports; an annual executive summary; 12 visualizations; DCF analysis; and a general cap table with investment IRRs.
How is the template delivered?
The Excel model is available for immediate download after the one-time $75 purchase.
Put products, customers, and cash in one plan
Compare the economics of product access and direct sales.
Get the 10-year PaaS financial model for $75 and build the assumptions around your business.
