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 post excel spreadsheet steps.