CAGR

[Guest]

I am trying to calculate CAGR by using the suggested fromula XIRR but contnue
to get #NAME? as an answer and not the xx%. Is this formula correct?

 

[Don Guillett]

I think xirr is in the analysis toolpak addin.

 

[Guest]

If you want CAGR, why not just use ((X1/X0)^(1/n))-1

 

[Gord Dibben]

Mike

XIRR is from the Analysis Toolpak add-in.

If this function is not available, and returns the #NAME? error, install and
load the Analysis ToolPak add-in.

Check out Tools>Add-ins for the ATP and checkmark it.


Gord Dibben Excel MVP

 

[Myrna Larson]

Did you look at Help for this function? It tells you what that result means
and what to do about it.