FIN 3414, Fall 2017, Excel Projec Insert Page Layout Formulas Data Review View 1 AMORTIZATION TABLE 120,000 3 Loan Principal 4 Interest Rate 5 Loan Termlyear) Payments per Year 7 Number of Payments 8 Monthly Payment OComplete the follewing amortization table and graph the evolution of the payments to interest and to principal as we get closer to the loan matunity Hint: The ending balance in the last payment must equal zero To gragh the series, just select the month cokumn and the two other columns and plot as ascatter plot yment to Payment to Ening Month Balance Payment Interest Principal Dalance