Hi all,
Is there a way to calculate the duration of uneven cash flows? I realize the duration function will do the trick on a regular bond, but I need something else. The XIRR function is extremely helpful for this when it comes to yields, but I couldn't find a similar function for duration.
Thanks!
Is there a way to calculate the duration of uneven cash flows? I realize the duration function will do the trick on a regular bond, but I need something else. The XIRR function is extremely helpful for this when it comes to yields, but I couldn't find a similar function for duration.
Thanks!