show the work in excell with formulas please

Grading period Summer 2021 Assume that you have saved up enough for the down payment for a new car. Therefore, any rebate you receive would be applied towards the principle to reduce the amount financed. Also, assume that the sales tax can be rolled into the amount financed. Which option would you choose and why? Option 1 Option 2 Rebate $1500 $0 Interest rate 3.9% 0.9% 60 60 Payments (monthly) Purchase price $24,000 $24,000 Sales tax (6.5%) ? ? 10% Down payment (% 10% of purchase price) Monthly pmt $? $? S 12:21 PM O Bi Tuesday ED 1 6/15/2021