ABCDEFGHIJKLMNOPQRSTUVWXY
1
2
Parameters to Edit
3
Expected Return Buy and Hold0.12
4
Expected Return Trading0.2
5
Short Term Tax Rate0.32
Most will be 22-24%
https://www.nerdwallet.com/article/taxes/capital-gains-tax-rates
6
Long Term Tax Rate0.2Most 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$112,000.00$ -1$100,000.00$120,000.00$4,960.00$2,560.00$2,400.00
13
2$112,000.00$125,440.00$ -2$115,040.00$138,048.00$5,705.98$2,945.02$2,760.96
14
3$125,440.00$140,492.80$ -3$132,342.02$158,810.42$6,564.16$3,387.96$3,176.21
15
4$140,492.80$157,351.94$ -4$152,246.26$182,695.51$7,551.41$3,897.50$3,653.91
16
5$157,351.94$176,234.17$ -5$175,144.09$210,172.91$8,687.15$4,483.69$4,203.46
17
6$176,234.17$197,382.27$ -6$201,485.76$241,782.92$9,993.69$5,158.04$4,835.66
18
7$197,382.27$221,068.14$ -7$231,789.22$278,147.07$11,496.75$5,933.80$5,562.94
19
8$221,068.14$247,596.32$ -8$266,650.32$319,980.39$13,225.86$6,826.25$6,399.61
20
9$247,596.32$277,307.88$ -9$306,754.53$368,105.44$15,215.02$7,852.92$7,362.11
21
10$277,307.88$310,584.82$ -10$352,890.41$423,468.49$17,503.36$9,033.99$8,469.37
22
11$310,584.82$347,855.00$ -11$405,965.13$487,158.15$20,135.87$10,392.71$9,743.16
23
12$347,855.00$389,597.60$ -12$467,022.28$560,426.74$23,164.31$11,955.77$11,208.53
24
13$389,597.60$436,349.31$ -13$537,262.44$644,714.92$26,648.22$13,753.92$12,894.30
25
14$436,349.31$488,711.23$ -14$618,066.71$741,680.05$30,656.11$15,822.51$14,833.60
26
15$488,711.23$547,356.58$ -15$711,023.94$853,228.73$35,266.79$18,202.21$17,064.57
27
16$547,356.58$613,039.37$ -16$817,961.94$981,554.33$40,570.91$20,939.83$19,631.09
28
17$613,039.37$686,604.09$ -17$940,983.41$1,129,180.10$46,672.78$24,089.18$22,583.60
29
18$686,604.09$768,996.58$ -18$1,082,507.32$1,299,008.78$53,692.36$27,712.19$25,980.18
30
19$768,996.58$861,276.17$ -19$1,245,316.42$1,494,379.70$61,767.69$31,880.10$29,887.59
31
20$861,276.17$964,629.31$ -20$1,432,612.01$1,719,134.41$71,057.56$36,674.87$34,382.69
32
21$964,629.31$1,080,384.83$ -21$1,648,076.86$1,977,692.23$81,744.61$42,190.77$39,553.84
33
22$1,080,384.83$1,210,031.01$ -22$1,895,947.62$2,275,137.14$94,039.00$48,536.26$45,502.74
34
23$1,210,031.01$1,355,234.73$ -23$2,181,098.14$2,617,317.76$108,182.47$55,836.11$52,346.36
35
24$1,355,234.73$1,517,862.89$ -24$2,509,135.30$3,010,962.36$124,453.11$64,233.86$60,219.25
36
25$1,517,862.89$1,700,006.44$ -25$2,886,509.25$3,463,811.09$143,170.86$73,894.64$69,276.22
37
26$1,700,006.44$1,904,007.21$ -26$3,320,640.24$3,984,768.28$164,703.76$85,008.39$79,695.37
38
27$1,904,007.21$2,132,488.08$ -27$3,820,064.53$4,584,077.43$189,475.20$97,793.65$91,681.55
39
28$2,132,488.08$2,388,386.65$ -28$4,394,602.23$5,273,522.68$217,972.27$112,501.82$105,470.45
40
29$2,388,386.65$2,674,993.05$ -29$5,055,550.41$6,066,660.49$250,755.30$129,422.09$121,333.21
41
30$2,674,993.05$2,995,992.21$579,198.4430$5,815,905.19$6,979,086.23$288,468.90$148,887.17$139,581.72
42
43
Final Balance$2,416,793.77Final Balance$6,690,617.33
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