Tag Price Function

How to Calculate Duration and Convexity of a Bond with Excel

Duration and convexity are important numbers in bond portfolio management, and duration is pretty simple in Excel because there are built-in functions. Convexity, though, is another matter. Of course, there are formulas that you can type in (see table below), but they aren’t easy for most people to remember and are tedious to enter. In this article I will show…

Make-whole Call Provisions in Excel

In recent years, bond issuers have changed from the traditional call schedule to a “make-whole” type of call. Generally, this is good for investors as it makes it less likely that high interest bonds will be called. If it is called, then they are “made whole” because they are paid the present value of the remaining cash flows. In a…

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),…