Please show formulas used and fill all orange cells. Thanks

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 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 222 23 24 25 B- Create a stacked column chart that shows interest and principal on each column Place Chart Here! 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? (Ignore your old vehicle.) Buy Personal Investment Rate 4% Salvage Value $ 5,000.00 Car Loan Payments Lease Down Payment $ 3,000.00 Monthly Payments $ 350.00 NPV of Buying NPV of Leasing Buy or Lease