Complete the following in the Excel file. Please make sure to report annual duration and convexity measures where applicable. 1. Calculate the price at issue for the five bonds and put your answers in the “Price” tab. Be sure to label each bond using its CUSIP. 2. Calculate DV01 at the time the bonds were issued for the five bonds and put your answers in the “DV01” tab. Please report dollar changes per $1,000 of face value. Be sure to label each bond using its CUSIP. 3. Duration at issue – to be reported in “Duration at issue” tab. Be sure to label each bond using its CUSIP. a. Calculate the annual modified duration at the time the bonds were issued
#Sales Offer!| Get upto 25% Off: