xirr function

[john]

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,

 

[Fred Smith]

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.