Bond Pricing

[Kent]

I have Excel 97 and looking for a template or source of
info to be able to calculate the price of a bond if I know
the settlement date, the coupon, the maturity, and the
current yield.
Any suggestions to go to within Excel 97 (in case I have
overlooked it) or a third party source that would offer
such programs.

 

[Jay]

I have Excel 97 and looking for a template or source of

info to be able to calculate the price of a bond if I know
the settlement date, the coupon, the maturity, and the
current yield.
Any suggestions to go to within Excel 97 (in case I have
overlooked it) or a third party source that would offer
such programs.

There's an Excel template for bond premium amortization at
http://office.microsoft.com/templates/default.aspx
Click on "Personal Finance" first (it's under "Finance and Accounting"),
and then on "Bond Amortization." You can download the Excel template from
there.

Typically, somebody wants to figure out the effective rate, given the
price. They'd fill out the first four blanks of the template and use
Excel's "Goal Seek" to make the final "Carrying amount of bond" value equal
to the "Face value of the bond" by changing the "Effective rate."

You seem to want the opposite. You'd fill out the 2nd through 5th blank,
then use "Goal Seek" to make the final "Carrying amount of bond" value
equal to the "Face value of the bond" by changing the "Bond purchase
price."

 

[Jay]

As an afterthought, I just noticed the ODDFPRICE function, which might fit
your need.