SaaS Metrics 7 min read

Unit Economics Calculator: Free Template (Google Sheets)

Free unit economics calculator template for Google Sheets. LTV, CAC, LTV:CAC ratio, and payback period formulas with benchmarks by stage and segment.

Siddharth Gangal

TL;DR

  • LTV = (ARPA × Gross Margin %) ÷ Monthly Churn. CAC = Total S&M Spend ÷ New Customers. LTV:CAC = LTV ÷ CAC. Always use gross-margin-adjusted figures.
  • 3:1 LTV:CAC is the minimum for a fundable SaaS business. Growth-stage target is 3–4:1. Scale-stage top quartile is 5:1+.
  • CAC payback benchmarks: SMB <12 months · Mid-market <18 months · Enterprise <24 months. Series A deal-breaker threshold is 18+ months.
  • The calculator structure: four sections — CAC inputs, LTV inputs, ratio outputs, benchmark comparison table.
  • Unit economics that look fine on a spreadsheet can hide segment-level problems. Track by cohort, channel, and customer segment — not just company-wide averages.

Unit economics answer one question: does acquiring and serving a customer make financial sense? For SaaS companies, that question resolves into four numbers — CAC, LTV, LTV:CAC ratio, and CAC payback period. Every investor due diligence process, every board discussion about go-to-market efficiency, and every budget decision about scaling sales and marketing comes back to these four figures.

The formulas are not complex. The discipline is in calculating them correctly — using gross-margin-adjusted values, segmenting by customer type, and tracking trends across cohorts rather than reporting a single blended company-wide average. This post covers the exact formulas, a worked example, the complete calculator structure for Google Sheets, benchmarks by stage and segment, and what investors look for at each funding round.

Unit Economics. The direct revenues and costs associated with acquiring and serving a single customer, expressed as ratios that measure whether and how profitably a business model scales. For SaaS, the primary unit economics metrics are Customer Acquisition Cost (CAC), Customer Lifetime Value (LTV), LTV:CAC ratio, and CAC payback period.

The Four Core Formulas

1. Customer Acquisition Cost (CAC)

CAC = Total Sales & Marketing Spend ÷ New Customers Acquired

Include: salaries, commissions, ad spend, tools, events, agency fees
Timeframe: use the same period for spend and customers (typically quarterly or trailing 12 months)

The most common CAC calculation error is using only marketing spend while excluding sales team costs. A correct CAC includes all costs required to bring a customer to close — marketing programs, sales rep salaries and commissions, SDR costs, sales engineering, and any demand generation tooling. For companies with longer sales cycles, use a lagged CAC calculation: apply the spend from the prior quarter to the customers closed this quarter.

2. Customer Lifetime Value (LTV)

LTV = (ARPA × Gross Margin %) ÷ Monthly Churn Rate

Where: ARPA = Average Monthly Revenue Per Account
Gross Margin % = (Revenue − COGS) ÷ Revenue
Monthly Churn Rate = % of customers who cancel each month

Gross margin is not optional in LTV calculations. It adjusts lifetime value for the cost of delivering the product — hosting, support, third-party services, customer success headcount. A business with $500 ARPA and 60% gross margin has the same raw revenue per customer as one with 80% gross margin, but generates $100 less gross profit per customer per month. Over a customer lifetime, that gap is significant.

For annual contracts, convert to monthly values first: divide annual contract value by 12 to get monthly ARPA. Then apply gross margin and monthly churn. If you use annual churn, divide by 12 before plugging into the formula.

3. LTV:CAC Ratio

LTV:CAC Ratio = LTV ÷ CAC

A ratio of 3.0 means each customer generates 3× their acquisition cost in gross profit over their lifetime.

4. CAC Payback Period

CAC Payback (months) = CAC ÷ (New MRR per Customer × Gross Margin %)

New MRR per Customer = ACV ÷ 12 (for annual contracts)

Payback period and LTV:CAC are complementary metrics that answer different questions. Payback measures cash-flow timing — when does this investment break even? LTV:CAC measures ultimate profitability — how good is the return? A business can have a high LTV:CAC ratio but still be capital-intensive if the payback period is long. Both metrics belong in every unit economics review.

Worked Example

Consider a mid-market SaaS company with the following operating profile for the trailing twelve months:

Input Value
Annual S&M spend$1,200,000
New customers acquired (year)80
CAC$15,000
Average ACV$18,000
Average monthly ARPA (ACV ÷ 12)$1,500
Gross margin75%
Monthly churn rate1.5%

LTV calculation: ($1,500 × 0.75) ÷ 0.015 = $1,125 ÷ 0.015 = $75,000

LTV:CAC ratio: $75,000 ÷ $15,000 = 5.0:1

CAC payback: $15,000 ÷ ($1,500 × 0.75) = $15,000 ÷ $1,125 = 13.3 months

At 5:1 LTV:CAC and 13.3-month payback, this business has strong unit economics for a mid-market motion. The LTV:CAC ratio sits in top-quartile territory. The payback period is within the 12–18 month benchmark for this segment. Both signals point toward a business that can efficiently scale go-to-market investment.

Changing monthly churn from 1.5% to 2.5% in this example drops LTV from $75,000 to $45,000 and LTV:CAC from 5.0 to 3.0. A single percentage point of churn improvement is worth more than almost any go-to-market optimization.

Unit Economics Calculator Template Structure

The template below replicates the exact structure you should use in Google Sheets. Build it as four sequential sections on a single tab, with a fifth summary section at the top that references the outputs.

Section 1: CAC Inputs

Cell Label Input / Formula Notes
Sales team salaries & commissions (period)[manual input]All sales headcount cost
Marketing programs spend[manual input]Paid, events, content, tools
Marketing team salaries[manual input]Include allocated overhead
Total S&M spend=SUM(B2:B4)Auto-sum of all inputs
New customers acquired (period)[manual input]Net-new logos only
CAC=B5/B6Total S&M ÷ New Customers

Section 2: LTV Inputs

Cell Label Input / Formula Notes
Average ACV ($)[manual input]Annual contract value per customer
Average monthly ARPA=B10/12ACV ÷ 12
Gross margin (%)[manual input]Enter as decimal (e.g. 0.75)
Monthly churn rate (%)[manual input]Enter as decimal (e.g. 0.015)
Gross profit per customer per month=B11*B12ARPA × Gross Margin
LTV=B14/B13Gross profit per month ÷ Churn

Section 3: Ratio Outputs

Metric Formula Conditional Format Rule
LTV:CAC Ratio=B15/B7Green ≥3 · Yellow 2–3 · Red <2
CAC Payback (months)=B7/B14Green <12 · Yellow 12–18 · Red >18
Magic Number=(New ARR − Prior ARR) × GM% ÷ Prior Qtr S&MGreen ≥0.75 · Yellow 0.5–0.75 · Red <0.5
Avg Customer Lifetime (months)=1/B13Reference only
LTV:CAC Payback Multiple=B20/B21LTV:CAC ÷ Payback (efficiency index)

Section 4: Benchmark Comparison

Lock this section so it cannot be accidentally edited. Use conditional formatting on ratio outputs (Section 3) to highlight cells against the target benchmarks below.

Segment LTV:CAC Target CAC Payback Target Gross Margin Floor
PLG / Self-serve5:1+<6 months75%+
SMB (ACV <$10K)3–4:1<12 months70%+
Mid-market (ACV $10K–$50K)3–5:1<18 months72%+
Enterprise (ACV $50K+)3:1+ (with NRR >120%)<24 months70%+

Benchmarks by Funding Stage

Investors calibrate their expectations against the funding stage, not just the segment. The same 3:1 LTV:CAC ratio that satisfies a Series A investor is barely acceptable at Series B. Unit economics are expected to strengthen with scale — if they are not improving, that is a signal the business model has structural problems.

Pre-Seed and Seed

At pre-seed and seed, investors do not expect refined unit economics — they expect evidence of the business model and early signals. A 2–3:1 LTV:CAC ratio is acceptable. More important is whether the company understands which acquisition channels produce the best-quality customers and whether churn is stabilizing. Seed-stage companies have a median CAC payback period around 16–17 months, according to recent benchmarking data. The key question investors are asking is not "are unit economics great?" but "is there a path to 3:1+ at scale?"

Series A

Series A investors in 2025 are raising the bar. The median expectation is 3.5:1+ LTV:CAC and CAC payback under 18 months. A payback period above 18 months is frequently cited as a deal-breaker. The five non-negotiables most cited by Series A investors are: $1M–$3M ARR, 100%+ YoY growth, 50+ customers, 3:1+ LTV:CAC, and 60%+ gross margin for SaaS. The businesses that struggle at Series A are those growing fast with deteriorating unit economics — investors have significantly less tolerance for that pattern than they did in 2021–2022.

Series B and Growth Stage

At Series B and beyond, unit economics replace growth rate as the primary evaluation lens. Investors expect LTV:CAC above 4:1 and payback under 12–15 months for SMB and mid-market motions. Enterprise is allowed up to 24 months if net revenue retention exceeds 120%. The Rule of 40 becomes a filter at this stage — companies that satisfy both Rule of 40 and strong unit economics command significantly higher revenue multiples. Companies with LTV:CAC above 5:1 and payback under 12 months are described as "efficient growers" and typically command a 1.5–2× valuation premium over peers with equivalent ARR growth but weaker unit economics.

Stage Min LTV:CAC Target LTV:CAC CAC Payback Investor Lens
Seed2:12–3:1<24 monthsDirection of travel
Series A3:13.5–4:1<18 monthsProof of scalable GTM
Series B3.5:14–5:1<15 monthsEfficient scaling engine
Scale / IPO-track4:15:1+<12 monthsRule of 40 + unit econ

The Limits of a Blended Calculator

The most important limitation of any unit economics calculator is that company-wide blended averages can mask serious segment-level problems. A 4:1 blended LTV:CAC might reflect a 7:1 ratio on enterprise customers, 3:1 on mid-market, and 1.5:1 on SMB — a business that is quietly losing money on its highest-volume segment while looking fine in aggregate.

The template above works best when populated separately for each customer segment, each acquisition channel, and each customer cohort. If you only run one analysis, run it by channel: know whether your paid, organic, partner, and outbound channels each individually produce positive unit economics. Channels that look profitable in aggregate sometimes rely on one high-performing source to subsidize others.

Teams using Fairview can track unit economics by segment, cohort, and channel in a single operating view — rather than rebuilding the calculation monthly in a spreadsheet. The advantage is not just speed; it is the ability to see how unit economics are trending within a quarter, before the data hits a board deck.

Five Levers That Improve Unit Economics

Unit economics improve through four input variables: lower CAC, higher ARPA, higher gross margin, or lower churn. In practice, these break down into five actionable levers:

1. Raise gross margin. This is the highest-leverage lever because it improves both LTV and payback period simultaneously. A 5-point improvement in gross margin (from 70% to 75%) on $1,000 ARPA at 2% monthly churn increases LTV from $35,000 to $37,500 — a $2,500 improvement per customer with no change in acquisition cost.

2. Reduce churn. LTV is inversely proportional to churn. Cutting monthly churn from 2% to 1.5% increases average customer lifetime from 50 months to 67 months — a 33% increase in LTV per customer. No go-to-market investment produces returns of that magnitude. Improving onboarding, time-to-value, and success coverage are usually the most capital-efficient ways to improve unit economics.

3. Increase average contract value. Higher ACV at the same customer count raises ARPA, which improves LTV and shortens payback period. Expanding deal sizes through product packaging, seat-based pricing, or usage-based tiers compounds with improved retention.

4. Shift acquisition channel mix. Not all channels produce the same CAC. Organic and referral channels typically produce CAC that is 3–5× lower than outbound and paid channels. Systematically growing the share of lower-CAC channels improves blended unit economics without touching the product or pricing model.

5. Shorten sales cycle length. For complex sales motions, longer cycles increase the cost per acquisition (more sales rep time per deal). Tools that accelerate qualification, reduce demo-to-close time, or improve conversion at specific funnel stages directly reduce effective CAC. Fairview's operating data often surfaces where exactly in the sales funnel conversion is leaking — the first step toward fixing cycle length is knowing where time is being spent.

Frequently asked questions

What is a good LTV:CAC ratio for SaaS?

A 3:1 LTV:CAC ratio is the widely cited floor for a sustainable SaaS business. Early-stage companies under $2M ARR can operate at 2–3:1 while building product-market fit. Growth-stage companies between $2M and $10M ARR should target 3–4:1. At $10M+ ARR, top-quartile operators often reach 5:1 or higher through refined go-to-market and lower churn. Product-led growth businesses with efficient acquisition frequently exceed 5:1. A ratio above 5:1 can also indicate underinvestment in growth — if you have exceptional unit economics, the right move may be to invest more aggressively in acquisition.

How do you calculate LTV for a SaaS company?

The standard SaaS LTV formula is: LTV = (ARPA × Gross Margin %) ÷ Monthly Churn Rate. ARPA is the average monthly revenue per account; gross margin accounts for the cost of delivering the product; and churn rate is the percentage of customers who cancel each month. For example, with $500 ARPA, 75% gross margin, and 2% monthly churn: LTV = ($500 × 0.75) ÷ 0.02 = $18,750. Always use gross-margin-adjusted LTV — not raw revenue LTV — when reporting to investors or making go-to-market investment decisions. Raw revenue LTV systematically overstates the value of each customer.

What CAC payback period do investors expect at Series A?

Series A investors typically expect CAC payback under 18 months, with best-in-class companies showing 6–12 months. A payback period above 18 months is frequently cited as a deal-breaker for growth-stage rounds. The threshold varies by segment: SMB-focused businesses should target under 12 months; mid-market under 18 months; enterprise is allowed up to 24 months provided net revenue retention exceeds 120%. Benchmarkit's 2025 data shows the median across funded SaaS is now around 18 months, up from 14 months in prior years — reflecting a more capital-constrained environment where investors weight go-to-market efficiency more heavily than in 2021.

What is the difference between LTV:CAC ratio and CAC payback period?

LTV:CAC ratio measures the total long-horizon return on acquisition — how much gross profit a customer generates relative to what it cost to acquire them. CAC payback period measures how quickly that investment breaks even — the number of months before gross profit from the customer equals CAC. Both are required for a complete picture. LTV:CAC tells you the ultimate profitability of your go-to-market model. Payback period tells you the cash-flow timing and capital intensity of that model. A high LTV:CAC with a long payback period signals a capital-intensive business that may struggle to self-fund growth. A short payback with a modest LTV:CAC can still be a strong business if customers renew predictably.

How do I build a unit economics calculator in Google Sheets?

Structure the sheet in four sections: (1) CAC Inputs — total S&M spend, new customers acquired, CAC formula; (2) LTV Inputs — average revenue per account, gross margin %, monthly churn rate, LTV formula; (3) Ratio Outputs — LTV:CAC ratio, CAC payback period in months, magic number; (4) Benchmark Comparison — hardcoded stage and segment benchmarks next to your calculated values. Use named ranges for each input so formulas are readable (e.g., =LTV/CAC instead of =B15/B7). Lock benchmark cells. Use conditional formatting on ratio outputs to flag results against target thresholds in green, yellow, and red. Add a fifth summary section at the top that pulls from Sections 1–3 so the key numbers are visible without scrolling.