Question

In: Finance

Congratulations, you have been hired as an analyst at the Procter and Gamble Co. (PG).  Your first...

Congratulations, you have been hired as an analyst at the Procter and Gamble Co. (PG).  Your first assignment is to estimate the appropriate rate that a new 30-year bond would need in order to be issued competitively to the public.  It is April 1, 2020 (ignore actual current market rates).  PG just made a coupon payment (semi-annual) on its "8% 2045" bonds that mature on April 1, 2045. The bonds currently sell for 104 with a par value of 100.  Kimberly-Clark Corp. (KMB) has a 5% 2045 bond issue with a YTM of 6.0%. The PG and KMB bonds are identical in every way, including the Moody’s and S&P ratings, maturity date, and the fact that the respective companies can call them at any time. (The bonds were issued on different dates, thus their coupon rates and current market prices are different.)

            

a.         What is the yield to maturity on the PG bond?

            YTM    _______

b.         What is the price for the KMB bond?

            Price   _______

c.         Explain the difference in the YTM for the PG and KMB bonds.  Which bond provides the more accurate estimate of the rate required in the marketplace for PG at this time?  

d.         KMB has just issued a 5-year semi-annual bond with a 6% coupon, a par value of 100 and a 5% YTM.  Which KMB bond (5 year or 25 year) has the higher price risk and which one has the higher re-investment rate risk?   

(Circle 0ne)  Higher Price Risk                                            5 Year             25 Year

(Circle 0ne)  Higher Re-investment Rate Risk                  5 Year             25 Year

Solutions

Expert Solution

a]

YTM is calculated using RATE function in Excel with these inputs :

nper = 25*2 (25 years to maturity with 2 semiannual coupon payments each year)

pmt = 100 * 8% / 2 (semiannual coupon payment = face value * annual coupon rate / 2. This is a positive figure as it is an inflow to the bondholder)

pv = -104 (current bond price. This is a negative figure as it is an outflow to the buyer of the bond)

fv = 100 (face value of the bond receivable on maturity. This is a positive figure as it is an inflow to the bondholder)

The RATE is calculated to be 3.82%. This is the semiannual YTM. To calculate the annual YTM, we multiply by 2. Annual YTM is 7.64%

b]

Price of a bond is the present value of its cash flows. The cash flows are the coupon payments and the face value receivable on maturity

Price of bond is calculated using PV function in Excel :

rate = 6%/2 (Semiannual YTM of bonds = annual YTM / 2)

nper = 25 * 2 (25 years remaining until maturity with 2 semiannual coupon payments each year)

pmt = 100 * 5% / 2 (semiannual coupon payment = face value * coupon rate / 2)

fv = 100 (face value receivable on maturity)

PV is calculated to be $87.14

c]

The PG bond has a higher YTM than the KMB bond. This is due to the higher risk of PG bond perceived by bond investors. This could be due to poor financial health of PG relative to KMB

The PG bond provides the more accurate estimate of the rate required in the marketplace for PG at this time. This is because the yield on PG bonds best reflects the risk and required return for PG's bond investors

d]

Bonds with longer maturity have higher price risk, because their prices are more sensitive to changes in interest rates

Bonds with shorter maturity have higher reinvestment rate risk because at maturity, the bond proceeds must be reinvested. If the interest rates are lower at maturity, the proceeds must be reinvested at the lower interest rates.

5-year bond has higher reinvestment rate risk

2-year bond has higher price risk


Related Solutions

Procter and Gamble? (PG) paid an annual dividend of $ 1.73 in 2009. You expect PG...
Procter and Gamble? (PG) paid an annual dividend of $ 1.73 in 2009. You expect PG to increase its dividends by 8.4 % per year for the next five years? (through 2014), and thereafter by 2.9 % per year. If the appropriate equity cost of capital for Procter and Gamble is 7.3 % per? year, use the? dividend-discount model to estimate its value per share at the end of 2009.
Procter and Gamble​ (PG) paid an annual dividend of $ 1.68 in 2009. You expect PG...
Procter and Gamble​ (PG) paid an annual dividend of $ 1.68 in 2009. You expect PG to increase its dividends by 7.3 % per year for the next five years​ (through 2014), and thereafter by 3.2 % per year. If the appropriate equity cost of capital for Procter and Gamble is 7.2 % per​ year, use the​ dividend-discount model to estimate its value per share at the end of 2009. a.) What is the price per share? **Please show all...
Procter and Gamble​ (PG) paid an annual dividend of $ 1.66 in 2009. You expect PG...
Procter and Gamble​ (PG) paid an annual dividend of $ 1.66 in 2009. You expect PG to increase its dividends by 7.1 % per year for the next five years​ (through 2014), and thereafter by 2.8 % per year. If the appropriate equity cost of capital for Procter and Gamble is 8.7 % per​ year, use the​ dividend-discount model to estimate its value per share at the end of 2009. The price per share is______​$ (round to the nearest cent)....
Procter and Gamble​ (PG) paid an annual dividend of $ 1.79 in 2009. You expect PG...
Procter and Gamble​ (PG) paid an annual dividend of $ 1.79 in 2009. You expect PG to increase its dividends by 7.3% per year for the next five years​ (through 2014), and thereafter by 3.4 % per year. If the appropriate equity cost of capital for Procter and Gamble is 8.5% per​ year, use the​ dividend-discount model to estimate its value per share at the end of 2009. The price per share is______​$ (round to the nearest cent).
Procter and Gamble(PG) paid an annual dividend of $1.77 in 2009. You expect PG to increase...
Procter and Gamble(PG) paid an annual dividend of $1.77 in 2009. You expect PG to increase its dividends by 7.1% per year for the next five years(through 2014), and thereafter by 2.7%er year. If the appropriate equity cost of capital for Procter and Gamble is 8.2% per year, use the dividend-discount model to estimate its value per share at the end of 2009. The price per share is _____(two decimal)
You have been hired by Amazon to serve as their international financial analyst. Your first task...
You have been hired by Amazon to serve as their international financial analyst. Your first task is to support Amazon’s M&A prospecting efforts by create a country risk rating for three countries: Algeria, Hungary, and Laos. To do so, you must select and use a method to assess these country’s risks. Name and describe a method (or methods) that you would use to gather information to evaluate these three countries’ risks. Name at least three steps Amazon can take to...
You have been hired as an analyst for Melvin Bank and your team is working on...
You have been hired as an analyst for Melvin Bank and your team is working on an independent assessment of TWINKY, which is a firm that specializes in the production and distribution of ice and glass products in Sweden. Your assistant has provided you with the following data about the company and its industry. You analysis should include intra-company, inter-company, and industry benchmark comparisons. What can you say about the firm's overall management in terms of the following? (Be as...
You have been hired as an analyst for Bank WA and your team is working on...
You have been hired as an analyst for Bank WA and your team is working on an independent assessment of a firm that specializes in the production of freshly imported farm products from New Zealand. Your assistant has provided you with the following data about the company and its industry. Ratio 2019 2018 2017 2019- Industry Average Long-term debt 0.45 0.40 0.35 0.35 Inventory Turnover 62.65 42.42 32.25 53.25 Depreciation/Total Assets 0.25 0.014 0.018 0.015 Days’ sales in receivables 113...
1. You have been hired as an analyst for an advisory company and your team is...
1. You have been hired as an analyst for an advisory company and your team is working on an independent assessment of G-Aviation. G-Aviation is a firm that specializes in the production of aviation material. Your assistant has provided you with the following data for G-Aviation and their industry. Ratio 2019 2018 2017 2019- Industry Average Long-term debt 0.45 0.40 0.35 0.35 Inventory Turnover 62.65 42.42 32.25 53.25 Depreciation/Total Assets 0.25 0.014 0.018 0.015 Days’ sales in receivables 113 98...
You have been hired as an analyst for Bank WA and your team is working on...
You have been hired as an analyst for Bank WA and your team is working on an independent assessment of Duck Food Inc. (DF Inc.). DF Inc. is a firm that specializes in the production of freshly imported farm products from New Zealand.  Your assistant has provided you with the following data about the company and its industry. Ratio 2018 2017 2016 2018- Industry Average Long-term debt 0.45 0.40 0.35 0.35 Inventory Turnover 62.65 42.42 32.25 53.25 Depreciation/Total Assets 0.25 0.014...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT