Financial model template for a SaaS or subscription business for consumer, SMB, midmarket, or Enterprise SaaS.
4.9(69)9,260 downloads
$20 suggested, but "0" is ok. All donations appreciated.
Instant Access
Hemrock’s financial models are available to everyone. All donations are appreciated to support their continue development and support.
This model is open source under the Apache License 2.0. You can use it, modify it, redistribute it, and incorporate it into commercial work subject to the license. Apache 2.0 license
Forecast a SaaS, subscription, or services business for consumer, SMB, midmarket, or enterprise-style companies. Supports two modes: aggregate forecasting from growth and churn assumptions, or pipeline-based forecasting where you list specific deals with size, contract length, billing cycle, close probability, start date, and expansion.
Outputs a full set of SaaS metrics (MRR, ARR, LTV) and revenue accounting (bookings, billings, revenue, deferred revenue). Intentionally simplified: no expenses, no net income.
For financial statements and full reporting, use the Standard Financial Model.
Forecast a SaaS, subscription, or services business. Two modes:
Either way, outputs MRR, ARR, bookings, billings, revenue, deferred revenue, and LTV. Intentionally simple. No expenses, no income statement. Just the revenue side, clean.
Focused tool for SaaS and enterprise revenue mechanics. If you need full financial statements, expenses, hiring, and cap table, use the Standard Financial Model. Same revenue logic plus everything else.
Every cell open. Inputs in blue, formulas in black. Built to be edited.
Why download this when AI can forecast SaaS for me?
AI will produce a SaaS forecast that looks right, and subscription mechanics (cohort churn, deferred revenue, MRR versus billings) are a common place for it to be subtly wrong. This gives it a structure where that accounting already holds, so it customizes instead of reinventing it.
Aggregate or pipeline, which mode do I need?
Aggregate if revenue comes from statistical churn across many users (consumer, SMB, midmarket). Pipeline if it depends on a handful of large contracts (enterprise, services, agencies). You can switch between them, so start with whichever fits and change later.
Is it too complex to use?
No, this is deliberately the simple one: just the revenue side, no expenses or statements. If you need the full picture, the Standard Financial Model has the same revenue logic plus everything else.
Excel or Google Sheets?
Both. All formulas open, no macros.
“Taylor's SaaS model has helped me quickly and easily build a financial model. It allowed me to easily capture the assumptions about my business model and discuss them with my investors. Allowing me to close a high six-figure seed round in record time.”
The downloadable model is licensed under the Apache License 2.0. Hemrock trademarks and other brand assets are not included in that license. Financial models are provided as-is for informational and analytical purposes. They may contain assumptions, simplifications, errors, or omissions and are not legal, tax, accounting, investment, or other professional advice. You are responsible for reviewing the model and determining whether it is appropriate for your circumstances. See the Apache License 2.0 and the Hemrock terms for complete terms.
$20 suggested, but "0" is ok. All donations appreciated.
Instant Access