A SaaS P&L is, in isolation, almost useless as a tool for understanding whether a business is healthy. Revenue growth looks good until you discover that logo churn is accelerating. EBITDA looks strong until you realise that sales and marketing spend — the engine of future revenue — has been cut. Net loss looks bad until you understand that it reflects heavy investment in customer success that is driving NRR above 120%.
The five metrics below are the ones that a SaaS board, a PE investor, and a well-informed CFO use to build a genuine picture of the business. None of them appear directly on a standard management accounts pack. All of them should.
1. Annual Recurring Revenue (ARR) — and Its Waterfall
ARR is the annualised value of contracted recurring subscription revenue. It is not revenue — in a SaaS business with annual contracts and upfront billing, reported revenue in any given month may be largely deferred, while ARR reflects the actual scale of the recurring book.
What matters as much as the ARR figure itself is the ARR waterfall — the movement analysis between periods that shows:
- New ARR — from new customers signed in the period
- Expansion ARR — from existing customers upgrading or buying more seats
- Contraction ARR — from existing customers downgrading
- Churned ARR — from customers who cancelled entirely
Opening ARR + New + Expansion − Contraction − Churned = Closing ARR. This decomposition tells you far more than the headline number. A business growing ARR through expansion from existing customers is a fundamentally different — and typically more valuable — business than one growing by constantly replacing churned customers with new ones.
The automation opportunity: If your billing system (Stripe, Chargebee, etc.) exports subscription data, the ARR waterfall can be built entirely in Python from that export — no manual calculation, no spreadsheet errors, updated at the push of a button.
2. Net Revenue Retention (NRR)
NRR answers a simple question: if you signed no new customers at all this year, would your ARR be higher or lower than last year? It is calculated as:
NRR = (Opening ARR + Expansion − Contraction − Churn) ÷ Opening ARR
An NRR above 100% means the business grows even without new customer acquisition — existing customers are spending more over time. This is the hallmark of a great SaaS business and is the metric most closely scrutinised by growth investors.
World-class SaaS businesses achieve NRR of 120%+. A well-run mid-market SaaS business should target above 105-110%. NRR below 100% is a serious warning sign — the business is leaking revenue from its existing base and must acquire new customers just to stand still.
3. Customer Acquisition Cost (CAC) and CAC Payback Period
CAC is the fully-loaded cost of acquiring a new customer. This means all sales and marketing spend — salaries, commissions, advertising, events, tools — divided by the number of new customers acquired in the period.
The number that matters even more is the CAC payback period: how many months does it take to recover the cost of acquiring a customer from the gross margin that customer generates? The formula:
CAC Payback (months) = CAC ÷ (Monthly ARR per customer × Gross Margin %)
A payback period under 12 months is excellent. 12–24 months is typical for a healthy mid-market SaaS business. Above 24 months signals that either CAC is too high, gross margins are too thin, or pricing needs to increase. Above 36 months is a capital efficiency problem that will concern any PE or VC investor.
4. Churn Rate — Two Ways
Churn is the enemy of every SaaS business and must be measured in two distinct ways:
- Logo churn — the percentage of customers who cancel in a period, regardless of their contract value. High logo churn from small customers may be acceptable if large customers are retained. Low logo churn that masks high revenue churn from large customers leaving is dangerous.
- Revenue churn — the percentage of ARR lost to cancellations in a period. This is the number that directly feeds your NRR calculation and your investor reporting.
Both should be tracked monthly, trended over time, and segmented by customer cohort, customer size, product and geography. A churn model that scores each customer by probability of churn — built using a logistic regression or gradient boosting classifier on your customer data — is one of the highest-return analytical investments a SaaS business can make.
The automation opportunity: A churn prediction model built in Python (scikit-learn) on features like login frequency, feature adoption, support ticket volume and payment behaviour can identify at-risk customers weeks before they churn — giving customer success teams time to intervene.
5. LTV:CAC Ratio
Customer Lifetime Value (LTV) is the total gross margin a customer is expected to generate over their lifetime. Combined with CAC, the LTV:CAC ratio tells you whether your unit economics make sense:
LTV = (Average ARR per customer × Gross Margin %) ÷ Revenue Churn Rate
LTV:CAC = LTV ÷ CAC
A ratio above 3x is generally considered the benchmark for a viable SaaS unit model. Below 3x, the business is spending too much to acquire customers relative to what those customers are worth. Above 5x, the business may actually be under-investing in growth.
The LTV:CAC ratio also changes the conversation about churn. A 1% improvement in monthly churn rate has a dramatic non-linear effect on LTV — reducing churn from 2% to 1% per month nearly doubles LTV. This is why churn management deserves CFO-level attention, not just a line on the customer success OKRs.
Automating the Dashboard
All five of these metrics can be calculated automatically from your billing system and CRM data using Python (Pandas for data manipulation, Matplotlib or Seaborn for visualisation). A well-built Python script that runs monthly against a Stripe or Chargebee export will produce an ARR waterfall, NRR calculation, CAC payback and LTV:CAC ratio in seconds — with no manual spreadsheet work and no risk of formula errors.
This is not a theoretical aspiration. At Dext Software, the deferred revenue recognition, ARR waterfall and key metric reporting were fully automated within the first year of the finance transformation programme — reducing a manual process that took days into one that ran overnight and was ready for the board pack the following morning.
If your SaaS business is still producing these metrics manually in Excel, the efficiency and accuracy gains from automation are significant — and the investment required is smaller than you might expect.
Graeme Weeden is a CA(SA)-qualified CFO and founder of Croftlands Consulting Limited. He specialises in finance leadership and data-driven financial systems for PE-backed and founder-led SaaS businesses.