ABCDEFGHIJKLMNOPQRSTUVWXY
1
2
Parameters to Edit
3
Expected Return Buy and Hold0.12
4
Expected Return Trading0.15
5
Short Term Tax Rate0.24
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$115,000.00$2,790.00$1,440.00$1,350.00
13
2$112,000.00$125,440.00$ -2$112,210.00$129,041.50$3,130.66$1,615.82$1,514.84
14
3$125,440.00$140,492.80$ -3$125,910.84$144,797.47$3,512.91$1,813.12$1,699.80
15
4$140,492.80$157,351.94$ -4$141,284.55$162,477.24$3,941.84$2,034.50$1,907.34
16
5$157,351.94$176,234.17$ -5$158,535.40$182,315.71$4,423.14$2,282.91$2,140.23
17
6$176,234.17$197,382.27$ -6$177,892.57$204,576.46$4,963.20$2,561.65$2,401.55
18
7$197,382.27$221,068.14$ -7$199,613.25$229,555.24$5,569.21$2,874.43$2,694.78
19
8$221,068.14$247,596.32$ -8$223,986.03$257,583.94$6,249.21$3,225.40$3,023.81
20
9$247,596.32$277,307.88$ -9$251,334.73$289,034.94$7,012.24$3,619.22$3,393.02
21
10$277,307.88$310,584.82$ -10$282,022.70$324,326.10$7,868.43$4,061.13$3,807.31
22
11$310,584.82$347,855.00$ -11$316,457.67$363,926.32$8,829.17$4,556.99$4,272.18
23
12$347,855.00$389,597.60$ -12$355,097.15$408,361.72$9,907.21$5,113.40$4,793.81
24
13$389,597.60$436,349.31$ -13$398,454.51$458,222.69$11,116.88$5,737.74$5,379.14
25
14$436,349.31$488,711.23$ -14$447,105.81$514,171.68$12,474.25$6,438.32$6,035.93
26
15$488,711.23$547,356.58$ -15$501,697.43$576,952.04$13,997.36$7,224.44$6,772.92
27
16$547,356.58$613,039.37$ -16$562,954.68$647,397.88$15,706.44$8,106.55$7,599.89
28
17$613,039.37$686,604.09$ -17$631,691.45$726,445.17$17,624.19$9,096.36$8,527.83
29
18$686,604.09$768,996.58$ -18$708,820.97$815,144.12$19,776.11$10,207.02$9,569.08
30
19$768,996.58$861,276.17$ -19$795,368.02$914,673.22$22,190.77$11,453.30$10,737.47
31
20$861,276.17$964,629.31$ -20$892,482.45$1,026,354.82$24,900.26$12,851.75$12,048.51
32
21$964,629.31$1,080,384.83$ -21$1,001,454.56$1,151,672.74$27,940.58$14,420.95$13,519.64
33
22$1,080,384.83$1,210,031.01$ -22$1,123,732.16$1,292,291.98$31,352.13$16,181.74$15,170.38
34
23$1,210,031.01$1,355,234.73$ -23$1,260,939.86$1,450,080.83$35,180.22$18,157.53$17,022.69
35
24$1,355,234.73$1,517,862.89$ -24$1,414,900.61$1,627,135.70$39,475.73$20,374.57$19,101.16
36
25$1,517,862.89$1,700,006.44$ -25$1,587,659.98$1,825,808.97$44,295.71$22,862.30$21,433.41
37
26$1,700,006.44$1,904,007.21$ -26$1,781,513.26$2,048,740.25$49,704.22$25,653.79$24,050.43
38
27$1,904,007.21$2,132,488.08$ -27$1,999,036.03$2,298,891.43$55,773.11$28,786.12$26,986.99
39
28$2,132,488.08$2,388,386.65$ -28$2,243,118.33$2,579,586.08$62,583.00$32,300.90$30,282.10
40
29$2,388,386.65$2,674,993.05$ -29$2,517,003.08$2,894,553.54$70,224.39$36,244.84$33,979.54
41
30$2,674,993.05$2,995,992.21$434,398.8330$2,824,329.15$3,247,978.52$78,798.78$40,670.34$38,128.44
42
43
Final Balance$2,561,593.38Final Balance$3,169,179.74
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