information

question

You have been given the following data on two bonds. SA. Using the PRICE function, calculate the intrinsic value of each bond. Use an IF statement to decide whether each bond is currently undervalued? 6 B. Calculate the CURRENT YIELD of both bonds. 7 C. Using the YIELD function, calculate the yield to maturity of each bond using the current market prices. 8 D. Calculate the DURATION and MODIFIED DURATION of each bond. 2/15/32 9 10 11 12 Settlement De 13 May Date 14 Coupon Rate 15 Price 16 Face Value 17 Required Return 18 Frequency 19 20 Intrinsie Value 21 Under Over Valued 22 Cure Yield 23 Yick to Maurity 24 Duration 25 Modified Duration 26 27 Bond A 2/15/12 2/15/32 5.00 SR90.00 $1.000,00 4.00 2 Bond B 2/1912 2/15/17 7.50% $1.040.00 $100000 8002 2. (semanual) $1,136.78 $979.72 S1.116.28 Undervalued 5.62% 3979.72 Overvalid 7.21% Series "Yield" Point "21.0" Value: 20% 8.00 4% 8% 1335 13.09 4.09 Yield Bend A Bond $ 2,000,00 1.175.00 f) Find the percentage change in the price of the bond under the scenarios below. Guide: You may find it easier to use the Bonds' values in your table above. % Change in Price Bond A Bond B Change in Yields -3.00% 3.00%