Hi guys,
I have a question regarding the xirr formula compared to ordinary present value calculation. I guess this is a pretty common problem, but i could not find the answer in other threads.
Please see the excel file attached. I cannot understand why there becomes a difference between these two figures - they uses the same set of numbers.
I need the 5,519 to become 5,515 somehow, not the other way around - the cash flow it self i correct.
Best,
Kristoffer
I have a question regarding the xirr formula compared to ordinary present value calculation. I guess this is a pretty common problem, but i could not find the answer in other threads.
Please see the excel file attached. I cannot understand why there becomes a difference between these two figures - they uses the same set of numbers.
I need the 5,519 to become 5,515 somehow, not the other way around - the cash flow it self i correct.
Best,
Kristoffer