USE EXCEL PLEASE

to maturity is currently 4.5% 2) If I want to buy the bond from question 1, on January 1, 2022, what would I pay (dirty price)? Note: this is a corporate bond which uses 30/360 basis (30 days per month and 360 days per year). The last coupon was paid on 10/1/2021 (90 days prior to my purchase date). J K L 30 31 5000 32 33 face value coupan yield term price 34 125 0.05*K31/2 0.0225 0.045/2 30 15*2 $5,270.57 pv(K33,K34,-K32,-K31) 35 36 1) Determine the price in USD of a bond that was issued on April 1, 2020 and is set to mature on April 1, 2035. This bond pays a coupon of 5% semi-annually. The face value is $5,000. The yield to maturity is currently 4.5% to maturity is currently 4.5% 2) If I want to buy the bond from question 1, on January 1, 2022, what would I pay (dirty price)? Note: this is a corporate bond which uses 30/360 basis (30 days per month and 360 days per year). The last coupon was paid on 10/1/2021 (90 days prior to my purchase date). J K L 30 31 5000 32 33 face value coupan yield term price 34 125 0.05*K31/2 0.0225 0.045/2 30 15*2 $5,270.57 pv(K33,K34,-K32,-K31) 35 36 1) Determine the price in USD of a bond that was issued on April 1, 2020 and is set to mature on April 1, 2035. This bond pays a coupon of 5% semi-annually. The face value is $5,000. The yield to maturity is currently 4.5%