ABCDEFGHIJKLMNOPQRSTUVWXY
1
2
Parameters to Edit
3
Expected Return Buy and Hold0.08
4
Expected Return Trading0.1
5
Short Term Tax Rate0.305
Most will be 22-24%
https://www.nerdwallet.com/article/taxes/capital-gains-tax-rates
6
Long Term Tax Rate0.22Most 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$108,000.00$ -1$100,000.00$110,000.00$2,540.00$1,220.00$1,320.00
13
2$108,000.00$116,640.00$ -2$107,460.00$118,206.00$2,729.48$1,311.01$1,418.47
14
3$116,640.00$125,971.20$ -3$115,476.52$127,024.17$2,933.10$1,408.81$1,524.29
15
4$125,971.20$136,048.90$ -4$124,091.06$136,500.17$3,151.91$1,513.91$1,638.00
16
5$136,048.90$146,932.81$ -5$133,348.26$146,683.08$3,387.05$1,626.85$1,760.20
17
6$146,932.81$158,687.43$ -6$143,296.04$157,625.64$3,639.72$1,748.21$1,891.51
18
7$158,687.43$171,382.43$ -7$153,985.92$169,384.51$3,911.24$1,878.63$2,032.61
19
8$171,382.43$185,093.02$ -8$165,473.27$182,020.60$4,203.02$2,018.77$2,184.25
20
9$185,093.02$199,900.46$ -9$177,817.58$195,599.34$4,516.57$2,169.37$2,347.19
21
10$199,900.46$215,892.50$ -10$191,082.77$210,191.05$4,853.50$2,331.21$2,522.29
22
11$215,892.50$233,163.90$ -11$205,337.54$225,871.30$5,215.57$2,505.12$2,710.46
23
12$233,163.90$251,817.01$ -12$220,655.72$242,721.30$5,604.66$2,692.00$2,912.66
24
13$251,817.01$271,962.37$ -13$237,116.64$260,828.31$6,022.76$2,892.82$3,129.94
25
14$271,962.37$293,719.36$ -14$254,805.54$280,286.10$6,472.06$3,108.63$3,363.43
26
15$293,719.36$317,216.91$ -15$273,814.04$301,195.44$6,954.88$3,340.53$3,614.35
27
16$317,216.91$342,594.26$ -16$294,240.56$323,664.62$7,473.71$3,589.73$3,883.98
28
17$342,594.26$370,001.81$ -17$316,190.91$347,810.00$8,031.25$3,857.53$4,173.72
29
18$370,001.81$399,601.95$ -18$339,778.75$373,756.63$8,630.38$4,145.30$4,485.08
30
19$399,601.95$431,570.11$ -19$365,126.25$401,638.87$9,274.21$4,454.54$4,819.67
31
20$431,570.11$466,095.71$ -20$392,364.66$431,601.13$9,966.06$4,786.85$5,179.21
32
21$466,095.71$503,383.37$ -21$421,635.07$463,798.57$10,709.53$5,143.95$5,565.58
33
22$503,383.37$543,654.04$ -22$453,089.04$498,397.95$11,508.46$5,527.69$5,980.78
34
23$543,654.04$587,146.36$ -23$486,889.49$535,578.44$12,366.99$5,940.05$6,426.94
35
24$587,146.36$634,118.07$ -24$523,211.44$575,532.59$13,289.57$6,383.18$6,906.39
36
25$634,118.07$684,847.52$ -25$562,243.02$618,467.32$14,280.97$6,859.36$7,421.61
37
26$684,847.52$739,635.32$ -26$604,186.35$664,604.98$15,346.33$7,371.07$7,975.26
38
27$739,635.32$798,806.15$ -27$649,258.65$714,184.51$16,491.17$7,920.96$8,570.21
39
28$798,806.15$862,710.64$ -28$697,693.34$767,462.68$17,721.41$8,511.86$9,209.55
40
29$862,710.64$931,727.49$ -29$749,741.26$824,715.39$19,043.43$9,146.84$9,896.58
41
30$931,727.49$1,006,265.69$199,378.4530$805,671.96$886,239.16$20,464.07$9,829.20$10,634.87
42
43
Final Balance$806,887.24Final Balance$865,775.09
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