Ratio of capital gains when saving for FIRE

	B	C	D	F	G	H	J
1	salary	2000	Please File > Make a copy to edit		Post:	https://merelycurious.me/post/diversifying-over-etf-providers
2	savings ratio	0.3
3	SWR	4%
4	yearly market growth	7%		FI number	420000
5
6	month	saved (overall)	approximate ratio of FI	saved (tax payed)	capital gain this month	saved (capital gain)	Y
7	0	0	0	0	0	0	0
8	1	600	0.001428571429	600	4.807390716	0	0
9	2	1204.807391	0.002868589026	1200	9.653299774	4.807390716	0.00399017366
10	3	1814.46069	0.004320144501	1800	14.5380358	14.46069049	0.007969690699
11	4	2428.998726	0.005783330301	2400	19.46190987	28.99872628	0.01193855146
12	5	3048.460636	0.00725823961	3000	24.4252356	48.46063616	0.01589675641
13	6	3672.885872	0.008744966361	3600	29.42832907	72.88587176	0.01984430617
14	7	4302.314201	0.01024360524	4200	34.47150891	102.3142008	0.02378120148
15	8	4936.78571	0.01175425169	4800	39.55509631	136.7857097	0.02770744322
16	9	5576.340806	0.01327700192	5400	44.67941503	176.340806	0.03162303241
17	10	6221.020221	0.01481195291	6000	49.84479142	221.0202211	0.03552797021
18	11	6870.865012	0.01635920241	6600	55.05155445	270.8650125	0.0394222579
19	12	7525.916567	0.01791884897	7200	60.30003572	325.9165669	0.0433058969
20	13	8186.216603	0.01949099191	7800	65.59056949	386.2166027	0.04717888878
21	14	8851.807172	0.02107573136	8400	70.92349269	451.8071721	0.05104123524
22	15	9522.730665	0.02267316825	9000	76.29914497	522.7306648	0.05489293809
23	16	10199.02981	0.02428340431	9600	81.71786869	599.0298098	0.05873399931
24	17	10880.74768	0.02590654209	10200	87.18000895	680.7476785	0.062564421
25	18	11567.92769	0.02754268497	10800	92.6859136	767.9276874	0.06638420538
26	19	12260.6136	0.02919193715	11400	98.23593332	860.6136011	0.07019335484
27	20	12958.84953	0.03085440365	12000	103.8304216	958.8495344	0.07399187187
28	21	13662.67996	0.03253019037	12600	109.4697346	1062.679956	0.07777975912
29	22	14372.14969	0.03421940403	13200	115.1542316	1172.149691	0.08155701936
30	23	15087.30392	0.0359221522	13800	120.8842747	1287.303922	0.08532365549
31	24	15808.1882	0.03763854333	14400	126.6602286	1408.188197	0.08907967057
32	25	16534.84843	0.03936868673	15000	132.4824613	1534.848425	0.09282506776
33	26	17267.33089	0.04111269259	15600	138.3513436	1667.330887	0.09655985038
34	27	18005.68223	0.04287067198	16200	144.2672493	1805.68223	0.1002840219
35	28	18749.94948	0.04464273686	16800	150.2305551	1949.94948	0.1039975858
36	29	19500.18003	0.04642900008	17400	156.2416408	2100.180035	0.1077005459
37	30	20256.42168	0.04822957542	18000	162.3008892	2256.421676	0.111392906
38	31	21018.72256	0.05004457754	18600	168.4086862	2418.722565	0.1150746701
39	32	21787.13125	0.05187412203	19200	174.5654208	2587.131251	0.1187458423
40	33	22561.69667	0.05371832541	19800	180.7714852	2761.696672	0.1224064268
41	34	23342.46816	0.05557730514	20400	187.0272745	2942.468157	0.126056428
42	35	24129.49543	0.0574511796	21000	193.3331872	3129.495431	0.1296958505
43	36	24922.82862	0.05934006814	21600	199.6896248	3322.828619	0.1333246988
44	37	25722.51824	0.06124409106	22200	206.0969923	3522.518243	0.1369429777
45	38	26528.61524	0.06316336961	22800	212.5556976	3728.615236	0.1405506922
46	39	27341.17093	0.06509802603	23400	219.0661522	3941.170933	0.1441478473
47	40	28160.23709	0.06704818354	24000	225.6287705	4160.237086	0.1477344481
48	41	28985.86586	0.06901396632	24600	232.2439707	4385.865856	0.1513105
49	42	29818.10983	0.07099549959	25200	238.9121739	4618.109827	0.1548760084
50	43	30657.022	0.07299290953	25800	245.6338049	4857.022001	0.1584309787
51	44	31502.65581	0.07500632335	26400	252.4092917	5102.655806	0.1619754168
52	45	32355.0651	0.07703586928	27000	259.2390659	5355.065097	0.1655093285
53	46	33214.30416	0.07908167658	27600	266.1235624	5614.304163	0.1690327196
54	47	34080.42773	0.08114387554	28200	273.0632197	5880.427726	0.1725455963
55	48	34953.49095	0.08322259749	28800	280.0584797	6153.490945	0.1760479648
56	49	35833.54943	0.08531797482	29400	287.109788	6433.549425	0.1795398315
57	50	36720.65921	0.08743014098	30000	294.2175936	6720.659213	0.1830212027
58	51	37614.87681	0.08955923049	30600	301.3823492	7014.876807	0.1864920851
59	52	38516.25916	0.09170537894	31200	308.6045111	7316.259156	0.1899524854
60	53	39424.86367	0.09386872302	31800	315.8845393	7624.863667	0.1934024105
61	54	40340.74821	0.09604940049	32400	323.2228973	7940.748206	0.1968418673
62	55	41263.9711	0.09824755025	33000	330.6200526	8263.971104	0.200270863
63	56	42194.59116	0.1004633123	33600	338.0764763	8594.591156	0.2036894047
64	57	43132.66763	0.1026968277	34200	345.5926432	8932.667632	0.2070974999
65	58	44078.26028	0.1049482388	34800	353.169032	9278.260276	0.2104951561
66	59	45031.42931	0.1072176888	35400	360.8061253	9631.429308	0.2138823807
67	60	45992.23543	0.1095053225	36000	368.5044093	9992.235433	0.2172591817
68	61	46960.73984	0.1118112853	36600	376.2643745	10360.73984	0.2206255667
69	62	47937.00422	0.1141357243	37200	384.086515	10737.00422	0.223981544
70	63	48921.09073	0.1164787875	37800	391.971329	11121.09073	0.2273271214
71	64	49913.06206	0.118840624	38400	399.9193186	11513.06206	0.2306623073
72	65	50912.98138	0.1212213842	39000	407.93099	11912.98138	0.2339871101
73	66	51920.91237	0.1236212199	39600	416.0068534	12320.91237	0.2373015382
74	67	52936.91922	0.1260402839	40200	424.1474233	12736.91922	0.2406056002
75	68	53961.06665	0.1284787301	40800	432.353218	13161.06665	0.2438993049
76	69	54993.41986	0.130936714	41400	440.6247601	13593.41986	0.2471826611
77	70	56034.04462	0.133414392	42000	448.9625765	14034.04462	0.2504556778
78	71	57083.0072	0.1359119219	42600	457.3671981	14483.0072	0.253718364
79	72	58140.3744	0.1384294629	43200	465.8391601	14940.3744	0.2569707291
80	73	59206.21356	0.1409671751	43800	474.3790023	15406.21356	0.2602127823
81	74	60280.59256	0.1435252204	44400	482.9872683	15880.59256	0.2634445331
82	75	61363.57983	0.1461037615	45000	491.6645066	16363.57983	0.266665991
83	76	62455.24434	0.1487029627	45600	500.4112696	16855.24434	0.2698771659
84	77	63555.65561	0.1513229895	46200	509.2281145	17355.65561	0.2730780674
85	78	64664.88372	0.1539640089	46800	518.1156027	17864.88372	0.2762687056
86	79	65782.99932	0.1566261889	47400	527.0743003	18382.99932	0.2794490904
87	80	66910.07362	0.1593096991	48000	536.1047779	18910.07362	0.282619232
88	81	68046.1784	0.1620147105	48600	545.2076105	19446.1784	0.2857791408
89	82	69191.38601	0.1647413953	49200	554.3833778	19991.38601	0.2889288272
90	83	70345.76939	0.1674899271	49800	563.6326644	20545.76939	0.2920683016
91	84	71509.40205	0.1702604811	50400	572.9560592	21109.40205	0.2951975747
92	85	72682.35811	0.1730532336	51000	582.354156	21682.35811	0.2983166572
93	86	73864.71227	0.1758683625	51600	591.8275533	22264.71227	0.3014255601
94	87	75056.53982	0.1787060472	52200	601.3768545	22856.53982	0.3045242943
95	88	76257.91668	0.1815664683	52800	611.0026677	23457.91668	0.3076128709
96	89	77468.91934	0.184449808	53400	620.705606	24068.91934	0.3106913011
97	90	78689.62495	0.1873562499	54000	630.4862873	24689.62495	0.3137595962
98	91	79920.11124	0.1902859791	54600	640.3453346	25320.11124	0.3168177677
99	92	81160.45657	0.1932391823	55200	650.2833757	25960.45657	0.3198658271
100	93	82410.73995	0.1962160475	55800	660.3010435	26610.73995	0.3229037861