{"id":1741,"date":"2021-12-28T15:45:56","date_gmt":"2021-12-28T08:45:56","guid":{"rendered":"https:\/\/mintea.blog\/?p=1741"},"modified":"2021-12-28T15:46:16","modified_gmt":"2021-12-28T08:46:16","slug":"1741","status":"publish","type":"post","link":"https:\/\/mintea.blog\/?p=1741","title":{"rendered":"Main CLV Formula"},"content":{"rendered":"<p><strong>Main CLV Formula<\/strong><\/p>\n<p>Let\u2019s look at the main CLV formula is two ways \u2013 the first way in words and then as a\u00a0<a href=\"https:\/\/www.clv-calculator.com\/customer-lifetime-value-formulas\/clv-formula\/clv-equation\/\">CLV equation<\/a>\u00a0(see separate article on the CLV equation). As you will see, the main customer lifetime value formula is an extension of the\u00a0<a href=\"https:\/\/www.clv-calculator.com\/customer-lifetime-value-formulas\/simple-clv-formula\/\">simple CLV formula<\/a>.<\/p>\n<p>The main changes are that the main CLV formula looks at each year of\u00a0<a href=\"https:\/\/www.clv-calculator.com\/customer-revenues\/\">customer revenues<\/a>\u00a0and\u00a0<a href=\"https:\/\/www.clv-calculator.com\/customer-costs\/\">costs\u00a0<\/a>on an individual basis. This allows different numbers to be utilized each year. The main customer lifetime value formula also uses a\u00a0<a href=\"https:\/\/www.clv-calculator.com\/discount-rates\/role-discount-rate-clv\/\">discount rate<\/a>\u00a0to determine the present value of future revenues and costs.<\/p>\n<p><strong>The simple CLV formula is:<\/strong><\/p>\n<ul>\n<li>Annual profit contribution per customer X<\/li>\n<li>Number of years that they remain a customer less<\/li>\n<li>The initial cost of customer acquisition<\/li>\n<\/ul>\n<p><strong>Whereas this CLV formula is:<\/strong><\/p>\n<ul>\n<li>Annual profit contribution per customer (for each year under consideration) X<\/li>\n<li>The cumulative customer retention rate less<\/li>\n<li>The initial cost of customer acquisition<\/li>\n<li>With each yearly figure adjusted by an appropriate discount rate<\/li>\n<\/ul>\n<p><strong>Note:<\/strong>\u00a0the second line formula \u2013 referring to churn rate \u2013 is actually calculating customer\u2019s\u00a0<a href=\"https:\/\/www.clv-calculator.com\/customer-retention\/converting-retention-rate\/\">average lifetime period in years<\/a>.<\/p>\n<p><strong>Main differences between the two CLV formulas<\/strong><\/p>\n<p>The main differences between the\u00a0<a href=\"https:\/\/www.clv-calculator.com\/customer-lifetime-value-formulas\/simple-clv-formula\/\">simple version<\/a>\u00a0and the full version of the CLV formulas are that the full customer lifetime value formula allows for:<\/p>\n<ul>\n<li>Changing customer revenues each year,<\/li>\n<li>Changing customer retention and up selling costs over time,<\/li>\n<li>Changing retention (and therefore churn rates) over time, and<\/li>\n<li>It applies a\u00a0<a href=\"https:\/\/www.clv-calculator.com\/discount-rates\/\">discount rate<\/a>\u00a0(to determine the present value).<\/li>\n<\/ul>\n<p><strong>An example for the main customer lifetime value formula<\/strong><\/p>\n<p>Let\u2019s assume the following:<\/p>\n<ul>\n<li>Profit (customer revenues less costs) generated by the customer in year one = $1,000<\/li>\n<li>This increases to $1,500 in year two and then to a maximum of $2,000 for year three onwards<\/li>\n<li>The retention rate of customers is 75% (and therefore the churn rate is 25%)<\/li>\n<li>Cost to acquire the customer = $1,000<\/li>\n<li>A discount rate of 10% is considered appropriate<\/li>\n<\/ul>\n<p><strong>The calculation of CLV (BEFORE discounting) would be:<\/strong><\/p>\n<ul>\n<li>Year 0 = \u2013 $1,000 acquisition costs<\/li>\n<li>Year 1 = $1,000 customer profit<\/li>\n<li>Year 2 = $1,500 customer profit X 75% retention = $1,125<\/li>\n<li>Year 3 = $2,000 customer profit X 56% (75% of 75%) retention = $1,125<\/li>\n<li>Year 4 = $2,000 customer profit X 42% (75% of 75% X 75%) retention = $844<\/li>\n<li>Year 5 = $2,000 customer profit X 32% (75% of 75% X 75% X 75%) retention = $633<\/li>\n<li>And so on<\/li>\n<\/ul>\n<p><strong>Using the\u00a0<\/strong><a href=\"https:\/\/www.clv-calculator.com\/free-clv-excel-templates\/\"><strong>free Excel template\u00a0<\/strong><\/a><strong>\u2013 the non-discounted CLV = $6,125<\/strong><\/p>\n<p><strong>The calculation of CLV (WITH discounting) would be:<\/strong><\/p>\n<ul>\n<li>Year 0 = \u2013 $1,000 acquisition costs divided by 1 (no discount)<\/li>\n<li>Year 1 = $1,000 customer profit divided by 1.1 (10% discount) = $909<\/li>\n<li>Year 2 = $1,500 customer profit X 75% retention divided by 1.21 (10% X 10% discount) = $930<\/li>\n<li>Year 3 = $2,000 customer profit X 56% (75% of 75%)\u00a0 retention divided by 1.32 (10% X 10% X 10% discount) = $845<\/li>\n<li>And so on<\/li>\n<\/ul>\n<p><strong>Using the\u00a0<\/strong><a href=\"https:\/\/www.clv-calculator.com\/free-clv-excel-templates\/\"><strong>free Excel template<\/strong><\/a><strong>\u00a0\u2013 the discounted CLV = $3,995<\/strong><\/p>\n<p><strong><em>As you can see, the discounting factor has a significant impact on the final customer lifetime value.<\/em><\/strong><\/p>\n<h1>Example of a Customer Lifetime Value Calculation<\/h1>\n<h2>A step-by-step example of the customer lifetime value calculation<\/h2>\n<p>Please note that there is also another example in the article\u00a0<a href=\"https:\/\/www.clv-calculator.com\/customer-lifetime-value-formulas\/clv-formula\/\">explaining the customer lifetime value formula<\/a>.<\/p>\n<p>In this example, the calculations have been summarized from a spreadsheet on a step-by-step basis. Please refer to the\u00a0<a href=\"https:\/\/www.clv-calculator.com\/free-clv-excel-templates\/\">free Excel CLV templates\u00a0<\/a>on this site.<\/p>\n<h2>Example of a Customer Lifetime Value Calculation<\/h2>\n<p>In this example, the following assumptions have been made:<\/p>\n<ul>\n<li>that the initial\u00a0<a href=\"https:\/\/www.clv-calculator.com\/customer-costs\/\">acquisition cost<\/a>\u00a0per customer is $250<\/li>\n<li>that the average\u00a0<a href=\"https:\/\/www.clv-calculator.com\/customer-revenues\/\">customer revenue<\/a>\u00a0starts at $500 in year one and increases by $50 per year \u2013 rising to $950 by year 10<br \/>\ncustomer costs have been set at 50% of revenue \u2013 therefore, it costs the firm in (in year one) $250 in product and service costs to generate $500 revenue<\/li>\n<li>only customer revenues and costs are considered up to year 10, with any subsequent revenues being disregarded in the calculation<\/li>\n<li>a\u00a0<a href=\"https:\/\/www.clv-calculator.com\/customer-retention\/converting-retention-rate\/\">retention rate<\/a>\u00a0of 75% has been used<\/li>\n<li>and a\u00a0<a href=\"https:\/\/www.clv-calculator.com\/discount-rates\/role-discount-rate-clv\/\">discount rate<\/a>\u00a0of 10% has been applied<\/li>\n<\/ul>\n<p>Each of the numbers will be discussed below, but the key number \u2013 customer lifetime value \u2013 has been shown in the bottom right yellow cell and is equal to $583.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"1222\" height=\"743\" class=\"wp-image-1742\" src=\"https:\/\/mintea.blog\/wp-content\/uploads\/2021\/12\/table-description-automatically-generated-12.png\" alt=\"Table\n\nDescription automatically generated\" srcset=\"https:\/\/mintea.blog\/wp-content\/uploads\/2021\/12\/table-description-automatically-generated-12.png 1222w, https:\/\/mintea.blog\/wp-content\/uploads\/2021\/12\/table-description-automatically-generated-12-300x182.png 300w, https:\/\/mintea.blog\/wp-content\/uploads\/2021\/12\/table-description-automatically-generated-12-1024x623.png 1024w, https:\/\/mintea.blog\/wp-content\/uploads\/2021\/12\/table-description-automatically-generated-12-768x467.png 768w, https:\/\/mintea.blog\/wp-content\/uploads\/2021\/12\/table-description-automatically-generated-12-180x110.png 180w\" sizes=\"auto, (max-width: 1222px) 100vw, 1222px\" \/><\/p>\n<h3>Understanding the Customer Lifetime Value Calculation<\/h3>\n<h5>Acquisition Costs<\/h5>\n<p>The first row simply shows acquisition costs per customer. In this case the firm has determined that their overall promotional, sales and set-up costs per customer is equal to this amount. You should note that this expenditure\/marketing investment has been incurred in year zero. This is because there is a lag time between promotional campaigns and the generation of first-time customers. Therefore, acquisition costs typically set in year zero with revenues coming on-stream the following year.<\/p>\n<h5>Customer Profit Contribution<\/h5>\n<p>The next two rows show the average per customer revenue and the average costs incurred by the organization to obtain that revenue \u2013 resulting in the fourth row, which is the difference between those two and is the average profit contribution per active customer.<\/p>\n<p>It is important to note that these three rows show revenues, costs and profit contribution for current\/active customers only. That is, for continuing\/existing customers. It is further down in the calculation that considers the retention\/churn rate of customers.<\/p>\n<h5>Retention (loyalty) Rate<\/h5>\n<p>As you can then see, the fifth row of numbers (retention rate) reduces by a factor of 25% each year. In the first year, we assume that all first-time customers have purchased from the firm \u2013 which they would need to in order to be considered customers. In the second year, we have retained 75% of those, and in the third year we have retained 75% of the 75% (which is equal to 56% of customers).<\/p>\n<p>Even with a relatively high retention rate of 75%, by year 6, only around 24% of those customers acquired have remained loyal. This calculates the following row, which is profit contribution of retained customers. This is calculated by the retention percentage of that year \u2013 say in year 6 (of 24%) multiplied by the product contribution received from active customers in that year (which is $375). This works out to be 24% X $375 = $89.<\/p>\n<p>In other words, for the customers that have remained loyal, the firm is making $375 in profit contribution \u2013 but there are only around a quarter of them who are still existing customers \u2013 which means we have to reduce the profit contribution accordingly.<\/p>\n<p>The best way to think about the role of the retention rate in the customer lifetime value calculation is to consider that it estimates the\u00a0<strong><em>percentage probability<\/em><\/strong>\u00a0of the firm receiving the customer\u2019s revenue in future years.<\/p>\n<h5>Discount Rate<\/h5>\n<p>The next row shows the discount rate, which is compound at 10% per annum. The average profit contribution of a retained customer \u2013 say $89 in years six \u2013 is then divided by the discount rate, in order to adjust to present day value. As year six is a reasonable distance into the future, the customer lifetime value calculation reduces it to $50 (as an equivalent to today\u2019s money for the organization).<\/p>\n<h5>Customer Lifetime Value (CLV)<\/h5>\n<p>The running total along the bottom row shows the cumulative customer lifetime value over time. As the firm has decided to only consider 10 years of revenue and costs, the end customer lifetime value calculation works out to be $583.<\/p>\n<h3>Graphing the customer lifetime value example<\/h3>\n<p>Using the example above, let\u2019s graph three rows from the table (see below). The blue line trending upwards is the profit contribution of any active\/loyal customers over time. In the example, the company was working to increase revenues during the life the customer.<\/p>\n<p>The red line is trending downwards. This is the profit contribution per customer (that is, the blue line) adjusted for customer retention rates. Over time, this line will eventually run to zero dollars as all customers will cease to be loyal at some time.<\/p>\n<p>The green line is the cumulative customer lifetime value calculation.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"518\" height=\"417\" class=\"wp-image-1743\" src=\"https:\/\/mintea.blog\/wp-content\/uploads\/2021\/12\/chart-line-chart-description-automatically-gener-3.png\" alt=\"Chart, line chart\n\nDescription automatically generated\" srcset=\"https:\/\/mintea.blog\/wp-content\/uploads\/2021\/12\/chart-line-chart-description-automatically-gener-3.png 518w, https:\/\/mintea.blog\/wp-content\/uploads\/2021\/12\/chart-line-chart-description-automatically-gener-3-300x242.png 300w\" sizes=\"auto, (max-width: 518px) 100vw, 518px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>The key points to note about the pattern of the cumulative customer lifetime value line are:<\/p>\n<ol>\n<li>It starts negative, due to the upfront acquisition costs,<\/li>\n<li>In this case, acquisition costs are not fully paid back until sometime in year three, and<\/li>\n<li>Eventually the customer lifetime value will flatten, due to the combined effects of churn of customers and the application of a discount rate.<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Main CLV Formula Let\u2019s look at the main CLV formula is two ways \u2013 the first way in words and then as a\u00a0CLV equation\u00a0(see separate article on the CLV equation). As you will see, the main customer lifetime value formula is an extension of the\u00a0simple CLV formula. The main changes are that the main CLV &hellip; <a href=\"https:\/\/mintea.blog\/?p=1741\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">Main CLV Formula<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":1733,"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-1741","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\/1741","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=1741"}],"version-history":[{"count":2,"href":"https:\/\/mintea.blog\/index.php?rest_route=\/wp\/v2\/posts\/1741\/revisions"}],"predecessor-version":[{"id":1745,"href":"https:\/\/mintea.blog\/index.php?rest_route=\/wp\/v2\/posts\/1741\/revisions\/1745"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/mintea.blog\/index.php?rest_route=\/wp\/v2\/media\/1733"}],"wp:attachment":[{"href":"https:\/\/mintea.blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1741"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mintea.blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1741"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mintea.blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1741"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}