Please use excel functions to calculate. Please give formulas and numbers used to calculate. Thank you

** INCASE picture is blurry **

assume that interest is compounded monthly and payments will be made at the beginning of the month. use 0 or blank for the "type" argument

car price $28600

option 1: 1.5% ingerest rate for monthly payments for 7 years

option 2: $2000, reduction in the price of the car, and an interest rate of 2.5% for monthly payments for 5 years

7. You wee in the market to purchare a faw car, The car has a price The dealership hat offered you the following twotinanoing optiont. 1 Assme that interest is compeunded morithly and payments will be made af the begining ot the month. Use 0 or tlank for the "iype" argument. 4. This viden may be helptul for the paymert caloulations httpe ffww wi youtuhe.onmiwatch