Does anyone know how to computer yield to maturity, in Excel, for a bond that pays interest more than 4 times per year. Excel's builtin function limits payment frequency to 4 times per year. However, many bonds pay interest monthly.
Does anyone know how to computer yield to maturity, in Excel, for a bond that pays interest more than 4 times per year. Excel's builtin function limits payment frequency to 4 times per year. However, many bonds pay interest monthly.
Hi,
Following should help ...
8 Nb of monthsPlease Login or Register to view this content.
0 Coupon
98 current price
100 price at maturity
HTH
Carim
Last edited by Carim; 11-29-2006 at 05:19 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks