Please show how to do these answers with excel functions.

Points lost Question 4- Anortization 1 2 Roger has landed his first big contract. He is thinking of purchasing or leasing a Bentley. 1. He can buy his dream car by taking out a 5 year loan for $20,000 at 7.30 % interest rate per annum. He will need to repay in fixed monthly payments. 2. He can lease the vehicle from a local dealership instead. This 5 year lease option will require a $4,000 down payment and monthly payments of $230. The salvage value of 6 the new vehicle after 5 years is $6,500 and you can invest at a rate of return of 4%. Buy 8 Personal Investment Rate 4.0% 7.30% 9 10 Interest Rate Number of years 11 Value of Loan $20,000,00 12 13 Salvage Value 14 Car Loan Payments S 6,500 15 Lease 16 17 Down Payment 18 Monthly Payments S 4,000 S 230 19 Your sign matters here! ]Your sign matters here! 20 NPV of Buying 21 NPV of Leasing 22 23 Buy or Lease? 24 B-Create an amortization table of the loan that shows the portion of interest and principal on 25 each payment. C Create a stacked column chart that shows interest and principal on each column 26 Place Chart Here! Beginning Ending Period Payment Interest Principal Balance Balance 27 28 1 29 2 30 3 31 4 32 5 33 6 34 7 35 8 36 37 10 38 11 39 12 S67 Points lost Question 4- Anortization 1 2 Roger has landed his first big contract. He is thinking of purchasing or leasing a Bentley. 1. He can buy his dream car by taking out a 5 year loan for $20,000 at 7.30 % interest rate per annum. He will need to repay in fixed monthly payments. 2. He can lease the vehicle from a local dealership instead. This 5 year lease option will require a $4,000 down payment and monthly payments of $230. The salvage value of 6 the new vehicle after 5 years is $6,500 and you can invest at a rate of return of 4%. Buy 8 Personal Investment Rate 4.0% 7.30% 9 10 Interest Rate Number of years 11 Value of Loan $20,000,00 12 13 Salvage Value 14 Car Loan Payments S 6,500 15 Lease 16 17 Down Payment 18 Monthly Payments S 4,000 S 230 19 Your sign matters here! ]Your sign matters here! 20 NPV of Buying 21 NPV of Leasing 22 23 Buy or Lease? 24 B-Create an amortization table of the loan that shows the portion of interest and principal on 25 each payment. C Create a stacked column chart that shows interest and principal on each column 26 Place Chart Here! Beginning Ending Period Payment Interest Principal Balance Balance 27 28 1 29 2 30 3 31 4 32 5 33 6 34 7 35 8 36 37 10 38 11 39 12 S67