Your company is planning to borrow $1.5 million on a 5-year, 13%, annual payment, fully amortized term loan. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the question below.

Excel Online Activity: Loan X Cabout:blank MindTap - Cengage Learnir X Draw Page Layout Formulas 10 B Hv G Excel template - Saved File Home Insert 5. Arial D3 A B C 1 Loan Amortization 2 3 Loan amount $1,500,000 4 Term in years 5 5 Annual coupon rate 13.00% 6 7 Calculation of Loan Payment Formula #N/A 8 Loan payment = 9 10 Loan Amortization Schedule 11 Beginning Balance Payment Year 1 12 13 2 14 3 15 4 16 5 17 18 Formulas 19 Loan Amortization Schedule 20 Beginning Balance Payment Year 1 21 #N/A #N/A 22 2 #N/A #N/A 23 3 #N/A #N/A 24 4 #N/A #N/A F F 25 5 #N/A #N/A 26 Percentage of 2nd Year Payment Representing Repayment 27 of Principal 28 29 30 31 32 33 24 Sheet1 + Calculation Mode: Automatic Workbook Statistics fx Data Excel Online Student Work XC Your Company Is Planning X C Assume That Your Father is x G screenshot on mac - Goog x + Search (Option + Q) Review Editing Comments > O