SmartHelping / SaaS & Recurring Revenue / Excel
5-Year SaaS Startup Financial Model
Connect subscriber growth, churn, four pricing tiers, operating costs, and financing in a five-year SaaS forecast. See how your assumptions affect revenue, cash flow, customer acquisition economics, and valuation.
Review monthly and annual financial statements, a cap table, contribution and distribution summaries, CAC payback, LTV, and investment returns in one Excel model.
Google Sheets transfer is available at no extra charge.
Immediate download after purchase. By purchasing, you agree to the Terms of Service.
Model walkthrough
Follow the SaaS forecast from assumptions to financial reports.
Watch the latest overview covering the cap table, financial statements, contribution and distribution summary, and formatting conventions. Open the screenshots to preview the workbook.
Revenue, costs, and financing
Build the forecast around your subscriber and spending assumptions.
Set revenue timing, customer growth, churn, direct costs, operating expenses, and financing to explore the economics of a startup or early-stage SaaS business.
Four pricing tiers and start dates
Model four separate pricing tiers and choose the revenue start month for each stream.
One-time signup revenue
Include one-time revenue per signup in addition to recurring revenue, with the signup amount adjustable by year.
Growth and churn assumptions
Set monthly subscriber growth, subscriber churn, and revenue growth rates, with assumptions that can vary from year to year.
Direct costs and operating expenses
Enter cost of goods sold as a percentage of revenue. Input operating costs as dollar amounts for sales staff, executives, research and development, general and administrative expenses, and other cost lines.
Financing and debt service
Choose the financing month and use the built-in amortization schedule to calculate debt service. The forecast reflects financing timing and duration, and can also be run without financing.
Tax and cash flow adjustments
Adjust the corporate tax assumption by year and use the manual cash flow and tax-effect adjustment. The tax calculation accounts for the distinction between interest and principal repayments.
Financial reports and SaaS metrics
Review operating performance, funding, and customer economics.
The model brings the operating forecast together with financial statements, ownership analysis, valuation, and visual summaries.
Monthly and annual financial statements
Review an income statement, balance sheet, and cash flow statement on both a monthly and annual basis.
Cap table and investor summaries
Use the cap table and contribution and distribution summary to review ownership and investor cash flows alongside the operating forecast.
CAC, payback, and lifetime value
Review monthly customer acquisition cost and CAC payback, together with lifetime value and the LTV-to-CAC ratio.
DCF, IRR, and run-rate valuation
Evaluate discounted cash flow and IRR outputs, and use the run-rate multiple valuation to review an estimated value for each year of operation.
Annual and executive summaries
Review subscriber, revenue, cost, and cash flow results in the annual summary, including revenue by pricing tier. Use the executive summary for a higher-level view.
Financial and SaaS visualizations
View charts for financial flows, bank balance including financing effects, annual subscriber and recurring revenue changes, LTV, LTV-to-CAC, CAC, and CAC payback in months.
From operating targets to financial outcomes
See what your subscriber targets imply for cash flow and returns.
Revenue timing, subscriber growth, churn, pricing tiers, and signup fees establish the revenue forecast. Direct costs and operating expenses then shape profitability, while financing and tax assumptions affect the cash available to the business.
Review the financial statements and bank balance alongside CAC payback, LTV-to-CAC, and valuation. Change the assumptions to see how a different growth path, cost plan, or financing schedule affects the five-year results.
How to use the model
Build the forecast in four steps.
-
Set up the revenue streams
Define the four pricing tiers, revenue start months, signup revenue, and growth and churn assumptions for each year.
-
Enter the cost plan
Set COGS as a percentage of revenue and enter dollar-based operating expenses in the cost tables.
-
Configure funding and taxes
Enter financing timing and terms, review the cap table, and set annual tax assumptions and any manual cash flow or tax-effect adjustments.
-
Review the financial and SaaS outputs
Evaluate the statements, annual summary, bank balance, acquisition metrics, contribution and distribution summary, and valuation results.
Included in the SaaS collection
Explore more recurring-revenue models.
This 5-Year SaaS Startup Model is included in the SaaS / Recurring Revenue Models Bundle.
SaaS / Recurring Revenue Models Bundle
Explore models for subscriptions, memberships, marketplaces, and other recurring revenue businesses.
Explore the bundle →Related operating models
Plan other service and membership businesses.
Explore financial models for services, memberships, advertising, lending platforms, and property management.
Security System / Alarm Services Model
Connect hardware installations, technician capacity, three subscription tiers, upgrades, downgrades, and funding to a five-year forecast.
View template details →LaaS Lending Platform Financial Model
Project lending activity by risk grade, platform interest and closing fees, defaults, financing, and returns over ten years.
View template details →Property Management Financial Model
Forecast customer growth, units under management, management fees, operating costs, financial statements, and investment returns.
View template details →Professional Services Firm & Agency Model
Connect hiring, billing rates, quota ramps, and employee tenure to professional billings, payouts, costs, and cash flow.
View template details →Ad Network Financial Model
Build an ad-network forecast from publisher growth, impressions, fill rates, CPM, network fees, costs, and financing.
View template details →Car Wash Financial Model
Model wash demand, ticket pricing, memberships, capacity, operating expenses, financing, and investor returns over five years.
View template details →Private Membership Golf Course Model
Forecast membership capacity, joining fees, monthly dues, events, food and beverage sales, costs, and investment returns.
View template details →Customer economics, reporting, and costing
Explore supporting calculators, trackers, and guides.
Review separate tools for churn, customer cohorts, pricing, recurring revenue, financial statements, and inventory costing.
SaaS CFO Dashboard
Track three MRR tiers, customers, churn, SaaS economics, and progress against annual goals in a monthly dashboard.
View template details →Historical Customer Cohort Analysis
Analyze historical customer transactions for retention, churn, cohort spending, and lifetime value using up to five years of data.
View template details →SaaS Pricing Sensitivity Simulator
Compare pricing, contract terms, retention, and costs across 10 customer configurations using lifetime value, acquisition cost, payback, and returns.
View template details →Mobile App / SaaS Ad Spend Guide
Analyze historical customer cohorts to estimate lifetime value, acquisition cost, and LTV-to-CAC ratios using separate mobile-app and SaaS templates.
View template details →SaaS MRR Calculator
Calculate recurring revenue across up to 20 pricing types, compare reporting periods, and estimate value from annual run rate.
View template details →Rolling SaaS Revenue Forecast
Combine existing customer cohorts and new acquisitions across four pricing tiers in a rolling, five-year revenue forecast.
View template details →Customer Spend and Retention Curves
Forecast customer counts and revenue from monthly acquisitions and spending and retention curves that change with customer age.
View template details →Financial Statement Generator
Turn transaction entries into monthly, quarterly, and annual financial statements using accrual- or cash-basis accounting.
View template details →FIFO Cost of Goods Sold Calculator
Calculate cost of goods sold by assigning the oldest available purchase-batch costs to sales entered in date order.
View template details →Annual Churn Rate Calculator
Compare three annual churn methods using forecast assumptions or actual customer dates, with monthly movement, cohort analysis, and retention patterns.
View template details →How to Calculate CAC for SaaS
Learn how to calculate customer acquisition cost and interpret timing, lifetime value, and payback, with a linked Google Sheets calculator.
Read the guide →Common questions
Before you build your SaaS forecast.
How many pricing tiers and years can I model?
The template covers five years and supports four separate pricing tiers, with monthly detail and annual reporting.
Can growth and churn assumptions change each year?
Yes. Monthly subscriber growth, subscriber churn, and revenue growth rates can vary by year. Revenue start months can also be set for individual streams.
Does the model include all three financial statements?
Yes. It includes monthly and annual income statements, balance sheets, and cash flow statements, together with a cap table and contribution and distribution summary.
Are CAC payback and LTV-to-CAC included?
Yes. The model includes monthly CAC and CAC payback, LTV, and LTV-to-CAC, with visualizations for these metrics.
Can I model one-time signup fees and financing?
Yes. One-time revenue per signup can be changed each year. Financing uses an amortization schedule, and you can set its timing or run the model without financing.
Can this be transferred to Google Sheets?
Yes. A Google Sheets transfer is available at no extra charge. Contact Jason through the contact link below to arrange it.
Is account-executive hiring help available?
An account-executive hiring add-on can be explained and implemented as part of the initial purchase, using an MRR target and annual goal-attainment assumptions. Contact Jason through the link below to discuss the setup.
When can I download the model?
The Excel template is available immediately after purchase. It is also included in the SaaS and Recurring Revenue bundle linked above.
Plan the SaaS business behind the subscriber targets
Connect growth, spending, financing, and valuation.
Build a five-year forecast and review the customer economics alongside the financial statements. For Google Sheets transfer, the account-executive hiring add-on, or custom work, contact Jason.
Disclaimer: I am not liable for any financial gain/loss that results in the use of this SaaS financial model template.
