Can you help with or provide detailed explanation about how to estimate the value of a customer by calculating the customer value multiplier for the modified "customervalue.xlsx" dataset from the textbook. Also, carry out sensitivity analysis. Note that the number of time periods is changed to 180 (instead of 360 as in the textbook example), the discount rate to 0.15 (instead of 0.1), and the retention rate to 0.75 (instead of 0.8). Refer to pages 328, 329, and 330 of the marketing analytics textbook. discount rate 0.15 time frame retention rate 0.75 assume constant margins end Period Customers df beginning 1 middle 2 3

Please list and and provide detailed explain and post excel spreadsheet each of the step.

Note that the

End is 0

Beginning is 1

Middle is 0.5