Please show work in excel

1.You have decided to evaluate the following three corporate bonds to include in vour oortfolio: a) (10 points) Determine the maximum quoted price (clean price) at which you would still buy these bonds. b) (12 points) Calculate the accrued interest and the invoice price (dirty price) of each bond. c) (10 points) Using data tables, find out how the bond (clean) prices determined in part a) change when your required return changes. There should be one data table for each bond and the bond prices should be presented for the required return ranging from 2% to 6% with 1% increments. Answer in writing = What trend in prices do you see? What happens to prices as the tequired teturn increases? Why is this the cave? 1.You have decided to evaluate the following three corporate bonds to include in vour oortfolio: a) (10 points) Determine the maximum quoted price (clean price) at which you would still buy these bonds. b) (12 points) Calculate the accrued interest and the invoice price (dirty price) of each bond. c) (10 points) Using data tables, find out how the bond (clean) prices determined in part a) change when your required return changes. There should be one data table for each bond and the bond prices should be presented for the required return ranging from 2% to 6% with 1% increments. Answer in writing = What trend in prices do you see? What happens to prices as the tequired teturn increases? Why is this the cave