Excel Assignment Background: Suppose you are a health fitness consultant. Your clients come to you for advice ranging from diet and nutrition to exercise. He wants you to help him evaluate two options. Your job is to recommend which option will be more cost-effective.

Option A: Go back to the gym. He is currently paying $150 per month (taxes included) for a gym membership. He assumes that this price will likely remain the same for the next 10 years. If he goes back to the gym, he will make sure to observe social distancing, wear gloves and a face mask, and make sure each equipment that he uses is wiped down and sanitized. Dustin plans to stay on plan A's workout regimen for 6-10 years. His opportunity cost, i.e., discount rate, is between 5.5% - 7.75%. Which option will be more cost-effective?

For this method, calculate the outcome for each of the following scenarios: (attach a separate sheet showing your solutions for each scenario) a. If Dustin keeps working out for the next five years and the discount rate is 5.5%. b. If Dustin keeps working out for the next five years and the discount rate is 7.75%. c. If Dustin keeps working out for the next ten years and the discount rate is 5.5%. d. If Dustin keeps working out for the next ten years and the discount rate is 7.75%.

Option B: Purchase Tonal. A home gym that costs $3,495. He also has to purchase equipment worth $495 and pay for installation (assume this is $500) and taxes (assume the sales tax is 9.5% and will be applied to the total cost). He also has to pay a $49 per month (taxes included) membership fee. He assumes this monthly membership fee will likely remain the same for the next 10 years. Dustin plans to stay on plan B's workout regimen for 6-10 years. His opportunity cost, i.e., discount rate, is between 5.5% - 7.75%. Which option will be more cost-effective?

For this method, calculate the outcome for each of the following scenarios: (attach a separate sheet showing your solutions for each scenario) a. If Dustin keeps working out for the next five years and the discount rate is 5.5%. b. If Dustin keeps working out for the next five years and the discount rate is 7.75%. c. If Dustin keeps working out for the next ten years and the discount rate is 5.5%. d. If Dustin keeps working out for the next ten years and the discount rate is 7.75%.