RESP Investment v.0.2 Public
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABAC
1
Assuming you have 50k to invest when your child is born, how much will you or the child get when the child is 21?
2
Assumptions50k lump sum RESPMaximize grant and RESP balanceNo RESPMaximize Grant Only
3
Child ageGrowth ratesYear-end BalanceGrantContributionsEnd Year RESP Balance, avg.Year end Taxable acct balance, TAX PAIDGrantContributionYear end Taxable acct balance, TAX PAIDEnd Year RESP Balance, avg.Year end Taxable acct balance, TAX PAIDGrantContribution
4
06.00%53,530.00500.0050,000.0018,020.0035,108.00500.0016,500.0052,400.003,180.0049,780.00500.002,500.00
5
16.00%56,741.8022,281.2034,173.18500.002,500.0054,915.206,550.8049,549.44500.002,500.00
6
26.00%60,146.3126,798.0733,193.50500.002,500.0057,551.1310,123.8549,307.81500.002,500.00
7
36.00%63,755.0931,585.9632,166.78500.002,500.0060,313.5813,911.2849,054.59500.002,500.00
8
46.00%67,580.3936,661.1131,090.79500.002,500.0063,208.6417,925.9648,789.21500.002,500.00
9
56.00%71,635.2242,040.7829,963.15500.002,500.0066,242.6522,181.5148,511.09500.002,500.00
10
66.00%75,933.3347,743.2328,781.38500.002,500.0069,422.3026,692.4048,219.62500.002,500.00
11
76.00%80,489.3353,787.8227,542.89500.002,500.0072,754.5731,473.9547,914.16500.002,500.00
12
86.00%85,318.6960,195.0926,244.94500.002,500.0076,246.7936,542.3847,594.04500.002,500.00
13
96.00%90,437.8166,986.8024,884.70500.002,500.0079,906.6341,914.9347,258.56500.002,500.00
14
106.00%95,864.0874,186.0023,459.17500.002,500.0083,742.1547,609.8246,906.97500.002,500.00
15
115.00%100,657.2881,045.3021,965.21500.002,500.0087,091.8453,140.3146,538.50500.002,500.00
16
125.00%105,690.1588,247.5720,243.82500.002,500.0090,575.5158,947.3345,800.04500.002,500.00
17
135.00%110,974.6595,809.9518,453.57500.002,500.0094,198.5365,044.7045,032.05500.002,500.00
18
145.00%116,523.38101,860.4418,151.71200.001,000.0097,966.4769,556.9345,793.33200.001,000.00
19
155.00%122,349.55106,953.4718,877.78101,885.1373,034.7847,625.06
20
165.00%128,467.03112,301.1419,632.89105,960.5476,686.5249,530.06
21
174.00%133,605.71116,793.1920,418.21109,351.2779,753.9851,511.27
22
184.00%138,949.94121,464.9121,071.59112,850.5182,944.1453,159.63
23
193.00%143,118.44125,108.8621,745.88115,558.9385,432.4654,860.73
24
203.00%147,411.99128,862.1322,267.78118,332.3487,995.4456,177.39
25
213.00%151,834.35132,727.9922,802.21121,172.3290,635.3057,525.65
26
How is the investment growth paid out for each method?
27
AIP paid48,640.4936,253.440.0022,768.94
28
EAP paid80,449.1465,355.110.0043,161.89
29
Taxable acct paid0.0022,802.2171,172.3257,525.65
30
Paid to SubscriberOR48,640.4959,055.6471,172.3280,294.59
31
Paid to Beneficiary80,449.1488,157.3271,172.32100,687.54
32
Expected Value
(see assumptions)
74,087.4182,336.9871,172.3296,608.95
33
34
More Assumptions:
35
Subsrciber marginal rate32.00%
36
Avg investment growth tax (including capital gains, dividends, bonds)20.00%
37
Beneficiary marginal rate21.00%
38
Expected amount of EAP not needed20%
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
 
 
 
RESP Investments
 
 
Main menu