How to make RWR Retirement Plans in less than 15 minutes.

If there's only one person, then input their first name into cell A3. If there is another person, then input the oldest's person's first name into cell A3, and the youngest person's first name into cell A4.

Input the current year into cell A5.

Input the oldest person's year of birth into cell A7.

If there is a younger person, input their year of birth into cell A8.

Input how much money is needed to live on (for one or both people combined) an annual basis into cell A9.

Input the age retirement is to start for the oldest person into cell E3.

Input the age retirement is to start for the youngest person into cell E4.

Inflation: Input "3" (which will turn into "3%" after you press enter) into all three cells, E5, E6, and E7.

Taxes: Input "20" (which will turn into "20%" after you press enter) into cell E8.

Input the age you want (them) to start collecting Social Security into cells E9 & E10. Enter 65 (for both people if there are two people) if you are confused.

Input $1,000 into cells E11, and E12 if there are two people. This is an average guess of how much Social Security one receives.

Social Security Inflation: Enter "1" (which will turn into "1%" after you press enter) into cell E13 for annual Social Security Cost of Living (inflation) increases.

Input 50% into cell E22. This is how much Social Security will taxable.

Click the sheet tab to the right, called Oldest Asset #1, or press Control and Page Down at the same time, once to go there.

Input the name of the biggest asset into cell A5 - call it "Assets" for now.

It's normal for red error messages to appear until there is sufficient input.

Input the current value of all investment/retirement assets into cell A6 (don't input home equity, vehicles, or personal property).

Input the current age of the oldest person, shown in cell A3, into cell A7.

Input the age that the oldest person will retire, shown in cell L3, at into cell A8.

Asset's Growth Rate: Input 8% into cell A9.

If this asset is mostly in qualified retirement plans (401k, IRA, etc.), then input 100% into cell A10. If it's not, input 50%.

Enter 6 into cell A16.

Ensure cells A12 - 15 have appropriate data input into them if you want to account for contributions to the asset.

Return to the Summing & Input sheet.

Ensure that Rows 14 through 17 of the Summing & Input sheet does not display any red error messages. If they do then the text tells how to fix them.

Cells A11 - A13 come with input in them already. If there's nothing in them, then input 5% into cell A11, and 100 in A12 and A13.

Using the Monte Carlo feature: Go to the far left Monte Carlo sheet. Press control M (hold the control key down and press the M key). A macro runs. When it stops and asks you if it's okay to delete the temporary sheet, click OK. It then ends up on the cell with the resulting probability number. It takes about seven minutes.

That's it. Now just look at the sheets to the left of the Summing and Input sheet to see the results.

If you're seeing this: #### then either increase your Zoom magnification number (View, Zoom), or make the column or row width wider.

This is all that's needed for the most basic input.

Now please read the manual to account for details.

Quickie Directions for Dual RWR

Go to the Master Input sheet (where the program first opens up to).

The Current / Old retirement plan input is in column A. Proposed / New retirement plan input is in column D.

Input the last name (yours or the client's) into cell A4.

If there's only one person, then input their first name into cell A5. If there is another person, then input the oldest's person's first name into cell A5, and the youngest person's first name into cell A6.

Input the current year into cell A7.

Input the oldest person's year of birth into cell A9.

If there is a younger person, input their year of birth into cell A10.

Input how much money is needed to live on an annual basis, after retirement, into cell A11.

Cells A13 - A15 come with input in them already. If there's nothing in them, then input 5% into cell A13, and 100 in A14 and A15.

Input the age retirement is to start for the oldest person into cell A16.

Input the age retirement is to start for the youngest person into cell A17.

Inflation: Input "3" (which will turn into "3%" after you press enter) into all three cells, A18, A19, and A20.

Taxes: Input "20" (which will turn into "20%" after you press enter) into cell A21.

Input the age you want (them) to start collecting Social Security into cells A22 & A23. Enter 65 (for both people if there are two people) if you are confused.

Input $1,000 into cells A24 and A25. This is an average guess of how much Social Security one receives.

Social Security Inflation: Enter "1" (which will turn into "1%" after you press enter) into cell A26 for annual Social Security Cost of Living (inflation) increases.

Input 50% into cell A27. This is how much Social Security will taxable.

Input the name of the biggest asset into cell A123 - call it "Assets" for now if you're confused.

It's normal for red error messages to appear until there is sufficient input.

Input the current value of all retirement/investment assets into cell A124 (don't input home equity, vehicles, or personal property).

Input the current age of the oldest person into cell A125.

Input the age that the oldest person will retire at into cell A126.

Asset's Growth Rate: Input 8% into cell A127.

If this asset is mostly in qualified retirement plans (401k, IRA, etc.), then input 100% into cell A128. If it's not, input 50%.

Enter 6 into cell A134.

Ensure that cells D4 and D6 of the Master Input sheet do not display any red error messages. If they do, then they tell you how to fix your input.

Using the Monte Carlo feature: Go to one of the two far left Monte Carlo sheets. To run a simulation for the Current version, go to the Current Monte Carlo sheet and press control M (hold the control key down and press the M key).

A macro runs. When it stops and asks you if it's okay to delete the temporary sheet, click OK. It then ends up on the cell with the resulting probability number.

To run a simulation for the Proposed version, go to the Proposed Monte Carlo sheet and press control N. It takes about 20 minutes.

That's it. Now just look at the sheets to the left of the Master Input sheet to see the results.

If you're seeing this: #### then either increase your Zoom magnification number (View, Zoom), or make the column or row width wider.

This is all that's needed for the most basic input.

If you want to play with a proposed version, then you can copy and paste data into column D, or you can input it manually.

Now please read the manual to account for details.

Quickie Directions for RP and the Free Retirement Calculator

Go to the Summing & Input sheet (where the program first opens up to).

Input the last name (yours or the client's) into cell A2.

Input the current year into cell A5.

Input the oldest person's year of birth into cell A7.

If there is a younger person, input their year of birth into cell A8.

Input how much money is needed to live on (for one or both people combined) an annual basis into cell A9.

Input the year retirement is to start for the oldest person into cell F3.

Input the year retirement is to start for the youngest person into cell F4.

Inflation: Input "3" (which will turn into "3%" after you press enter) into all three cells, F5, F6, and F7.

Taxes: Input "20" (which will turn into "20%" after you press enter) into cell F8.

Input the age you want (them) to start collecting Social Security into cells F9 & F10. Enter 65 (for both people if there are two people) if you are confused.

Input $1,000 into cells F11, and F12 if there are two people. This is an average guess of how much Social Security one receives.

Social Security Inflation: Enter "1" (which will turn into "1%" after you press enter) into cell F13 for annual Social Security Cost of Living (inflation) increases.

Input 50% into cell F22. This is how much Social Security will taxable.

Click the sheet tab to the right, called Oldest Asset #1, or press Control and Page Down at the same time, once to go there.

Input the name of the biggest asset into cell A5 - call it "Assets" for now.

Input the current value of all investment/retirement assets into cell A6 (don't input home equity, vehicles, or personal property).

Input the current age of the oldest person, shown in cell A3, into cell A4.

Input the age that the oldest person will retire, shown in cell J3, at into cell A7.

Asset's Growth Rate: Input 8% into cell A8.

Ensure cells A9 - 12 have appropriate data input into them if you want to account for contributions to the asset.

Return to the Summing & Input sheet.

Ensure that Rows 14 through 17 of the Summing & Input sheet does not display any red error messages. If they do then the text tells how to fix them.

Cells A11 - A13 come with input in them already. If there's nothing in them, then input 5% into cell A11, and 100 in A12 and A13.

That's it. Now just look at the sheets to the left of the Summing and Input sheet to see the results.

If you're seeing this: #### then either increase your Zoom magnification number (View, Zoom), or make the column or row width wider.

This is all that's needed for the most basic input.

Now please read the manual to account for details.

Product Information

Menu of Retirement Planning Software

Asset Allocation Overview with Our Historical Returns

Asset Allocation Software

Asset Allocation Models with Our Historical Returns

Our Monthly Updated Mutual Fund Picks

Financial Plan Tools