From: lmahaffey on 26 Jan 2010 14:38
Anyone know of a function that calculates the bond premium amortization using
the constant yield method?
An example of a bond premium that would need amortizing would be:
Bought: July 15, 2009
Maturity: June 30, 2019
Cash Paid: 101,000
Coupon: 5% paid semi-annually, 6/30 and 12/31
Prev: Addition Error
Next: Is it possible to count the no. of characters in a cell in Excel?