Using the information in problem 12, if something offends the customer, the firm stands to lose less than the amount calculated because of the impact of NPV. Explain why this is so and develop a spreadsheet to show the LTV value for a range of interest rates from 1% to 5%.