Show calculations and key strokes

in Excel

You are considering purchasing a 2022 RX Hybrid for $46,720. The Lexus dealer is offering the following three options to own or lease the vehicle: Option 1. Receive a $3,500 rebate on the price of the car and finance the balance over 5 years at 3.2% interest Option 2. Finance the vehicle for 60 months at 0 % interest. Option 3. Lease the vehicle for 36 months with $529 monthly payment and $3,999 due at signing. 1. What is the monthly payment for Option 1? 2. What is the total cost of Option 1