Tag Accrued Interest

Calculate Accrued Interest on a Bond in Excel – 3 Ways

Typically, in finance textbooks, bond valuation is discussed with a hidden assumption: that you are valuing the bond on a coupon payment date. If that is the case, then you can use the PV function to find the price (though there is another hidden assumption in there: that the yield curve is flat). The problem with this is that usually…

Bond Valuation Using Microsoft Excel

A bond is a debt instrument, usually tradable, that represents a debt owed by the issuer to the owner of the bond. Most commonly, bonds are promises to pay a fixed rate of interest for a number of years, and then to repay the principal on the maturity date. In the U.S. bonds typically pay interest every six months (semi-annually),…