Question 1

What's included in this SaaS business plan template?

Accepted Answer

The template includes 5 worksheets: an Executive Summary with pricing, ACV, MRR targets, and CAC payback; a Startup Costs & Funding sheet breaking down product development, sales and marketing, customer success, and working capital; a 12-month Revenue Forecast built from customer acquisition and churn with resulting MRR growth; a 3-Year Projected P&L showing revenue, gross profit, operating expenses, CAC payback period, magic number, and EBITDA; and a Dashboard with MRR growth trends, customer growth, CAC, LTV, churn rate, net revenue retention, and profitability trajectory. All formulas are pre-built.

Question 2

What's monthly recurring revenue (MRR) and how do I calculate it?

Accepted Answer

MRR is the amount of revenue you can expect to receive every month from active subscriptions, excluding one-time charges. Calculate it as: number of active customers × average monthly subscription price. For example, if you have 100 customers paying $2,000 per year ($166.67 per month), your MRR is 100 × $166.67 = $16,667. If you have some customers on annual contracts ($2,000/year) and some on monthly ($200/month), calculate the monthly equivalent for each and sum. MRR is the core metric of SaaS because it's recurring (predictable) and you can see it trend upward as you grow.

Question 3

What's annual contract value (ACV) and how is it different from MRR?

Accepted Answer

ACV is the total revenue you receive per customer per year. MRR is the monthly equivalent. For example, a customer with $2,000 ACV generates $166.67 in MRR (ACV ÷ 12). Some SaaS companies have a mix of ACV: enterprise customers with $100,000+ ACV, mid-market at $10,000–$50,000, and SMB at $1,000–$5,000. Calculate your blended ACV: (% enterprise × enterprise ACV) + (% mid-market × mid-market ACV) + (% SMB × SMB ACV). This drives your expected customer count: to reach $1,000,000 ARR with $10,000 ACV, you need 100 customers; with $50,000 ACV, you need 20.

Question 4

What's customer churn and how does it affect growth?

Accepted Answer

Customer churn is the percentage of customers who cancel (or downgrade) each month. Monthly churn of 5% means 5% of your customer base churns every month. This compounds: if you have 100 customers at month 1 with 5% monthly churn, you'll have 95 at month 2, 90 at month 3, etc. Importantly, churn reduces growth even if you acquire new customers: if you acquire 10 new customers per month but lose 5 to churn, your net growth is 5 per month. Low churn is critical: 2% monthly churn is excellent (76% annual retention); 5% is acceptable but means you must aggressively acquire new customers; 10%+ is problematic and suggests product or market issues.

Question 5

What's customer lifetime value (LTV) and how do I calculate it?

Accepted Answer

Customer lifetime value is the total profit you expect to receive from a customer over their lifetime. Calculate it as: (ACV × Gross Margin %) ÷ Monthly Churn Rate. For example, if ACV is $2,000, gross margin is 70%, and monthly churn is 5%, LTV = ($2,000 × 70%) ÷ 0.05 = $28,000. This is the maximum you should spend to acquire that customer (CAC). If you spend more on acquisition than the customer's LTV, you'll never be profitable. The Dashboard calculates LTV so you can see whether your unit economics are healthy.

Question 6

What's customer acquisition cost (CAC) and why does it matter?

Accepted Answer

CAC is the total cost to acquire one customer. Calculate it as: (Sales + Marketing + Customer Success ramp) ÷ Number of new customers acquired. For example, if you spend $100,000 per month on sales and marketing and acquire 10 new customers, your CAC is $10,000 per customer. Compare this to LTV: if LTV is $40,000 and CAC is $10,000, you have a healthy 4x LTV:CAC ratio. If CAC is $20,000 and LTV is $25,000, your unit economics are marginal. The higher your CAC, the more profitable you need to be and the longer you need to keep customers.

Question 7

What's CAC payback period and what should I target?

Accepted Answer

CAC payback period is the number of months it takes for a customer's gross profit to recover the cost to acquire them. Calculate it as: CAC ÷ (ACV × Gross Margin % ÷ 12). For example, if CAC is $10,000, ACV is $24,000 (= $2,000/month), and gross margin is 70%, CAC payback = $10,000 ÷ ($24,000 × 70% ÷ 12) = 7.1 months. Under 12 months is good; under 6 months is excellent. Longer than 12 months means you need deep pockets to grow because you won't recover acquisition costs for over a year. Early-stage SaaS typically has 10–18 month CAC payback; mature SaaS has 6–12 months.

Question 8

What's net revenue retention (NRR) and why do investors focus on it?

Accepted Answer

Net revenue retention (also called net dollar retention) is the percentage of revenue retained from existing customers after accounting for churn, downgrades, and expansion. NRR = (Beginning Revenue - Churned + Downgrades + Upgrades) ÷ Beginning Revenue. For example, if you start with $100,000 MRR and end with $103,000 MRR from the same cohort of customers (after losses from churn, gains from upsells), your NRR is 103%. NRR over 100% means your existing customer base is growing despite losing some customers—this is the hallmark of a healthy SaaS. High-growth SaaS targets 120%+ NRR; mature SaaS targets 100%+.

Question 9

What's the magic number and what does it tell me?

Accepted Answer

Magic number is a measure of sales efficiency: (revenue growth quarter-over-quarter) ÷ (sales and marketing spend in previous quarter). For example, if revenue grew from $500,000 to $600,000 in Q2 (growth of $100,000) and you spent $50,000 on sales and marketing in Q1, magic number is $100,000 ÷ $50,000 = 2. Magic number over 0.75 is good; over 1.0 is excellent. This tells you how efficiently you're converting sales and marketing spend into revenue growth. High magic number means your growth is efficient; low magic number means you're spending too much to generate growth.

Question 10

Does this work in Google Sheets?

Accepted Answer

Yes. The template is built in Excel (.xlsx) but is fully compatible with Google Sheets. Upload the file to Google Drive, open it with Google Sheets, and all formulas, formatting, and charts will work without modification. You can share it with your co-founders, accountant, or potential investors directly from Google Drive.

SaaS Business Plan Template

What's Inside This SaaS Business Plan Template

Executive Summary

Startup Costs & Funding

Revenue Forecast

Projected P&L

Dashboard

SaaS Business Plan Template Features

How to Use This SaaS Business Plan Spreadsheet

Why SaaS Businesses Need a Solid Business Plan

SaaS Industry at a Glance

Revenue Drivers

Key Cost Categories

Typical Margins

Seasonality

Key Performance Indicators

SaaS Business Plan Template FAQ

More SaaS Templates

More Business Plan Templates