Please show your calculations in Excel and submit them via Moodle.

PLEASE HELP ME !! and show me how to work these problems, I am struggling in this class

Ben is considering purchasing a 2023 Toyota Highlander L for $39,832. The dealer is offering the

following three options to own or lease the vehicle. If he normally changes his car every four years, which option would you recommend? Why?

Additional Information:

Residual Value (Resale Value) =$19,120

(Note: Please exclude any personal property taxation and inflation from your calculations. The following

concepts/calculations will be covered in detail in ECO/FIN 343 Fundamentals of Financial Planning

course).

Option 1. Receive a $500 instant cash rebate from the MSRP and purchase the car outright in cash. Dealer fee and sales taxes will be $2,633.68.

1. What is the total cost of Option 1

2. What is the monthly payment for Option 2?

2. What is the total cost of Option 2?

3. What is the total cost of Option 3?

4. Which option would you recommend based on the total cost of the car? Why?

6. Considering Option 3, what other factors should you consider?

Provide at least 3 advantages and 3 disadvantages for all three options associated with this decision considering the total cost of the car, the residual value of the car, cash flow, etc.