Retirement Withdrawal worksheet

1. Money lasts: 30.2 years

1. Start with your withdrawal rate: the first year's withdrawal as a percent of your savings

   $\frac{\mathrm{\$50,000.00}}{\mathrm{\$900,000.00}}\times 100$$=\mathrm{5.56\%}$

2. Each year, take out that year's withdrawal at the start. It rises 1.9% a year to keep up with prices. Then what's left grows by 6%

   $\text{next balance}$$=\left(\text{balance}-\mathrm{\$50,000.00}\times {\left(1+0.019\right)}^{\text{k}}\right)\times \left(1+0.06\right)$

3. After 30 full years only $18,247.26 is left, less than that year's $87,941.84 withdrawal. So add the part of a year it covers

   $30+\frac{\mathrm{\$18,247.26}}{\mathrm{\$87,941.84}}$$=30.21\text{years}$

4. Round down to a tenth of a year, so the answer never promises too much. The money lasts

   $\text{money lasts}$$=\text{30.2 years}$

5. To find the most you could take for 24 years, divide your savings by the sum of qᵏ. Here q is (1 + inflation) ÷ (1 + return), how much each withdrawal grows compared with your money

   $\frac{\mathrm{\$900,000.00}}{15.822256}$$=\mathrm{\$56,881.90}$

2. Money lasts: 17.6 years

1. Start with your withdrawal rate: the first year's withdrawal as a percent of your savings

   $\frac{\mathrm{\$48,000.00}}{\mathrm{\$675,000.00}}\times 100$$=\mathrm{7.11\%}$

2. Each year, take out that year's withdrawal at the start. It rises 3% a year to keep up with prices. Then what's left grows by 6%

   $\text{next balance}$$=\left(\text{balance}-\mathrm{\$48,000.00}\times {\left(1+0.03\right)}^{\text{k}}\right)\times \left(1+0.06\right)$

3. After 17 full years only $53,908.57 is left, less than that year's $79,336.69 withdrawal. So add the part of a year it covers

   $17+\frac{\mathrm{\$53,908.57}}{\mathrm{\$79,336.69}}$$=17.68\text{years}$

4. Round down to a tenth of a year, so the answer never promises too much. The money lasts

   $\text{money lasts}$$=\text{17.6 years}$

5. To find the most you could take for 26 years, divide your savings by the sum of qᵏ. Here q is (1 + inflation) ÷ (1 + return), how much each withdrawal grows compared with your money

   $\frac{\mathrm{\$675,000.00}}{18.583906}$$=\mathrm{\$36,321.75}$

3. Money lasts: 27.8 years

1. Start with your withdrawal rate: the first year's withdrawal as a percent of your savings

   $\frac{\mathrm{\$37,000.00}}{\mathrm{\$750,000.00}}\times 100$$=\mathrm{4.93\%}$

2. Each year, take out that year's withdrawal at the start. It rises 2.4% a year to keep up with prices. Then what's left grows by 5%

   $\text{next balance}$$=\left(\text{balance}-\mathrm{\$37,000.00}\times {\left(1+0.024\right)}^{\text{k}}\right)\times \left(1+0.05\right)$

3. After 27 full years only $56,208.29 is left, less than that year's $70,194.09 withdrawal. So add the part of a year it covers

   $27+\frac{\mathrm{\$56,208.29}}{\mathrm{\$70,194.09}}$$=27.8\text{years}$

4. Round down to a tenth of a year, so the answer never promises too much. The money lasts

   $\text{money lasts}$$=\text{27.8 years}$

5. To find the most you could take for 45 years, divide your savings by the sum of qᵏ. Here q is (1 + inflation) ÷ (1 + return), how much each withdrawal grows compared with your money

   $\frac{\mathrm{\$750,000.00}}{27.317024}$$=\mathrm{\$27,455.41}$

4. Money lasts: 31 years

1. Start with your withdrawal rate: the first year's withdrawal as a percent of your savings

   $\frac{\mathrm{\$55,000.00}}{\mathrm{\$1,160,000.00}}\times 100$$=\mathrm{4.74\%}$

2. Each year, take out that year's withdrawal at the start. It rises 3.1% a year to keep up with prices. Then what's left grows by 6%

   $\text{next balance}$$=\left(\text{balance}-\mathrm{\$55,000.00}\times {\left(1+0.031\right)}^{\text{k}}\right)\times \left(1+0.06\right)$

3. After 31 full years only $2,531.13 is left, less than that year's $141,703.74 withdrawal. So add the part of a year it covers

   $31+\frac{\mathrm{\$2,531.13}}{\mathrm{\$141,703.74}}$$=31.02\text{years}$

4. Round down to a tenth of a year, so the answer never promises too much. The money lasts

   $\text{money lasts}$$=\text{31 years}$

5. To find the most you could take for 24 years, divide your savings by the sum of qᵏ. Here q is (1 + inflation) ÷ (1 + return), how much each withdrawal grows compared with your money

   $\frac{\mathrm{\$1,160,000.00}}{17.768287}$$=\mathrm{\$65,284.85}$

5. Money lasts: 28.1 years

1. Start with your withdrawal rate: the first year's withdrawal as a percent of your savings

   $\frac{\mathrm{\$52,000.00}}{\mathrm{\$1,075,000.00}}\times 100$$=\mathrm{4.84\%}$

2. Each year, take out that year's withdrawal at the start. It rises 2.5% a year to keep up with prices. Then what's left grows by 5%

   $\text{next balance}$$=\left(\text{balance}-\mathrm{\$52,000.00}\times {\left(1+0.025\right)}^{\text{k}}\right)\times \left(1+0.05\right)$

3. After 28 full years only $12,921.91 is left, less than that year's $103,817.74 withdrawal. So add the part of a year it covers

   $28+\frac{\mathrm{\$12,921.91}}{\mathrm{\$103,817.74}}$$=28.12\text{years}$

4. Round down to a tenth of a year, so the answer never promises too much. The money lasts

   $\text{money lasts}$$=\text{28.1 years}$

5. To find the most you could take for 20 years, divide your savings by the sum of qᵏ. Here q is (1 + inflation) ÷ (1 + return), how much each withdrawal grows compared with your money

   $\frac{\mathrm{\$1,075,000.00}}{16.061753}$$=\mathrm{\$66,929.18}$

6. Money lasts: 47.5 years

1. Start with your withdrawal rate: the first year's withdrawal as a percent of your savings

   $\frac{\mathrm{\$40,000.00}}{\mathrm{\$950,000.00}}\times 100$$=\mathrm{4.21\%}$

2. Each year, take out that year's withdrawal at the start. It rises 2.4% a year to keep up with prices. Then what's left grows by 6%

   $\text{next balance}$$=\left(\text{balance}-\mathrm{\$40,000.00}\times {\left(1+0.024\right)}^{\text{k}}\right)\times \left(1+0.06\right)$

3. After 47 full years only $67,760.66 is left, less than that year's $121,943.30 withdrawal. So add the part of a year it covers

   $47+\frac{\mathrm{\$67,760.66}}{\mathrm{\$121,943.30}}$$=47.56\text{years}$

4. Round down to a tenth of a year, so the answer never promises too much. The money lasts

   $\text{money lasts}$$=\text{47.5 years}$

5. To find the most you could take for 28 years, divide your savings by the sum of qᵏ. Here q is (1 + inflation) ÷ (1 + return), how much each withdrawal grows compared with your money

   $\frac{\mathrm{\$950,000.00}}{18.254243}$$=\mathrm{\$52,042.70}$

7. Money lasts: 71.2 years

1. Start with your withdrawal rate: the first year's withdrawal as a percent of your savings

   $\frac{\mathrm{\$40,000.00}}{\mathrm{\$1,125,000.00}}\times 100$$=\mathrm{3.56\%}$

2. Each year, take out that year's withdrawal at the start. It rises 2.6% a year to keep up with prices. Then what's left grows by 6%

   $\text{next balance}$$=\left(\text{balance}-\mathrm{\$40,000.00}\times {\left(1+0.026\right)}^{\text{k}}\right)\times \left(1+0.06\right)$

3. After 71 full years only $71,859.18 is left, less than that year's $247,470.03 withdrawal. So add the part of a year it covers

   $71+\frac{\mathrm{\$71,859.18}}{\mathrm{\$247,470.03}}$$=71.29\text{years}$

4. Round down to a tenth of a year, so the answer never promises too much. The money lasts

   $\text{money lasts}$$=\text{71.2 years}$

5. To find the most you could take for 22 years, divide your savings by the sum of qᵏ. Here q is (1 + inflation) ÷ (1 + return), how much each withdrawal grows compared with your money

   $\frac{\mathrm{\$1,125,000.00}}{15.959092}$$=\mathrm{\$70,492.73}$

8. Money lasts: 35.2 years

1. Start with your withdrawal rate: the first year's withdrawal as a percent of your savings

   $\frac{\mathrm{\$40,000.00}}{\mathrm{\$975,000.00}}\times 100$$=\mathrm{4.1\%}$

2. Each year, take out that year's withdrawal at the start. It rises 2.6% a year to keep up with prices. Then what's left grows by 5%

   $\text{next balance}$$=\left(\text{balance}-\mathrm{\$40,000.00}\times {\left(1+0.026\right)}^{\text{k}}\right)\times \left(1+0.05\right)$

3. After 35 full years only $22,388.11 is left, less than that year's $98,224.00 withdrawal. So add the part of a year it covers

   $35+\frac{\mathrm{\$22,388.11}}{\mathrm{\$98,224.00}}$$=35.23\text{years}$

4. Round down to a tenth of a year, so the answer never promises too much. The money lasts

   $\text{money lasts}$$=\text{35.2 years}$

5. To find the most you could take for 30 years, divide your savings by the sum of qᵏ. Here q is (1 + inflation) ÷ (1 + return), how much each withdrawal grows compared with your money

   $\frac{\mathrm{\$975,000.00}}{21.886489}$$=\mathrm{\$44,548.03}$

9. Money lasts: 33.2 years

1. Start with your withdrawal rate: the first year's withdrawal as a percent of your savings

   $\frac{\mathrm{\$35,000.00}}{\mathrm{\$800,000.00}}\times 100$$=\mathrm{4.38\%}$

2. Each year, take out that year's withdrawal at the start. It rises 2.4% a year to keep up with prices. Then what's left grows by 5%

   $\text{next balance}$$=\left(\text{balance}-\mathrm{\$35,000.00}\times {\left(1+0.024\right)}^{\text{k}}\right)\times \left(1+0.05\right)$

3. After 33 full years only $22,331.03 is left, less than that year's $76,553.78 withdrawal. So add the part of a year it covers

   $33+\frac{\mathrm{\$22,331.03}}{\mathrm{\$76,553.78}}$$=33.29\text{years}$

4. Round down to a tenth of a year, so the answer never promises too much. The money lasts

   $\text{money lasts}$$=\text{33.2 years}$

5. To find the most you could take for 24 years, divide your savings by the sum of qᵏ. Here q is (1 + inflation) ÷ (1 + return), how much each withdrawal grows compared with your money

   $\frac{\mathrm{\$800,000.00}}{18.260204}$$=\mathrm{\$43,811.12}$

10. Money lasts: 20.4 years

1. Start with your withdrawal rate: the first year's withdrawal as a percent of your savings

   $\frac{\mathrm{\$50,000.00}}{\mathrm{\$900,000.00}}\times 100$$=\mathrm{5.56\%}$

2. Each year, take out that year's withdrawal at the start. It rises 2.6% a year to keep up with prices. Then what's left grows by 4%

   $\text{next balance}$$=\left(\text{balance}-\mathrm{\$50,000.00}\times {\left(1+0.026\right)}^{\text{k}}\right)\times \left(1+0.04\right)$

3. After 20 full years only $39,707.09 is left, less than that year's $83,544.38 withdrawal. So add the part of a year it covers

   $20+\frac{\mathrm{\$39,707.09}}{\mathrm{\$83,544.38}}$$=20.48\text{years}$

4. Round down to a tenth of a year, so the answer never promises too much. The money lasts

   $\text{money lasts}$$=\text{20.4 years}$

5. To find the most you could take for 37 years, divide your savings by the sum of qᵏ. Here q is (1 + inflation) ÷ (1 + return), how much each withdrawal grows compared with your money

   $\frac{\mathrm{\$900,000.00}}{29.294875}$$=\mathrm{\$30,722.10}$