Excel Finance - Calculate the Present Value of a Bond with Semiannual or Quarterly Interest Payments

Go to http://www.teachmsoffice.com for this and more tutorials and training in Excel and Microsoft office.

This Excel Finance tutorial shows you how to calculate the present value or price of a bond that has semiannual or quarterly interest (coupon) payments. This is similar to calculating the price of an annual bond except that you have to alter the particular details of the bond to take into account the multiple payment periods per year. This tutorial provides a step by step explanation of how to calculate the price of a bond with semiannual or quarterly interest payments as well as why there is a difference in the price of similar bonds that have different payment periods per year.



This tutorial published with permission from http://www.teachmsoffice.com

Category:

Education

Tags:

• finance
• excel
• calculate
• present
• value
• price
• bond
• quarterly
• semi
• annual
• semiannual
• interest
• coupon
• payments