So, for the life of me I cannot wrap my head around calculating potential growth on my 401k right now. I've done scenarios based off my current income, current 401k allotment, and current employee contributions out to age 45, 50, and 55, starting at $0 (which thankfully isn't the case). This chart, based on my income, was 401k contribution percentages from 6% - 30%, what what they'd total at the ages I've listed above. However, that is just contributed dollars based on 0% interest, just what myself and my employers dollars would total up to. I'd like to be able to itemize it out at 5% - 10% projected returns to those ages.
Does that make sense? Can anyone help? I'm doing it in excel right now, as I was playing with how much increasing my contribution would change my take home pay, and then it's just spiraled from there..