ity: Loan Amortization File Home Insert Draw Formulas Data Review 10 B 21 AY - Gen THITHI Interest Excel Online Structured Activity: Loan Amortization Print Area f Loan Amortization Your company is planning to borrow $2 million on a 5-year, 15%, annual payment, B fully amortized term loan. Loan Amortization 2 The data has been collected in the Microsoft Excel Online file below. Open the 3 Loan amount $2.000.000 4 spreadsheet and perform the required analysis to answer the question below. Term in years 5 5 Annual coupon rate 15.00% 6 7 Calculation of Loan Payment Formula 8 Loan payment #N/A 9 Open spreadsheet 10 Loan Amortization Schedule What fraction of the payment made at the end of the second year will represent 11 Year Beginning Balance Payment 12 repayment of principal? Do not round intermediate calculations. Round your answer 13 2 to two decimal places. 14 3 15 4 % 16 5 17 18 Formulas 19 Loan Amortization Schedule Reset Problem Check My Work 20 Year Beginning Balance Payment 21 1 #N/A #N/A 22 2 #N/A #N/A 23 3 #N/A #N/A 24 4 #N/A #N/A 5 #N/A #N/A 26 Percentage of 2nd Year Payment Representing Repayment 27 of Principal Interest #N/A #NIA #N/A #N/A #N/A F #DIV/0