Tutorial: Re-Implementation of the Excel PRICE function.

Note

The Excel Price function calculates the value of a fixed coupon bond given a constant yield. In other words: the bond is valued assuming a flat zero discount curve. Note that this valuation is rarely adequate. It's only justification may be to determine the implied zero rate of a given fix coupon price, by solving this function for the yield.

Download

The classes (and the spread sheets) can be downloaded here: Excel Price and Yield.zip