[ad_1]
Please use Excel to complete the problem below.Please submit your solution electronically. ( file is attached ..fill in the answers Your company has just built and patented a laser defense system and is planning on installing the equipment in various locations around the country.To finance the installations, you, the CFO, have borrowed $12.4 billion, which your company will need to repay in 10 years.The market interest rate is 7.8%, so the present value of this obligation is $5,851,053,601.You decide to fund the obligation using five-year zero-coupon bonds and perpetuities that make annual coupon payments. Duration and Convexity1.What is the duration of a 7-year, 6.9% semi-annual bond if the market rate on bonds of similar quality is 5.1%? 2.Now suppose that the YTM has changed to 5.11%%.Using Macaulay duration (which is practically the same as using modified duration since you need to divide by (1+y)), what is the approximate percent change in the price of the bond?(You do not need to recalculate Macaulay duration using 5.11%.Use the duration value that you found in Problem 1.) 3.Now include convexity to estimate the percent change in the price of the bond.
What Students Are Saying About Us
.......... Customer ID: 12*** | Rating: ⭐⭐⭐⭐⭐"Honestly, I was afraid to send my paper to you, but splendidwritings.com proved they are a trustworthy service. My essay was done in less than a day, and I received a brilliant piece. I didn’t even believe it was my essay at first 🙂 Great job, thank you!"
.......... Customer ID: 14***| Rating: ⭐⭐⭐⭐⭐
"The company has some nice prices and good content. I ordered a term paper here and got a very good one. I'll keep ordering from this website."