Duration Function

C

Clive

The duration function requires a frequency variable. Excell proposes 3
frequencies Annual (1), Semi annual (2), Quarterly (4) but no Monthly ...
How to calculate the Duration or Modified Duration of monthly Cash Flows
using the Excel Function?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

XIRR vs. IRR Function 11
Problem with SET & REF function 0
IRR function in Excel 2010 returns #NUM! error for an investment withall negative cash flows 9
How to automatically update a 12 month budget 5
Macro to delete row if cells greater than certain value 1
Bond duration for monthly coupon 0
IF Function 6
What regular savings, increasing every year to reach goal 11

Top