Bookmark this page:
[ Delicious Delicious ] [ Mister Wong Mister Wong ] [ Stumble It! ]
A Java Object Handler for Excel and OpenOffice.

Tutorial: Re-Implementation of the Excel PRICE function.


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.


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