SaaS Unit Economics for Founders: Spreadsheet Formulas and FD Checklist

September 15, 2026

Written by

Blog Img

Check three numbers before anything else: your LTV:CAC ratio, your CAC payback period, and your gross margin. If your LTV:CAC sits near or above 3:1, payback lands within a commonly accepted healthy range, and gross margin clears 70%, your growth is very likely sustainable. Fall short on two of three, and no amount of top-line growth will save the business from a cash crunch.


TL;DR:

  • Fully loaded CAC should include sales salaries, onboarding costs, and trial infrastructure, not just advertising expenses, to accurately reflect true customer acquisition costs.
  • An LTV:CAC ratio above 3:1 is ideal, but it can fall to around 3.34:1 when fully loaded CAC is considered, which still indicates healthy unit economics.
  • CAC payback periods within 12 months are ideal; longer periods, such as 15 months, may be acceptable if customer retention and NRR are high enough to justify the investment.
  • Cohort analysis reveals hidden efficiencies or inefficiencies by segmenting customers by acquisition channel, size, or profile, instead of relying solely on blended metrics.
  • For early-stage SaaS, a lower LTV:CAC ratio and longer payback are common, but later stages require higher ratios and shorter payback periods to demonstrate sustainable growth.

Priceandaccountants
Turn SaaS Metrics Into Clear Decisions
Our virtual finance director services help growing technology businesses use financial insights for informed decisions and sustainable growth.
Explore our accounting support

Table of Contents

What is unit economics for SaaS, and which metrics matter?

The “unit” in unit economics for SaaS is usually a single customer, though some businesses track it per seat licence, per API call, or per active user when that maps better to how revenue actually scales. A per-seat model needs seat-level economics. A usage-based product needs the unit to reflect consumption, not headcount. Get this wrong and every metric downstream is distorted.

Seven metrics form the core framework, and each answers a different question about the business.

  • Customer Acquisition Cost (CAC): total sales and marketing spend divided by new customers acquired in the period. This tells you what it costs to win one customer.
  • Lifetime Value (LTV): the gross profit you expect from a customer over the life of the relationship, typically calculated as average revenue per account multiplied by gross margin, divided by churn rate.
  • LTV:CAC ratio: LTV divided by CAC. This is the single number investors reach for first, because it captures both efficiency and durability in one figure. A healthy benchmark sits around 3:1.
  • CAC payback period: months required to recover CAC from the gross profit a customer generates each month. Stripe’s guidance treats anything under 12 months as healthy, with top performers hitting 5 to 7 months.
  • Churn (logo and revenue): logo churn counts customers lost; revenue churn weights that loss by the money attached to it. A business can lose 5% of logos and still grow revenue if the customers who leave are small.
  • Net Revenue Retention (NRR): revenue retained from existing customers including upgrades, downgrades, and cancellations, expressed as a percentage. NRR above 100% means your existing base grows even with zero new sales.
  • ARPU, MRR, and ARR: average revenue per user, monthly recurring revenue, and annual recurring revenue. These size the business; they don’t tell you whether it’s efficient.

The distinction between logo churn and revenue churn trips up more founders than any other metric on this list. A SaaS company can report flat logo churn while revenue churn quietly climbs, because the customers leaving are increasingly the valuable ones. NRR catches this. It’s why investors increasingly treat NRR as more diagnostic than gross churn alone, especially past Series A when expansion revenue should be doing real work.

How to calculate unit economics for SaaS: a worked example

The formulas are straightforward. The trouble is what founders leave out of them.

  1. CAC = (sales spend + marketing spend + relevant salaries) ÷ new customers acquired
  2. LTV = (ARPU × gross margin %) ÷ monthly churn rate, a structure recommended in EconKit’s guide because using raw revenue instead of margin overstates value
  3. LTV:CAC = LTV ÷ CAC
  4. CAC payback = CAC ÷ (ARPU × gross margin %)

Now the worked example. Say a SaaS company spends £40,000 on paid marketing and £20,000 on sales commissions in a quarter, acquiring 40 new customers. A narrow, “marketing-only” CAC calculation gives you £40,000 ÷ 40 = £1,000 per customer. That number looks good in a pitch deck and is quietly misleading.

Statistic in focus: fully loaded CAC should include sales salaries, onboarding costs, and trial infrastructure, not just ad spend, according to Dual Entry’s CFO framework.

Now run LTV. ARPU is £150/month, gross margin is 78%, and monthly churn is 2%. LTV = (£150 × 0.78) ÷ 0.02 = £5,850. Using the narrow CAC, LTV:CAC is around 5.85:1, which is above typical benchmarks. Using fully loaded CAC, it drops to about 3.34:1, still generally considered healthy, but telling a different story for a board deck.

CAC payback tells the cash story. With fully loaded CAC of £1,750 and monthly gross profit of £117 (£150 × 0.78), payback is approximately 15 months, which falls within commonly cited acceptable ranges but is longer than the sub-12-month mark that is often linked to greater capital efficiency.

Two pitfalls recur constantly. First, calculating LTV against revenue instead of gross profit, which inflates the number and makes weak unit economics look strong. Second, blending CAC across a mixed go-to-market motion, product-led growth alongside enterprise sales, when the two channels have wildly different cost structures and payback profiles. Blend them and you get a number that describes neither channel accurately.

How to calculate unit economics for SaaS: a worked example — overview diagram

What good unit economics look like at each stage

Benchmarks aren’t fixed. They shift with ARR stage and with go-to-market motion, and treating a Seed-stage PLG product against Series B enterprise benchmarks will lead you to the wrong conclusions.

  • Pre-seed to Seed: LTV:CAC often sits below 3:1 while the product finds its market; the priority is signal on retention, not ratio perfection.
  • Series A: LTV:CAC should be approaching or clearing 3:1, CAC payback ideally under 18 months, gross margin above 70%.
  • Series B and beyond: LTV:CAC above 3:1 expected, payback tightening toward 12 months, NRR above 110% increasingly the differentiator investors focus on.
  • PLG motion: product-led businesses frequently achieve sub-6-month payback because acquisition cost per customer is low, even when average contract value is small.
  • Enterprise/sales-led motion: longer payback, sometimes 18 to 24 months, is acceptable when NRR is high, because the customer relationship compounds value over years.

Common red flags, and what they usually mean: an LTV:CAC ratio under 1:1 signals you’re losing money on every customer, full stop, regardless of growth rate. CAC payback periods that extend beyond typical ranges without justification by high NRR may indicate inefficiencies in acquisition channels or pricing issues. Gross margin below about 60% in a pure software business typically signals cost structure issues such as high infrastructure expenses or excessive manual service labor. At later stages, some founders also check the Rule of 40, where growth rate plus profit margin should sum to 40 or above, as a single sanity check on whether growth is coming at a sustainable cost.

The playbook for improving unit economics that actually works

Retention comes first, before acquisition tweaks, before pricing changes, because it compounds. A move from 2% to 1.5% monthly churn doesn’t look dramatic on a slide, but it extends average customer lifespan from 50 months to 67 months, and LTV rises by a third with no change to ARPU or CAC. Retention is the single most destructive or constructive force in SaaS unit economics, and it’s the lever most founders underweight because it’s less visible than a new campaign launch.

Illustration of retention improving customer lifespan

Pro Tip: *Before touching your acquisition channels, model what a one-point reduction in monthly churn does to LTV.

With retention addressed, work through the remaining levers in rough order of leverage:

  • Pricing and packaging: shift low-ACV customers toward annual billing, introduce usage-based tiers for expansion revenue, and audit whether your cheapest plan is subsidising churn-prone customers who were never a fit.
  • Targeted expansion: build upsell triggers into the product itself, seat growth, usage thresholds, feature gating, so NRR grows without new sales headcount.
  • Channel mix and demand generation: audit acquisition channels individually rather than blending them; a B2B SaaS affiliate audit can reveal a partner channel quietly delivering lower CAC than paid search.
  • Cloud cost control: infrastructure spend that scales linearly with usage erodes gross margin as you grow; renegotiate committed-use discounts and right-size compute before margin becomes a board-level problem.
  • Self-serve and support automation: shifting onboarding and tier-one support to self-serve flows lowers the cost side of CAC and protects margin as customer count rises without proportional headcount growth.

Retention tactics deserve particular attention because they’re often cheaper to execute than acquisition fixes. Proven retention strategies tend to centre on proactive customer success outreach timed to usage drop-offs, something most SaaS companies can build without new engineering resource.

How cohort analysis reveals what blended metrics hide

A single company-wide LTV:CAC figure hides more than it reveals. Segmenting by cohort is how you find out which parts of the business are actually working.

  1. Define your cohorts. Group customers by acquisition month, acquisition channel, ACV band, or ideal customer profile fit, whichever split matters most for the decision you’re making.
  2. Calculate LTV and CAC separately for each cohort, using the same formulas as the blended calculation but restricted to that cohort’s data.
  3. Compare cohorts against each other, not just against a single company average, to spot where efficiency actually lives.
  4. Track cohort curves over time, not just at a single snapshot, since churn and expansion both play out over months.

This is where blended numbers mislead founders most often. A paid search channel might show CAC of £1,200 against an organic channel’s £400, making paid search look inefficient at first glance. Run the cohort analysis and you might find paid search customers have double the NRR of organic ones, because the channel attracts a better-fit customer who expands faster. The higher-CAC channel ends up with a superior LTV:CAC once you follow the cohort rather than the average. A SaaS metrics dashboard built around cohort views, rather than trailing twelve-month averages, is what catches this before a board meeting does.

What to ask your outsourced FD to build for you

An accountant filing your VAT return isn’t equipped to build this. An outsourced finance director should be. Here’s what a proper engagement produces.

  • A fully loaded CAC model that includes sales salaries, onboarding labour, and trial infrastructure, not just ad spend.
  • A cohort LTV dashboard segmented by acquisition channel, ACV band, and ICP fit, updated monthly.
  • CAC payback scenarios modelled against different growth assumptions, so you know your cash exposure before you commit spend.
  • A runway impact analysis connecting payback period directly to financial runway, since a long payback period is really a cash-flow problem wearing a metrics costume.
  • Clean revenue recognition practices underpinning ARR figures, because restated ARR destroys investor trust faster than almost any other finance error.

With extensive combined accounting expertise and experience working with startups, the team has built these models for founders who needed investor-ready numbers on a tight timeline. In a discovery call, ask direct questions: how is CAC loaded, how often is the cohort dashboard refreshed, and how does the model handle a mixed PLG and sales-led motion without blending the two into a misleading average.

Reading your numbers depends on what you’re optimising for

Founders and investors read the same metrics differently, and conflating the two readings causes real damage. A founder trying to survive eighteen months of runway should tolerate a longer CAC payback if it buys market share cheaply; an investor doing diligence weeks before a term sheet wants payback tight and auditable, because payback uses current, observable cash data rather than projected LTV, which is precisely why it gets more diligence weight than LTV:CAC.

The trade-off worth naming plainly: chase growth at the expense of payback only when you have the runway to absorb it and a clear reason to believe the market window is closing. Otherwise, tighten first. A one-week move worth making now: pull your fully loaded CAC, cohort your last six months of customers by acquisition channel, and see which channel your gut has been wrong about.

— Rahamut

How Priceandaccountants turns your metrics into investor-ready numbers

Most founders discover their CAC was understated the hard way, in a diligence call, when an investor asks why sales salaries weren’t in the model. Priceandaccountants builds the fully loaded numbers before that conversation happens, not during it.

Priceandaccountants

As a finance service provider for UK tech and fintech startups, the company builds fully loaded CAC models, cohort LTV dashboards, and CAC payback scenarios tied directly to your runway, work that sits alongside SaaS revenue recognition support so your ARR figures hold up under investor scrutiny. Where R&D activity is part of your product build, R&D tax credit claims can free up non-dilutive cash that directly improves your payback math. If you’re heading into a funding round or simply want numbers you can defend in a board meeting, book a discovery call and bring your current CAC and churn figures; the model built from there is the one you’ll actually use.

This article is general information, not a substitute for advice from a qualified financial advisor. Consult a qualified financial professional about your own circumstances before acting on anything here.

Sources

FAQ

What is the 3:3:2:2:2 rule of SaaS?

It’s a framework describing SaaS growth phases: roughly three years of tripling revenue followed by years of doubling, though founders should treat it as a rough growth narrative rather than a target, since unit economics matter more than growth rate alone.

What is the Rule of 40 in SaaS?

The Rule of 40 states that revenue growth rate plus profit margin should equal or exceed 40, used as a high-level health check at later stages when growth alone no longer tells the full story.

What are examples of unit economics?

CAC, LTV, LTV:CAC ratio, CAC payback period, gross margin, churn, and NRR are the core examples; each measures a different dimension of whether a single customer relationship is profitable and durable.

What is a good EBITDA margin for a SaaS company?

There’s no single fixed figure, since EBITDA expectations vary enormously by growth stage and reinvestment strategy; earlier-stage companies often run negative EBITDA deliberately while prioritising growth, whereas mature SaaS businesses are frequently judged more on the Rule of 40 than on EBITDA margin in isolation.

How is fully loaded CAC different from marketing-only CAC?

Fully loaded CAC includes sales salaries, onboarding costs, and trial infrastructure alongside marketing spend, and typically produces a noticeably higher figure than a marketing-only calculation, which is why Priceandaccountants builds the fully loaded version before any investor conversation.