You can use this calculator to solve seven different fields.
1. End Date
2. 1st of the month deposits
3. 15th of the month deposits
4. Both 1st and 15th of the month deposits
5. Lump Sum Deposit
6. End Value Amount
7. Return On Investment % (ROI)
Enter your known data and click on the ? to find a solution.
Example:
You have used the Withdrawal Solver With Taxes to calculate that you will require $114,721.96 to retire with $2000.00 per month.
Withdrawal Solver
With Taxes Settings
We assume we were born August 31, 1959
You will retire at age 60
You need to withdraw funds until age 90
You require $2000.00 per month before taxes
§ Tax Rate - Enter Your Tax Rate
§ Starting Value -
§ Starting Date - Enter 01/31/02
§ Start Withdrawal Date - Enter 01/31/20
§ No. of Withdrawal Years - Enter 30
§ End Date is calculated to - Enter 01/31/50
§ Yearly Rate of Return - Enter 6
§ Withdrawal Amount - Enter 2000
§ Date of Birth - Enter 08/31/1959
§ <Frequency> Select Per Month
§ You can fill in the rest as required.
§ Click the ? beside Starting Value
§ End Balance Desired - Enter 10000
§ The Starting Value is calculated to $114,721.96
§ You require $114,721.96 to meet your objective.
Go to the Return On Investment Monthly Deposits IRR calculator
You have $25,678.88 in your portfolios. You need to have $114,721.96 accumulated before January 31, 2020 calculated with the Start Withdrawal Date from above. This is the year you will retire.
Enter the following data in the Return On Investment Monthly Deposits IRR calculator.
§ Starting Value - Enter 25678.88
§ Pac Start Date - Enter 02/01/2002
§ End Date - Enter 01/31/2020
§ 1st of month - Enter 0
§ 15th of month - Enter 0
§ Lump Sum - Enter 0
§ End Value - Enter 114721.96
§ ROI [%] - Enter 6
Your screen should look something like this
Click the ? beside 1st of the month field.
The calculator solves and fills in the spreadsheet below.
You require a deposit of $108.88 on the 1st of each month to achieve your goal.
You would rather deposit on the 15th of the month.
1st of month - Enter 0
Click the ? beside 15th of the month field
You require a deposit of $108.32 on the 15th of each month to achieve your goal.
You decide that you want to make deposits on the 1st and 15th of each month.
1st of month - Enter 0
15th of month - Enter 0
Click the ? beside the 1st and 15th of the month ? s
You find that you are required to deposit $54.10 on the 1st and the 15th of each month to achieve your goal.
You can afford to deposit $150.00 on the 1st of the month and the $54.10 on the 15th.
1st of month - Enter 150
You then Click the ? beside the End Date field
The result is you can achieve your goal June 18, 2016
You could retire 3 years 6 months and 13 days earlier and in the summer time (Northern Hemisphere).
You can now decide if the extra $95.90 a month is worth it!
You decide that it is not worth it to add $95.90 a month.
You will be able to add $10,000.00 from an investment that will come due March 1, 2007.
You should be able to deposit the money on March 5, 2007
Reenter your data to match the original 1st and 15th solution.
We will add a Lump Sum of $10,000.00
§ Starting Value - Enter 25678.88
§ Pac Start Date - Enter 02/01/2002
§ End Date - Enter 01/31/2020
§ 1st of month - Enter $54.10
§ 15th of month - Enter $54.10
§ Lump Sum - Enter 10000
§ Deposit Date - 03/05/07
§ End Value - Enter 114721.96
§ ROI [%] - Enter 6
You then Click the ? beside the End Date field
You will be able to retire August 8, 2017
This is 2 years 5 months and 20 days years earlier.
This is only one example of enumerable solutions.