ABCDEFGHIJKLMNOPQRSTUVWXY
1
2
Parameters to Edit
3
Expected Return Buy and Hold0.05
4
Expected Return Trading0.07
5
Short Term Tax Rate0.25
Most will be 22-24%
https://www.nerdwallet.com/article/taxes/capital-gains-tax-rates
6
Long Term Tax Rate0.15Most will be 15%
7
8
9
Buy and Hold, Taxes Deferred Until the EndActive Trading 1256 Contracts, Taxes Realized Annually
10
Tax Breakdown
11
YearStarting BalanceEnding BalanceTax PaidYearStarting BalanceEnding BalanceTax PaidShort TermLong Term
12
1$100,000.00$105,000.00$ -1$100,000.00$107,000.00$1,330.00$700.00$630.00
13
2$105,000.00$110,250.00$ -2$105,670.00$113,066.90$1,405.41$739.69$665.72
14
3$110,250.00$115,762.50$ -3$111,661.49$119,477.79$1,485.10$781.63$703.47
15
4$115,762.50$121,550.63$ -4$117,992.70$126,252.18$1,569.30$825.95$743.35
16
5$121,550.63$127,628.16$ -5$124,682.88$133,410.68$1,658.28$872.78$785.50
17
6$127,628.16$134,009.56$ -6$131,752.40$140,975.07$1,752.31$922.27$830.04
18
7$134,009.56$140,710.04$ -7$139,222.76$148,968.36$1,851.66$974.56$877.10
19
8$140,710.04$147,745.54$ -8$147,116.69$157,414.86$1,956.65$1,029.82$926.84
20
9$147,745.54$155,132.82$ -9$155,458.21$166,340.28$2,067.59$1,088.21$979.39
21
10$155,132.82$162,889.46$ -10$164,272.69$175,771.78$2,184.83$1,149.91$1,034.92
22
11$162,889.46$171,033.94$ -11$173,586.95$185,738.04$2,308.71$1,215.11$1,093.60
23
12$171,033.94$179,585.63$ -12$183,429.33$196,269.38$2,439.61$1,284.01$1,155.60
24
13$179,585.63$188,564.91$ -13$193,829.77$207,397.86$2,577.94$1,356.81$1,221.13
25
14$188,564.91$197,993.16$ -14$204,819.92$219,157.32$2,724.10$1,433.74$1,290.37
26
15$197,993.16$207,892.82$ -15$216,433.21$231,583.54$2,878.56$1,515.03$1,363.53
27
16$207,892.82$218,287.46$ -16$228,704.97$244,714.32$3,041.78$1,600.93$1,440.84
28
17$218,287.46$229,201.83$ -17$241,672.55$258,589.63$3,214.24$1,691.71$1,522.54
29
18$229,201.83$240,661.92$ -18$255,375.38$273,251.66$3,396.49$1,787.63$1,608.86
30
19$240,661.92$252,695.02$ -19$269,855.16$288,745.03$3,589.07$1,888.99$1,700.09
31
20$252,695.02$265,329.77$ -20$285,155.95$305,116.87$3,792.57$1,996.09$1,796.48
32
21$265,329.77$278,596.26$ -21$301,324.29$322,417.00$4,007.61$2,109.27$1,898.34
33
22$278,596.26$292,526.07$ -22$318,409.38$340,698.04$4,234.84$2,228.87$2,005.98
34
23$292,526.07$307,152.38$ -23$336,463.19$360,015.62$4,474.96$2,355.24$2,119.72
35
24$307,152.38$322,509.99$ -24$355,540.66$380,428.50$4,728.69$2,488.78$2,239.91
36
25$322,509.99$338,635.49$ -25$375,699.81$401,998.80$4,996.81$2,629.90$2,366.91
37
26$338,635.49$355,567.27$ -26$397,001.99$424,792.13$5,280.13$2,779.01$2,501.11
38
27$355,567.27$373,345.63$ -27$419,512.00$448,877.84$5,579.51$2,936.58$2,642.93
39
28$373,345.63$392,012.91$ -28$443,298.34$474,329.22$5,895.87$3,103.09$2,792.78
40
29$392,012.91$411,613.56$ -29$468,433.35$501,223.69$6,230.16$3,279.03$2,951.13
41
30$411,613.56$432,194.24$49,829.1430$494,993.52$529,643.07$6,583.41$3,464.95$3,118.46
42
43
Final Balance$382,365.10Final Balance$523,059.65
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