I had a series of CF's that should produce a negative IRR (uisng the XIRR
function).
However, the excel XIRR answer always goes to 0.00%.
When I force to periodic payments and use IRR funciton I do get a negative
IRR answer.
Is this a XIRR issue?
I had a series of CF's that should produce a negative IRR (uisng the XIRR
function).
However, the excel XIRR answer always goes to 0.00%.
When I force to periodic payments and use IRR funciton I do get a negative
IRR answer.
Is this a XIRR issue?
No, XIRR will quite happily produce a negative return.
Post your data so we can help you out solving the problem.
--
Regards,
Fred
"dave in Toronto" <[email protected]> wrote in message
news:[email protected]...
>I had a series of CF's that should produce a negative IRR (uisng the XIRR
> function).
> However, the excel XIRR answer always goes to 0.00%.
> When I force to periodic payments and use IRR funciton I do get a negative
> IRR answer.
>
> Is this a XIRR issue?
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks