Construct the Debt Schedule 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 18,000,000 RATE Index Spread LIBOR + 4.0500% Interest LIBOR 1.50% Year 0 Year 1 Year 2 Year 5 Year 4 0.00% LIBOR Increase Schedule Payments Year 0 Year 2 5% Year 4 10% Schedule Payments % OUTPUT DEBT ASSUMPTIONS & RETURN ANALYSIS Year 2 Year 0 18,000,000 Amount Outstanding (End of Year) Schedule Principal Payments Interest Payment (Calc based on last Year's Outstanding) Total Financing Payment LIBOR Bate Increase Assumptions LIBOR RATE Spread Price Interest Rate (LIBOR + Spread) Annual Weighted Average Rate = 0.50% Year 1 5% 0.50% Year 3 1.00% Year 3 5% Year 1 0.00% Year 5 10% Year 3 Year 6 0.00% Year 6 15% Year 4 Year 7 0.00% Year 7 50% Year 5 Year 6 Year 7 Construct the Debt Schedule 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 18,000,000 RATE Index Spread LIBOR + 4.0500% Interest LIBOR 1.50% Year 0 Year 1 Year 2 Year 5 Year 4 0.00% LIBOR Increase Schedule Payments Year 0 Year 2 5% Year 4 10% Schedule Payments % OUTPUT DEBT ASSUMPTIONS & RETURN ANALYSIS Year 2 Year 0 18,000,000 Amount Outstanding (End of Year) Schedule Principal Payments Interest Payment (Calc based on last Year's Outstanding) Total Financing Payment LIBOR Bate Increase Assumptions LIBOR RATE Spread Price Interest Rate (LIBOR + Spread) Annual Weighted Average Rate = 0.50% Year 1 5% 0.50% Year 3 1.00% Year 3 5% Year 1 0.00% Year 5 10% Year 3 Year 6 0.00% Year 6 15% Year 4 Year 7 0.00% Year 7 50% Year 5 Year 6 Year 7