11:55 5G 42 Back Assignment1-1.docx corporate bonds. Use issuer name in the quick search to find all bond issues. If you know the CUSIP of the bond, you can find the specific issue. Present the main features of the bond in a clear way (see it presented in excel in the example file). Part II. 1. Build the tool to price corporate bonds. Per Vah Inputs for the bond valuation (price) should include: par value (face value), coupon rate (for zero-coupon bonds, coupon rate=0), number of compounding periods per year, time to maturity in years, YTM (APR) 2. Use the solver function to solve for YTM given the bond price. If you do not see the "solver" in the Data" tab, you need to add it as an add-in". 3. The quoted bond prices are "clean prices" which do not include accrued interest. Build a separate function to calculate accrued interest, then calculate dirty price. Accrued interest = (days since last couponumber of days in the coupon period)*next coupon payment Dirty price = clean price + accrued interest 4. Check to make sure that your bond price function works correctly using price-yield pairs, for example: yield at offering and price at offering. 2 11 Dashboard Calendar To Do Notifications Inbox 11:55 5G 42 Back Assignment1-1.docx corporate bonds. Use issuer name in the quick search to find all bond issues. If you know the CUSIP of the bond, you can find the specific issue. Present the main features of the bond in a clear way (see it presented in excel in the example file). Part II. 1. Build the tool to price corporate bonds. Per Vah Inputs for the bond valuation (price) should include: par value (face value), coupon rate (for zero-coupon bonds, coupon rate=0), number of compounding periods per year, time to maturity in years, YTM (APR) 2. Use the solver function to solve for YTM given the bond price. If you do not see the "solver" in the Data" tab, you need to add it as an add-in". 3. The quoted bond prices are "clean prices" which do not include accrued interest. Build a separate function to calculate accrued interest, then calculate dirty price. Accrued interest = (days since last couponumber of days in the coupon period)*next coupon payment Dirty price = clean price + accrued interest 4. Check to make sure that your bond price function works correctly using price-yield pairs, for example: yield at offering and price at offering. 2 11 Dashboard Calendar To Do Notifications Inbox