BOND CALCULATIONS & GRAPHING

[Chuckles123]

Although it has some limitations, perhaps the XLS file meets my needs.

It assumes an whole number of semiannual coupons between the Settl
Date and the maturity date (a PAR Call date could be substituted fo
the maturity date, but the model is not designed for above PAR calls).
The model is designed for amortizing a premium only; it cannot handl
OID bonds purchased below PAR.
The model does not consider accrued interest (consistent with Settl
Dates and coupon dates being coincident).

I punched some numbers into the template and compared the result fo
the "Effective Rate" to Bloomberg -- the numbers agree to the thir
decimal place.

Chuckles123

P.S.: OK Myrna, I give up ... what is IMO

 

[Myrna Larson]

I'm glad to get the report on what that template can and can't do. Sounds like
it's quite limited. It would be worthless for the type of clients my brother
deals with (primarily estates of people with many bonds -- up to 1200 in one
case).

The reason my 87k of code is so long is that it doesn't have any of the
limitations you cite <g>.

IMO = "in my opinion".

Here are links to some web sites with lists of acronyms. It makes quite
interesting reading <g>.

http://www.astro.umd.edu/~marshall/abbrev.html
http://www.ucc.ie/cgi-bin/acronym