Please show Functions used.

Question 2 You want to buy a car by taking out a 3 year loan for $15,000 with a 7% Interest rate. A - Create an amortization table of the loan that shows the portion of Interest and principal on each payment. Period Beginning Balance Payment Interest Principal Ending Balance 1 22 3 4 S 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 B - Create a stacked column chart that shows interest and principal on each column Place Chart Herel C-Suppose that you have the option to buy the car with a 3 year car loan or lease the car during the same period of time. The 3 year lease option will require a $3,000 down payment and monthly payments of $350. If the salvage value of the new vehicle after 3 years is $5,000 and you can invest at a rate of return of 4%, what is your best option? (linore your old vehicle.) Buy Personal Investment Rate Salvage Value Car Loan Payments 4% 5,000.00 $ Lease Down Payment Monthly Payments $ $ 3,000.00 350.00 NPV of Buying NPV of Leasing Buy or Lease