|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 23rd, 2005, 01:55 PM
|
|||
|
|||
CAGR
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? 
|
|
#2
March 23rd, 2005, 01:59 PM
|
|||
|
|||
|
I think xirr is in the analysis toolpak addin.
-- Don Guillett SalesAid Software "Mike" wrote in message ... 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?
|
|
#3
March 23rd, 2005, 02:53 PM
|
|||
|
|||
|
If you want CAGR, why not just use ((X1/X0)^(1/n))-1
"Mike" wrote: 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?
|
|
#4
March 23rd, 2005, 08:04 PM
|
|||
|
|||
|
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 ToolsAdd-ins for the ATP and checkmark it. Gord Dibben Excel MVP On Wed, 23 Mar 2005 05:55:04 -0800, "Mike" wrote: 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?
|
|
#5
March 23rd, 2005, 09:14 PM
|
|||
|
|||
|
Did you look at Help for this function? It tells you what that result means
and what to do about it. On Wed, 23 Mar 2005 05:55:04 -0800, "Mike" wrote: 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?
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How do I calculate CAGR when there are periodic additional investm | Roger Phillips | Worksheet Functions | 3 | March 1st, 2005 02:10 AM |
| CAGR | [email protected] | Worksheet Functions | 2 | May 17th, 2004 10:35 PM |
| CAGR | UncleD | Worksheet Functions | 1 | January 23rd, 2004 04:03 PM |
| CAGR -- How? | Peter | Worksheet Functions | 3 | January 4th, 2004 09:10 PM |
Linear Mode
