If the data is organized as follows, how do I adjust the XIRR formula (or
format of the data) to produce a CAGR ?
2008 2009 2010
NS 100 200 350
Must the year row include m/d/y format only ?
Thanks,
If the data is organized as follows, how do I adjust the XIRR formula (or
format of the data) to produce a CAGR ?
2008 2009 2010
NS 100 200 350
Must the year row include m/d/y format only ?
Thanks,
You don't use XIRR. Use IRR.
By the way you will need to have at least one negative cash flow to get a
result. The data you have says you are receiving $100 in 2008, $200 in 2009 and
$350 in 2010. But how much did you invest, and when did you invest it? You'll
have to tell IRR (and XIRR for that matter) that before it can calculate a
result.
--
Regards,
Fred
"john" <[email protected]> wrote in message
news:[email protected]...
> If the data is organized as follows, how do I adjust the XIRR formula (or
> format of the data) to produce a CAGR ?
>
> 2008 2009 2010
> NS 100 200 350
>
> Must the year row include m/d/y format only ?
>
> Thanks,
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks