{"id":1748,"date":"2021-12-28T15:59:35","date_gmt":"2021-12-28T08:59:35","guid":{"rendered":"https:\/\/mintea.blog\/?p=1748"},"modified":"2021-12-28T15:59:51","modified_gmt":"2021-12-28T08:59:51","slug":"1748","status":"publish","type":"post","link":"https:\/\/mintea.blog\/?p=1748","title":{"rendered":"Existing Customer CLV Formula"},"content":{"rendered":"<p><strong>Existing Customer CLV Formula<\/strong><\/p>\n<p>A fairly standard CLV formula that you will find for measuring the lifetime value of existing customers is:<\/p>\n<p>CLV = (m.r)\/(1+d-r)<\/p>\n<ul>\n<li>Where m = customer margin (or profit contribution) per year<\/li>\n<li>Where d = discount rate<\/li>\n<li>And r = retention\/loyalty rate per year<\/li>\n<\/ul>\n<p><strong>Important note:\u00a0<\/strong>This formula is designed to measure the customer lifetime value of EXISTING customers only. You should also note that there is NO use of an acquisition cost, as existing customers have already been acquired and that expense is now historical (or a sunken cost).<\/p>\n<p><strong>How this CLV formula for existing customers works<\/strong><\/p>\n<p>To make sense of what this formula is doing, let\u2019s first look at the bottom line of 1+d-r, but remove the discount rate (d) and we are now left with 1-r.<\/p>\n<p>We should know that 1 minus the retention rate is churn (or customer loss) rate. When we use the churn rate at the bottom (denominator) of the fraction\/equation, we are actually calculating the lifetime period of a customer in years.<\/p>\n<ul>\n<li>For example, a 60% loyalty rate = 40% churn\/loss = 1\/0.4 = 2.5 years, and<\/li>\n<li>An 80% loyalty rate = 20% churn\/loss = 1\/0.2 = 5 years<\/li>\n<\/ul>\n<p>Now let\u2019s look at the impact of the retention rate at the top of the equation. At the top of this CLV formula (numerator) there is m times r. This has the immediate impact of reducing the margin (profit) to the likely margin be be achieved in the FOLLOWING year.<\/p>\n<p>This occurs because the formula is looking at an existing customer (already acquired) and estimating their FUTURE value \u2013 not their total value over the course of their customer relationship.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"585\" height=\"581\" class=\"wp-image-1749\" src=\"https:\/\/mintea.blog\/wp-content\/uploads\/2021\/12\/table-description-automatically-generated-13.png\" alt=\"Table\n\nDescription automatically generated\" srcset=\"https:\/\/mintea.blog\/wp-content\/uploads\/2021\/12\/table-description-automatically-generated-13.png 585w, https:\/\/mintea.blog\/wp-content\/uploads\/2021\/12\/table-description-automatically-generated-13-300x298.png 300w, https:\/\/mintea.blog\/wp-content\/uploads\/2021\/12\/table-description-automatically-generated-13-150x150.png 150w, https:\/\/mintea.blog\/wp-content\/uploads\/2021\/12\/table-description-automatically-generated-13-100x100.png 100w\" sizes=\"auto, (max-width: 585px) 100vw, 585px\" \/><\/p>\n<p>To make sense of this difference, let\u2019s compare a new customer\u2019s CLV to an existing customer.<\/p>\n<p>The new customer is shown on the left hand side. As you can see, their acquisition cost was $500 in Year 0, their margin was $300 in Year 1, which then reduces by 60% each year in line with estimated retention rates.<\/p>\n<p>After the 10% discount rate, their CLV (shown as DCF = discounted cash flow) is $160.<\/p>\n<p>On the right hand side of the table, the CLV figures are shown for an existing customer using the above formula.<\/p>\n<p>As you can see, there is NO acquisition cost (as they are already a customer), and we essentially start the customer in Year 2 with a annual margin of $180 (which is 60% of Year One\u2019s $300 \u2013 note the two highlighted yellow cells).<\/p>\n<p>In this case, the customer value (after discounting) is $360. This is also what the above formula tells us:<\/p>\n<ul>\n<li>CLV = (m.r)\/(1+d-r) = (300 X 60%)\/(1+.1-.6) = 180\/0.5 = $360<\/li>\n<\/ul>\n<p><strong>LIMITATIONS OF THIS CLV FORMULA<\/strong><\/p>\n<p>The main concern with this approach to calculating customer lifetime value is its use of static values. Firstly, it assumes a stable margin (annual customer profit), which is generally unlikely (please see article on\u00a0<a href=\"https:\/\/www.clv-calculator.com\/customer-revenues\/increasing-customer-revenue-time\/\">increasing customer revenues<\/a>). And secondly, it also assumes a stable loyalty rate over time, which again is generally unlikely.<\/p>\n<p>That\u2019s why the\u00a0<a href=\"https:\/\/www.clv-calculator.com\/free-clv-excel-templates\/\">free CLV Excel template<\/a>\u00a0available on this website allows for flexible revenues, costs and margins over time.<\/p>\n<p><strong>So why use this CLV formula?<\/strong><\/p>\n<p>CLV = (m.r)\/(1+d-r) is appropriate as a simple estimation of future customer value. It can be easily applied to a customer database (say in a spreadsheet format) where the customer\u2019s profit\/margin for the year is listed, along with an estimated loyalty\/retention rate.<\/p>\n<p>This CLV value becomes a forward-looking metric that a marketer can use to determine the financial viability of various cross-selling and loyalty focused marketing tactics.<\/p>\n<p><strong>Related Topics<\/strong><\/p>\n<h1>Customer Lifetime Value: Existing versus new customers<\/h1>\n<h2>Are you measuring the CLV of existing or new customers?<\/h2>\n<p>Customer lifetime value calculations, and the most suitable CLV formula to use, will vary depending upon what type of customer that you are attempting to measure. To make this point quite simply, there are two main types of customers that we are seeking to measure for customer lifetime value purposes, which are:<\/p>\n<ol>\n<li>Existing (current) customers, or<\/li>\n<li>Potential (new) customers (which will also include re-acquiring lost or lapsed customers).<\/li>\n<\/ol>\n<h4>KEY CLV FORMULA DIFFERENCES BETWEEN EXISTING AND POTENTIAL CUSTOMERS<\/h4>\n<p>There is a significant different in the CLV calculation for these two categories of customers. The most significant difference is in regards to the treatment of the acquisition cost. Obviously, existing customers have already been acquired \u2013 hence their acquisition cost is essentially a sunken cost that we would not take into account. Whereas new\/potential customers still need to be acquired and will incur an acquisition cost.<\/p>\n<p>The second difference is that the loyalty (retention) rate of existing customers is likely to differ between existing and new customers. To make sense of this retention rate difference, let\u2019s consider this graph of customer loyalty over time.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"481\" height=\"289\" class=\"wp-image-1750\" src=\"https:\/\/mintea.blog\/wp-content\/uploads\/2021\/12\/loyalty-rate-over-time.png\" alt=\"loyalty rate over time\" srcset=\"https:\/\/mintea.blog\/wp-content\/uploads\/2021\/12\/loyalty-rate-over-time.png 481w, https:\/\/mintea.blog\/wp-content\/uploads\/2021\/12\/loyalty-rate-over-time-300x180.png 300w\" sizes=\"auto, (max-width: 481px) 100vw, 481px\" \/> The first arrow on the left shows the loyalty rate for (new) customers after the first year of just 60%, whereas the arrow on the right shows the loyalty rate of existing customer (in years 7-8) approaching 80%.<\/p>\n<p>So why does this happen? When you think about it, the loyalty rate pattern makes logical sense.<\/p>\n<p>At the start (year 1), new customers are essentially trialing the brand\u2019s\/firm\u2019s offering. If they are dissatisfied (or a consumer more prone to switching), then they are more likely to churn (switch or lapse) early in their brand relationship. However, if they are satisfied with their initial purchase and remain loyal after the first year, it is likely that the loyalty rate of the remaining customers will increase over time (as the less satisfied customers decide to discontinue or switch brands).<\/p>\n<h4>EXAMPLE OF DIFFERENT CLV CALCULATIONS: NEW VERSUS EXISTING CUSTOMERS<\/h4>\n<p>To make the customer lifetime value calculation as simple as possible, let\u2019s assume:<\/p>\n<ul>\n<li>The acquisition cost of new customers is $1,000<\/li>\n<li>The customer profit (revenues less appropriate costs) is $500 per year<\/li>\n<li>The loyalty rate of new customers is 60% (as per the above table, which = 2.5 years)<\/li>\n<li>And the retention rate of existing customers is 80% (say for year 9 in the table above, which = 5 years)<\/li>\n<\/ul>\n<p>Therefore, the customer lifetime value of NEW customers would be:<\/p>\n<ul>\n<li>$500 X 2.5 years, less $1,000 = $250<\/li>\n<\/ul>\n<p>And the CLV of EXISTING customers would be:<\/p>\n<ul>\n<li>$500 X 5 years = $2,500<\/li>\n<\/ul>\n<h5>What do these CLV results mean?<\/h5>\n<p>As you can see, the customer lifetime value for existing customers is 10 times the value for new customers. However, this is to be expected. Due to the loyalty rate pattern for this example (60% increasing to 80%+ retention), there is only a small number of existing customers after ten years.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"481\" height=\"289\" class=\"wp-image-1751\" src=\"https:\/\/mintea.blog\/wp-content\/uploads\/2021\/12\/percentage-of-customers-over-time.png\" alt=\"percentage of customers over time\" srcset=\"https:\/\/mintea.blog\/wp-content\/uploads\/2021\/12\/percentage-of-customers-over-time.png 481w, https:\/\/mintea.blog\/wp-content\/uploads\/2021\/12\/percentage-of-customers-over-time-300x180.png 300w\" sizes=\"auto, (max-width: 481px) 100vw, 481px\" \/> Let\u2019s now look at the percentage of customers that actually remain loyal for ten years (even with a retention rate of 60-80%). As you can see in the graph, only around 5% of customers are still with the firm\/brand at the ten year mark.<\/p>\n<p>These customers are highly loyal (most probably due to choice, rather than habit at this stage) and therefore should be quite profitable ongoing.<\/p>\n<p>And compared to the less loyal newer customer, their CLV figure will be naturally higher. But keep in mind that within every cohort of new customers there will be very short-term low value customers, as well as a small number of long-term high value customers.<\/p>\n<h4>IMPACT ON NEW VERSUS EXISTING CUSTOMER ACQUISITION STRATEGY<\/h4>\n<p>Based on the differing CLV\u2019s of new versus existing customers, there is possibly a suggestion that the best strategy would be to focus on existing customer only. But you are probably aware of the\u00a0<a href=\"https:\/\/www.clv-calculator.com\/customer-retention\/crm-clv\/leaky-bucket-theory\/\">leaky bucket theory<\/a>\u00a0\u2013 which suggests that even with high retention rates there will always be a drain on customer numbers (as illustrated in the previous chart).<\/p>\n<p>Therefore, the clear strategy should be to continue with new customer acquisition, with the intent of identifying (or creating) the long-term, high value customer than underpins the ongoing profitability of the firm or brand.<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Existing Customer CLV Formula A fairly standard CLV formula that you will find for measuring the lifetime value of existing customers is: CLV = (m.r)\/(1+d-r) Where m = customer margin (or profit contribution) per year Where d = discount rate And r = retention\/loyalty rate per year Important note:\u00a0This formula is designed to measure the &hellip; <a href=\"https:\/\/mintea.blog\/?p=1748\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">Existing Customer CLV Formula<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":1750,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25],"tags":[32,63,62,55,56,26,54],"class_list":["post-1748","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-bookmarked-articles","tag-analytic","tag-clv","tag-crm","tag-customer-analytic","tag-customer-lifecycle","tag-data","tag-data-mining"],"_links":{"self":[{"href":"https:\/\/mintea.blog\/index.php?rest_route=\/wp\/v2\/posts\/1748","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mintea.blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mintea.blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mintea.blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mintea.blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1748"}],"version-history":[{"count":2,"href":"https:\/\/mintea.blog\/index.php?rest_route=\/wp\/v2\/posts\/1748\/revisions"}],"predecessor-version":[{"id":1753,"href":"https:\/\/mintea.blog\/index.php?rest_route=\/wp\/v2\/posts\/1748\/revisions\/1753"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/mintea.blog\/index.php?rest_route=\/wp\/v2\/media\/1750"}],"wp:attachment":[{"href":"https:\/\/mintea.blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1748"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mintea.blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1748"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mintea.blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1748"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}