Please show excel formulas/functions

Lease vs. Purchase (20 points) You are considering the purchase of a new Mercedes. The car's MSRP is $85,000, but due to your excellent negotiation skills, you've been able to talk the manager down to $75,000. However, the car dealer also offers to lease you the car over 48 months with only $1,515 due a signing and a monthly payment of $900 per month. If you lease the car, you guarntee that the vehicle will be worth at least 60% of MSRP when the lease is up. You believe that the car will be worth $48,000 when you're done with it. a) If you can borrow at 7% to buy the car, should you lease or purchase? Create a table to compare the differences between the lease and purchase cash flows. b) If you did borrow at 7% from the bank to purchase the car, what would your monthly payments be? Assume that you have to make the same initial payment if you did borrow to finance the purchase. Lease vs. Purchase (20 points) You are considering the purchase of a new Mercedes. The car's MSRP is $85,000, but due to your excellent negotiation skills, you've been able to talk the manager down to $75,000. However, the car dealer also offers to lease you the car over 48 months with only $1,515 due a signing and a monthly payment of $900 per month. If you lease the car, you guarntee that the vehicle will be worth at least 60% of MSRP when the lease is up. You believe that the car will be worth $48,000 when you're done with it. a) If you can borrow at 7% to buy the car, should you lease or purchase? Create a table to compare the differences between the lease and purchase cash flows. b) If you did borrow at 7% from the bank to purchase the car, what would your monthly payments be? Assume that you have to make the same initial payment if you did borrow to finance the purchase