The world’s Largest Sharp Brain Virtual Experts Marketplace Just a click Away
Levels Tought:
Elementary,Middle School,High School,College,University,PHD
| Teaching Since: | May 2017 |
| Last Sign in: | 283 Weeks Ago, 4 Days Ago |
| Questions Answered: | 27237 |
| Tutorials Posted: | 27372 |
MCS,MBA(IT), Pursuing PHD
Devry University
Sep-2004 - Aug-2010
Assistant Financial Analyst
NatSteel Holdings Pte Ltd
Aug-2007 - Jul-2017
Hi I need help with the following question, BUT i NEED THE ANSWER IN THE NEXT 1 HOUR, PLEASE ANSWER IF YOU CAN DO IT IN THE NEXT HOUR OR SO...
I need the excel or word file with calculations in it.
Â
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-costincluding 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
----------- Â ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------usi-----------ng -----------our----------- we-----------bsi-----------te -----------and----------- ac-----------qui-----------sit-----------ion----------- of----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------ns.----------- Pl-----------eas-----------e p-----------ing----------- me----------- on----------- ch-----------at -----------I a-----------m o-----------nli-----------ne -----------or -----------inb-----------ox -----------me -----------a m-----------ess-----------age-----------