 Quote:
Originally Posted by jIMOh
my function wizard does not have XIRR
running excel 2003.
the link does not show the math behind the calculation, can you display it here? thx
|
Perhaps your software has the IRR function?
ExcelTips: Using the IRR Function
I guess you'd set up the time scale as months and the IRR would be the
monthly return so probably not as accurate as XIRR. I'm assuming the annual return would be the monthly return compounded for 12 mos and you could set up the spreadsheet to calculate that.
|