Portion of the cost of the loan

Reference no: EM131016787

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: EM131016787

Questions Cloud

Swot analysis of the product : The SWOT analysis of the product/service you are developing for course - Publication Manual of the American Psychological Association

Identify some specific positive and negative aspects of the : Identify some specific positive and negative aspects of the proposal. Would you be in favor of the proposal, if you lived in the city? Would it make a difference if you lived along the creek?

What was the accounting entry : The Marco Factory wrote a computer program for a customer and billed the customer $2,000 for this work. What was the accounting entry?

Determine from these data with aid of dimensional analysis : Determine from these data, with the aid of dimensional analysis, the relationship between θ, 0, and ω for this particular apparatus. Hint: Plot the data using appropriate dimensionless parameters, and determine the equation of the resulting curve ..

Portion of the cost of the loan : 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? What portion of the cost of the loan is at risk of changing? If the LIBOR rate jumps to 5.00% after the first year ..

Consider the bureau of labor statistics website : Use the Internet and / or Strayer Resource Center to research career options within the field of finance. Consider the Bureau of Labor Statistics Website, and the Websites of finance professional associations such as the Association for Financial ..

Explain the significance of the information : Short Report (20 points): Each team will compose a memo of 700-900 words The purpose of the report is to persuade your audience of professionals in the field that the topic the team has investigated is worth learning more about. The report should ex..

Pitch promotion company recieved a bill for jet fuel : Pitch Promotion Company recieved a bill for jet fuel. The bill is for $86,000 and is payable in 45 days. The accounting entry is?

What conditions exist when economic profits are maximized : What do think would happen to competition in the industry where you work if, say, a certain number of firms would close down? What would happen to their price-making ability?

User Account

All Pages