If you do it on paper, show me the work please so I am able to understand. If done in excel, please show formula.

Thank you

Please show your calculations as well as the numerical answer for each question.I need you to do this in excel. You can attach your spreadsheet or copy and paste the portion of the spreadsheet into word. If you just write the answers without showing how you arrived at them, you may not get the full points Scenario 1 Shirley Miller has decided to join a hiking club. The club charges a membership fee of $25 per year. The membership entitles Shirley Miller to join 4 hikes a year, which she utilizes to the maximum. During a hike, she usually buys some hiking equipment and a sports drink from the club. On average, she spends $50 during each hike with the club and the cost of providing the required products runs to about $20 for the club. Assume a 4% discount rate and the club loses about 30% of its customers a year Answer the questions sequentially, and keep adding the new information given in each question to the next one 1. What is Shirley's CLV for the club? 2. As part of the promotion to get new members, the club conducted a free hike and provided food drinks, and equipment. The free hike attracted 10 hikers (one of which is Shirley) and cost the club $250 to conduct. They also send her flyers and mails that cost $6 a year. With these costs added in, what is her new CLV? Does this advertising campaign make sense for the club to do? 3. During a hike, Shirley Miller meets the CEO of the club, and mentions to him that inflation is so low that a 4% discount rate is not reasonable, and that the market discount rate is about 2.5%. Assuming the same costs described above, what is the CLV that the CEO should assign to Shirley? (Assume the same costs are same as that given in question 2.) 4., Shirley Miller slips and falls down during a difficult turn, which the hiking guide didn't warn her about. She is very upset and tells the club that she is leaving unless she is compensated. What is the maximum amount the club should be willing to pay out to retain Shirley as a client? (Assume the same costs and interest rate are same as that given in questions 2 and 3.) Discuss your answer. If you were the manager. what would vou do