Compute the yield of the following bonds using the rate function in MS Excel Pri

Question

Compute the yield of the following bonds using the rate function in MS Excel

Price face value time to maturity bond rate 1 1020.45 1000 20 3.10% 2 1060.68 1000 11 2.71% 3 848.76 1000 5 9.71% 4 1013.39 1000 13 8.39% 5 839 1000 10 6.91% 6 838.49 1000 17 9.06% 7 946.19 1000 12 8.18% 8 953.78 1000 11 3.20% 9 827.83 1000 10 5.69% 10 821.69 1000 16 7.64% 11 845.57 1000 10 10.64% 12 941.33 1000 14 1.04% 13 1139.9 1000 6 5.63% 14 900.28 1000 14 5.85% 15 1040.48 1000 13 3.72% 16 1092 1000 12 9.71% 17 1138.64 1000 13 2.37% 18 1046.73 1000 15 1.51% 19 866.87 1000 14 3.25% 20 877.15 1000 11 2.19%

Explanation / Answer

Assuming semi annual payments. See the below link for solution

https://drive.google.com/open?id=0Bw82pL_9z1wOc2JtYndlaXJOLUU

https://drive.google.com/open?id=0Bw82pL_9z1wOZEcyZ2psMHlPYUk

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

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