Use the information for York Corporation to answer following question(s). Use an Excel spreadsheet that shows all your work with step-by-step explanations. Make sure your final answer is clearly identified.

York is taking out a $10,000,000 two-year loan at a variable rate of LIBOR plus 1.50%. The LIBOR rate will be reset each year at an agreed upon date. The current LIBOR rate is 4.00% per year. The loan has an upfront fee of 1.00%

a) What is the all-in-cost (i.e., the internal rate of return) of the York loan including the LIBOR rate, fixed spread and upfront fee?

b) What portion of the cost of the loan is at risk of changing?

c) If the LIBOR rate jumps to 5.00% after the first year what will be the all-in-cost (i.e. the internal rate of return) for York for the entire loan?

d) If the LIBOR rate falls to 3.00% after the first year what will be the all-in-cost (i.e. the internal rate of return) for York for the entire loan?