Please show how this is solved in excel thank you so much Ca

Please show how this is solved in excel, thank you so much!!!

Calibri (Body) 11 AA Wrap Text General Paste B I ++| Merge & Center? $?% A1 x vfic 8.02 Valuing Bonds Microhard has issued a bond with the following characteristics: 8.02 Valuing Bonds Microhard has issued a bond with the following characteristics Par: $1,000 Time to maturity: 20 years Coupon rate: 7 percent Semiannual payments Calculate the price of this bond if the YTM is a. 7 percent b. 9 percent 1 c. 5 percent Coupon Rate Compounding Frequency 3 Face Value Maturity 4 6 YTM Bond Price 7.00% 9.00% 5.00% 10

Solution

paste the following in Excel

=-PV(7%/2,40,35,1000,0)

=-PV(9%/2,40,35,1000,0)

=-PV(5%/2,40,35,1000,0)

Bond Price

$1,000.00

$815.98

$1,251.03