xirr function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Back
Top