Sign in

SaaS Forecasting Tool

Financial model template for a SaaS or subscription business for consumer, SMB, midmarket, or Enterprise SaaS.

4.9(51)6,512 downloads

Pay what you want

$20 suggested, but "0" is ok. All donations appreciated.

$USD

Instant Access

Download to Excel or Copy to Google Sheets
Easy to customize with your AI
Free email support

License and Terms apply on all purchases, services, and courses.

Get help buying. Call, text, WhatsApp 1-646-770-0052.

Highlights

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.

What you'll do with it

Forecast a SaaS, subscription, or services business. Two modes:

  • Aggregate. Inputs for growth rate, conversion, churn, contract length, billing cycle, revenue per subscriber. Best for consumer, SMB, or midmarket SaaS where revenue comes from statistical churn across many users.
  • Pipeline-based. List specific customers and contracts, each with size, contract length, billing cycle, close probability, start date, expansion, and churn. Best for enterprise SaaS, services, consulting, and agencies, where revenue depends on a small number of large contracts.

Either way, outputs MRR, ARR, bookings, billings, revenue, deferred revenue, and LTV. Intentionally simple. No expenses, no income statement. Just the revenue side, clean.

When to use this vs. the Standard Financial Model

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.

Edit with AI

Cells open. Inputs in blue, formulas in black. Built to be edited.

Documentation

Ratings

4.9(51 ratings)
5
92%
4
6%
3
2%
2
0%
1
0%

Reviews

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.
Aaron Vidas
Aaron Vidas· CEO, StrategyBox
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.
Aaron Vidas· CEO, StrategyBox