USING EXCEL

BOND VALUATION (again) 6. AAPL issues some new $1,000 face value subordinated debentures with an annual coupon rate of 4.0%, payable semi-annually. The bonds mature in 25 years. The bond does not contain a call feature. The market interest rate on similar risk and maturity bonds is 4.1%, compounded semi-annually. a) You buy a bond. Find the price you pay. b) Ten years later the market interest rate on 15 year bonds is 4.6%, compounded semi-annually. You sell the bond. What do you receive for it? c) Compute the rate of return you earned over the ten year period if you sell the bond. That is, solve for the IRR of the cash flows you paid out, and received, over the 10 years. d) Explain why the original bond in question \#2 sold at a premium, and the bond in #6 sold at a discount