Created
June 19, 2014 16:26
-
-
Save bgits/12dbc51d7f01a7f4fcbd to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
margin = float(input("Enter the gross margin per customer: ")) | |
churn = float(input("Enter the percentage of customers who end their relationship with a company in a given period: ")) | |
discount = float(input("Enter the cost of capital used to discount future revenue from a customer(discount rate): ")) | |
gc = float(input("Enter the yearly gross contribution per customer: ")) | |
clv = (gc * margin) * ((1 - churn) / (1 + discount - (1 - churn))) | |
cpl = float(input("Enter the average cost per lead: ")) | |
closing = float(input("Enter your average closing ratio: ")) | |
hours = float(input("Enter the average number of manhours per pitch: ")) | |
hr = float(input("Enter the hourly rate of manhours: ")) | |
th = hours * hr | |
cpa = cpl + th / closing | |
nclv = clv - cpa | |
print ('The customer lifetime value is: %s' % (clv)) | |
print ('The cost per customer acquistion is: %s' % (cpa)) | |
print ('The net customer lifetime value: %s' % (nclv)) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
A simple customer lifetime value calculator