He contributes to Excel and ... by hand or by using Microsoft Excel. The easiest way to think of the CAGR is to recognize that the value of something may change over a number of years, hopefully ...

For an investor who has held the investment for three years, calculating ... 12 months and CAGR for investments held over 12 months. = (((ending value/beginning value)^(1/number of years))-1 ...