SaaS Metrics

SaaS Customer Lifetime Value Drives SaaS Company Value

For the life of me, I still can’t fathom how VCs value early stage startups. I think it is one part business logic and five parts voodoo (no offense to my VC friends, but you know what I mean). However, I’m guessing most SaaS-focused VCs know this SaaS company valuation principle in their gut even if they can’t reduce it to a financial projection: SaaS Customer Lifetime Value Drives SaaS Company Value. For what is a company if not the sum of its customers?

The link between SaaS CLTV and SaaS company valuation
arises naturally from the SaaS subscription model
where topline company revenue emerges
as the sum of individual customer revenue streams.

This is the final post in a series that aims to uncover the mysteries of SaaS financial metrics from a new angle, a little mathematics. In this installment, I’ll explore the important SaaS metric of customer lifetime value (CLTV) and introduce a new SaaS financial metrics rule-of-thumb that relates SaaS CLTV to SaaS company value.

Buyer Beware: The ideas presented in this installment of the SaaS metrics series are not meant to offer methods or models for evaluating the value of any particular SaaS company, but rather to offer credence to the gut reaction above. Use the formulas herein at your own discretion. Chaotic Flow, i.e., me, accepts no liability thereof.

SaaS Metrics Rule-of-Thumb #10
SaaS Customer Lifetime Value Drives SaaS Company Value

The financially accepted method for estimating the value of company is the calculation of the discounted value of its future cash flows, or net present value. Now, I’m not saying that anyone in InternetWorld actually uses this method, but for the sake of this series on SaaS financial metrics, this is the only approach that lends itself to mathematical analysis. So, I am stuck with it.

The exact mathematical statement of SaaS Metric Rule-of-Thumb #10 above is expressed as follows (see SaaS Metrics Math Notes below for the derivation):

SaaS Company NPV = CLTV x NEWLTV

Where CLTV is the average SaaS customer lifetime value and NEWLTV is an analogous measure for the lifetime value number of customers that represents the discounted number of new customers acquired by our SaaS company during its lifetime, using the standard NPV formula.

NEWLTV = NEW1/( 1 + i ) + NEW2/( 1 + i )2 +…+ NEWN/( 1 + i )N

Here NEWn is the number of new customers acquired during the period n. NEWLTV is the present value of all the new customers that the company will ever acquire discounted by how long it takes to acquire them. If market penetration is slow, then NEWLTV might be less than 10% of the total number of customers at maturity. Whereas, if market penetration is fast and absolute, then NEWLTV will be closer to the total number of potential customers.

The formula above elegantly encompasses three critical questions asked by SaaS VCs:

  • What is the value to the customer? (CLTV)
  • How big is the market? (NEWN)
  • How fast can you get there? (NEWLTV)

The link between SaaS CLTV and SaaS company valuation arises naturally from the SaaS subscription model where topline company revenue emerges as the sum of individual customer revenue streams. In this regard, this new SaaS metrics rule-of-thumb linking customer value to company value is really a corollary of SaaS Metrics Rule-of-Thumb #4 – Company Time to Profit Follows Customer Break-Even, which had I been more esoteric (as if this SaaS metrics series isn’t already esoteric enough!), I might have stated as SaaS company cash flow follows SaaS customer cash flow (most SaaS CEOs can validate this version of the principle without any need for advanced mathematics).

While CLTV can be calculated for each individual customer, it is more commonly quoted as a generalized metric that describes the average SaaS customer as follows:

CLTV = ARRLTV – ACSLTV – CAC

CLTV = (ARR1 – ACS1)/( 1 + i ) + (ARR2 – ACS2)/( 1 + i )2 +…+ (ARRN – ACSN)/( 1 + i )N – CAC

Where “ARRLTV” is average lifetime recurring revenue per customer, “ACSLTV” is the average lifetime recurring cost of service per customer, and “CAC” is the average customer acquisition cost. ARRn and ACSn are the average customer recurring revenue and cost of service for the period n, and “i” is the cost of capital, which for VC funded startups is 30%+.

I’ve explicitly separated revenue from costs, because costs are variously omitted from CLTV depending on the application. For example, if I want to compare the “lifetime value” of a customer in terms of net contribution vs. the cost of acquiring a customer, then I omit the acquisition cost from the CLTV calculation. Or, if I wan’t to measure the “lifetime value” as the money a customer pays during its lifetime, then I’d only keep ARRLTV. The formula as written is the total net present value of all cash flows related to acquiring and servicing the average SaaS customer.

Using this “fully loaded” CLTV, we can also give a useful variation to the formula for total SaaS company value when the company already has current customers, Cold, as follows:

NPV = CLTV x NEWLTV + ( CLTV + CAC ) x Cold

or

NPV = CLTV x NEWLTV + ( ARRLTV – ACSLTV ) x Cold

Where in this case NEWLTV represents all the future customers still yet to be acquired and Cold represents the number of current customers. Notice that using our “fully loaded” CLTV we must add CAC back for current customers, because it is a sunk cost. If new customers are somehow different from old customers, or CLTV changes over the customer lifetime, then the old customer CLTV / CAC values would also be different from the new.

In the simple case of constant recurring payments and costs per period, CLTV for the average customer is calculated as follows:

CLTV = (ARR – ACS)/( 1 + i ) + (ARR – ACS)/( 1 + i )2 +…+ (ARR – ACS)/( 1 + i )N – CAC

CLTV = ( ARR – ACS )/i x ( 1 – ( 1 + i )-N ) – CAC

When there is no limit placed on the number of payments (an annuity).

CLTV = (ARR – ACS )/i – CAC

And, if we throw churn and viral growth into the mix CLTV becomes.

CLTV = ( ARR – ACS – gCAC )/( i + a – g ) – CAC

with the constraint g < i + a

Where “ARR” is the average recurring revenue per customer, “ACS” is the average recurring cost of service per customer, “a” is percentage churn rate, “g” is the viral growth rate. This last formula should be used with extreme caution in high growth, big g scenarios as treating viral growth as something that extends indefinitely is unrealistic. Sooner or later you hit the market limit and growth slows. Which is why the formula blows up when g = i + a.

SaaS Financial Metrics Math Notes

The idea that the character of a SaaS company is determined in large part by its average customer is a theme played out in many of the SaaS metrics rules-of-thumb. The underlying cause of this general principle is the recurring revenue subscription model. Unlike customers of licensed software, SaaS customers ease into their relationships with SaaS vendors through many repeat purchases. Each new SaaS customer brings a new thread of recurring revenue, which is woven into the larger tapestry of customers to create the total SaaS company recurring revenue stream. Using the continuous SaaS metric model, the formula for total recurring revenue is as follows:

Total Recurring Revenue = TRR(t) = ?0t New(t’)ARR(t – t’)dt’

Where New(t) is the number of new customers acquired by the SaaS company over time, and ARR(t) is the recurring revenue of the single average customer over time. The integral sum adds up the recurring revenue from each new customer acquired from the beginning to today (0 to t), starting each new customer on its own recurring revenue path beginning at the time it was acquired, t’. For the math heads, it’s a convolution of New(t) and ARR(t).

In the continuous model, the net present value of company recurring revenue is given by the following formula:

NPV Total Recurring Revenue = TRRLTV = ?0? TRR(t)e-itdt

Where “i” is the cost of capital. Again, for the math heads in the audience (and I can’t much imagine there is anyone else left at this point), this is a standard Laplace Transform. Using a known property of Laplace Transforms that the transform of a convolution equals the product of the two individual transforms, we can simplify the expression for TRRLTV as follows:

TRRLTV = ?0?NEW(t)e-itdt x ?0?ARR(t)e-itdt

TRRLTV = NEWLTV x ARRLTV

Which is starting to look a lot like SaaS Metrics Rule of Thumb #10 above. Had we started with ARR – ACS and thrown in CAC from the start, we would have had the following:

TRRLTV – TCSLTV – TCAC = NEWLTV x ( ARRLTV – ACSLTV – CAC )

SaaS Company NPV = NEWLTV x ( ARRLTV – ACSLTV – CAC )

SaaS Company NPV = NEWLTV x CLTV

Voila! SaaS Rule-of-Thumb #10 – SaaS Customer Lifetime Value Drives SaaS Company Value.

Check out the rest of the SaaS Metrics Rules-of-Thumb

Comment on Facebook!

10 Comments

Leave a Reply to CFO & Controller Services - Part time, Interim & Projects - Charlotte, Raleigh, Greensboro X