1. Recreate the following tables in Excel. FXHIBIT 4 Pricefried Melatisoshio for Fou Hypocherical Opcion Fise konds EXHIBMT 6 Intentancia Percentage Price Chenge for Four Hypathetial Boad (t-itial yidd for al four bende is 6wil Notes: a) Problem 1 requires you to be very careful how you feference the cells. b) It illustrates the use of Excel PRlCE function. You need to make up a Settlement date and Maturity date to match the data. c) It is also important that you are careful in making sure that the yields and coupons are denoted properly in the PRICE function. 1. Recreate the following tables in Excel. FXHIBIT 4 Pricefried Melatisoshio for Fou Hypocherical Opcion Fise konds EXHIBMT 6 Intentancia Percentage Price Chenge for Four Hypathetial Boad (t-itial yidd for al four bende is 6wil Notes: a) Problem 1 requires you to be very careful how you feference the cells. b) It illustrates the use of Excel PRlCE function. You need to make up a Settlement date and Maturity date to match the data. c) It is also important that you are careful in making sure that the yields and coupons are denoted properly in the PRICE function