Risk free rate for 5 year Bond = 0.87%
Credit Spread = 1%
Hence, Effective rate of borrowing will be = 1%+0.81% = 1.87%
Since the bank is lending $1M to the company in next 4 years with certain amount of "X" receiving upfront from the company. and bank gets it total amount in 5 years.
Hence in case of no arbitrage, X will be difference in present value of $1M in 4 years and 5 years.
Hence X = PV of $1M in 4 years - PV of $1M in 5 years
= $1M/1.87^4 - $1M/1.87^5
= $ 38046
Question 5 please! 5. An A-rated company knows it will need to borrow $1M in 4...
Analyze the results of the
sensitivity analysis done for a company by doing certain changes to
the input variables (rows in "Summary Page" worksheet) based on
information provided in "Instructions" worksheet and that had
effect on the target variables (columns in "Summary Page"
worksheet) - what do the numbers signify?
000 AutoSave OFF S u - Sensitivity Analysis View Share Comments conditional Formatting Home Insert AvX Paste 5 | A40 x v A B Page Layout Formulas Data Review %...