Hello. Please answer this question using Excel. This is financial modelling with excel. Kindly show the formulas you used as well. Thanks

1. Mr. Richard went to his local car dealership and wanted to buy a car with MSRP of $30,000. He negotiated a price of $27,250. Should he choose to lease, hell make 36 monthly payments of $375.00, starting one month from today, and make a down payment of $1,400 (including a destination charge of $500, which he has to pay regardless of whether he purchase by cash or by financing, an acquisition fee of $450 and a security deposit of $450, which will be returned to him at the end of the lease term IF his vehicle has a market value above 57% of the original MSRP.)
   1. (20%) By checking the KBB, he believes that the car will have a market value of $19,000 at the end of its 36-month leasing term. If he can borrow an auto loan at an APR of 7%, should he lease the car or borrow the auto loan from his bank and purchase the car?
   2. (5%) Perform a sensitivity analysis of leasing APR on the residual value of the car from $15,000 to $25,000, in increments of $1,000.