Filetype Excel XLSX | Posted on 17 Aug 2022 | 4 years ago
Authentication
digital resources
308x Filetype XLSX File size 0.02 MB Source: cdn2.hubspot.net
Sheet 1: Basic CLV Calculator
| Simple Customer Lifetime Value Calculator | |||
| Customer Information | |||
| Average Contribution Margin per purchase/order | $10,000 | ||
| Average # of Customer purchases/orders per year | 2 | ||
| Average Customer Lifetime (# of years) | 5 | ||
| Average Cost to acquire a new customer | $15,000 | ||
| Average cost to retain a current customer | $6,750 | ||
| Company Information | |||
| Number of Customers | 400 | ||
| Number of new customer per year | 95 | ||
| Number of lost customers per year | 28 | ||
| Summary Metrics | |||
| Customer Lifetime Value | $51,249 | ||
| Customer Retention Rate | 93% | ||
| Overall Customer lifetime value | $20,499,600 | ||
| Overall Annual Profit | $4,099,920 | ||
no reviews yet
Please Login to review.
