PC Review


Reply
Thread Tools Rate Thread

How do I calculate CAGR other than using XIRR function?

 
 
=?Utf-8?B?cnJpZ25leQ==?=
Guest
Posts: n/a
 
      6th Jul 2006
How do I calculate CAGR other than using XIRR function?
 
Reply With Quote
 
 
 
 
Fred Smith
Guest
Posts: n/a
 
      9th Jul 2006
The other available functions are RATE and IRR. The appropriate function will
depend on what data you have.

--
Regards,
Fred


"rrigney" <(E-Mail Removed)> wrote in message
news:E7C753C8-09DC-4C24-B0FD-(E-Mail Removed)...
> How do I calculate CAGR other than using XIRR function?



 
Reply With Quote
 
joeu2004@hotmail.com
Guest
Posts: n/a
 
      10th Jul 2006
Fred Smith wrote:
> "rrigney" <(E-Mail Removed)> 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 With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I calculate CAGR in Excel? =?Utf-8?B?bWVsc2h1bHQ=?= Microsoft Excel Worksheet Functions 4 2nd Dec 2011 03:05 PM
CAGR for short sales using XIRR oukid Microsoft Excel Misc 3 9th Jul 2008 03:24 PM
Calculate value at the end of nth year using CAGR Fenil Shah Microsoft Excel Worksheet Functions 4 2nd Jan 2008 08:30 AM
How to calculate CAGR for mutual fund performance using XIRR =?Utf-8?B?RGljayBpbiBTTA==?= Microsoft Excel Worksheet Functions 6 6th Jan 2006 10:07 PM
Calculate the CAGR =?Utf-8?B?QnJ1Y2U=?= Microsoft Excel Worksheet Functions 6 7th Jun 2005 02:17 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:14 AM.