Situation Ah Lee, a financial manager at a US based mid-sized manufacturing firm, has been caught off-guard before. In an effort to earn the most on excess cash, Ah Lee once bought five-year US Treasury bonds (a maturity longer than the firm's liabilities) only to see interest rates rise. The loss when the Treasury bonds were sold did not make Ah Lee's supervisor, Carlo, Chief Financial Officer, very happy. Ah Lee is now in a similar situation - Carlo has asked for a recommendation on the nvestment of another $10 million in excess cash. Risk and Return using RCY The risk of unexpected changes in interest rates is a given with coupon-paying bonds. Even if the bonds are held to maturity, there is reinvestment risk. A bond's exposure to interest rate risk depends on the size and the number of coupon payments made to the bondholder. The realized return from a bond depends on the rates at which the coupons are invested; the rates can only be estimated at the time the bond is purchased. Given estimates of futures interest rates, however, the expected realized compound yield (RCY) can be calculated in order to cope with the reinvestment problem. For a bond that pays annual coupons over n years, the appropriate calculation for the annualized return is:RCY = [(Total future dollar value/Purchase price of bond)1 - 1]. The total future dollar value from the investment includes the coupon payments, the earnings on each coupon, and the value of the bond at the end of the holding period. In estimating the future dollars from a bond purchase, Ah Lee needs a forecast of the direction and level of future interest rates. At yesterday's investment meeting, Carlo stated his belief that interest rates would remain unchanged for the next three years because of an unchanging expected inflation rate. Ah Cheung, another financial manager at the firm and someone that has earned Carlo's respect for his reasoned judgment, suggests Ah Lee use the current term structure to gauge interest rate expectations. He uses the following table from Federal Reserve Statistical Release H.15 to get current spot rates on one-, two-, and three-year constant maturity Treasury securities. (See table below) Treasury constant maturities Spot Rate Today 1-year 1.54% 2-year 1.61% 3-year 1.61% 4-year 1.63% 5-year 1.65% 7-year 1.75% Task Carlo will accept a recommendation different than his own only if it is justified by analysis," advises Ah Cheung. "Well-reasoned analysis is an opportunity to gain back some of Carlo' trust, which was lost after your last bond purchase." Ah Lee's problem is to recommend the best investment among three different US Treasury bonds. The $10 million investment will be liquidated in three years to help epay a bank loan charging a fixed rate interest at 8.50% per year. The bonds, each with a $1,000 par value and annual convention, are described as following: Bond Annual Current Price Maturity (yrs) Coupon Bond 1 0% $882.50 Bond 2 11.625% $1403.39 Bond 3 5.5% $1107.592. Risk and Return analysis (i) Analyse the durations of the 3 bonds and why does that matter in the analysis? Explain. (20 Points) (Hint: You need to calculate the YTM of the 3 bonds in order to calculate the Duration). (ii) Perform RCY analysis on the 3 bonds (40 Points) (Hint: Make use of spot rates to calculate the corresponding forward rates for coupon reinvestment calculation.} C F2 C 251 Year 1 Year 2 Year 3 Year 4 Year 5 (Hint: You also need forward rates for future Bond price) Bond Price C+F Fa C 2F3 Year 1 Year 2 Year 3 Year 4 Year 5