CCPC vs Personal with 25 years of Capital Gains
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABAC
1
Personal Taxation
2
Year12345678910111213141516171819202122232425
3
Earned Income250,000250,000250,000250,000250,000250,000250,000250,000250,000250,000250,000250,000250,000250,000250,000250,000250,000250,000250,000250,000250,000250,000250,000250,000250,000
4
5
6
Taxes on earned income
7
RateThreshold
8
Fed - Rate 1Exempt116350000000000000000000000000
9
Fed - Rate 215%459165,1425,1425,1425,1425,1425,1425,1425,1425,1425,1425,1425,1425,1425,1425,1425,1425,1425,1425,1425,1425,1425,1425,1425,1425,142
10
Fed - Rate 320.5%918319,4139,4139,4139,4139,4139,4139,4139,4139,4139,4139,4139,4139,4139,4139,4139,4139,4139,4139,4139,4139,4139,4139,4139,4139,413
11
Fed - Rate 426%14235313,13613,13613,13613,13613,13613,13613,13613,13613,13613,13613,13613,13613,13613,13613,13613,13613,13613,13613,13613,13613,13613,13613,13613,13613,136
12
Fed - Rate 529%20280017,53017,53017,53017,53017,53017,53017,53017,53017,53017,53017,53017,53017,53017,53017,53017,53017,53017,53017,53017,53017,53017,53017,53017,53017,530
13
Fed - Rate 633%9999999915,57615,57615,57615,57615,57615,57615,57615,57615,57615,57615,57615,57615,57615,57615,57615,57615,57615,57615,57615,57615,57615,57615,57615,57615,576
14
Total Fed Income Tax60,79660,79660,79660,79660,79660,79660,79660,79660,79660,79660,79660,79660,79660,79660,79660,79660,79660,79660,79660,79660,79660,79660,79660,79660,796
15
ON - Rate 1Exempt101710000000000000000000000000
16
ON - Rate 25%422011,6181,6181,6181,6181,6181,6181,6181,6181,6181,6181,6181,6181,6181,6181,6181,6181,6181,6181,6181,6181,6181,6181,6181,6181,618
17
ON - Rate 39.15%844043,8623,8623,8623,8623,8623,8623,8623,8623,8623,8623,8623,8623,8623,8623,8623,8623,8623,8623,8623,8623,8623,8623,8623,8623,862
18
ON - Rate 411.16%1500007,3217,3217,3217,3217,3217,3217,3217,3217,3217,3217,3217,3217,3217,3217,3217,3217,3217,3217,3217,3217,3217,3217,3217,3217,321
19
ON - Rate 512.16%2200008,5128,5128,5128,5128,5128,5128,5128,5128,5128,5128,5128,5128,5128,5128,5128,5128,5128,5128,5128,5128,5128,5128,5128,5128,512
20
ON - Rate 613.16%999999993,9483,9483,9483,9483,9483,9483,9483,9483,9483,9483,9483,9483,9483,9483,9483,9483,9483,9483,9483,9483,9483,9483,9483,9483,948
21
Total ON Income Tax (Basic)25,26025,26025,26025,26025,26025,26025,26025,26025,26025,26025,26025,26025,26025,26025,26025,26025,26025,26025,26025,26025,26025,26025,26025,26025,260
22
ON surtax 0Exempt45560000000000000000000000000
23
ON surtax 120%5831255255255255255255255255255255255255255255255255255255255255255255255255255
24
ON surtax 256%9999999910,88010,88010,88010,88010,88010,88010,88010,88010,88010,88010,88010,88010,88010,88010,88010,88010,88010,88010,88010,88010,88010,88010,88010,88010,880
25
Total ON Income Tax (Surtax)11,13511,13511,13511,13511,13511,13511,13511,13511,13511,13511,13511,13511,13511,13511,13511,13511,13511,13511,13511,13511,13511,13511,13511,13511,135
26
Total ON Income Tax (Basic+Surtax)36,39536,39536,39536,39536,39536,39536,39536,39536,39536,39536,39536,39536,39536,39536,39536,39536,39536,39536,39536,39536,39536,39536,39536,39536,395
27
Total Personal Income Taxes97,19197,19197,19197,19197,19197,19197,19197,19197,19197,19197,19197,19197,19197,19197,19197,19197,19197,19197,19197,19197,19197,19197,19197,19197,191
28
29
After-tax income152,809152,809152,809152,809152,809152,809152,809152,809152,809152,809152,809152,809152,809152,809152,809152,809152,809152,809152,809152,809152,809152,809152,809152,809152,809
30
Retained %61%61%61%61%61%61%61%61%61%61%61%61%61%61%61%61%61%61%61%61%61%61%61%61%61%
31
32
Required for living expenses100,000100,000100,000100,000100,000100,000100,000100,000100,000100,000100,000100,000100,000100,000100,000100,000100,000100,000100,000100,000100,000100,000100,000100,000100,000
33
Available for investment52,80952,80952,80952,80952,80952,80952,80952,80952,80952,80952,80952,80952,80952,80952,80952,80952,80952,80952,80952,80952,80952,80952,80952,80952,809
34
35
Invest after-tax income (for capgain)
36
Starting Principal52,809108,787168,124231,020297,691368,362443,273522,678606,848696,069790,642890,890997,1531,109,7911,229,1881,355,7481,489,9031,632,1061,782,8421,942,6212,111,9882,291,5172,481,8172,683,5352,897,357
37
Investment return6%3,1696,52710,08713,86117,86122,10226,59631,36136,41141,76447,43953,45359,82966,58773,75181,34589,39497,926106,971116,557126,719137,491148,909161,012173,841
38
Ending Principal55,978115,314178,211244,882315,552390,463469,869554,039643,259737,833838,081944,3431,056,9821,176,3781,302,9391,437,0931,579,2971,730,0321,889,8122,059,1792,238,7072,429,0082,630,7262,844,5473,071,198
39
40
Pre-tax nest-egg (Year 25)3,071,198
41
Capital gain1,750,965
42
Cap gain tax base (50%)875,483
43
Personal taxes on capital gain
44
Fed - Rate 1Exempt116350
45
Fed - Rate 215%459165,142
46
Fed - Rate 320.5%918319,413
47
Fed - Rate 426%14235313,136
48
Fed - Rate 529%20280017,530
49
Fed - Rate 633%99999999221,985
50
Total Fed Income Tax267,205
51
ON - Rate 1Exempt101710
52
ON - Rate 25%422011,618
53
ON - Rate 39.15%844043,862
54
ON - Rate 411.16%1500007,321
55
ON - Rate 512.16%2200008,512
56
ON - Rate 613.16%9999999986,262
57
Total ON Income Tax (Basic)107,573
58
ON surtax 0Exempt45560
59
ON surtax 120%5831255
60
ON surtax 256%9999999956,976
61
Total ON Income Tax (Surtax)57,231
62
Total ON Income Tax (Basic+Surtax)164,804
63
Total Personal Income Taxes on CapGain
432,009
64
65
66
AFTER-TAX NESTEGG (FV)
2,639,189
67
AFTER-TAX NESTEGG (PV)
1,260,491
68
Discount rate3%
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...