How do I calculate CAGR other than using XIRR function?

  • Thread starter Thread starter Guest
  • Start date Start date
The other available functions are RATE and IRR. The appropriate function will
depend on what data you have.
 
The other available functions are RATE and IRR. The appropriate function will
depend on what data you have.
Click to expand...

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 :-(.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

CAGR 4
xirr function 1
how do i calculate CAGR for a series of years of revenues? 1
How to write XIRR formula on excel using different Year basis than 365. 5
Cost increase rate 3
How to get compound annual growth rates in pivot tables. 2
installing XIRR 4
CAGR 2

Back
Top