SaaS Startup Financial Model in Excel: Unit Economics Guide (2026)

April 5, 2026 · VeloraAI Team
Financial Modeling Data Analysis Excel

Nine out of ten startups fail, and the number-one reason cited by post-mortems is running out of cash. A SaaS startup financial model in Excel is not a fundraising decoration — it is a survival tool. It forces founders and analysts to quantify assumptions about customer acquisition, retention, and burn rate before the runway disappears. Yet most template-based models hide their logic behind locked cells and opaque macros, leaving you unable to adapt when your board asks "what happens if churn doubles?"

This guide builds a complete SaaS financial model from scratch in Excel, covering MRR waterfall mechanics, unit economics (CAC, LTV, payback period), cohort-based churn analysis, and a three-year P&L forecast. Every formula is shown so you can follow along cell by cell.

What Is a SaaS Financial Model?

A SaaS financial model is a spreadsheet that projects a subscription-based company's revenue, expenses, and cash flow over a multi-year horizon. Unlike traditional business models that recognize revenue at the point of sale, SaaS models must account for recurring revenue streams, customer cohort behavior, and the time lag between acquiring a customer and recovering that cost.

The core output is a set of interconnected projections: a monthly recurring revenue (MRR) waterfall, a unit economics dashboard (CAC, LTV, LTV:CAC ratio, payback period), an operating expense forecast, and a cash flow runway calculation. Together, these tell investors — and founders — whether the business model actually works.

Who Needs This Model?

  • Founders preparing a pitch deck or board presentation
  • FP&A analysts at SaaS companies building operating plans
  • Venture capital associates evaluating early-stage investments
  • Finance students learning subscription business mechanics

How Do You Structure a SaaS Model Workbook?

The best SaaS models separate inputs, calculations, and outputs into distinct tabs. This makes the model auditable, flexible, and presentation-ready.

Here is the recommended tab structure:

Tab Name Purpose Key Contents
Assumptions All editable inputs in one place Pricing, growth rates, churn, CAC, headcount plan
MRR Waterfall Monthly revenue build-up New MRR, expansion, contraction, churned MRR
Unit Economics Per-customer profitability CAC, LTV, LTV:CAC, payback period
Cohort Analysis Retention tracking by signup month Monthly retention curves, net dollar retention
P&L Income statement projection Revenue, COGS, gross margin, OpEx, EBITDA
Cash Flow Runway and burn rate Operating cash flow, fundraising, months of runway
Dashboard Charts and KPIs for presentation MRR trend, unit economics gauges, runway chart

For the Dashboard tab specifically — wiring MRR trend charts, unit economics gauges, and a runway indicator into a single-screen view that auto-refreshes when you update the Assumptions tab — our financial dashboard in Excel guide covers the exact chart types and data connections you'll need.

💡 Pro Tip: Color-code every input cell (blue font on white background is the industry standard). This lets anyone reviewing your model instantly distinguish assumptions from formulas.

graph LR
    A[Assumptions Tab] --> B[MRR Waterfall]
    A --> C[Unit Economics]
    A --> D[Cohort Analysis]
    B --> E[P&L]
    C --> E
    D --> B
    E --> F[Cash Flow]
    F --> G[Dashboard]
    E --> G
    C --> G

SaaS startup team reviewing financial metrics on analytics dashboard

Step 1: Build the Assumptions Tab

The assumptions tab is the control panel for your entire model. Every number that could change — pricing, growth rate, churn, headcount — lives here and is referenced by every other tab.

Revenue Assumptions

Set up a table with monthly columns (Month 1 through Month 36 for a three-year model) and these rows:

Monthly price per customer:        $99
Starting customers (Month 1):      50
New customer growth rate (m/m):    12%
Gross churn rate (monthly):        3.5%
Expansion revenue per customer:    $8

Cost Assumptions

CAC (blended, per customer):       $650
COGS as % of revenue:              25%
Monthly payroll (starting):        $45,000
Payroll growth (quarterly step):   15%
Other OpEx (monthly):              $12,000
Other OpEx growth (m/m):           3%

⚠️ Warning: Never hard-code these numbers directly in formulas. Always reference the Assumptions tab cell. If you hard-code $650 for CAC in 40 different cells, you will inevitably forget to update one when the number changes.

Naming Your Assumptions

Use Excel named ranges for clarity:

=DEFINE.NAME("monthly_price", Assumptions!$C$3)
=DEFINE.NAME("starting_customers", Assumptions!$C$4)
=DEFINE.NAME("growth_rate", Assumptions!$C$5)
=DEFINE.NAME("churn_rate", Assumptions!$C$6)

Or simply use the Name Manager (Ctrl+F3) to assign names. This lets you write formulas like =starting_customers * (1 + growth_rate) instead of cryptic cell references.

Step 2: Build the MRR Waterfall

The MRR waterfall is the heartbeat of any SaaS model. It tracks how monthly recurring revenue changes from period to period by decomposing it into four components.

MRR Waterfall Components

graph TD
    A[Beginning MRR] --> B[+ New MRR]
    A --> C[+ Expansion MRR]
    A --> D[- Contraction MRR]
    A --> E[- Churned MRR]
    B --> F[Ending MRR]
    C --> F
    D --> F
    E --> F

Formulas for Each Component

Assume your MRR Waterfall tab has months in columns (C = Month 1, D = Month 2, etc.) and these rows:

Row 3 — Beginning Customers:

=IF(C1=1, starting_customers, D8)

This pulls starting customers for Month 1, then references the prior month's ending customers.

Row 4 — New Customers:

=ROUND(C3 * growth_rate, 0)

Row 5 — Churned Customers:

=-ROUND(C3 * churn_rate, 0)

Note the negative sign — churned customers reduce the base.

Row 6 — Ending Customers:

=C3 + C4 + C5

Row 8 — Beginning MRR:

=IF(C1=1, starting_customers * monthly_price, D12)

Row 9 — New MRR:

=C4 * monthly_price

Row 10 — Expansion MRR:

=C3 * expansion_per_customer

This assumes existing customers generate incremental expansion revenue (upsells, add-ons, seat upgrades).

Row 11 — Churned MRR:

=C5 * monthly_price

This is already negative from the churned customers calculation.

Row 12 — Ending MRR:

=C8 + C9 + C10 + C11

Example: If you start Month 1 with 50 customers at $99/month, your beginning MRR is $4,950. With 12% growth you add 6 new customers ($594 new MRR), lose 2 to churn (-$198), and gain $400 in expansion. Ending MRR = $5,746.

Calculating ARR

Annual Recurring Revenue is simply:

=C12 * 12

This annualizes the ending MRR for that month. Investors typically want to see the latest-month ARR, not an average.

How Do You Calculate CAC, LTV, and Payback Period in Excel?

These three metrics form the unit economics triangle that every investor examines. Here is exactly how to calculate each one.

Customer Acquisition Cost (CAC)

CAC measures how much it costs to acquire one new customer. The formula:

=Total_Sales_and_Marketing_Spend / New_Customers_Acquired

In your model, if Month 6 sales & marketing spend is $15,000 and you acquired 23 new customers:

=$15,000 / 23 = $652

ℹ️ Note: Use a blended CAC (total S&M spend / total new customers) for simplicity, but sophisticated models split this into paid CAC and organic CAC to identify channel efficiency.

Customer Lifetime Value (LTV)

LTV estimates the total revenue a customer generates before churning. The standard formula:

=ARPU / Monthly_Churn_Rate

Where ARPU is Average Revenue Per User per month. If ARPU = $107 (base $99 + $8 expansion) and monthly churn = 3.5%:

=$107 / 0.035 = $3,057

For a gross-margin-adjusted LTV (which investors prefer):

=(ARPU * Gross_Margin) / Monthly_Churn_Rate

=($107 * 0.75) / 0.035 = $2,293

LTV:CAC Ratio

=LTV / CAC

=$3,057 / $652 = 4.7x
LTV:CAC Ratio Interpretation Action
< 1.0x Losing money on every customer Unsustainable — fix pricing or churn immediately
1.0x – 2.0x Breaking even or marginal Improve retention or reduce acquisition cost
3.0x – 5.0x Healthy unit economics Sweet spot for most VCs
> 5.0x Potentially under-investing in growth Consider spending more aggressively on acquisition

CAC Payback Period

How many months until a customer's gross profit repays the cost of acquiring them:

=CAC / (ARPU * Gross_Margin)

=$652 / ($107 * 0.75) = 8.1 months

💡 Pro Tip: Best-in-class SaaS companies achieve payback periods under 12 months. If your payback is 18+ months, you need strong net dollar retention (>120%) to compensate, or your business will choke on working capital.

Financial spreadsheet with SaaS revenue charts and unit economics calculations

Step 3: Build a Cohort Retention Table

A cohort analysis tracks groups of customers who signed up in the same month and measures what percentage remain active over time. This is far more accurate than assuming a flat churn rate.

Setting Up the Cohort Matrix

Create a matrix where:

  • Rows = signup month (cohort)
  • Columns = months since signup (Month 0, Month 1, Month 2, ...)
  • Values = percentage of original cohort still active
           Month 0   Month 1   Month 2   Month 3   Month 4
Cohort 1   100%      96.5%     93.2%     90.0%     87.0%
Cohort 2   100%      95.8%     92.5%     89.4%
Cohort 3   100%      96.1%     93.0%
Cohort 4   100%      97.0%
Cohort 5   100%

Retention Curve Formula

For each cell in the matrix (e.g., Cohort 1, Month 2):

=Previous_Month_Retention * (1 - churn_rate)

Or if you have actual data, use:

=Active_Customers_in_Period / Original_Cohort_Size

Net Dollar Retention (NDR)

NDR measures revenue retention including expansion:

=(Beginning_MRR + Expansion - Contraction - Churn) / Beginning_MRR

=($4,950 + $400 - $0 - $198) / $4,950 = 104.1%
NDR Range Interpretation
< 90% Revenue is leaking — red flag for investors
90% – 100% Acceptable for SMB SaaS, weak for enterprise
100% – 120% Good — expansion offsets churn
> 120% Elite — typical of enterprise PLG companies (Snowflake, Datadog)

Step 4: Build the P&L Forecast

The profit and loss statement ties your revenue model to your cost structure. For a SaaS startup, the P&L has a distinctive shape — deep losses early, improving unit economics, and eventual operating leverage.

Revenue Section

Monthly Revenue = Ending_MRR

If your model also includes one-time revenue (implementation fees, professional services), add a separate line:

Total Revenue = Ending_MRR + Onetime_Revenue

Cost of Goods Sold (COGS)

SaaS COGS typically includes hosting (AWS/GCP/Azure), customer support salaries, and payment processing:

COGS = Total_Revenue * COGS_Percentage

Gross Profit = Total_Revenue - COGS
Gross Margin % = Gross_Profit / Total_Revenue

ℹ️ Note: Healthy SaaS gross margins range from 70–85%. If yours is below 60%, investors will question whether you are truly a software company or a services business.

Operating Expenses

Break OpEx into standard SaaS categories:

Sales & Marketing    = New_Customers * CAC
Research & Development = Engineering_Headcount * Avg_Salary / 12
General & Administrative = Fixed_Monthly_Amount * (1 + growth_rate)

EBITDA and Burn Rate

EBITDA = Gross_Profit - Total_OpEx
Monthly Burn Rate = -EBITDA  (when EBITDA is negative)
Runway (months) = Cash_Balance / Monthly_Burn_Rate

The runway formula is the most important output for early-stage companies:

=Cash_Balance / MAX(1, -EBITDA)

The MAX(1, ...) prevents a divide-by-zero error if the company is profitable.

Step 5: Scenario Analysis and Sensitivity Tables

No financial model is complete without stress-testing its assumptions — for a complete walkthrough of one-way tables, tornado charts, and dynamic scenario switches, see our sensitivity analysis guide for Excel financial models. Excel's Data Table feature is perfect for this.

Two-Variable Data Table

To see how Ending MRR at Month 36 changes across different growth rates and churn rates:

  1. Place your output formula (Ending MRR at Month 36) in cell F2
  2. List growth rates in F3:F8 (8%, 10%, 12%, 15%, 18%, 20%)
  3. List churn rates in G2:L2 (2%, 3%, 3.5%, 4%, 5%, 6%)
  4. Select the range F2:L8
  5. Go to Data → What-If Analysis → Data Table
  6. Row input cell = your churn_rate assumption cell
  7. Column input cell = your growth_rate assumption cell

The result is a grid showing Ending MRR across 30 different scenarios.

Quick Scenario Toggle

Create three named scenarios in the Assumptions tab:

Assumption Bear Case Base Case Bull Case
Growth rate (m/m) 8% 12% 18%
Monthly churn 5.0% 3.5% 2.0%
CAC $850 $650 $450
ARPU $89 $107 $129
Gross margin 68% 75% 82%

Use a single toggle cell (e.g., Assumptions!$B$1 with values 1, 2, or 3) and drive every assumption with INDEX:

=INDEX(C5:E5, 1, scenario_toggle)

This lets you instantly switch the entire model between scenarios with one cell change.

⚠️ Warning: Always present your base case to investors first, then show the range. Leading with the bull case destroys credibility. Leading with the bear case creates unnecessary anxiety.

Collaborative startup workspace with team analyzing growth metrics

Common Mistakes in SaaS Financial Models

1. Ignoring Churn Compounding

A 3.5% monthly churn rate does not mean 42% annual churn. The correct annualized formula:

=1 - (1 - monthly_churn)^12

=1 - (1 - 0.035)^12 = 34.9%

2. Confusing MRR With Cash Collected

MRR is recognized revenue, not cash. Annual prepayments, deferred revenue, and failed payments create a gap. Your cash flow tab must account for billing frequency and collection lag — the same revenue-to-cash timing differences that a three-statement financial model captures through its integrated balance sheet and cash flow statement. Modeling that cash collection gap accurately requires the same DSO-based working capital logic covered in our working capital schedule guide for Excel. For startups managing tight runway — where week-level cash visibility matters as much as the annual model — our 13-week cash flow forecast guide for Excel covers the rolling treasury view that bridging rounds and board meetings require.

3. Flat-Lining CAC

CAC almost never stays constant. It typically increases as you exhaust your most efficient channels. Model CAC with a step-up function:

=base_CAC * (1 + 0.02 * MAX(0, month_number - 12))

This increases CAC by 2% per month after Month 12, reflecting channel saturation.

4. Forgetting Gross Margin in LTV

Raw LTV (ARPU / churn) overstates customer value because it ignores the cost of serving that customer. Always use gross-margin-adjusted LTV when calculating LTV:CAC.

5. Missing the Rule of 40

The Rule of 40 states that a SaaS company's growth rate plus profit margin should exceed 40%. Add this check to your dashboard:

=Annual_Revenue_Growth_Rate + EBITDA_Margin

If the result is below 40%, the model signals an imbalance between growth and efficiency.

How Can AI Speed Up SaaS Financial Modeling?

Building a SaaS model from scratch takes 10–20 hours for an experienced analyst. AI tools can compress that dramatically by handling the repetitive formula writing and assumption research.

Formula generation is the clearest win. Instead of manually writing =IF(C1=1, starting_customers, D8) for every waterfall row, you describe the logic in plain English — "carry forward ending customers as next month's beginning customers" — and let AI generate the formula.

Assumption validation is another area where AI excels. Feed your model assumptions into an AI tool, and it can benchmark them against publicly available SaaS metrics (median churn rates by segment, typical CAC by channel, gross margin ranges by business model).

Tools like VeloraAI bring this capability directly into Excel, letting you describe what you want a formula to do in natural language and get a working formula instantly — no more hunting through Microsoft documentation for the right combination of INDEX, MATCH, and IF. For a broader look at how AI tools are reshaping every stage of financial model construction — from formula generation and data cleaning to scenario analysis and variance commentary — see our guide on AI workflows for financial modeling.

Frequently Asked Questions

What is the best Excel template for a SaaS startup financial model?

The best template is one you build yourself or fully understand. Pre-built templates from sources like the SaaS CFO or Y Combinator's standard model provide solid starting points, but you must customize assumptions for your specific business — pricing model, customer segments, billing frequency, and cost structure all vary dramatically between SaaS companies.

How many months should a SaaS financial model forecast?

Most early-stage SaaS models project 36 months (three years). Seed-stage investors want to see 18–24 months of detailed monthly projections plus a high-level annual view for Years 2–3. Series A and beyond typically require 36 months monthly with annual projections through Year 5.

What is a good LTV:CAC ratio for a SaaS startup?

A 3:1 LTV:CAC ratio is the commonly cited benchmark, meaning each customer generates three times the revenue it cost to acquire them. However, context matters — enterprise SaaS with high ACVs can sustain 5:1+ ratios, while PLG (product-led growth) models often operate at 2:1 with much lower CAC and shorter payback periods.

How do you model churn if you only have a few months of data?

Start with industry benchmarks — B2B SaaS monthly gross churn typically ranges from 2–5% for SMB and 0.5–1.5% for enterprise. Use your actual data to calculate a trailing three-month average, then sensitivity-test the model with churn rates 50% above and below your assumption to understand the impact range.

Should I model monthly or annual revenue?

Model monthly. SaaS businesses operate on monthly cycles (MRR, monthly churn, monthly CAC). Annual aggregations should be calculated from monthly data, not the other way around. Monthly granularity also helps you spot inflection points — the month your burn rate peaks, the quarter expansion MRR starts offsetting churn, or the period when you need to raise.

Wrapping Up

A well-built SaaS financial model does more than impress investors — it becomes your operating system. It tells you when to hire, how much to spend on acquisition, and exactly when the money runs out if assumptions miss. As the company matures, budget vs actual variance analysis becomes the monthly mechanism for holding each team accountable to the operating plan and diagnosing where growth assumptions diverged from reality.

Start with the MRR waterfall, layer in unit economics, add the P&L, and stress-test everything with scenarios. Keep every assumption in one tab, every formula transparent, and every output defensible. If your model cannot survive a 30-minute board interrogation, it is not ready. Every round also dilutes existing holders — tracking SAFE conversions, option pool top-ups, and each investor's fully-diluted percentage belongs in a cap table model in Excel that maps directly to the exit waterfall your investors will model at each stage. At later funding stages, investors layer a DCF valuation in Excel on top of the SaaS model's revenue projections — so building your MRR forecast with a clean annual summary makes it straightforward to feed terminal-year free cash flow into a discounted cash flow analysis.

For the formula-heavy parts of this work — waterfall calculations, cohort matrices, and scenario tables — VeloraAI can generate the Excel formulas from plain-English descriptions, saving hours of manual writing and debugging.