Please show how this is solved in excel, thank you so much!!! Calibri (Body) 11

Question

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

Explanation / Answer

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

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.