Retire on Calculator (Patreon)

Hi Team

as promised, per the video today, here is the model. 

rem you need to use the SOLVER to back into the numbers. 

Step 1 - Hit File, Make a Copy

Step 2 - Use Solver to make retirement balance zero at end of your chosen period

Here are the steps on how to use Solver in Google Sheets:

1. Open Google Sheets and create a new spreadsheet.
2. In the spreadsheet, enter the values for your variables and the objective function.
3. Select the cell that contains the objective function.
4. Click on the "Data" tab and then click on "Solver".
5. In the Solver dialog box, enter the following information:Set the objective cell to the cell that contains the objective function.
   Set the target cell to the cell that contains the value you want to maximize or minimize.
   Select the type of solver algorithm you want to use.
   Enter the constraints for your problem.
   Click on the "Solve" button.
   
6. Solver will solve the problem and display the solution in the spreadsheet.

Here are some additional tips for using Solver:

• Make sure that your spreadsheet is set up correctly. The variables and the objective function must be in the correct cells.
• The constraints must be realistic. If they are not, Solver may not be able to find a solution.
• If Solver does not find a solution, try changing the solver algorithm or the constraints.
• You can also use the "Solver Options" dialog box to change the solver settings.

I hope this helps! Let me know if you have other requests or questions.