ABCDEFGHIJKLMNOPQRSTUVWXY
1
2
Parameters to Edit
3
Expected Return Buy and Hold0.12
4
Expected Return Trading0.15
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$115,000.00$3,720.00$1,920.00$1,800.00
13
2$112,000.00$125,440.00$ -2$111,280.00$127,972.00$4,139.62$2,136.58$2,003.04
14
3$125,440.00$140,492.80$ -3$123,832.38$142,407.24$4,606.56$2,377.58$2,228.98
15
4$140,492.80$157,351.94$ -4$137,800.68$158,470.78$5,126.19$2,645.77$2,480.41
16
5$157,351.94$176,234.17$ -5$153,344.59$176,346.28$5,704.42$2,944.22$2,760.20
17
6$176,234.17$197,382.27$ -6$170,641.86$196,238.14$6,347.88$3,276.32$3,071.55
18
7$197,382.27$221,068.14$ -7$189,890.27$218,373.81$7,063.92$3,645.89$3,418.02
19
8$221,068.14$247,596.32$ -8$211,309.89$243,006.37$7,860.73$4,057.15$3,803.58
20
9$247,596.32$277,307.88$ -9$235,145.64$270,417.49$8,747.42$4,514.80$4,232.62
21
10$277,307.88$310,584.82$ -10$261,670.07$300,920.58$9,734.13$5,024.07$4,710.06
22
11$310,584.82$347,855.00$ -11$291,186.46$334,864.42$10,832.14$5,590.78$5,241.36
23
12$347,855.00$389,597.60$ -12$324,032.29$372,637.13$12,054.00$6,221.42$5,832.58
24
13$389,597.60$436,349.31$ -13$360,583.13$414,670.60$13,413.69$6,923.20$6,490.50
25
14$436,349.31$488,711.23$ -14$401,256.91$461,445.44$14,926.76$7,704.13$7,222.62
26
15$488,711.23$547,356.58$ -15$446,518.69$513,496.49$16,610.50$8,573.16$8,037.34
27
16$547,356.58$613,039.37$ -16$496,885.99$571,418.89$18,484.16$9,540.21$8,943.95
28
17$613,039.37$686,604.09$ -17$552,934.73$635,874.94$20,569.17$10,616.35$9,952.83
29
18$686,604.09$768,996.58$ -18$615,305.77$707,601.64$22,889.37$11,813.87$11,075.50
30
19$768,996.58$861,276.17$ -19$684,712.26$787,419.10$25,471.30$13,146.48$12,324.82
31
20$861,276.17$964,629.31$ -20$761,947.81$876,239.98$28,344.46$14,629.40$13,715.06
32
21$964,629.31$1,080,384.83$ -21$847,895.52$975,079.85$31,541.71$16,279.59$15,262.12
33
22$1,080,384.83$1,210,031.01$ -22$943,538.13$1,085,068.85$35,099.62$18,115.93$16,983.69
34
23$1,210,031.01$1,355,234.73$ -23$1,049,969.23$1,207,464.62$39,058.86$20,159.41$18,899.45
35
24$1,355,234.73$1,517,862.89$ -24$1,168,405.76$1,343,666.63$43,464.69$22,433.39$21,031.30
36
25$1,517,862.89$1,700,006.44$ -25$1,300,201.93$1,495,232.22$48,367.51$24,963.88$23,403.63
37
26$1,700,006.44$1,904,007.21$ -26$1,446,864.71$1,663,894.42$53,823.37$27,779.80$26,043.56
38
27$1,904,007.21$2,132,488.08$ -27$1,610,071.05$1,851,581.71$59,894.64$30,913.36$28,981.28
39
28$2,132,488.08$2,388,386.65$ -28$1,791,687.07$2,060,440.13$66,650.76$34,400.39$32,250.37
40
29$2,388,386.65$2,674,993.05$ -29$1,993,789.37$2,292,857.77$74,168.96$38,280.76$35,888.21
41
30$2,674,993.05$2,995,992.21$579,198.4430$2,218,688.81$2,551,492.13$82,535.22$42,598.83$39,936.40
42
43
Final Balance$2,416,793.77Final Balance$2,468,956.91
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