Wall Street Prep

LTV/CAC Ratio

LTV/CAC Ratio Step-by-Step Calculation Tutorial (and Template)

Learn Online Now

LTV/CAC Ratio

Key Takeaways
  • Conceptually, what is the meaning of the LTV/CAC ratio?
  • What do customer lifetime value (LTV) and customer acquisition cost (CAC) represent?
  • For the SaaS industry, what is considered the target LTV/CAC ratio?
  • If a company’s LTV/CAC ratio is deemed too low, what does this imply (and vice versa)?

Traditional GAAP reporting standards tend to fall short in depicting the financial performance of these software companies accurately.

Hence, the SaaS industry relies on its own set of metrics to help bridge the disconnect.

The LTV/CAC ratio is perhaps the important metric for evaluating software-as-a-service (“SaaS”) companies as it can be used to:

  • Gauge the cost-efficiency of sales & marketing strategies
  • Determine the long term feasibility of customer acquisition strategies

The LTV/CAC ratio is most frequently used to assess early-stage SaaS companies, but its usage extends to any type of business with repeat purchases (e.g., e-commerce, direct-to-consumer).

LTV/CAC Calculation Tutorial

In this tutorial, we will break down each step of the calculation. But before we begin, download the spreadsheet to follow along using the form below:

dl
Submitting ...

Conceptually, the LTV/CAC ratio is calculated by dividing the total sales (or gross margin) made to a single customer or customer group over their entire lifetimes (LTV) by the cost required to initially convince that same customer or customer group to make their first purchase (CAC).

Note that essentially, this calculation is a measure of the “return on investment” of each dollar that the company spent in order to initially acquire that customer.

Given your own experiences with subscriptions and purchasing habits, you may be wondering how we measure LTV, given that certain customers will subscribe but ultimately unsubscribe (which we call a “churn rate” – more on this later). Let’s start by digging into LTV in further detail.

Lifetime Value (LTV)

Customer Lifetime (LT)

The lifetime of the customer represents the implied duration an average customer remains with the company.

Since we are working towards estimating the value of a customer, we must take into account how long a typical customer does business with a company, as no customer stays a customer perpetually.

As we mentioned earlier, certain customers will ultimately unsubscribe (in the case of a subscription-based company) or otherwise stop purchasing at some point. We call this the customer churn rate, which is defined as the percentage of existing customers who discontinue their relationship with the company in a given year.

The formula used to calculate the customer lifetime is thus one divided by the customer churn rate.

For example, if the annual customer churn rate is 5% (which means that 5% of existing customers discontinue their relationship with the company in any given year), then the lifetime would be calculated as 1 ÷ 5%, which comes out to 20 years. We can interpret 20 years as being the average length an average customer stays a customer of the company.

Lifetime

The flip side of thinking about the churn rate is the retention rate. The retention rate is the average percentage of customers who continue their relationship with the company in any given year, and is calculated as 1 minus the churn rate. In our example here, the retention rate would thus equal 1 – 5% = 95%.

Although our example used an annual churn rate, a monthly churn rate could also be used here. But regardless of which is used, the important thing is to remain consistent throughout the entirety of the calculation with either monthly or annual metrics in order to avoid timing mismatches.

Lifetime Value (LTV)

Now that we know how long on average a given customer stays a customer with the company, to continue in our calculation of LTV, we need to know how much revenue on average a given customer generates per year. To estimate the average revenue generated by a single given customer per year, we calculate the average revenue per account (“ARPA”).

The formula for ARPA is the company’s total recurring revenue divided by the current number of active users.

Average Revenue Per Account (ARPA)

As previously mentioned, be mindful of being consistent regarding timing. Since we used the annual churn above, we will now use annual recurring revenue (“ARR”) as the numerator in the ARPA formula.

Once ARPA is calculated, it is multiplied by the gross margin to arrive at the gross contribution per customer.

Note that to calculate gross contribution per customer, we should only take into account the variable costs directly related to serving the customer.

And then, LTV can be calculated using the formula below:Lifetime Formula

To reiterate, the LTV denotes the average gross contribution a single customer is expected to generate for the business over its lifetime.

LTV is critical to track because it can be among the most useful data points in projecting the future revenue that can be expected from each customer.

As such, LTV can be a proxy for the “value” of the customer to the company. And by quantifying how much value the average customer provides during the entire lifespan of their relationship, the company can measure how much it can reasonably spend to acquire these customers.

Margin Multiple: Discount Rate in LTV

The inclusion of a Discount Rate as part of the LTV formula accounts for the time value of money and reflects how much a company values receiving payment right now versus at a later date.

The standard discount rates range around:

  • Public Companies: 8% to 10%
  • Late-Stage Private Companies: 10% to 15%
  • Early-Stage Start-Ups: 15% to 20%+

Discount rates are higher for an early-stage company because it values earlier payments more given its risk profile (i.e., cash burn rate, urgent spending needs, inconsistent Free Cash Flows).

However, the discount rates used are highly subjective and will vary depending on the person performing the analysis. Certain people use a 10% discount rate for early-stage, high-risk companies under the assumption that the company would someday be public (i.e., a best-case scenario).

The margin multiple is the right side of the LTV formula shown above. Often referred to as the “multiplier”, it is calculated with the retention rate as the numerator, and the denominator consisting of one plus the discount rate minus the retention rate.

Here, the gross profit contribution by the customer is taken and multiplied by the present value of the lifetime – thus, the output could be interpreted as a “discounted” customer lifetime value.

In the hypothetical scenario used in our template, the financials are as follows:

  1. The ARR is $2.5mm with 10,000 total customers, which means ARPA is $250
  2. Upon applying the 80% gross margin to the ARPA, the gross contribution per customer comes out to $200
  3. Given the 5% annual churn rate, the retention rate can be backed out of by just subtracting the churn rate from one, which is 95%
  4. To calculate the margin multiple, the 95% retention rate is the numerator, while the denominator is comprised of 1 plus the 10% discount rate, less the 95% retention rate
  5. LTV can now be calculated by multiplying the $200 gross contribution by the margin multiple of 6.3x, which comes out to approximately $1.27k

LTV-Discounted Approach

Customer Acquisition Costs (CACs)

LTV can be used as a proxy for how profitable customers acquired will be – which can then be compared against the spending required to acquire them.

Now the LTV has been calculated, we can move onto calculating the customer acquisition cost (CAC), the denominator in the LTV/CAC ratio.

CAC is the total cost incurred to make the customer initially purchase the products being sold. In short, the CAC is the sum of all sales & marketing (“S&M”) expenses divided by the total number of new users acquired.

To acquire new customers, companies use a variety of marketing tactics, sales channels (e.g., digital, social media), and in-person strategies – furthermore, the effectiveness and return on investment of those strategies can be measured via the LTV/CAC ratio.

Customer Acquisition Cost (CAC)

Going back to our example, the three channels (and cash outflows) related to new customers acquisitions are:

  1. Sales Team Compensation: Ten sales reps that are each paid $65k every year
  2. Digital Marketing Campaign Expenses: $20k is spent on digital marketing such as targeted social media and email campaigns
  3. Search Engine Marketing Expenses: SEM utilizes a pay-per-click (“PPC”) model, where one click costs $1.00 and there were a total of 10,000 site visits (and therefore a $10k expense)

S&M Spend Discounted

From above, $680k was spent to acquire 1.6k new customers this year, which comes out to a CAC of $425.

So in the final step, we have the two components required to calculate the LTV/CAC ratio.

The formula used to compute the LTV/CAC ratio is the customer lifetime value (LTV) divided by the customer acquisition cost (CAC).

LTV/CAC Ratio Formula

The completed output of the LTV/CAC ratio calculation tutorial example is shown below:

LTV-CAC Discounted Approach

By dividing the LTV of $1.27k by the CAC of $425, we arrive at 3.0x for the implied LTV/CAC. Another way to think about this result is that for every $1 spent on sales and marketing, the company generated $3 of additional gross contribution.

CAC/LTV Calculation: Alternative LTV Formula

An alternative approach uses a simpler formula for calculating the lifetime value (LTV), also eliminating the concept of a discount rate:

Lifetime Value Simple FormulaAnother illustrative example has been shown below:

LTV-CAC Simple Calculation

From the screenshot above, we can see that:

  1. The ARR is $100,000 with 2,000 customers (and $50 average revenue per account, or ARPA), meaning this is a seed-stage company (sub-$1mm revenue)
  2. By dividing the contribution margin of $43 ($50 ARPA x 85% Gross Margin) by the annual churn rate of 10%, we get an LTV of $425
  3. In the last step, we can divide the $425 LTV by the $417 CAC (50k S&M Spend ÷ 120 New Customers), which comes out to an implied LTV/CAC a slight bit over 1.0x

In this example, we see that for every $1 spent on sales and marketing, the company generated only $1 of additional gross contribution. Basically, it is only just breaking even on its sales and marketing spend.

LTV/CAC Ratio Guidelines

For early-stage companies, general guidelines for the targeted LTV/CAC ratio are:

LTV/CAC: ~3.0x
  • Often cited as the ideal target range for the majority of software companies as the pace is sustainable (and reasonably profitable)
  • Intuitively, an LTV/CAC of 3.0x means the company receives $3 per $1 spent to acquire the customer
LTV/CAC: <1.0x
  • Considered unsustainable and implies the company is facing difficulty monetizing its newly acquired customers
  • Either the wrong strategies are being used or the customer base is too difficult to monetize (i.e., no spending power, unwillingness to pay)
LTV/CAC: >5.0x
  • While the value received on a per-dollar basis is high – the context of the situation makes the ratio not ideal (i.e., for an early-stage company, revenue/user growth are more important than cost reduction)
  • For instance, an early-stage company attempting to disrupt an industry is facing (or soon will) face pushback from incumbents and other competitors
  • Therefore, management likely needs to spend more on new customer acquisitions as it may be missing out on growth opportunities
  • Or, the conservative spending may be due to diminished growth opportunities
Causes of <1.0x LTV/CAC

An LTV/CAC ratio of 1.0x means the company is right at the break-even point – but note, CAC excludes expenses unrelated to acquiring customers. That said, an LTV/CAC below 1.0x means the company is failing to break even.

Starting out, if the LTV/CAC ratio is too low, there are adjustments that must be implemented before attempting to scale. Upon closer examination, the start-up could be making the mistakes of:

  • Ineffective Budgeting: For example, a sizeable portion of the budget may be spent in less effective S&M channels, whilst the under-funded campaigns are bringing in most of the new customers
  • Unclear Target Market: Targeting markets composed of inadequate product demand leads to poor traction and revenue growth, as expenses continue to accumulate
  • Broad Strategy: Being too broad in the sales strategy and market segmentation coincides with the inefficient allocation of capital (i.e., low return on investment)

In other cases, the LTV/CAC ratio might start out near 3.0x but decline as the market matures. The downtrend suggests the competitive landscape has become saturated with new entrants, making the acquisition of new customers more difficult (and costlier).

And then in the worst-case scenario, an LTC/CAC ratio consistently on the lower end despite constant modifications points towards the potential of there being a more concerning underlying issue (e.g., the lack of product-market fit, an unmonetizable end-market).

LTV/CAC Conceptual Explanation

When LTV and CAC are compared to one together, it is effectively showing whether the expenses spent to acquire customers are worth the value received in return from said customers.

For the business model and customer acquisition strategy to be repeatable and feasible, the profits derived from customers must be in excess of the costs associated with acquiring them.

If not, the business model is not sustainable over the long haul.

Often, it is normal for CACs to start out on the lower end as the target market and customer acquisition strategy were intentionally left open-ended.

The start-up should ideally be able to make the proper adjustments post-feedback and insights collected from customer data as it matures and enters the Growth-Stage.

A sign of progress in the right direction is reflected in the LTV/CAC ratio converging towards 3.0x – which represents a more normalized, sustainable rate.

Otherwise, the unsustainable cash burn rate will eventually catch up to the company as it soon runs out of the funds raised (and investors become reluctant to offer more capital).

While there are well-funded companies that can burn through their cash reserves at rather rapid paces, certain companies can continue raising capital (often from Growth Equity Funds) because:

  • The product concept and the business model has been relatively validated
  • The LTV/CAC ratio might be lower than the target range; nevertheless, the market and revenue opportunity seems compelling enough for Existing/New Investors
  • The reason behind the spending pace might be due to the increased competition and funding of similar start-ups, which again validates the product concept (e.g., Uber Eats vs. Grubhub/Seamless vs. DoorDash)

Or, if a start-up does not seem to be spending sufficiently, this could suggest that either growth opportunities in the industry are scarce or management is being overly conservative with spending, which places the start-up at the risk of trailing behind its competitors in the market.

LTV/CAC Individualized Segmentation

The majority of companies examine LTV/CAC at a more granular level using a customer cohort analysis, which rather than looking at just a single “average customer,” breaks down customers into multiple different customer groups according to various parameters such as demographics or even the initial year of acquisition. Doing so provide far more practical insights such as:

  • Based on historical profitability and product demand, which customer profile should the company target?
  • Is the current state of the business model feasible in terms of becoming profitable someday in the future while being able to scale efficiently?
  • How much spending should be allocated towards hiring sales reps and marketing campaigns?

Upon calculating the LTV/CAC for each customer profile, the most profitable customers must be determined and then be strategically marketed towards.

Companies can oftentimes benefit from narrowing their market focus and establishing a niche based on their most profitable segments (and later have the optionality to enter other markets).

As a side benefit, a targeted sales & marketing campaign permits more effective, personalized marketing since the specific end markets and customer types are identified.

Otherwise, the company might eventually continue burning cash at an unsustainable rate until it is ultimately forced to unwind and shut down operations.

For early-stage SaaS companies moving beyond the product development period, being able to monetize users consistently, maintain high customer retention rates, and the efficient allocation of capital are critical components in obtaining market traction and continuing to grow.

The chart below lists the main contributors that impact the LTV/CAC ratio:

LTV CAC Graph

The reason LTV/CAC carries such importance is that each dollar spent to acquire new customers should be justified by the value derived from those customers in return.

Comments
guest
0 Comments
Inline Feedbacks
View all comments
VC Term Sheets & Cap Tables Demystified

Learn Online: Understand the analysis done by venture capital professionals in early-stage investing.

Learn More
X

The Wall Street Prep Quicklesson Series

7 Free Financial Modeling Lessons

Get instant access to video lessons taught by experienced investment bankers. Learn financial statement modeling, DCF, M&A, LBO, Comps and Excel shortcuts.