In: Finance
Stocks |
Mean Return |
Variance of Return |
|
X |
2 |
2.25 |
|
Y |
4 |
36 |
|
Z |
6 |
4 |
|
Correlations |
|||
X and Y |
X and Z |
Z and Y |
|
0.5 |
0.2 |
0.9 |
2. A bond has a face value of $1000 with a time to maturity ten years from now. The yield to maturity of the bond now is 10%. What is the price today if pays 8% coupon rate semi-annually?
Please refer to below spreadsheet for calculation and answer. Cell reference also provided.
Cell reference -