As a result, the $50 million term loan balance remains constant across all four periods. To calculate the interest rate, the spread is added to the LIBOR in the corresponding year, as shown below in the screenshot. From above, we can also see the “MAX” function in Excel is used to...