Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Bond duration for monthly coupon
For some reason, Excel can only calculation duration (using the
DURATION() formula) for annual, semiannual, or quarterly coupons. It does not work for monthly coupons. Does anyone know how to make it work for any interval of coupons? If I can't make Excel's built-in function to work, is there a hard formula for duration that I can enter that would work? Cheers. N. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Complicated work! Any idea?? | Excel Worksheet Functions | |||
Format cell to show duration of phone calls | Excel Worksheet Functions | |||
Calculating Bond Price | Excel Worksheet Functions | |||
Bond YTM if Coupon Payment is at Maturity? | Excel Discussion (Misc queries) | |||
Duration | Excel Discussion (Misc queries) |