asked on # Customer Value Analytics

I have searched the EE Database and cannot find what I'm looking for. I am searching for an Excel spreadsheet or formulas that calculate several different Customer Value KPIs.

Customer Life-TIme-Value

Customer Churn rate

Customer Defection or Retention

If you have any ideas on either formulas or samples; it would be much appreciated.

Thank you in advance,

B.

Customer Life-TIme-Value

Customer Churn rate

Customer Defection or Retention

If you have any ideas on either formulas or samples; it would be much appreciated.

Thank you in advance,

B.

Microsoft ExcelMath / ScienceAlgorithms

http://en.wikipedia.org/wiki/Customer_lifetime_value see this wikipedia article...

Aiklamha,

Thank you for the quick response. I have the definition for CLV; what I was looking for is someone who either knows how to or has already put into an Excel spreadsheet the mathmatical formula. I would do it myself but math wasn't one of my strong points in College.

Thanks,

B.

Thank you for the quick response. I have the definition for CLV; what I was looking for is someone who either knows how to or has already put into an Excel spreadsheet the mathmatical formula. I would do it myself but math wasn't one of my strong points in College.

Thanks,

B.

Log in or sign up to see answer

Become an EE member today7-DAY FREE TRIAL

Members can start a 7-Day Free trial then enjoy unlimited access to the platform

or

Learn why we charge membership fees

We get it - no one likes a content blocker. Take one extra minute and find out why we block content.

Not exactly the question you had in mind?

Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.

ask a question
Aiklamha,

Does that mean that creating LTV is simply a function of NPV for cash flow or does the equation expressed in the article you sent me hint at more?

B.

Does that mean that creating LTV is simply a function of NPV for cash flow or does the equation expressed in the article you sent me hint at more?

B.

All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat

William Peck

Here is a sample based on the article. What is not clear to me is the math formula for calculating LTV. How does "churn" rate come into play? Any improvements you can make to this?

Thank you,

B.

Calculation-for-LTV-Sample.xlsm

Thank you,

B.

Get an unlimited membership to EE for less than $4 a week.

Unlimited question asking, solutions, articles and more.

and yes to your first question..

aiklamha,

If you take a look at the model I sent you will see an attempt to build out the math to create a LTV model. Is the NPV representative of LTV or did I miss something? How would I add "churn" into the model? Any improvement ideas?

Thank you,

B.

If you take a look at the model I sent you will see an attempt to build out the math to create a LTV model. Is the NPV representative of LTV or did I miss something? How would I add "churn" into the model? Any improvement ideas?

Thank you,

B.

Get an unlimited membership to EE for less than $4 a week.

Unlimited question asking, solutions, articles and more.

Thanks guys! You got me on the right track.......

B.

B.