Could someone help me work this problem out in excel please?

You want to purchase a new car by taking out a 3 year loan for $56,000 with a 10% interest rate and monthly payments. Create an amortization table to show the breakdown of all the payments. Month Beginning Balance Payment Interest Principal Ending Balance 1 2 3 . 4 - 5 6 7 . 8 9 . 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 24 25 26 27 28 20 29 30 31. 3 32 33 34 35 36 36 Suppose you have the option to purchase the car using the loan detailed in the amortization table, or you can lease the car over the same period. If you lease the car you will need to make a $2,000 down payment up front, but your monthly payments will only be $900. If you lease the car then you will have to return it to the dealership at the end of the 3 years, but if you purchase the car you will be able to sell it. You estimate that you would be able to sell the car for $25,000. If you are able to borrow and lend at 15.5%, is it better to purchase or lease? (i.e. - which has the lowest overall cost?) 15.5% Discount Rate Purchase Car Monthly Payments Sell Price $ Lease Car Down Payment $ Monthly Payment $ 25,000.00 2.000.00 900.00 NPV of Purchasing NPV of Leasing Purchase or Lease