NEED THE EXCEL FORMULAS 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 A A 2/15/12 2/15/22 Bond B 2/15/12 2011-12 Settlement Date Maturity Date Coupon Rate Price Face Valec Required Return Frequency $1,000.00 4.00 2 $1.04000 $1,000.00 8.00 2 9 Intrinsie Vabee Under/Over Vaheed Current Yield Yield so Maturity Duration Modified Deration Yield 0% Prie A Price B E. Construct a line chart showing the relationship between yield and price for two bonds. Place Chart Here S% 7% 8% 9% 10% 11% 12% 14% 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 Yleid 100 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 A A 2/15/12 2/15/22 Bond B 2/15/12 2011-12 Settlement Date Maturity Date Coupon Rate Price Face Valec Required Return Frequency $1,000.00 4.00 2 $1.04000 $1,000.00 8.00 2 9 Intrinsie Vabee Under/Over Vaheed Current Yield Yield so Maturity Duration Modified Deration Yield 0% Prie A Price B E. Construct a line chart showing the relationship between yield and price for two bonds. Place Chart Here S% 7% 8% 9% 10% 11% 12% 14% 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 Yleid 100 3.00%