How to Calculate Customer Lifetime Value

How to Calculate Customer Lifetime Value CLVDo you know how much profit your customers produce over their lifetime?  “Customer lifetime value”, or “CLV”, is a valuable metric that helps you target your most profitable customer segments and understand how much you can spend to acquire them.

How does the theory work in action?  Let’s say you sell two products:  widgets and gidgets, and that the cost to sell either product is equal.

Let’s say you use a CLV calculation and discover that a widget customer is worth $1,000 over a lifetime, but a gidget customer is only worth $500.  Now you know that

  • You’ll be far more profitable by selling widgets instead of gidgets
  • You need to spend < $1,000 to sell a widget

So how do you calculate CLV for a customer segment?  First, gather this data:

Data Value #
Average # of orders a customer places before defecting A
Average time between orders, in equal increments B
Average revenue per order C
Gross profit margin (as a %) D
Discount rate (used to bring the future payments into today’s dollars. Could be the inflation rate, or the rate of return of another investment) E

To calculate your CLV, use the “Present Value” function in Microsoft Excel:

Present value function to calculate customer lifetime value in Excel

Here are the formulas for the data you’ll enter in each box:

Line Formula Your entry
Rate E/B
Nper A
Pmt -C*D
FV Enter 0 (for future value)
Type Enter 1

The result is your customer lifetime value – the present value of the total profit a customer delivers over a lifetime of purchasing from your company.

 

CAMPAIGN PLANNING TEMPLATES / MARKETING PLANS / PROJECT MANAGEMENT

EVERYTHING YOU NEED FOR YOUR MARKETING PROJECT

The Marketing MO planning app is your behind-the-scenes Chief Marketing Officer, a comprehensive resource that will improve your overall business, whether it’s a consulting practice, start up, or mid-size company. When tackling any new marketing task, have confidence that we have your back – with the structure and detail you need to get things done right.

Try It NowNo Credit Card Required