Skip to the useful part
SavingsCalculator.ca A LONGER VIEW, WITH ROOM FOR WHAT-IFS

Retirement savings and withdrawal worksheet

Explore accumulation, constant-return withdrawals, annual inflation and the first modelled shortfall.

The savings pot through withdrawalsCAD · illustrative
$0$96,929$193,858$290,787$387,7160 mo90 mo180 mo270 mo360 mo

Inspect monthly withdrawals
MonthInterestRequested withdrawalActual withdrawalRemaining
1$1,269.28$1,500.00$1,500.00$387,485.03
2$1,268.53$1,500.00$1,500.00$387,253.56
3$1,267.77$1,500.00$1,500.00$387,021.33
4$1,267.01$1,500.00$1,500.00$386,788.34
5$1,266.24$1,500.00$1,500.00$386,554.58
6$1,265.48$1,500.00$1,500.00$386,320.06
7$1,264.71$1,500.00$1,500.00$386,084.77
8$1,263.94$1,500.00$1,500.00$385,848.71
9$1,263.17$1,500.00$1,500.00$385,611.88
10$1,262.39$1,500.00$1,500.00$385,374.27
11$1,261.62$1,500.00$1,500.00$385,135.89
12$1,260.83$1,500.00$1,500.00$384,896.72
13$1,260.05$1,530.00$1,530.00$384,626.77
14$1,259.17$1,530.00$1,530.00$384,355.94
15$1,258.28$1,530.00$1,530.00$384,084.22
16$1,257.39$1,530.00$1,530.00$383,811.61
17$1,256.50$1,530.00$1,530.00$383,538.11
18$1,255.60$1,530.00$1,530.00$383,263.71
19$1,254.71$1,530.00$1,530.00$382,988.42
20$1,253.80$1,530.00$1,530.00$382,712.22
21$1,252.90$1,530.00$1,530.00$382,435.12
22$1,251.99$1,530.00$1,530.00$382,157.11
23$1,251.08$1,530.00$1,530.00$381,878.19
24$1,250.17$1,530.00$1,530.00$381,598.36
25$1,249.25$1,560.60$1,560.60$381,287.01
26$1,248.23$1,560.60$1,560.60$380,974.64
27$1,247.21$1,560.60$1,560.60$380,661.25
28$1,246.19$1,560.60$1,560.60$380,346.84
29$1,245.16$1,560.60$1,560.60$380,031.40
30$1,244.12$1,560.60$1,560.60$379,714.92
31$1,243.09$1,560.60$1,560.60$379,397.41
32$1,242.05$1,560.60$1,560.60$379,078.86
33$1,241.01$1,560.60$1,560.60$378,759.27
34$1,239.96$1,560.60$1,560.60$378,438.63
35$1,238.91$1,560.60$1,560.60$378,116.94
36$1,237.86$1,560.60$1,560.60$377,794.20
37$1,236.80$1,591.81$1,591.81$377,439.19
38$1,235.64$1,591.81$1,591.81$377,083.02
39$1,234.47$1,591.81$1,591.81$376,725.68
40$1,233.30$1,591.81$1,591.81$376,367.17
41$1,232.13$1,591.81$1,591.81$376,007.49
42$1,230.95$1,591.81$1,591.81$375,646.63
43$1,229.77$1,591.81$1,591.81$375,284.59
44$1,228.58$1,591.81$1,591.81$374,921.36
45$1,227.39$1,591.81$1,591.81$374,556.94
46$1,226.20$1,591.81$1,591.81$374,191.33
47$1,225.01$1,591.81$1,591.81$373,824.53
48$1,223.80$1,591.81$1,591.81$373,456.52
49$1,222.60$1,623.65$1,623.65$373,055.47
50$1,221.29$1,623.65$1,623.65$372,653.11
51$1,219.97$1,623.65$1,623.65$372,249.43
52$1,218.65$1,623.65$1,623.65$371,844.43
53$1,217.32$1,623.65$1,623.65$371,438.10
54$1,215.99$1,623.65$1,623.65$371,030.44
55$1,214.66$1,623.65$1,623.65$370,621.45
56$1,213.32$1,623.65$1,623.65$370,211.12
57$1,211.97$1,623.65$1,623.65$369,799.44
58$1,210.63$1,623.65$1,623.65$369,386.42
59$1,209.28$1,623.65$1,623.65$368,972.05
60$1,207.92$1,623.65$1,623.65$368,556.32
61$1,206.56$1,656.12$1,656.12$368,106.76
62$1,205.09$1,656.12$1,656.12$367,655.73
63$1,203.61$1,656.12$1,656.12$367,203.22
64$1,202.13$1,656.12$1,656.12$366,749.23
65$1,200.64$1,656.12$1,656.12$366,293.75
66$1,199.15$1,656.12$1,656.12$365,836.78
67$1,197.65$1,656.12$1,656.12$365,378.31
68$1,196.15$1,656.12$1,656.12$364,918.34
69$1,194.65$1,656.12$1,656.12$364,456.87
70$1,193.14$1,656.12$1,656.12$363,993.89
71$1,191.62$1,656.12$1,656.12$363,529.39
72$1,190.10$1,656.12$1,656.12$363,063.37
73$1,188.57$1,689.24$1,689.24$362,562.70
74$1,186.94$1,689.24$1,689.24$362,060.40
75$1,185.29$1,689.24$1,689.24$361,556.45
76$1,183.64$1,689.24$1,689.24$361,050.85
77$1,181.99$1,689.24$1,689.24$360,543.60
78$1,180.33$1,689.24$1,689.24$360,034.69
79$1,178.66$1,689.24$1,689.24$359,524.11
80$1,176.99$1,689.24$1,689.24$359,011.86
81$1,175.31$1,689.24$1,689.24$358,497.93
82$1,173.63$1,689.24$1,689.24$357,982.32
83$1,171.94$1,689.24$1,689.24$357,465.02
84$1,170.25$1,689.24$1,689.24$356,946.03
85$1,168.55$1,723.03$1,723.03$356,391.55
86$1,166.73$1,723.03$1,723.03$355,835.25
87$1,164.91$1,723.03$1,723.03$355,277.13
88$1,163.08$1,723.03$1,723.03$354,717.18
89$1,161.25$1,723.03$1,723.03$354,155.40
90$1,159.41$1,723.03$1,723.03$353,591.78
91$1,157.57$1,723.03$1,723.03$353,026.32
92$1,155.72$1,723.03$1,723.03$352,459.01
93$1,153.86$1,723.03$1,723.03$351,889.84
94$1,152.00$1,723.03$1,723.03$351,318.81
95$1,150.13$1,723.03$1,723.03$350,745.91
96$1,148.25$1,723.03$1,723.03$350,171.13
97$1,146.37$1,757.49$1,757.49$349,560.01
98$1,144.37$1,757.49$1,757.49$348,946.89
99$1,142.36$1,757.49$1,757.49$348,331.76
100$1,140.35$1,757.49$1,757.49$347,714.62
101$1,138.33$1,757.49$1,757.49$347,095.46
102$1,136.30$1,757.49$1,757.49$346,474.27
103$1,134.27$1,757.49$1,757.49$345,851.05
104$1,132.23$1,757.49$1,757.49$345,225.79
105$1,130.18$1,757.49$1,757.49$344,598.48
106$1,128.13$1,757.49$1,757.49$343,969.12
107$1,126.07$1,757.49$1,757.49$343,337.70
108$1,124.00$1,757.49$1,757.49$342,704.21
109$1,121.92$1,792.64$1,792.64$342,033.49
110$1,119.73$1,792.64$1,792.64$341,360.58
111$1,117.53$1,792.64$1,792.64$340,685.47
112$1,115.32$1,792.64$1,792.64$340,008.15
113$1,113.10$1,792.64$1,792.64$339,328.61
114$1,110.87$1,792.64$1,792.64$338,646.84
115$1,108.64$1,792.64$1,792.64$337,962.84
116$1,106.40$1,792.64$1,792.64$337,276.60
117$1,104.16$1,792.64$1,792.64$336,588.12
118$1,101.90$1,792.64$1,792.64$335,897.38
119$1,099.64$1,792.64$1,792.64$335,204.38
120$1,097.37$1,792.64$1,792.64$334,509.11
121$1,095.10$1,828.49$1,828.49$333,775.72
122$1,092.69$1,828.49$1,828.49$333,039.92
123$1,090.29$1,828.49$1,828.49$332,301.72
124$1,087.87$1,828.49$1,828.49$331,561.10
125$1,085.44$1,828.49$1,828.49$330,818.05
126$1,083.01$1,828.49$1,828.49$330,072.57
127$1,080.57$1,828.49$1,828.49$329,324.65
128$1,078.12$1,828.49$1,828.49$328,574.28
129$1,075.67$1,828.49$1,828.49$327,821.46
130$1,073.20$1,828.49$1,828.49$327,066.17
131$1,070.73$1,828.49$1,828.49$326,308.41
132$1,068.25$1,828.49$1,828.49$325,548.17
133$1,065.76$1,865.06$1,865.06$324,748.87
134$1,063.14$1,865.06$1,865.06$323,946.95
135$1,060.52$1,865.06$1,865.06$323,142.41
136$1,057.88$1,865.06$1,865.06$322,335.23
137$1,055.24$1,865.06$1,865.06$321,525.41
138$1,052.59$1,865.06$1,865.06$320,712.94
139$1,049.93$1,865.06$1,865.06$319,897.81
140$1,047.26$1,865.06$1,865.06$319,080.01
141$1,044.58$1,865.06$1,865.06$318,259.53
142$1,041.90$1,865.06$1,865.06$317,436.37
143$1,039.20$1,865.06$1,865.06$316,610.51
144$1,036.50$1,865.06$1,865.06$315,781.95
145$1,033.79$1,902.36$1,902.36$314,913.38
146$1,030.94$1,902.36$1,902.36$314,041.96
147$1,028.09$1,902.36$1,902.36$313,167.69
148$1,025.23$1,902.36$1,902.36$312,290.56
149$1,022.36$1,902.36$1,902.36$311,410.56
150$1,019.48$1,902.36$1,902.36$310,527.68
151$1,016.59$1,902.36$1,902.36$309,641.91
152$1,013.69$1,902.36$1,902.36$308,753.24
153$1,010.78$1,902.36$1,902.36$307,861.66
154$1,007.86$1,902.36$1,902.36$306,967.16
155$1,004.93$1,902.36$1,902.36$306,069.73
156$1,001.99$1,902.36$1,902.36$305,169.36
157$999.05$1,940.41$1,940.41$304,228.00
158$995.96$1,940.41$1,940.41$303,283.55
159$992.87$1,940.41$1,940.41$302,336.01
160$989.77$1,940.41$1,940.41$301,385.37
161$986.66$1,940.41$1,940.41$300,431.62
162$983.53$1,940.41$1,940.41$299,474.74
163$980.40$1,940.41$1,940.41$298,514.73
164$977.26$1,940.41$1,940.41$297,551.58
165$974.11$1,940.41$1,940.41$296,585.28
166$970.94$1,940.41$1,940.41$295,615.81
167$967.77$1,940.41$1,940.41$294,643.17
168$964.59$1,940.41$1,940.41$293,667.35
169$961.39$1,979.22$1,979.22$292,649.52
170$958.06$1,979.22$1,979.22$291,628.36
171$954.72$1,979.22$1,979.22$290,603.86
172$951.36$1,979.22$1,979.22$289,576.00
173$948.00$1,979.22$1,979.22$288,544.78
174$944.62$1,979.22$1,979.22$287,510.18
175$941.23$1,979.22$1,979.22$286,472.19
176$937.84$1,979.22$1,979.22$285,430.81
177$934.43$1,979.22$1,979.22$284,386.02
178$931.01$1,979.22$1,979.22$283,337.81
179$927.57$1,979.22$1,979.22$282,286.16
180$924.13$1,979.22$1,979.22$281,231.07
181$920.68$2,018.80$2,018.80$280,132.95
182$917.08$2,018.80$2,018.80$279,031.23
183$913.48$2,018.80$2,018.80$277,925.91
184$909.86$2,018.80$2,018.80$276,816.97
185$906.23$2,018.80$2,018.80$275,704.40
186$902.58$2,018.80$2,018.80$274,588.18
187$898.93$2,018.80$2,018.80$273,468.31
188$895.26$2,018.80$2,018.80$272,344.77
189$891.59$2,018.80$2,018.80$271,217.56
190$887.90$2,018.80$2,018.80$270,086.66
191$884.19$2,018.80$2,018.80$268,952.05
192$880.48$2,018.80$2,018.80$267,813.73
193$876.75$2,059.18$2,059.18$266,631.30
194$872.88$2,059.18$2,059.18$265,445.00
195$869.00$2,059.18$2,059.18$264,254.82
196$865.10$2,059.18$2,059.18$263,060.74
197$861.19$2,059.18$2,059.18$261,862.75
198$857.27$2,059.18$2,059.18$260,660.84
199$853.34$2,059.18$2,059.18$259,455.00
200$849.39$2,059.18$2,059.18$258,245.21
201$845.43$2,059.18$2,059.18$257,031.46
202$841.45$2,059.18$2,059.18$255,813.73
203$837.47$2,059.18$2,059.18$254,592.02
204$833.47$2,059.18$2,059.18$253,366.31
205$829.46$2,100.36$2,100.36$252,095.41
206$825.29$2,100.36$2,100.36$250,820.34
207$821.12$2,100.36$2,100.36$249,541.10
208$816.93$2,100.36$2,100.36$248,257.67
209$812.73$2,100.36$2,100.36$246,970.04
210$808.52$2,100.36$2,100.36$245,678.20
211$804.29$2,100.36$2,100.36$244,382.13
212$800.04$2,100.36$2,100.36$243,081.81
213$795.79$2,100.36$2,100.36$241,777.24
214$791.52$2,100.36$2,100.36$240,468.40
215$787.23$2,100.36$2,100.36$239,155.27
216$782.93$2,100.36$2,100.36$237,837.84
217$778.62$2,142.37$2,142.37$236,474.09
218$774.15$2,142.37$2,142.37$235,105.87
219$769.68$2,142.37$2,142.37$233,733.18
220$765.18$2,142.37$2,142.37$232,355.99
221$760.67$2,142.37$2,142.37$230,974.29
222$756.15$2,142.37$2,142.37$229,588.07
223$751.61$2,142.37$2,142.37$228,197.31
224$747.06$2,142.37$2,142.37$226,802.00
225$742.49$2,142.37$2,142.37$225,402.12
226$737.91$2,142.37$2,142.37$223,997.66
227$733.31$2,142.37$2,142.37$222,588.60
228$728.70$2,142.37$2,142.37$221,174.93
229$724.07$2,185.22$2,185.22$219,713.78
230$719.29$2,185.22$2,185.22$218,247.85
231$714.49$2,185.22$2,185.22$216,777.12
232$709.67$2,185.22$2,185.22$215,301.57
233$704.84$2,185.22$2,185.22$213,821.19
234$699.99$2,185.22$2,185.22$212,335.96
235$695.13$2,185.22$2,185.22$210,845.87
236$690.25$2,185.22$2,185.22$209,350.90
237$685.36$2,185.22$2,185.22$207,851.04
238$680.45$2,185.22$2,185.22$206,346.27
239$675.52$2,185.22$2,185.22$204,836.57
240$670.58$2,185.22$2,185.22$203,321.93
241$665.62$2,228.92$2,228.92$201,758.63
242$660.51$2,228.92$2,228.92$200,190.22
243$655.37$2,228.92$2,228.92$198,616.67
244$650.22$2,228.92$2,228.92$197,037.97
245$645.05$2,228.92$2,228.92$195,454.10
246$639.87$2,228.92$2,228.92$193,865.05
247$634.66$2,228.92$2,228.92$192,270.79
248$629.44$2,228.92$2,228.92$190,671.31
249$624.21$2,228.92$2,228.92$189,066.60
250$618.95$2,228.92$2,228.92$187,456.63
251$613.68$2,228.92$2,228.92$185,841.39
252$608.40$2,228.92$2,228.92$184,220.87
253$603.09$2,273.50$2,273.50$182,550.46
254$597.62$2,273.50$2,273.50$180,874.58
255$592.14$2,273.50$2,273.50$179,193.22
256$586.63$2,273.50$2,273.50$177,506.35
257$581.11$2,273.50$2,273.50$175,813.96
258$575.57$2,273.50$2,273.50$174,116.03
259$570.01$2,273.50$2,273.50$172,412.54
260$564.43$2,273.50$2,273.50$170,703.47
261$558.84$2,273.50$2,273.50$168,988.81
262$553.23$2,273.50$2,273.50$167,268.54
263$547.59$2,273.50$2,273.50$165,542.63
264$541.94$2,273.50$2,273.50$163,811.07
265$536.27$2,318.97$2,318.97$162,028.37
266$530.44$2,318.97$2,318.97$160,239.84
267$524.58$2,318.97$2,318.97$158,445.45
268$518.71$2,318.97$2,318.97$156,645.19
269$512.82$2,318.97$2,318.97$154,839.04
270$506.90$2,318.97$2,318.97$153,026.97
271$500.97$2,318.97$2,318.97$151,208.97
272$495.02$2,318.97$2,318.97$149,385.02
273$489.05$2,318.97$2,318.97$147,555.10
274$483.06$2,318.97$2,318.97$145,719.19
275$477.05$2,318.97$2,318.97$143,877.27
276$471.02$2,318.97$2,318.97$142,029.32
277$464.97$2,365.35$2,365.35$140,128.94
278$458.75$2,365.35$2,365.35$138,222.34
279$452.50$2,365.35$2,365.35$136,309.49
280$446.24$2,365.35$2,365.35$134,390.38
281$439.96$2,365.35$2,365.35$132,464.99
282$433.66$2,365.35$2,365.35$130,533.30
283$427.33$2,365.35$2,365.35$128,595.28
284$420.99$2,365.35$2,365.35$126,650.92
285$414.62$2,365.35$2,365.35$124,700.19
286$408.24$2,365.35$2,365.35$122,743.08
287$401.83$2,365.35$2,365.35$120,779.56
288$395.40$2,365.35$2,365.35$118,809.61
289$388.95$2,412.66$2,412.66$116,785.90
290$382.33$2,412.66$2,412.66$114,755.57
291$375.68$2,412.66$2,412.66$112,718.59
292$369.01$2,412.66$2,412.66$110,674.94
293$362.32$2,412.66$2,412.66$108,624.60
294$355.61$2,412.66$2,412.66$106,567.55
295$348.87$2,412.66$2,412.66$104,503.76
296$342.12$2,412.66$2,412.66$102,433.22
297$335.34$2,412.66$2,412.66$100,355.90
298$328.54$2,412.66$2,412.66$98,271.78
299$321.72$2,412.66$2,412.66$96,180.84
300$314.87$2,412.66$2,412.66$94,083.05
301$308.00$2,460.91$2,460.91$91,930.14
302$300.96$2,460.91$2,460.91$89,770.19
303$293.88$2,460.91$2,460.91$87,603.16
304$286.79$2,460.91$2,460.91$85,429.04
305$279.67$2,460.91$2,460.91$83,247.80
306$272.53$2,460.91$2,460.91$81,059.42
307$265.37$2,460.91$2,460.91$78,863.88
308$258.18$2,460.91$2,460.91$76,661.15
309$250.97$2,460.91$2,460.91$74,451.21
310$243.73$2,460.91$2,460.91$72,234.03
311$236.48$2,460.91$2,460.91$70,009.60
312$229.19$2,460.91$2,460.91$67,777.88
313$221.89$2,510.13$2,510.13$65,489.64
314$214.40$2,510.13$2,510.13$63,193.91
315$206.88$2,510.13$2,510.13$60,890.66
316$199.34$2,510.13$2,510.13$58,579.87
317$191.78$2,510.13$2,510.13$56,261.52
318$184.19$2,510.13$2,510.13$53,935.58
319$176.57$2,510.13$2,510.13$51,602.02
320$168.93$2,510.13$2,510.13$49,260.82
321$161.27$2,510.13$2,510.13$46,911.96
322$153.58$2,510.13$2,510.13$44,555.41
323$145.86$2,510.13$2,510.13$42,191.14
324$138.12$2,510.13$2,510.13$39,819.13
325$130.36$2,560.33$2,560.33$37,389.16
326$122.40$2,560.33$2,560.33$34,951.23
327$114.42$2,560.33$2,560.33$32,505.32
328$106.41$2,560.33$2,560.33$30,051.40
329$98.38$2,560.33$2,560.33$27,589.45
330$90.32$2,560.33$2,560.33$25,119.44
331$82.23$2,560.33$2,560.33$22,641.34
332$74.12$2,560.33$2,560.33$20,155.13
333$65.98$2,560.33$2,560.33$17,660.78
334$57.82$2,560.33$2,560.33$15,158.27
335$49.62$2,560.33$2,560.33$12,647.56
336$41.40$2,560.33$2,560.33$10,128.63
337$33.16$2,611.54$2,611.54$7,550.25
338$24.72$2,611.54$2,611.54$4,963.43
339$16.25$2,611.54$2,611.54$2,368.14
340$7.75$2,611.54$2,375.89$0.00
341$0.00$2,611.54$0.00$0.00
342$0.00$2,611.54$0.00$0.00
343$0.00$2,611.54$0.00$0.00
344$0.00$2,611.54$0.00$0.00
345$0.00$2,611.54$0.00$0.00
346$0.00$2,611.54$0.00$0.00
347$0.00$2,611.54$0.00$0.00
348$0.00$2,611.54$0.00$0.00
349$0.00$2,663.77$0.00$0.00
350$0.00$2,663.77$0.00$0.00
351$0.00$2,663.77$0.00$0.00
352$0.00$2,663.77$0.00$0.00
353$0.00$2,663.77$0.00$0.00
354$0.00$2,663.77$0.00$0.00
355$0.00$2,663.77$0.00$0.00
356$0.00$2,663.77$0.00$0.00
357$0.00$2,663.77$0.00$0.00
358$0.00$2,663.77$0.00$0.00
359$0.00$2,663.77$0.00$0.00
360$0.00$2,663.77$0.00$0.00
Real retirement needs more than a steady line
This does not model market losses, sequence risk, changing asset allocations, tax on withdrawals, management fees, pension entitlements or minimum RRIF withdrawals. The accumulation uses annual compounding converted to monthly growth. Review the assumptions with a qualified planner before making a retirement decision.