excel

PROBLEMS 1. From the information given below, rank the customers in terms of their lifetime val AVG. ANNUAL SALES AVG. PROFIT MARGIN EXPECTED LIFETIME 17% 12% $2,500 $4,000 $ 1,200 Customer A: Customer B: Customer 8 years 6 years 12 years 30% Use a discount rate of 6 percent and treat the average annual sales figures as annuities. Should any of these customers be fired