Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I calculate CAGR other than using XIRR function?
How do I calculate CAGR other than using XIRR function?
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I calculate CAGR other than using XIRR function?
The other available functions are RATE and IRR. The appropriate function will
depend on what data you have. -- Regards, Fred "rrigney" wrote in message ... How do I calculate CAGR other than using XIRR function? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I calculate CAGR other than using XIRR function?
Fred Smith wrote:
"rrigney" wrote: How do I calculate CAGR other than using XIRR function? The other available functions are RATE and IRR. The appropriate function will depend on what data you have. And quite possibly neither of those functions or other functions use in concert with those two functions. As you said, the appropriate method depends on what the data are and perhaps the regularity (or not) of the cash flows. To the OP: Please specify the nature of the data that you are dealing with. A short concrete numerical example is most likely to ensure an applicable response. I would have responded to you directly, but I do not see your original posting in Google Groups :-(. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
variable date in XIRR function possible? | Excel Discussion (Misc queries) | |||
Calculating Compounded Growth & the XIRR Function | Excel Discussion (Misc queries) | |||
Function fails to calculate | Excel Worksheet Functions | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
Problem with XIRR function returning #NUM! | Excel Worksheet Functions |