{"id":2006,"date":"2022-04-17T15:37:00","date_gmt":"2022-04-17T08:37:00","guid":{"rendered":"https:\/\/mintea.blog\/?p=2006"},"modified":"2022-04-23T17:32:29","modified_gmt":"2022-04-23T10:32:29","slug":"2006","status":"publish","type":"post","link":"https:\/\/mintea.blog\/?p=2006","title":{"rendered":"What is Customer Equity (Clips, Excel Template)"},"content":{"rendered":"<div style=\"width: 660px;\" class=\"wp-video\"><video class=\"wp-video-shortcode\" id=\"video-2006-1\" width=\"660\" height=\"371\" preload=\"metadata\" controls=\"controls\"><source type=\"video\/mp4\" src=\"https:\/\/mintea.blog\/wp-content\/uploads\/2022\/04\/What-is-Customer-Equity-CLIP.mp4?_=1\" \/><a href=\"https:\/\/mintea.blog\/wp-content\/uploads\/2022\/04\/What-is-Customer-Equity-CLIP.mp4\">https:\/\/mintea.blog\/wp-content\/uploads\/2022\/04\/What-is-Customer-Equity-CLIP.mp4<\/a><\/video><\/div>\n<p><strong>What is Customer Equity?<\/strong><\/p>\n<p><strong>Defining Customer Equity<\/strong><\/p>\n<p>Customer equity is the sum of all\u00a0<a href=\"https:\/\/www.clv-calculator.com\/customer-lifetime-value-formulas\/clv-formula\/\">customer lifetime values<\/a>\u00a0for a firm. In other words, we calculate each customer\u2019s lifetime value and we total all of these values together to determine customer equity.<\/p>\n<p>Customer equity, therefore, is the total expected profitability to be generated from a customer base over time.It is calculated using a compounding\u00a0<a href=\"https:\/\/www.clv-calculator.com\/discount-rates\/\">discount rate<\/a>\u00a0which allows us to consider the total expected profitability from our customer base in today\u2019s dollars.<\/p>\n<p><strong>Should we include future customers in a customer equity calculation?<\/strong><\/p>\n<p>Existing customers are known to the organization \u2013 in that we know the current level of profit contribution, and we can estimate their\u00a0<a href=\"https:\/\/www.clv-calculator.com\/customer-retention\/\">retention<\/a>\/loyalty rate based upon our customer base history and analysis \u2013 which means that we can generally determine the customer lifetime value for each customer and then determine overall customer equity for the firm.<\/p>\n<p>When we include customer is likely to be acquired in the future, we may have less information about them, but we can also make certain assumptions about their likely customer lifetime value based upon our existing customer base \u2013 which means that we have relatively reliable information to include future customers.<\/p>\n<p>The reality is, that in today\u2019s world of heavy social media usage, many businesses will gain new customers whether or not they engage in marketing-driven customer acquisition activities. This is because new customers will be attracted to the firm through referrals (both online and off-line), information they find online, then knowledge of the brand, independent research, and so on.<\/p>\n<p>This means that, even if a firm stopped all their customer acquisition marketing activities, that they would continue to acquire new customers.<\/p>\n<p>This is a strong case to always include future customers in the overall customer equity calculation, as\u00a0<strong>the firm has earned these future customers due to their previous marketing activities and brand building efforts.<\/strong><\/p>\n<p><strong>What is the customer equity formula?<\/strong><\/p>\n<p><strong><em>Customer equity = sum of all customer lifetime values of the current and future customers<\/em><\/strong><\/p>\n<p><em>Note: as customer lifetime value should always be calculated using a discount rate, the above sum will provide the total expected profitability from current and future customers on a discounted basis as well.<\/em><\/p>\n<p><strong>An example of calculating customer equity<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"426\" class=\"wp-image-2009\" src=\"https:\/\/mintea.blog\/wp-content\/uploads\/2022\/04\/table-description-automatically-generated-1.png\" alt=\"Table Description automatically generated\" srcset=\"https:\/\/mintea.blog\/wp-content\/uploads\/2022\/04\/table-description-automatically-generated-1.png 1024w, https:\/\/mintea.blog\/wp-content\/uploads\/2022\/04\/table-description-automatically-generated-1-300x125.png 300w, https:\/\/mintea.blog\/wp-content\/uploads\/2022\/04\/table-description-automatically-generated-1-768x320.png 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<p><strong>Assumptions for this example calculation<\/strong><\/p>\n<ul>\n<li>We start with a customer base of 1,000 customers<\/li>\n<li>We \u201cwin\u201d 100 new customers each year, even without customer acquisition actions<\/li>\n<li>The profit we make from the average customer is $2,000 per annum<\/li>\n<li>A 10% discount rate has been used<\/li>\n<\/ul>\n<p>Note that we e are calculating customer equity assuming that the firm is NOT continuing to deliberately acquire news customers.<\/p>\n<p>While this would not happen in practice, approaching the calculation in this manner is an effective way of measuring customer equity as it only takes into account marketing activities up until now.<\/p>\n<p><strong>WALK-THROUGH OF THE CUSTOMER EQUITY CALCULATION<\/strong><\/p>\n<p>In this example, the retention rate is 60%, meaning that our churn rate is 40% \u2013 hence we lose 400 of 1,000 customers in the next year (year 1 of our calculation) and then 40% ongoing. However, this is slightly rectified due to our brand equity and we are likely to acquire 100 new customers each year, even without dedicated customer acquisition programs.<\/p>\n<p>For this calculation, as we have a fluctuating number of customers each year, we can use the average number of customers in the year. In year 1 we start with 1,000 customers, but end the year with only 700 = 850 average customer base for the year.<\/p>\n<p>Our 850 customers are then multiplied by the $2,000 pa per customer profit contribution, which equals $1,700,000 for the entire customer base. This figure is then discounted to 1,545,455 (to equate to a present day value).<\/p>\n<p>We start the next year with 700 customers only (1,000 \u2013 400 lost + 100 acquired) and we repeat the process with the same assumptions (but note that the discount rate compounds each year). This is continued ongoing (I use a 50 year horizon \u2013 please see this\u00a0<a href=\"https:\/\/www.clv-calculator.com\/clv-top-level-financials\/clv-max-5years\/\">article on the rationale<\/a>). And the sum of all the discounted profit contributions (e.g. 1,545,455 +1,008,264 + 700,225\u2026) equals our total customer equity of $7,357,407.<\/p>\n<p><strong>Different customer equity calculations?<\/strong><\/p>\n<p>Please note that this website has an\u00a0<a href=\"https:\/\/www.clv-calculator.com\/free-excel-template-for-calculating-customer-equity\/\">Excel template<\/a>\u00a0for calculating customer equity (available for free download), which calculates customer equity in three different ways.<\/p>\n<ol>\n<li>Customer equity of both current and future customers, assuming continued customer acquisition marketing efforts,<\/li>\n<li>Customer equity of both current and future customers, assuming no customer acquisition marketing efforts but some new customers from brand equity and related word-of-mouth, and<\/li>\n<li>Customer equity of the existing customer base only, with no future customers considered.<\/li>\n<\/ol>\n<p>Depending upon your measurement purpose, each customer equity calculation method has some merit and value.<\/p>\n<p>The first method is similar to measuring the overall value of a business as a going concern as it is likely that successful marketing activities will be continued.<\/p>\n<p>The second method measures the impact and success of all marketing efforts up to now in creating value and customer profitability for the firm.<\/p>\n<p>And the third method is more suitable for a small business (with limited brand equity) that is unlikely to acquire new customers without any marketing efforts.<\/p>\n<p><a href=\"https:\/\/youtu.be\/2uBG8oRTZNU\">https:\/\/youtu.be\/2uBG8oRTZNU<\/a><\/p>\n<p><strong>Why Customer Equity is a Powerful Marketing Metric<\/strong><\/p>\n<p>Customer equity is the total of all customer lifetime values of both current and future customers (please refer to this article for more information on\u00a0<a href=\"https:\/\/www.clv-calculator.com\/what-is-customer-equity\/\">how it is calculated<\/a>).<\/p>\n<p>This means that customer equity is a single measure of all future profits (on a\u00a0<a href=\"https:\/\/www.clv-calculator.com\/discount-rates\/role-discount-rate-clv\/\">discounted<\/a>\u00a0basis) that will be generated by the firm\u2019s (or brand\u2019s) customers.<\/p>\n<p>Because this metric takes into account:<\/p>\n<ul>\n<li>Profits from current customers<\/li>\n<li>Profits from future customers<\/li>\n<li>The \u201cfree\u201d acquisition of customers from the firm\u2019s previous brand building and other related marketing efforts<\/li>\n<li>The expected degree of loyalty from customers<\/li>\n<li>The level of profitability gained from customers \u2013 both of a short-term and long-term basis<\/li>\n<li>The ongoing marketing investment in customer acquisition and retention<\/li>\n<li>The time value of money (through using a discount)<\/li>\n<\/ul>\n<p><strong>Therefore, total customer equity is a metric that can measure the value and contribution of ALL marketing activities up to that point in time, taking into account both short-term and long-term expected profits from customers.<\/strong><\/p>\n<h1>Free Excel Template for Calculating Customer Equity<\/h1>\n<p>You can download the free template here\u2026<a href=\"https:\/\/mintea.blog\/wp-content\/uploads\/2022\/04\/What-is-Customer-Equity-TEMPLATE.xlsx\">customer equity template<\/a><\/p>\n<p>Below is an information video \u2013 but also see\u00a0<a href=\"https:\/\/www.clv-calculator.com\/what-is-customer-equity\/\">What is Customer Equity?<\/a>\u00a0and Why it is a\u00a0<a href=\"https:\/\/www.clv-calculator.com\/why-customer-equity-is-a-powerful-marketing-metric\/\">powerful marketing metric<\/a>.<\/p>\n<div style=\"width: 660px;\" class=\"wp-video\"><video class=\"wp-video-shortcode\" id=\"video-2006-2\" width=\"660\" height=\"298\" preload=\"metadata\" controls=\"controls\"><source type=\"video\/mp4\" src=\"https:\/\/mintea.blog\/wp-content\/uploads\/2022\/04\/What-is-Customer-Equity-TEMPLATE-CLIP.mp4?_=2\" \/><a href=\"https:\/\/mintea.blog\/wp-content\/uploads\/2022\/04\/What-is-Customer-Equity-TEMPLATE-CLIP.mp4\">https:\/\/mintea.blog\/wp-content\/uploads\/2022\/04\/What-is-Customer-Equity-TEMPLATE-CLIP.mp4<\/a><\/video><\/div>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>What is Customer Equity? Defining Customer Equity Customer equity is the sum of all\u00a0customer lifetime values\u00a0for a firm. In other words, we calculate each customer\u2019s lifetime value and we total all of these values together to determine customer equity. Customer equity, therefore, is the total expected profitability to be generated from a customer base over &hellip; <a href=\"https:\/\/mintea.blog\/?p=2006\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">What is Customer Equity (Clips, Excel Template)<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":1802,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25],"tags":[32,73,63,62,55,56,26,54,72],"class_list":["post-2006","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-bookmarked-articles","tag-analytic","tag-clip","tag-clv","tag-crm","tag-customer-analytic","tag-customer-lifecycle","tag-data","tag-data-mining","tag-excel-template"],"_links":{"self":[{"href":"https:\/\/mintea.blog\/index.php?rest_route=\/wp\/v2\/posts\/2006","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=2006"}],"version-history":[{"count":6,"href":"https:\/\/mintea.blog\/index.php?rest_route=\/wp\/v2\/posts\/2006\/revisions"}],"predecessor-version":[{"id":2050,"href":"https:\/\/mintea.blog\/index.php?rest_route=\/wp\/v2\/posts\/2006\/revisions\/2050"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/mintea.blog\/index.php?rest_route=\/wp\/v2\/media\/1802"}],"wp:attachment":[{"href":"https:\/\/mintea.blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2006"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mintea.blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2006"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mintea.blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2006"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}