Download the attached XL file and shoot holes in my calculations. The sheet is designed to take your current retirement fund balances along with your monthly contributions to retirement to calculate a future value at retirement. The sheet allows you to play with the age you wish to retire (be sure to plug in your birthdate so it knows your current age).

On the second tab, it allows you to see how much annual income you could get if you invested all funds and lived off your own personal annuity (if you will). At the bottom of the second page, it allows you calculate the net effect of annual income after taking inflation into account (that's depressing).

The biggest assumptions in this sheet is assuming an average 7% return on investments while saving for retirement, assumes you can invest all funds safely and earn 3.5% as you're living off the funds at retirement, and it assumes a 3% average rate of inflation. Of course, you can adjust any of these factors to change the outcome.

The amounts used are made up (except my date of birth and current employer 401 match / pay). So, don't assume I actually look that good or bad.

I look forward to your review.