Downloads - Written by Arthur Hughes - 1 Comment
Special Lifetime Value Calculator
Special Lifetime Value Calculator Download and Instructions
The Special Lifetime Value Calculator is presented as an Excel spreadsheet. Download the Special LTV Calculator, open it in Excel or other spreadsheet program then follow the instructions below.
Using the Excel chart Table 1, modify the numbers shown with your own numbers. The resulting lifetime value of your customer segments will appear in Table 2.
Notes:
This table should be computed for a customer segment which has similar purchasing habits. It could be seniors, or teenagers, married with children, for example. For business to business it could be SIC code groups with similar annual sales or numbers of employees.
- A. B. Orders per year and average order size. Estimate these from existing records.
- C. Determine from your database how many newly acquired customers continue to make purchases in the second and third years after acquisition.
- D. If you have a program that encourages customers to refer others who become customers, put the percentage of successful referrals here.
- D. Estimate the cost of fulfilling the products or services. These are all inclusive costs: cost of goods sold, costs of delivery, sales commissions, etc.
- F. Acquisition cost: Add together your annual expenditures to acquire new customers by TV, Radio, Print, Direct Mail, Sales Visits and Bonuses, etc. and divide that total by the number of new customers actually acquired in the year.
- G. H. I. Estimate the costs per customer of your marketing to them
- J. If you compensate customers for referring customers who actually become customers, put the average amount paid out per successful referral.
- K. This is the market rate of interest used by your company to borrow money. If you do not borrow money, use the existing market rate of interest charged by banks to business customers such as your company.
- L. Risk factor: there is always risk in business. 1.0 = No Risk at All. 2.0 = There are serious risks from competition, obsolescence, declining market, terrorism, etc.
- M. Consumers usually pay at the time of purchase. Business customers pay in 30, 60, 90, 120 days. Put your number in here.
- N. Segment size. The LTV is the same for any size segment.
Post Footer automatically generated by Add Post Footer Plugin for wordpress.
More In Articles
- How to Do Your Own Market Research & Identify Your Ideal Customer
- Email Strategy Study Group
- Why 21 Links Could Be Key to Your Email Success
- Why do e-mails bounce?
- How does frequency of e-mails affect open, click and conversion rates?
More In Telecom Articles
- Glossary of Telecom Marketing Terms
- Telecom Marketing Issue 01
- Creative Destruction Hits Telecom
- Case Study: Wireless Churn Reduction
- HDTV Bandwidth Requirements
More In Speeches
- Targeted Addressable Advertising Using Digital TV
- Speech on Distance Selling delivered in Athens, Greece by Arthur Middleton Hughes on December 15 2009
- Speech by Arthur Middleton Hughes on How to Retain Insurance Customers Delivered in Philadelphia to PIMA on November 17 2009
- Surviving the Recession Surviving the Recession with E-mail Marketing
- Online Marketing: Driving Traffic, Conversion and Sales