ABCDEFGHIJKLMNOPQRSTUVWXY
1
2
Parameters to Edit
3
Expected Return Buy and Hold0.1
4
Expected Return Trading0.13
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.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$110,000.00$ -1$100,000.00$113,000.00$3,484.00$1,924.00$1,560.00
13
2$110,000.00$121,000.00$ -2$109,516.00$123,753.08$3,815.54$2,107.09$1,708.45
14
3$121,000.00$133,100.00$ -3$119,937.54$135,529.42$4,178.62$2,307.60$1,871.03
15
4$133,100.00$146,410.00$ -4$131,350.80$148,426.40$4,576.26$2,527.19$2,049.07
16
5$146,410.00$161,051.00$ -5$143,850.14$162,550.66$5,011.74$2,767.68$2,244.06
17
6$161,051.00$177,156.10$ -6$157,538.92$178,018.98$5,488.66$3,031.05$2,457.61
18
7$177,156.10$194,871.71$ -7$172,530.32$194,959.27$6,010.96$3,319.48$2,691.47
19
8$194,871.71$214,358.88$ -8$188,948.31$213,511.59$6,582.96$3,635.37$2,947.59
20
9$214,358.88$235,794.77$ -9$206,928.63$233,829.35$7,209.39$3,981.31$3,228.09
21
10$235,794.77$259,374.25$ -10$226,619.96$256,080.55$7,895.44$4,360.17$3,535.27
22
11$259,374.25$285,311.67$ -11$248,185.11$280,449.18$8,646.77$4,775.08$3,871.69
23
12$285,311.67$313,842.84$ -12$271,802.41$307,136.72$9,469.60$5,229.48$4,240.12
24
13$313,842.84$345,227.12$ -13$297,667.13$336,363.85$10,370.72$5,727.12$4,643.61
25
14$345,227.12$379,749.83$ -14$325,993.13$368,372.24$11,357.60$6,272.11$5,085.49
26
15$379,749.83$417,724.82$ -15$357,014.64$403,426.54$12,438.39$6,868.96$5,569.43
27
16$417,724.82$459,497.30$ -16$390,988.15$441,816.61$13,622.03$7,522.61$6,099.42
28
17$459,497.30$505,447.03$ -17$428,194.58$483,859.88$14,918.30$8,238.46$6,679.84
29
18$505,447.03$555,991.73$ -18$468,941.58$529,903.99$16,337.92$9,022.44$7,315.49
30
19$555,991.73$611,590.90$ -19$513,566.06$580,329.65$17,892.64$9,881.01$8,011.63
31
20$611,590.90$672,749.99$ -20$562,437.01$635,553.82$19,595.31$10,821.29$8,774.02
32
21$672,749.99$740,024.99$ -21$615,958.51$696,033.12$21,459.99$11,851.04$9,608.95
33
22$740,024.99$814,027.49$ -22$674,573.13$762,267.63$23,502.13$12,978.79$10,523.34
34
23$814,027.49$895,430.24$ -23$738,765.50$834,805.02$25,738.59$14,213.85$11,524.74
35
24$895,430.24$984,973.27$ -24$809,066.43$914,245.06$28,187.87$15,566.44$12,621.44
36
25$984,973.27$1,083,470.59$ -25$886,057.19$1,001,244.63$30,870.23$17,047.74$13,822.49
37
26$1,083,470.59$1,191,817.65$ -26$970,374.39$1,096,523.06$33,807.84$18,670.00$15,137.84
38
27$1,191,817.65$1,310,999.42$ -27$1,062,715.22$1,200,868.20$37,025.00$20,446.64$16,578.36
39
28$1,310,999.42$1,442,099.36$ -28$1,163,843.20$1,315,142.82$40,548.30$22,392.34$18,155.95
40
29$1,442,099.36$1,586,309.30$ -29$1,274,594.52$1,440,291.81$44,406.87$24,523.20$19,883.67
41
30$1,586,309.30$1,744,940.23$328,988.0530$1,395,884.93$1,577,349.97$48,632.63$26,856.83$21,775.80
42
43
Final Balance$1,415,952.18Final Balance$1,528,717.34
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