Retire on Cocktail - Retirement Models (Patreon)

Published:

2023-08-10 23:27:54

Imported:

2023-08

Content

Hi Team, as promised, per the Retire on COCKTAIL video, here is the model I used to calculate the numbers so you can run your own models.

How to use it:

Remember- you need to use the SOLVER to back into the numbers. (You must download SOLVER as an Extension first)

Step 1 - Click 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:

Open Google Sheets and create a new spreadsheet.
In the spreadsheet, enter the values for your variables and the objective function.
Select the cell that contains the objective function.
Click on the "Data" tab and then click on "Solver".
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.
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.

Enjoy!

TESLA

BITCOIN

SOLANA