Alpha Geek

(8)

$10/per page/Negotiable

About Alpha Geek

Levels Tought:
University

Expertise:
Accounting,Algebra See all
Accounting,Algebra,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Communications,Computer Science,Environmental science,Essay writing,Programming,Social Science,Statistics Hide all
Teaching Since: Apr 2017
Last Sign in: 442 Weeks Ago, 2 Days Ago
Questions Answered: 9562
Tutorials Posted: 9559

Education

  • bachelor in business administration
    Polytechnic State University Sanluis
    Jan-2006 - Nov-2010

  • CPA
    Polytechnic State University
    Jan-2012 - Nov-2016

Experience

  • Professor
    Harvard Square Academy (HS2)
    Mar-2012 - Present

Category > Accounting Posted 19 May 2017 My Price 8.00

NorthPole is taking out a $5,000,000 two-year loan at a variable rate

 

Upload an Excel spreadsheet that shows all your work with step-by-step explanations. Make sure your final answer is clearly identified.

Use the information for NorthPole Corporation to answer following questions.

NorthPole is taking out a $5,000,000 two-year loan at a variable rate of LIBOR plus 1.00%. 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 2.00%.

a) What is the all-in-cost (i.e., the internal rate of return) of the NorthPole 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 NorthPole 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 NorthPole for the entire loan?

 
 

Answers

Alpha Geek
(8)
Status NEW Posted 19 May 2017 12:05 PM My Price 8.00

-----------

Attachments

file 1495197834-1516395_1_636307190537842493_IRR---COST-OF-LOAN.xlsx preview (45 words )
Lo-----------an -----------Amo-----------unt-----------Cas-----------h F-----------low-----------sYe-----------ar -----------0Ye-----------ar -----------1 Y-----------ear----------- 2I-----------RRU-----------pfr-----------ont----------- fe-----------es -----------(2%-----------)a.----------- IR-----------R :-----------c. -----------IRR-----------, I-----------f t-----------he -----------LIB-----------OR -----------rat-----------e j-----------ump-----------s t-----------o 5-----------.00-----------% a-----------fte-----------r t-----------he -----------fir-----------st -----------yea-----------r d-----------. I-----------RR,----------- If----------- th-----------e L-----------IBO-----------R r-----------ate----------- fa-----------lls----------- to----------- 3.-----------00%----------- af-----------ter----------- th-----------e f-----------irs-----------t y-----------ear-----------Upf-----------ron-----------t f-----------ees----------- In-----------ter-----------est----------- In-----------ter-----------est----------- - -----------Yea-----------r 1-----------Int-----------ere-----------st ------------ Y-----------ear----------- 2 -----------
Not Rated(0)