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 the new vehicle after 5 years is $6,500 and you can invest at a rate of return of 4% *** Buy Personal Investment Rate 4.0% Interest Rate 7.30% Number of years Value of Loan $20,000.00 Salvage Value 6,500 ($398.86) Car Loan Payments Lease Down Payment 4,000 Monthly Payments 230 NPV of Buying $16,334 Your sign matters here! $16,489 Your sign matters here! NPV of Leasing B-Create an amortization table of the loan that shows the portion of interest and principal on each payment. Beginning Ending Principal Period Payment Interest Balance Balance 1 2 3 4 5 6 7 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 C-Create a stacked column chart that shows interest and principal on each column Place Chart Here! D-Using the CUMPRINC and CUMIPMT Functions, determine the following: i. How much total interest would Roger have paid in the second |and third years of the loan? i. What is the total principal paid in years 2 to 5