In the attached Excel document on the second sheet, I have defined the Retirement Goal in cell B1 as 1000000, the Annual Contribution in cell B2 as 1 (this is the starting value but will change as we ...

This is where Excelâ s Goal Seek feature comes in handy. Using Goal Seek, you can avoid reverse calculations and let Excel find the inputs that result in your desired output.