You own two bonds. Bond A is a 10% coupon bond with a yield of 5% which makes payments every quarter and matures in 15 years. The face value of the bond is $100000. Bond B is a 3% coupon bond with a yield of 8% that makes payments every month and has a maturity of 10 years. Calculate the value of each bond at every coupon payments date until maturity using excel. Graph your results.

Answer rating: 100% (QA)

To calculate the value of each bond at every coupon payment date until maturity using Excel you can use the present value formula The present value fo... View the full answer