Create a 401(k) Calculator in Excel

A 401(k) calculator can estimate the growth of a 401(k) plan over time. The calculator inputs include: rate of return, the annual investment, and the beginning 401(k) balance.
A 401(k) calculator can estimate the growth of a 401(k) plan over time. The calculator inputs include: rate of return, the annual investment, and the beginning 401(k) balance.
The average American household’s net worth is $748,800. However, a better comparison is the median net worth of $121,700. This article shows the average and median net worth by age.
The U.S. median net worth is $258,531 for 70-74 year olds and $272,976 for 75-79 year olds. The average net worth by age 80 is $235,193.
The U.S. median net worth is $228,833 for 60-64 year olds and $271,805 for 65-69 year olds. So, the median net worth by age 70 is over $272,000.
The U.S. median net worth is $171,320 for 50-54 year olds and $193,549 for 55-59 year olds. So, the median net worth by age 60 is over $194,000.
The U.S. median net worth is $127,345 for 40–44 year olds and $164,197 for 45–49-yyear olds. So, the median net worth by age 50 is over $165,000.