NEED THE EXCEL FUNCTIONS PLEASE!

A. Using the PRICE function, calculate the intrinsic value of each bond. Lise an IF statement to decide whether each bond is currently undervalued? B. Calculate the CURRENT YIELD of both bonds. C. Using the YIELD function, calculate the yield to maturity of each bond using the current market prices. D. Calculate the DURATION and MODIFIED DURATION of each bond. Bond B 2/15P 2/15/17 Settlemen Date Maturity Date Coupon Rate Price Face Value Required Retem Frecesine Bond A | 2/15/12 2/15/12 5.00% 690.00 S1.000.00 4.00% 2 $1,040,00 $1.000,00 &.00% 2 Intrinsic Vales Under/Over Vated Current Yield Yield to Maturity Duration Modified Duration Price A Prke B Yield 0% 1% E. Construct a line chart showing the relationship between yield and price for two bonds. Place Chart Here 3% 4% S% 7% 8% 9% 10% 11% 12% 13% 15% 16% 17% 18% 19% 20% 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% A. Using the PRICE function, calculate the intrinsic value of each bond. Lise an IF statement to decide whether each bond is currently undervalued? B. Calculate the CURRENT YIELD of both bonds. C. Using the YIELD function, calculate the yield to maturity of each bond using the current market prices. D. Calculate the DURATION and MODIFIED DURATION of each bond. Bond B 2/15P 2/15/17 Settlemen Date Maturity Date Coupon Rate Price Face Value Required Retem Frecesine Bond A | 2/15/12 2/15/12 5.00% 690.00 S1.000.00 4.00% 2 $1,040,00 $1.000,00 &.00% 2 Intrinsic Vales Under/Over Vated Current Yield Yield to Maturity Duration Modified Duration Price A Prke B Yield 0% 1% E. Construct a line chart showing the relationship between yield and price for two bonds. Place Chart Here 3% 4% S% 7% 8% 9% 10% 11% 12% 13% 15% 16% 17% 18% 19% 20% 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%