Bond valuations and yields: What do they mean, and how do you derive their value
ID: 2617824 • Letter: B
Question
Bond valuations and yields: What do they mean, and how do you derive their values? Consider the following case of investment-grade bonds issued by Procter & Gamble Co. (P&G;) in August 2011 Proctor & Gamble (NYSE: PG) I Issue Details Issue Size ($Mil) $1,000 Coupon 0.700% Maturity Date 08/15/2014 Coupon Type Fixed Callable Yes Coupon Frequency Semiannually Proctor and Gamble's total amount of debt increased from 31.9% in March 2011 to 34.2% in December 2011, mainly due to its net debt issuances to fund general corporate purposes. What was the annual cost of the funds to P&G; raised from the $1.0 billion bonds that mature in 2014 70 basis points. Historical Treasury Rates 2 Year Nominal 5 Year Nominal Difference If the bond sold at 100.10 at the time of issue, investors observed that required annual yield would be0.67%. - - Looking at the comparable U.S. Treasury yield, these bonds were issued at a spread of 1basis points. 0.75% Because the coupon rate is 0.19% greater than the yield required by the market, the bond sold at at the time of issue uly 2011 Aug Sept. Oct. Now. Dec. Jan, Time Period Source: U.S. Department of Treasury, cited on Morningstar.com If the new observed yield of the bond is 1.3%, the bond is likely to be trading at a price of If the current yield is higher than the coupon rate, investors would want a higher return on their investment. If the coupon rate is less than the yield required by the market, the price of the bond is most likely to be less than the par value of the bond, and the bond will sell at discount As interest rates increase, the yield required by the market will increase, and the price of the bond is likely to Thus, when the yield increases to 1.3%, the bond's price by Understanding yield to call and when bonds are called Suppose the bond had a call structure that allowed the company to call its bonds after one year. The call structure of the bonds states that the bonds would be callable at par What would be the yield to call? In what situation would the company call the bond? Q 1.785% Q 1.598% 2.498% 1.054% When current yield on the bonds falls When interest rates fall O When the bond's price rises When interest rates rise From an investor's perspective, if the investor holds these P&G; bonds in their portfolio and market interest rates rise the bonds' value in the fixed-income asset class in the portfolio will most likely rates fall, the value of bonds in the portfolio will ; but if market interestExplanation / Answer
Price of bond when Yield on bond is 1.3%
Price of bond when Yield on bond is 1.3%
Using present value function in MS excel
pv(rate,nper,pmt,fv,type) rate = 1.3/2 = .65% nper = 3*2 = 6 pmt = 1000*.7%*50% fv =1000 type = 0
PV(0.65%,6,3.5,1000,0)
($982.40)
2-
Decrease, decreases by (1000-982.40) = 17.60
3-
yield to call = using rate function in MS excel
rate(nper,pmt,pv,fv,type)
RATE(2,3.5,-982.4,1000,0)
1.25%
4-
when interest rates fall
5-
decrease, increase
Price of bond when Yield on bond is 1.3%
Price of bond when Yield on bond is 1.3%
Using present value function in MS excel
pv(rate,nper,pmt,fv,type) rate = 1.3/2 = .65% nper = 3*2 = 6 pmt = 1000*.7%*50% fv =1000 type = 0
PV(0.65%,6,3.5,1000,0)
($982.40)
2-
Decrease, decreases by (1000-982.40) = 17.60
3-
yield to call = using rate function in MS excel
rate(nper,pmt,pv,fv,type)
RATE(2,3.5,-982.4,1000,0)
1.25%
4-
when interest rates fall
5-
decrease, increase