Customer Lifetime Value Calculator

Resource Overview

Use this tool to determine your company's customer lifetime value considering the following factors: Retention Rate, Referral Rate, Interest Rate, # Orders, Average Order Size, Risk Factor, Acquisition Cost, Marketing Cost and Incentives. This tool will automatically calculate the following: Total Customers, Annual Revenue, Costs, Net Revenue, NPV Revenue and Lifetime Value.

Downloads
824

Your Problem

You need to determine your company's customer lifetime value (CLV).

Our Solution

Use this tool to determine your company's customer lifetime value considering the following factors: Retention Rate, Referral Rate, Interest Rate, # Orders, Average Order Size, Risk Factor, Acquisition Cost, Marketing Cost and Incentives. This tool will automatically calculate the following: Total Customers, Annual Revenue, Costs, Net Revenue, NPV Revenue and Lifetime Value.

To learn more about Customer Lifetime Value, review our How-To Guide, "Calculating Customer Lifetime Value." 

Key Benefits

  • easy to use
  • allows for customization
  • automatically generates reporting charts
  • save 5 hours on formatting
  • communicate results quickly and easily

 

Microsoft Excel Spreadsheet

Estimated Time Required: 4 Hours

Skills Required: Data Analysis