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: Par: 100,000 Price: 101 Bought: July 15, 2009 Maturity: June 30, 2019 Cash Paid: 101,000 Premium: 1,000 Coupon: 5% paid semi-annually, 6/30 and 12/31 Thank you
|
Pages: 1 Prev: Addition Error Next: Is it possible to count the no. of characters in a cell in Excel? |