What portion of the cost of the loan is at risk of changing

Assignment Help Financial Management

Reference no: EM13920166

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?

Reference no: EM13920166

Questions Cloud

Develop a mobile game using any game scenario of your choice : Using the J2ME platform, develop a mobile game using any game scenario of your choice. You are required to provide the following features in your implementation: 2D implementation using sprite, game canvas and tiled layer

About the brokerage account : You have $38,063.80 in a brokerage account, and you plan to deposit an additional $3,000 at the end of every future year until your account totals $230,000. You expect to earn 14% annually on the account. How many years will it take to reach your goa..

Social process and social development theory paper : One of the biggest questions in society is why crimes are committed. There are many assumptions on why or what may cause criminals to act the way they do is, such as a neglected social life, poor childhoods, bad parents, low social class, below no..

Model elite-t limited : A commercial truck dealership gets an allocation for 100 trucks from the manufacturer. Model A can be sold at $4500 above factory invoice, Model B at $5200, Model C at $4500, Model D at $4000. The dealership sold plenty of trucks last year, and is..

What portion of the cost of the loan is at risk of changing : 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. What portion of the cost of the loan is at ..

Given the alternatives and cash flows : Given the following alternatives and cash flows: Alternative A1 has an investment of $5,000 and an annual income of $1,400/year for ten years. Alternative A2 has an investment of $7,000 and an annual income of $1,900/year for five years If MARR = 10%..

Sampling distribution-confidence interval : (Sampling distribution & confidence interval) A random variable has a population mean equal to 1,573 and population variance equal to 952,021.

Different display distinct fallacies : Considering the fallacies discussed in Chapter Four of An Introduction to Logic, construct three different arguments that display distinct fallacies. Give an explanation of why each makes a mistake in drawing the conclusion it does. Review your cl..

How much money will be paid to creditors : Reconstruct the accounting equation for each company using percentages on the right side of the equation instead of dollar values. Which company is more financially stable? Why?

User Account

All Pages