Financial model template for a SaaS or subscription business for consumer, SMB, midmarket, or Enterprise SaaS.
4.9(68)9,260 downloads
$20 suggested, but "0" is ok. All donations appreciated.
Instant Access
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.”
“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.”
$20 suggested, but "0" is ok. All donations appreciated.
Instant Access