Next Live Training Date:

15-19 Feb, 14-18 Mar 2016

CAGR Excel (Compound Annual Growth Rate)

Calculate CAGR using Excel

One of Excel’s most spectacular and useful features is the tool which it provides for calculating a CAGR. A CAGR measures the rate of return for an investment – such as a mutual fund or bond – over an investment period of say 5 or 10 years. The CAGR can also be referred to as a “smoothed” rate of return as it measures the growth of an investment as if it had grown at a steady rate on an annually compounded basis.

Related Items: CAGR Video Clip, IRR in Excel, IRR Calculator, NPV in Excel

To calculate a CAGR using Excel, one should use the XIRR function.

The XIRR Function Details

XIRR returns the internal rate of return for a schedule of cash flows that is not necessarily periodic. The XIRR function is composed of the main syntax namely values, dates and guess, and these are to be discussed as follows:

XIRR Function Notes

When using the XIRR function of Excel, as a user you will need to pay careful attention, noting the following:

With these amazing features and capabilities it is no surprise that the use of Excel to calculate CAGR is so popular among not only professionals but the home user as well. With the XIRR function, Excel can handle and accurately calculate any return of investment in terms of the compound annual growth rate. With the automatic CAGR function that Excel boasts, calculating large numbers is now as best as done. All you need to do is enter your values in the appropriate cells, and the sit back and relax while Excel does the rest.

Free Tips & Tricks Newsletter

Please fill in your details below to get regular Excel tips and tricks and a free Quick Reference Download!

Handy Tips & Tricks

Summing, Counting, or Averaging visible cells only

Summing, Counting, or Averaging visible cells only in Excel Often when you use tools like filter, grouping or hiding rows in Excel you want to be able to do the summing, counting or averaging of the visible cells only. Alternatively … Continue reading

How to put m2 in excel

How to put m2 in excel (metres squared) When working in Excel, you may wonder how to put m² in Excel cells so that it looks like metres squared instead of just m2. It is surprisingly easy. Below what the … Continue reading

...Not only did I learn a lot about Access on this course, but I also gained quite a few useful Excel skills. The fact that Jonny is an accountant meant that he understood the daily challenges with data in a finance role...

– Excel with access- Hannover Re

Video Library & Tutorials //

View Entire Video Gallery ››

Making the same change to multiple worksheets in Excel

Making the same change to multiple worksheets in Excel

Tables in Excel for PowerPivot use

Tables in Excel for PowerPivot use

Excel see formula instead of value 2013

Excel see formula instead of value 2013

Excel Quick Sum 2013

Excel Quick Sum 2013

Some of our Featured Clients