How to build a SaaS financial model
A SaaS financial model is a bottom-up, monthly, driver-based forecast. Build it from customers, pricing, churn, expansion and sales capacity, then convert those inputs into MRR, ARR, recognized revenue, costs, cash flow and funding needs.
For a forecast covering 24 to 36 months as of, the model should show why revenue changes. Do not begin with one revenue growth percentage. That approach hides the effects of churn, pricing, hiring and customer acquisition.
SaaS Financial Model at a Glance
| Model component | Main question it answers |
|---|---|
| Customer model | How many customers will the company have? |
| Pricing model | How much revenue will each customer generate? |
| MRR bridge | What causes recurring revenue to increase or decrease? |
| Sales funnel | How many leads, opportunities and sales are required? |
| COGS model | What does it cost to serve customers? |
| Headcount model | When should the company hire and what will payroll cost? |
| P&L | Is the business profitable? |
| Cash flow | How much cash will the business use or generate? |
| Balance sheet | What assets, liabilities and equity will the company carry? |
| Scenario analysis | What happens if growth, churn or hiring differs from plan? |
1. Decide What the Model Must Help You Decide
Before opening a spreadsheet, define the decisions the model needs to support.
Common objectives include:
- Estimating cash runway
- Planning hiring
- Setting sales and marketing budgets
- Preparing for fundraising
- Testing pricing or packaging
- Forecasting the break-even month
- Calculating the funding required to reach a revenue target
- Assessing whether growth is economically sustainable
A SaaS model should usually forecast monthly for 24 to 36 months. Add annual summaries for investors, management reports and budgets.
A pre-revenue SaaS startup will rely heavily on assumptions about sales capacity, conversion rates and customer acquisition. An operating SaaS company should use historical customer cohorts, actual churn and observed expansion behavior wherever possible.
2. Create the Spreadsheet Structure
A practical SaaS financial model can use these tabs:
- Summary and outputs
- Assumptions
- Customer and revenue model
- Sales and marketing funnel
- Headcount and payroll
- Cost of goods sold
- Profit and loss statement
- Cash flow statement
- Balance sheet
- SaaS metrics
- Scenarios and sensitivities
Keep assumptions separate from calculations. This lets you change pricing, churn or hiring assumptions without rewriting formulas.
A simple color convention helps with review:
- Blue cells for user inputs
- Black cells for formulas
- Green cells for linked values
- Red cells for warnings or failed checks
3. Build the Customer Model First
The customer model drives the rest of the forecast.
At its simplest:
Ending customers
= Beginning customers
+ New customers
- Churned customers
A more useful model separates customers by plan, segment or acquisition channel.
| Customer segment | Beginning customers | New customers | Churn rate | Ending customers |
|---|---|---|---|---|
| Starter | 100 | 30 | 4.0% | 126 |
| Professional | 40 | 12 | 2.5% | 51 |
| Enterprise | 10 | 3 | 1.0% | 13 |
Segmentation matters because each group may have a different:
- Average contract value
- Gross margin
- Sales cycle
- Churn rate
- Implementation cost
- Expansion rate
- Payment term
Use Cohorts When Historical Data Exists
A cohort groups customers by the month or quarter in which they started.
For each cohort, track:
- Customers acquired
- Monthly logo retention
- MRR retention
- Expansion revenue
- Contraction revenue
- Churned customers
- Revenue by month since acquisition
Cohort modeling is more reliable than applying one churn percentage to the entire customer base. New customers often behave differently from long-standing customers.
4. Model the Sales Funnel
Connect sales activity to new customers instead of entering new customers as an unsupported assumption.
A basic funnel is:
Leads
× Lead-to-opportunity conversion rate
= Opportunities
Opportunities
× Opportunity-to-customer conversion rate
= New customers
For a sales-led SaaS company, add sales capacity:
Sales representatives
× Productivity per representative
= New customers
Productivity can mean:
- New customers per sales representative per month
- New ARR per sales representative per quarter
- Qualified opportunities created per representative
- Closed-won contracts per representative
A capacity model exposes unrealistic forecasts. If the model assumes 100 new enterprise customers next quarter but includes only two sales representatives, the gap should be visible.
Track acquisition by channel when the data supports it:
| Channel | Leads | Conversion rate | New customers | CAC |
|---|---|---|---|---|
| Organic | 1,000 | 3.0% | 30 | $200 |
| Paid search | 500 | 2.0% | 10 | $750 |
| Outbound sales | 200 | 5.0% | 10 | $1,500 |
| Partners | 100 | 8.0% | 8 | $900 |
Customer acquisition cost, or CAC, needs a consistent definition:
CAC = Sales and marketing acquisition cost ÷ New customers
Decide whether CAC includes only variable acquisition spend or all sales and marketing payroll. Either approach can work. Label the definition clearly and use it consistently.
5. Build the Pricing and MRR Model
Monthly recurring revenue, or MRR, is the predictable recurring income generated during a month. It differs from total revenue, which may also include one-time fees, implementation services, hardware and other non-recurring items. ARR annualizes recurring revenue, while MRR shows monthly movement in the revenue base.
For each plan:
Subscription MRR
= Active customers × Monthly recurring price
For seat-based pricing:
Subscription MRR
= Active customers × Average seats per customer × Price per seat
For usage-based pricing:
Usage revenue
= Billable usage units × Price per usage unit
Separate the main changes in recurring revenue:
Ending MRR
= Beginning MRR
+ New MRR
+ Expansion MRR
- Contraction MRR
- Churn MRR
+ Reactivation MRR
This bridge shows whether growth comes from new customers, expansion within existing accounts, pricing changes or returning customers.
Example MRR Bridge
Assume a SaaS company begins the month with $50,000 of MRR:
| MRR movement | Amount |
|---|---|
| Beginning MRR | $50,000 |
| New MRR | +$12,000 |
| Expansion MRR | +$3,000 |
| Contraction MRR | -$1,000 |
| Churn MRR | -$4,000 |
| Reactivation MRR | +$500 |
| Ending MRR | $60,500 |
Then:
ARR = Ending MRR × 12
ARR = $60,500 × 12
ARR = $726,000
ARR and MRR are management metrics. They are not the same as recognized revenue or cash collected.
6. Separate MRR, Bookings, Billings, Revenue and Cash
These figures are connected, but they answer different questions.
| Metric | Meaning |
|---|---|
| MRR | Recurring monthly run-rate from active subscriptions |
| ARR | Annualized recurring revenue run-rate |
| Bookings | Contracted value of signed customer agreements |
| Billings | Amount invoiced to customers |
| Revenue | Amount recognized in the income statement |
| Cash collections | Cash actually received from customers |
Example: Annual Prepaid Contract
Suppose a customer signs a $12,000 annual SaaS contract and pays upfront in January.
The model may show:
- January cash collection: $12,000
- January billings: $12,000
- Monthly recognized subscription revenue: $1,000
- Deferred revenue created at the start of the contract: $11,000
- Deferred revenue released over the service period: $1,000 per month
For U.S. GAAP reporting, revenue recognition follows Topic 606. The schedule depends on the contract, performance obligations, transaction price and when the company satisfies those obligations. FASB describes the standard as a framework for reporting the nature, timing and uncertainty of revenue from customer contracts.
Use the company's accounting policy for the final revenue schedule. Cash received is not automatically revenue recognized.
7. Calculate the Core SaaS Metrics
Add a metrics section to the model so the operating drivers and financial statements can be reviewed together.
| Metric | Formula | Why it matters |
|---|---|---|
| MRR | Recurring monthly revenue | Measures current recurring revenue |
| ARR | MRR × 12 | Shows annualized recurring scale |
| Logo churn | Churned customers ÷ Beginning customers | Measures customer retention |
| Revenue churn | Churned MRR ÷ Beginning MRR | Measures lost recurring revenue |
| Gross margin | (Revenue - COGS) ÷ Revenue | Shows delivery economics |
| CAC | Sales and marketing cost ÷ New customers | Measures acquisition efficiency |
| CAC payback | CAC ÷ Monthly gross profit per customer | Estimates months to recover CAC |
| NRR | (Beginning MRR - churn - contraction + expansion) ÷ Beginning MRR | Measures revenue retention from existing customers |
| ARPA | MRR ÷ Active customers | Measures average recurring revenue per account |
| LTV | ARPA × Gross margin ÷ Monthly churn | Provides a simple estimate of customer value |
NRR, also called net dollar retention in some contexts, measures how recurring revenue from existing customers changes after expansion, contraction and churn. It excludes new customer revenue. A result above 100% means the existing customer base is generating more recurring revenue than it did at the beginning of the period.
The simplified LTV formula works for early planning, but it assumes relatively stable pricing, gross margin and churn. Use cohort-based LTV when enough historical data exists.
8. Model Cost of Goods Sold
SaaS COGS should include the costs required to deliver and support the product.
Typical items include:
- Cloud hosting
- Data storage
- Bandwidth
- Payment processing
- Third-party APIs
- Customer support
- Infrastructure monitoring
- Implementation costs, if directly tied to delivery
- Technical operations directly supporting customers
A simple variable cost model is:
Hosting cost
= Active customers × Hosting cost per customer
For usage-heavy products:
Infrastructure cost
= Usage units × Cost per usage unit
Do not place every employee cost in operating expenses. Customer support and technical operations may belong in COGS when they directly support service delivery. The company's accounting policy should determine the final classification.
9. Add Headcount and Operating Expenses
Headcount is often the largest controllable expense in an early SaaS company. Model each role by start date rather than applying a general payroll growth percentage.
For every employee or planned hire, include:
- Department
- Start month
- Base salary
- Bonus or commission
- Payroll taxes
- Benefits
- Equity expense, if relevant
- Severance or one-time hiring costs
A monthly payroll formula can be structured as:
Monthly payroll
= Active employees × Annual salary ÷ 12
+ Benefits
+ Payroll taxes
+ Bonuses
+ Commissions
Separate headcount into:
- Cost of goods sold
- Research and development
- Sales and marketing
- General and administrative
Also include non-payroll expenses such as:
- Software subscriptions
- Rent and office costs
- Legal and accounting
- Insurance
- Travel
- Advertising
- Contractors
- Recruiting
- Equipment
- Professional services
Explicit hiring dates show how staffing decisions affect both profitability and cash runway.
10. Build the Three Financial Statements
Profit and Loss Statement
A SaaS P&L commonly includes:
Revenue
- Cost of goods sold
= Gross profit
- Research and development
- Sales and marketing
- General and administrative
= Operating income or loss
Show:
- Revenue growth
- Gross margin
- Operating margin
- EBITDA, if used
- Net income or loss
Cash Flow Statement
Cash flow should reflect the timing of collections and payments:
Beginning cash
+ Cash collections
+ Financing proceeds
- Payroll
- Operating expenses
- Capital expenditures
- Taxes
- Debt repayments
= Ending cash
Include the timing differences between revenue and cash. Key working capital accounts may include:
- Accounts receivable
- Deferred revenue
- Accounts payable
- Accrued payroll
- Prepaid expenses
- Capitalized costs
Balance Sheet
At minimum, include:
Assets
- Cash
- Accounts receivable
- Prepaid expenses
- Property and equipment
- Capitalized software, if applicable
Liabilities
- Accounts payable
- Accrued expenses
- Deferred revenue
- Debt
Equity
- Paid-in capital
- Retained earnings
- Accumulated losses
The balance sheet must balance:
Assets = Liabilities + Equity
Add a check that returns "OK" when the equation balances and "ERROR" when it does not.
11. Add Scenario Analysis
Create at least three scenarios:
- Base case
- Downside case
- Upside case
Change the operating drivers rather than manually changing the final revenue number.
Useful scenario inputs include:
- New customer growth
- Conversion rates
- Average contract value
- Pricing
- Logo churn
- Expansion rate
- Sales hiring
- Marketing spend
- Hosting costs
- Payment collection timing
- Fundraising date
For example:
| Assumption | Downside | Base case | Upside |
|---|---|---|---|
| Monthly new customer growth | 5% | 10% | 15% |
| Monthly logo churn | 5.0% | 3.0% | 2.0% |
| Gross margin | 70% | 78% | 82% |
| Sales hiring start | Month 12 | Month 9 | Month 6 |
| Cash runway | 14 months | 19 months | 25 months |
Sensitivity tables can show the effect of:
- Churn on cash runway
- CAC on required funding
- Pricing on ARR
- Hiring pace on profitability
- Gross margin on the break-even month
12. Test the Model Before Relying on It
Run these checks before using the forecast for a budget, board discussion or fundraising plan.
Customer Roll-Forward Check
Beginning customers
+ New customers
- Churned customers
- Ending customers
= 0
MRR Roll-Forward Check
Beginning MRR
+ New MRR
+ Expansion MRR
- Contraction MRR
- Churn MRR
+ Reactivation MRR
- Ending MRR
= 0
Cash Check
Beginning cash
+ Net change in cash
- Ending cash
= 0
Balance Sheet Check
Total assets
- Total liabilities
- Total equity
= 0
Also test unusual cases:
- Zero new customers
- 100% churn
- Negative or zero pricing
- A delayed fundraising round
- A large annual prepaid contract
- A customer downgrade
- A new hire starting mid-month
- A usage-based customer exceeding forecast usage
Common SaaS Financial Modeling Mistakes
Forecasting Revenue as a Single Growth Percentage
This hides the causes of growth and makes the forecast difficult to manage. Use customers, pricing and retention drivers instead.
Treating ARR as Revenue
ARR is an annualized recurring revenue metric. It does not automatically equal recognized revenue or cash collections.
Ignoring Expansion and Contraction
A model that includes only new sales and churn misses seat growth, upgrades, downgrades and add-ons.
Applying One Churn Rate to Every Customer
Churn can vary by plan, segment, tenure and acquisition channel. Use cohorts when the data supports it.
Mixing Cash and Accounting Revenue
Annual prepaid subscriptions can improve cash flow immediately while recognized revenue is spread across the service period.
Hiring Without Connecting Headcount to Output
Sales and marketing hiring should connect to leads, opportunities, productivity, new customers or new ARR.
Hiding Assumptions Inside Formulas
Keep assumptions visible and centralized. Hard-coded numbers make the model difficult to review and change.
The Simplest Workable SaaS Model
If you need a first version, build these five schedules:
Customer schedule
- Beginning customers
- New customers
- Churned customers
- Ending customers
MRR schedule
- Beginning MRR
- New MRR
- Expansion
- Contraction
- Churn
- Ending MRR
Cost schedule
- COGS
- Payroll
- Sales and marketing
- Operating expenses
Cash flow schedule
- Cash collections
- Cash expenses
- Financing
- Ending cash
Metrics dashboard
- ARR
- MRR growth
- Logo churn
- NRR
- Gross margin
- CAC
- CAC payback
- Monthly burn
- Cash runway
This first version can answer the operating questions that matter: how quickly the business is growing, what is driving that growth, how much cash it will use and when it may become self-sustaining.