Construct the Debt Schedule (use $ millions) and calculate the Weighted Average Annual Interest Rate of the Floating Rate Bank NextCorp secured a bank loan from Sapring Bank with the following terms: Amount 20,000,000 RATE Index Spread LIBOR + 4.5000% Interest LIBOR 1.50% Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 LIBOR Increase 0.50% 0.50% 1.00% 0.00% 0.00% 0.00% 0.00% Year 0 Schedule Payments Schedule Payments % Year 1 5% Year 2 5% Year 3 5% Year 4 10% Year 5 10% Year 6 15% Year 7 50% OUTPUT DEBT ASSUMPTIONS & RETURN ANALYSIS Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Amount Outstanding (End of Year) Schedule Principal Payments Interest Payment (Calc based on last Year's Outstanding) Total Financing Payment LIBOR Rate Increase Assumptions LIBOR RATE Spread Price Interest Rate (LIBOR + Spread) Annual Weighted Average Rate =