ABCDEFGHIJKLMNOPQRSTUVWXY
1
2
Parameters to Edit
3
Expected Return Buy and Hold0.12
4
Expected Return Trading0.22
5
Short Term Tax Rate0.37
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$112,000.00$ -1$100,000.00$122,000.00$5,236.00$3,256.00$1,980.00
13
2$112,000.00$125,440.00$ -2$116,764.00$142,452.08$6,113.76$3,801.84$2,311.93
14
3$125,440.00$140,492.80$ -3$136,338.32$166,332.75$7,138.67$4,439.18$2,699.50
15
4$140,492.80$157,351.94$ -4$159,194.07$194,216.77$8,335.40$5,183.36$3,152.04
16
5$157,351.94$176,234.17$ -5$185,881.37$226,775.27$9,732.75$6,052.30$3,680.45
17
6$176,234.17$197,382.27$ -6$217,042.52$264,791.87$11,364.35$7,066.90$4,297.44
18
7$197,382.27$221,068.14$ -7$253,427.53$309,181.58$13,269.47$8,251.60$5,017.87
19
8$221,068.14$247,596.32$ -8$295,912.12$361,012.78$15,493.96$9,634.90$5,859.06
20
9$247,596.32$277,307.88$ -9$345,518.82$421,532.97$18,091.37$11,250.09$6,841.27
21
10$277,307.88$310,584.82$ -10$403,441.60$492,198.75$21,124.20$13,136.06$7,988.14
22
11$310,584.82$347,855.00$ -11$471,074.55$574,710.95$24,665.46$15,338.19$9,327.28
23
12$347,855.00$389,597.60$ -12$550,045.49$671,055.50$28,800.38$17,909.48$10,890.90
24
13$389,597.60$436,349.31$ -13$642,255.11$783,551.24$33,628.48$20,911.83$12,716.65
25
14$436,349.31$488,711.23$ -14$749,922.76$914,905.77$39,265.96$24,417.49$14,848.47
26
15$488,711.23$547,356.58$ -15$875,639.81$1,068,280.57$45,848.50$28,510.83$17,337.67
27
16$547,356.58$613,039.37$ -16$1,022,432.07$1,247,367.13$53,534.54$33,290.39$20,244.16
28
17$613,039.37$686,604.09$ -17$1,193,832.58$1,456,475.75$62,509.07$38,871.19$23,637.89
29
18$686,604.09$768,996.58$ -18$1,393,966.68$1,700,639.35$72,988.10$45,387.56$27,600.54
30
19$768,996.58$861,276.17$ -19$1,627,651.25$1,985,734.53$85,223.82$52,996.32$32,227.49
31
20$861,276.17$964,629.31$ -20$1,900,510.71$2,318,623.06$99,510.74$61,880.63$37,630.11
32
21$964,629.31$1,080,384.83$ -21$2,219,112.32$2,707,317.03$116,192.72$72,254.30$43,938.42
33
22$1,080,384.83$1,210,031.01$ -22$2,591,124.31$3,161,171.66$135,671.27$84,367.01$51,304.26
34
23$1,210,031.01$1,355,234.73$ -23$3,025,500.39$3,691,110.48$158,415.20$98,510.29$59,904.91
35
24$1,355,234.73$1,517,862.89$ -24$3,532,695.28$4,309,888.24$184,971.92$115,024.56$69,947.37
36
25$1,517,862.89$1,700,006.44$ -25$4,124,916.31$5,032,397.90$215,980.62$134,307.28$81,673.34
37
26$1,700,006.44$1,904,007.21$ -26$4,816,417.29$5,876,029.09$252,187.61$156,822.55$95,365.06
38
27$1,904,007.21$2,132,488.08$ -27$5,623,841.48$6,861,086.61$294,464.34$183,112.28$111,352.06
39
28$2,132,488.08$2,388,386.65$ -28$6,566,622.27$8,011,279.16$343,828.34$213,809.22$130,019.12
40
29$2,388,386.65$2,674,993.05$ -29$7,667,450.82$9,354,290.00$401,467.73$249,652.20$151,815.53
41
30$2,674,993.05$2,995,992.21$434,398.8330$8,952,822.28$10,922,443.18$468,769.77$291,503.89$177,265.88
42
43
Final Balance$2,561,593.38Final Balance$10,453,673.40
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