ABCDEFGHIJKLMNOPQRSTUVWXY
1
2
Parameters to Edit
3
Expected Return Buy and Hold0.12
4
Expected Return Trading0.15
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$115,000.00$3,570.00$2,220.00$1,350.00
13
2$112,000.00$125,440.00$ -2$111,430.00$128,144.50$3,978.05$2,473.75$1,504.31
14
3$125,440.00$140,492.80$ -3$124,166.45$142,791.42$4,432.74$2,756.50$1,676.25
15
4$140,492.80$157,351.94$ -4$138,358.67$159,112.48$4,939.40$3,071.56$1,867.84
16
5$157,351.94$176,234.17$ -5$154,173.07$177,299.03$5,503.98$3,422.64$2,081.34
17
6$176,234.17$197,382.27$ -6$171,795.05$197,564.31$6,133.08$3,813.85$2,319.23
18
7$197,382.27$221,068.14$ -7$191,431.23$220,145.91$6,834.09$4,249.77$2,584.32
19
8$221,068.14$247,596.32$ -8$213,311.82$245,308.59$7,615.23$4,735.52$2,879.71
20
9$247,596.32$277,307.88$ -9$237,693.36$273,347.36$8,485.65$5,276.79$3,208.86
21
10$277,307.88$310,584.82$ -10$264,861.71$304,590.96$9,455.56$5,879.93$3,575.63
22
11$310,584.82$347,855.00$ -11$295,135.40$339,405.71$10,536.33$6,552.01$3,984.33
23
12$347,855.00$389,597.60$ -12$328,869.38$378,199.78$11,740.64$7,300.90$4,439.74
24
13$389,597.60$436,349.31$ -13$366,459.15$421,428.02$13,082.59$8,135.39$4,947.20
25
14$436,349.31$488,711.23$ -14$408,345.43$469,597.24$14,577.93$9,065.27$5,512.66
26
15$488,711.23$547,356.58$ -15$455,019.31$523,272.21$16,244.19$10,101.43$6,142.76
27
16$547,356.58$613,039.37$ -16$507,028.02$583,082.22$18,100.90$11,256.02$6,844.88
28
17$613,039.37$686,604.09$ -17$564,981.32$649,728.52$20,169.83$12,542.59$7,627.25
29
18$686,604.09$768,996.58$ -18$629,558.68$723,992.49$22,475.25$13,976.20$8,499.04
30
19$768,996.58$861,276.17$ -19$701,517.24$806,744.83$25,044.17$15,573.68$9,470.48
31
20$861,276.17$964,629.31$ -20$781,700.66$898,955.76$27,906.71$17,353.75$10,552.96
32
21$964,629.31$1,080,384.83$ -21$871,049.05$1,001,706.41$31,096.45$19,337.29$11,759.16
33
22$1,080,384.83$1,210,031.01$ -22$970,609.95$1,116,201.45$34,650.78$21,547.54$13,103.23
34
23$1,210,031.01$1,355,234.73$ -23$1,081,550.67$1,243,783.27$38,611.36$24,010.42$14,600.93
35
24$1,355,234.73$1,517,862.89$ -24$1,205,171.91$1,385,947.70$43,024.64$26,754.82$16,269.82
36
25$1,517,862.89$1,700,006.44$ -25$1,342,923.06$1,544,361.52$47,942.35$29,812.89$18,129.46
37
26$1,700,006.44$1,904,007.21$ -26$1,496,419.17$1,720,882.04$53,422.16$33,220.51$20,201.66
38
27$1,904,007.21$2,132,488.08$ -27$1,667,459.88$1,917,578.86$59,528.32$37,017.61$22,510.71
39
28$2,132,488.08$2,388,386.65$ -28$1,858,050.54$2,136,758.13$66,332.40$41,248.72$25,083.68
40
29$2,388,386.65$2,674,993.05$ -29$2,070,425.72$2,380,989.58$73,914.20$45,963.45$27,950.75
41
30$2,674,993.05$2,995,992.21$434,398.8330$2,307,075.38$2,653,136.69$82,362.59$51,217.07$31,145.52
42
43
Final Balance$2,561,593.38Final Balance$2,570,774.10
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