Please solve in Excel and show formulas used. Please fill in the orange cells.

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 pay Period Beginning Balance Payment Interest Principal Ending Balance 1 2 3 4 195. 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 20 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? 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 pay Period Beginning Balance Payment Interest Principal Ending Balance 1 2 3 4 195. 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 20 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