A 36-month SaaS financial model for founders and finance leads who need to show how subscription growth turns into revenue, cash and runway. It combines an MRR waterfall, acquisition channels, a hiring plan and full financial statements in one workbook.
What is included
Pricing: up to 5 tiers with price, mix, annual prepaid plans and discounts, logo churn, expansion and contraction per tier, including deferred revenue for annual billing.
Acquisition: 5 paid channels with budgets, growth and customer acquisition cost, plus organic and referral growth and sales reps with quota and ramp-up.
MRR waterfall: customers, new, expansion, contraction and churned MRR, ARR, billings and deferred revenue month by month.
Team and costs: a 25-role hiring plan by department, 12 cost lines, a cap table and up to 3 loans.
Statements: a 36-month P&L, cash flow and a balance sheet that checks to zero.
Unit economics: NRR, GRR, churn, CAC by channel, LTV/CAC, payback, magic number, burn multiple and Rule of 40.
Dashboard: headline SaaS metrics, a 7-point scorecard against your targets, a verdict and 4 charts.
How to use it
1. Open the Start Here tab: a three-step quick start, a color key and a clickable list of every sheet.
2. Replace the example values in the yellow input cells with your own. Everything else is calculated, and formulas are left visible so you can audit every step.
3. Read the Dashboard. Every number on it traces back to an input, and the scorecard compares the plan with the targets you set.
4. Switch between the Base, Upside and Downside scenarios to see what really drives the result.
Technical notes
The model is a single .xlsx workbook for Microsoft Excel 2016 or newer and Microsoft 365 on Windows and Mac. It also works in Google Sheets. There are no macros, add-ins, external links or locked cells, and it is set up to print one page wide. It ships with a complete worked example so you can see how everything fits together before entering your own numbers.
Quality: the workbook is generated from code and must pass automated tests against hand-calculated cases with zero formula errors, and it is opened and recalculated in Microsoft Excel before release. We use AI-assisted tooling in our build and testing process; the structure, logic and checks are designed and reviewed by us.
This is a planning and analysis tool, not financial, tax, legal or investment advice.
Got a question about the product? Email us at support@flevy.com or ask the author directly by using the "Ask the Author a Question" form. If you cannot view the preview above this document description, go here to view the large preview instead.
Source: Best Practices in SaaS, Integrated Financial Model Excel: SaaS Financial Model with MRR and Unit Economics Excel (XLSX) Spreadsheet, ModelDesk
|
Download our FREE Digital Transformation Templates
Download our free compilation of 50+ Digital Transformation slides and templates. DX concepts covered include Digital Leadership, Digital Maturity, Digital Value Chain, Customer Experience, Customer Journey, RPA, etc. |