Question

In: Finance

a financial analyst you are trying to put together a report about three different bonds. One...

a financial analyst you are trying to put together a report about three different bonds. One portion of the report requires you to estimate the expected return and standard deviation of each bond.

Which bond has the highest expected return?

Which bond has the riskiest? [Hint: You must use the probability model to compute the expected risk]

Probability

Yield for Bond X

Yield for Bond Y

Yield for Bond Z

0.10

12%

14%

7%

0.20

4%

3%

9%

0.30

23%

7%

15%

0.05

6%

-20%

30%

0.15

8%

5%

2%

0.09

1%

-12%

0.1%

0.11

9%

2%

10%

In excel. How do you know which bond is risker than the other?

Solutions

Expert Solution

a) Calculation of expected return of each bond.

Probability (P) Yield for Bond X in % (X) Yield for Bond Y in % (Y) Yield for Bond Z in % (Z) P*X P*Y P*Z
0.10 12 14 7 1.20 1.40 0.70
0.20 4 3 9 0.80 0.60 1.80
0.30 23 7 15 6.90 2.10 4.50
0.05 6 -20 30 0.30 -1.00 1.50
0.15 8 5 2 1.20 0.75 0.30
0.09 1 -12 0.1 0.09 -1.08 0.01
0.11 9 2 10 0.99 0.22 1.10

Expected Return on Bond X = P*X

= 1.2+.8+6.9+.3+1.2+.09+.99

= 11.48%

Expected Return on Bond Y = P*Y

= 1.40+.6+2.1-1+.75-1.08+.22

= 2.99%

Expected Return on Bond Z = P*Z

= .7+1.8+4.5+1.5+.3+.01+1.1

= 9.91%

Bond X has higher expected return.

b) Calculation of standard deviation of each bond.

-BOND X

Probability (P) Yield for Bond X in % (X) Deviation from expected return of 11.48% (D) PD2
0.10 12 0.52 0.0270
0.20 4 -7.48 11.1901
0.30 23 11.52 39.8131
0.05 6 -5.48 1.5015
0.15 8 -3.48 1.8166
0.09 1 -10.48 9.8847
0.11 9 -2.48 0.6765

Variance = PD2

= 64.9096

Standard Deviation = Variance

= 64.9096

= 8.06%

-BOND Y

Probability (P) Yield for Bond Y in % (Y) Deviation from expected return of 2.99% (D) PD2
0.10 14 11.01 12.1220
0.20 3 0.01 0.0000
0.30 7 4.01 4.8240
0.05 -20 -22.99 26.4270
0.15 5 2.01 0.6060
0.09 -12 -14.99 20.2230
0.11 2 -0.99 0.1078

Variance = PD2

= 64.3099

Standard Deviation = Variance

= 64.3099

= 8.02%

-BOND Z

Probability (P) Yield for Bond Z in % (Z) Deviation from expected return of 9.91% (D) PD2
0.10 7 -2.91 0.8468
0.20 9 -0.91 0.1656
0.30 15 5.09 7.7724
0.05 30 20.09 20.1804
0.15 2 -7.91 9.3852
0.09 0.1 -9.81 8.6612
0.11 10 0.09 0.0009

Variance = PD2

= 47.0126

Standard Deviation = Variance

= 47.0126

= 6.86%

Bond X is riskiest since it has higher standard deviation.


Related Solutions

Write one page report about Telecommunicating Services? Make sure that you put a bibliography in the...
Write one page report about Telecommunicating Services? Make sure that you put a bibliography in the paper?
You are called in as a financial analyst to appraise the bonds of Merck & Company,...
You are called in as a financial analyst to appraise the bonds of Merck & Company, Inc. The $1,000 par value bonds have a quoted annual interest rate of 5.4%, which is paid semiannually. The yield to maturity on the bonds is 6.4% annual interest. There are 25 years to maturity Compute the price of the bonds based on semiannual analysis.
You are called in as a financial analyst to appraise the bonds of Merck & Company,...
You are called in as a financial analyst to appraise the bonds of Merck & Company, Inc. The $1,000 par value bonds have a quoted annual interest rate of 8%, which is paid semiannually. The required interest rate on the bonds is 6% annual interest. There are 20 years to maturity a. Compute the bond’s value based on semiannual analysis. b. Suppose that two years after the bonds were issued (see part a), the required interest rate fell from 6%...
1. You are a financial analyst for an intenational firm that deals in bonds. There are...
1. You are a financial analyst for an intenational firm that deals in bonds. There are two bonds been offered: ADANSI EAST bond and ENERGY bond. ADANSI EAST is a tax free bond and ENERGY is taxable bond. The firm is interested in buying one of the bonds and you are being asked to explain the impact of tax free and tax statuses of the bonds on the price and interest rates of the two bonds using appropriate graphs.
Suppose that you have a one-year investment horizon. You are trying to choose among three bonds....
Suppose that you have a one-year investment horizon. You are trying to choose among three bonds. They are all default risk free. Also they all have $100 face value and have 5 years to mature. The Örst is a zero-coupon bond. The second has an 8% annual coupon rate and pays the $8 coupon once per year. The third has a 10% annual coupon rate and pays the $10 coupon once per year. (a) If all three bonds are now...
You are called in as a financial analyst to appraise the bonds of Olsen’s Clothing Stores....
You are called in as a financial analyst to appraise the bonds of Olsen’s Clothing Stores. The $1,000 par value bonds have a quoted annual interest rate of 11 percent, which is paid semiannually. The yield to maturity on the bonds is 14 percent annual interest. There are 15 years to maturity. Use Appendix B and Appendix D for an approximate answer but calculate your final answer using the formula and financial calculator methods. a. Compute the price of the...
You are called in as a financial analyst to appraise the bonds of Olsen’s Clothing Stores....
You are called in as a financial analyst to appraise the bonds of Olsen’s Clothing Stores. The $1,000 par value bonds have a quoted annual interest rate of 12 percent, which is paid semiannually. The yield to maturity on the bonds is 14 percent annual interest. There are 20 years to maturity. Use Appendix B and Appendix D for an approximate answer but calculate your final answer using the formula and financial calculator methods. a. Compute the price of the...
You are called in as a financial analyst to appraise the bonds of Olsen’s Clothing Stores....
You are called in as a financial analyst to appraise the bonds of Olsen’s Clothing Stores. The $1,000 par value bonds have a quoted annual interest rate of 8 percent, which is paid semiannually. The yield to maturity on the bonds is 10 percent annual interest. There are 20 years to maturity. Use Appendix B and Appendix D for an approximate answer but calculate your final answer using the formula and financial calculator methods. a. Compute the price of the...
You are called in as a financial analyst to appraise the bonds of Olsen’s Clothing Stores....
You are called in as a financial analyst to appraise the bonds of Olsen’s Clothing Stores. The $1,000 par value bonds have a quoted annual interest rate of 10 percent, which is paid semiannually. The yield to maturity on the bonds is 12 percent annual interest. There are 25 years to maturity. Use Appendix B and Appendix D for an approximate answer but calculate your final answer using the formula and financial calculator methods. a. Compute the price of the...
You are called in as a financial analyst to appraise the bonds of Olsen’s Clothing Stores....
You are called in as a financial analyst to appraise the bonds of Olsen’s Clothing Stores. The $1,000 par value bonds have a quoted annual interest rate of 12 percent, which is paid semiannually. The yield to maturity on the bonds is 12 percent annual interest. There are 10 years to maturity. Use Appendix B and Appendix D for an approximate answer but calculate your final answer using the formula and financial calculator methods.   Compute the price of the bonds...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT