Excel Online Structured Activity: Loan Amortization Your company is planning ta borton \$1.5 million on a 5 -year, 8%, annual payment, fully amertized term loan. The data has been collected in the Microsoft Excel Onlioe file below. Open the spreadsheet and perform the required analyals to answer the questice below. What fraction of the payment made at the end of the secend vear will represent feparment of principal? Do not reond intermediat calalutioss. flound your answer to two decimat olacen. 7. Calculation of Laan Payment 8 (Loan payment at Formula 10. Laan Amortianion Schedule. Fortudas Loan Anorturitons sochedue