A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Investment vs Savings Calculator | ||||||||||||||
2 | To use the calculator please use "File" and "Save a Copy." This will save an editable copy to your Google Drive. Then change the bolded fields below to your values. The results will be shown below that in the area marked "Results." When you are done you can delete your copy as when you access it again from https://www.greenhelixfinancial.com/financial-tools you will always have the most up to date version. | ||||||||||||||
3 | |||||||||||||||
4 | Note: Please adjust the tax rate based on your situation. For example if held in a TFSA, reduce both rates to 0%. | ||||||||||||||
5 | |||||||||||||||
6 | Inputs | ||||||||||||||
7 | |||||||||||||||
8 | Initial Deposit | $50,000 | |||||||||||||
9 | Annual Contribution | $10,000 | |||||||||||||
10 | Years | 25 | |||||||||||||
11 | Inflation Rate | 2% | |||||||||||||
12 | |||||||||||||||
13 | Savings Account | ||||||||||||||
14 | |||||||||||||||
15 | Annual Interest Rate | 3% | |||||||||||||
16 | Tax Rate on Interest | 53.50% | |||||||||||||
17 | |||||||||||||||
18 | Investment Account | ||||||||||||||
19 | |||||||||||||||
20 | Average Investment Return | 8% | |||||||||||||
21 | Investment Fees | 1% | |||||||||||||
22 | Tax Rate on Capital Gains | 26.75% | |||||||||||||
23 | |||||||||||||||
24 | Results | ||||||||||||||
25 | |||||||||||||||
26 | Total Principal | $300,000 | |||||||||||||
27 | |||||||||||||||
28 | Total Savings Interest | $470,219 | |||||||||||||
29 | Total Savings After Inflation | $49,378 | |||||||||||||
30 | |||||||||||||||
31 | Total Investment Return | $648,136 | |||||||||||||
32 | Total Investment Return After Inflation | $370,452 | |||||||||||||
33 | |||||||||||||||
34 | Final Savings Amount | $480,219 | |||||||||||||
35 | Final Savings Amount After Tax | $223,302 | |||||||||||||
36 | |||||||||||||||
37 | Final Investment Amount | $948,136 | |||||||||||||
38 | Final Investment Amount After Tax | $694,510 | |||||||||||||
39 | |||||||||||||||
40 | |||||||||||||||
41 | |||||||||||||||
42 | |||||||||||||||
43 | |||||||||||||||
44 | |||||||||||||||
45 | |||||||||||||||
46 | |||||||||||||||
47 | |||||||||||||||
48 | |||||||||||||||
49 | |||||||||||||||
50 | |||||||||||||||
51 | |||||||||||||||
52 | |||||||||||||||
53 | |||||||||||||||
54 | |||||||||||||||
55 | |||||||||||||||
56 | Ready To Take The Next Step? | ||||||||||||||
57 | Your financial future starts with a conversation. Whether you have questions about investing, insurance, or long-term planning, we’re here to help. | ||||||||||||||
58 | |||||||||||||||
59 | Click to schedule a free investment and insurance review | ||||||||||||||
60 | |||||||||||||||
61 | Nominal Savings | Real Savings | Nominal Investment | Real Investment | |||||||||||
62 | Year | Contribution | Year End | Year | Contribution | Year End | Year | Contribution | Year End | Year | Contribution | Year End | |||
63 | 0 | $50,000 | 0 | $50,000 | 0 | $50,000 | 0 | $50,000 | |||||||
64 | 1 | $10,000 | $61,800 | 1 | $10,000 | $60,600 | 1 | $10,000 | $64,200 | 1 | $10,000 | $63,000 | |||
65 | 2 | $10,000 | $73,954 | 2 | $10,000 | $71,306 | 2 | $10,000 | $79,394 | 2 | $10,000 | $76,650 | |||
66 | 3 | $10,000 | $86,473 | 3 | $10,000 | $82,119 | 3 | $10,000 | $95,652 | 3 | $10,000 | $90,983 | |||
67 | 4 | $10,000 | $99,367 | 4 | $10,000 | $93,040 | 4 | $10,000 | $113,047 | 4 | $10,000 | $106,032 | |||
68 | 5 | $10,000 | $112,648 | 5 | $10,000 | $104,071 | 5 | $10,000 | $131,660 | 5 | $10,000 | $121,833 | |||
69 | 6 | $10,000 | $126,327 | 6 | $10,000 | $115,211 | 6 | $10,000 | $151,577 | 6 | $10,000 | $138,425 | |||
70 | 7 | $10,000 | $140,417 | 7 | $10,000 | $126,463 | 7 | $10,000 | $172,887 | 7 | $10,000 | $155,846 | |||
71 | 8 | $10,000 | $154,930 | 8 | $10,000 | $137,828 | 8 | $10,000 | $195,689 | 8 | $10,000 | $174,138 | |||
72 | 9 | $10,000 | $169,877 | 9 | $10,000 | $149,306 | 9 | $10,000 | $220,087 | 9 | $10,000 | $193,345 | |||
73 | 10 | $10,000 | $185,274 | 10 | $10,000 | $160,899 | 10 | $10,000 | $246,194 | 10 | $10,000 | $213,513 | |||
74 | 11 | $10,000 | $201,132 | 11 | $10,000 | $172,608 | 11 | $10,000 | $274,127 | 11 | $10,000 | $234,688 | |||
75 | 12 | $10,000 | $217,466 | 12 | $10,000 | $184,435 | 12 | $10,000 | $304,016 | 12 | $10,000 | $256,923 | |||
76 | 13 | $10,000 | $234,290 | 13 | $10,000 | $196,379 | 13 | $10,000 | $335,997 | 13 | $10,000 | $280,269 | |||
77 | 14 | $10,000 | $251,619 | 14 | $10,000 | $208,443 | 14 | $10,000 | $370,217 | 14 | $10,000 | $304,782 | |||
78 | 15 | $10,000 | $269,467 | 15 | $10,000 | $220,627 | 15 | $10,000 | $406,832 | 15 | $10,000 | $330,521 | |||
79 | 16 | $10,000 | $287,851 | 16 | $10,000 | $232,933 | 16 | $10,000 | $446,010 | 16 | $10,000 | $357,547 | |||
80 | 17 | $10,000 | $306,787 | 17 | $10,000 | $245,363 | 17 | $10,000 | $487,931 | 17 | $10,000 | $385,925 | |||
81 | 18 | $10,000 | $326,290 | 18 | $10,000 | $257,916 | 18 | $10,000 | $532,786 | 18 | $10,000 | $415,721 | |||
82 | 19 | $10,000 | $346,379 | 19 | $10,000 | $270,595 | 19 | $10,000 | $580,781 | 19 | $10,000 | $447,007 | |||
83 | 20 | $10,000 | $367,070 | 20 | $10,000 | $283,401 | 20 | $10,000 | $632,136 | 20 | $10,000 | $479,857 | |||
84 | 21 | $10,000 | $388,383 | 21 | $10,000 | $296,335 | 21 | $10,000 | $687,086 | 21 | $10,000 | $514,350 | |||
85 | 22 | $10,000 | $410,334 | 22 | $10,000 | $309,399 | 22 | $10,000 | $745,881 | 22 | $10,000 | $550,568 | |||
86 | 23 | $10,000 | $432,944 | 23 | $10,000 | $322,593 | 23 | $10,000 | $808,793 | 23 | $10,000 | $588,596 | |||
87 | 24 | $10,000 | $456,232 | 24 | $10,000 | $335,919 | 24 | $10,000 | $876,109 | 24 | $10,000 | $628,526 | |||
88 | 25 | $10,000 | $480,219 | 25 | $10,000 | $349,378 | 25 | $10,000 | $948,136 | 25 | $10,000 | $670,452 | |||
89 | |||||||||||||||
90 | |||||||||||||||
91 | |||||||||||||||
92 | |||||||||||||||
93 | |||||||||||||||
94 | |||||||||||||||
95 | |||||||||||||||
96 | |||||||||||||||
97 | |||||||||||||||
98 | |||||||||||||||
99 | |||||||||||||||
100 |