how to calculate CAGR for 401k accounts

gordita

Golden Member
Mar 24, 2001
1,020
0
0
Anyone know how I can calculate my 401 CAGR over the last 5 yrs?
in the past 5 yrs, I've had yearly contributions, company matches and gains/losses.

unfortunately, my 401k provider can only go back to 2 yrs (we've changed our provider and investment funds a couple of times).

this is what i tried to do
1. determine ALL of my contributions for 5 yrs
2. determine ALL of the company matches.
3. determine the final value of my 401k in the 5th yr.

Then, divide the final value(3) by my contributions (1) and assume the number is 'x'
since it 5 yrs, inverse is 1/5 = 0.2
now, raise x to the power of 0.2 and I get Y.
subtract 1 from Y and i'm left with my compounded annual growth return.

is this correct?
any online calculators that allow me to input my yearly contributions and matches and then calculate my return?

most calculators I found need a starting amount, an ending amount and the # of years, that's all.....but for 401k, this won't do since I contribute every month...

any info would be appreciated!