FIRE.xlsx

	A	B	D	F	G	H	I	J	K	L	M	N	P	Q	S	T	V	AA	AB	AC
1	Age	Year	Net worth	Expenses						Inflation rate	Investment return	Gross worth	Capital gain taxes	Net gain after taxes	SWR	Gain after withdrawal	Net worth
2	Age	Year	Beginning	4% rule	Yearly	Monthly	Weekly	Daily		Inflation rate	Investment return	Gross worth	Capital gain taxes	Net gain after taxes	4.00%	Gain after withdrawal	End
3	40	2024	750,000	625,000	25,000	2,083	521	68		2.50%	9.00%	798,750	26%	36,075	30,000	11,075	761,075	500,000	1.0%	10,000

4	41	2025	761,075									810,545		36,608	30,443	11,608	772,683	550,000	1.5%	15,000
5	42	2026	772,683									822,907		37,166	30,907	12,166	784,849	600,000	2.0%	20,000
6	43	2027	784,849									835,864		37,751	31,394	12,751	797,600	650,000	2.5%	25,000
7	44	2028	797,600									849,444		38,365	31,904	13,365	810,965	700,000	3.0%	30,000
8	45	2029	810,965									863,677		39,007	32,439	14,007	824,972	750,000	3.5%	35,000
9	46	2030	824,972									878,595		39,681	32,999	14,681	839,653	800,000	4.0%	40,000
10	47	2031	839,653									894,231		40,387	33,586	15,387	855,040	850,000	4.5%	45,000
11	48	2032	855,040									910,618		41,127	34,202	16,127	871,168	900,000	5.0%	50,000
12	49	2033	871,168									927,794		41,903	34,847	16,903	888,071	950,000	5.5%	55,000
13	50	2034	888,071									945,796		42,716	35,523	17,716	905,787	1,000,000	6.0%	60,000
14	51	2035	905,787									964,663		43,568	36,231	18,568	924,356	1,250,000	6.5%	65,000
15	52	2036	924,356									984,439		44,462	36,974	19,462	943,817	1,500,000	7.0%	70,000
16	53	2037	943,817									1,005,165		45,398	37,753	20,398	964,215	1,750,000	7.5%	75,000
17	54	2038	964,215									1,026,889		46,379	38,569	21,379	985,593	2,000,000	8.0%	80,000
18	55	2039	985,593									1,049,657		47,407	39,424	22,407	1,008,000	2,100,000	8.5%	85,000
19	56	2040	1,008,000									1,073,520		48,485	40,320	23,485	1,031,485	2,200,000	9.0%	90,000
20	57	2041	1,031,485									1,098,532		49,614	41,259	24,614	1,056,100	2,300,000	9.5%	95,000
21	58	2042	1,056,100									1,124,746		50,798	42,244	25,798	1,081,898	2,400,000	10.0%	100,000
22	59	2043	1,081,898									1,152,221		52,039	43,276	27,039	1,108,937	2,500,000	10.5%
23	60	2044	1,108,937									1,181,018		53,340	44,357	28,340	1,137,277	2,600,000	11.0%
24	61	2045	1,137,277									1,211,200		54,703	45,491	29,703	1,166,980	2,700,000	11.5%
25	62	2046	1,166,980									1,242,834		56,132	46,679	31,132	1,198,112	2,800,000	12.0%
26	63	2047	1,198,112									1,275,989		57,629	47,924	32,629	1,230,741	2,900,000	12.5%
27	64	2048	1,230,741									1,310,739		59,199	49,230	34,199	1,264,940	3,000,000	13.0%
28	65	2049	1,264,940									1,347,161		60,844	50,598	35,844	1,300,784	3,100,000	13.5%
29	66	2050	1,300,784									1,385,334		62,568	52,031	37,568	1,338,351	3,200,000	14.0%
30	67	2051	1,338,351									1,425,344		64,375	53,534	39,375	1,377,726	3,300,000	14.5%
31	68	2052	1,377,726									1,467,278		66,269	55,109	41,269	1,418,995	3,400,000	15.0%
32	69	2053	1,418,995									1,511,229		68,254	56,760	43,254	1,462,248	3,500,000	15.5%
33	70	2054	1,462,248									1,557,294		70,334	58,490	45,334	1,507,582	3,600,000	16.0%
34	71	2055	1,507,582									1,605,575		72,515	60,303	47,515	1,555,097	3,700,000	16.5%
35	72	2056	1,555,097									1,656,178		74,800	62,204	49,800	1,604,897	3,800,000	17.0%
36	73	2057	1,604,897									1,709,216		77,196	64,196	52,196	1,657,093	3,900,000	17.5%
37	74	2058	1,657,093									1,764,804		79,706	66,284	54,706	1,711,799	4,000,000	18.0%
38	75	2059	1,711,799									1,823,066		82,338	68,472	57,338	1,769,136	4,100,000	18.5%
39	76	2060	1,769,136									1,884,130		85,095	70,765	60,095	1,829,232	4,200,000	19.0%
40	77	2061	1,829,232									1,948,132		87,986	73,169	62,986	1,892,218	4,300,000	19.5%
41	78	2062	1,892,218									2,015,212		91,016	75,689	66,016	1,958,234	4,400,000	20.0%
42	79	2063	1,958,234									2,085,519		94,191	78,329	69,191	2,027,425	4,500,000	20.5%
43	80	2064	2,027,425									2,159,207		97,519	81,097	72,519	2,099,944	4,600,000	21.0%
44	81	2065	2,099,944									2,236,440		101,007	83,998	76,007	2,175,951	4,700,000	21.5%
45	82	2066	2,175,951									2,317,388		104,663	87,038	79,663	2,255,614	4,800,000	22.0%
46	83	2067	2,255,614									2,402,229		108,495	90,225	83,495	2,339,109	4,900,000	22.5%
47	84	2068	2,339,109									2,491,152		112,511	93,564	87,511	2,426,621	5,000,000	23.0%
48	85	2069	2,426,621									2,584,351		116,720	97,065	91,720	2,518,341		23.5%
49	86	2070	2,518,341									2,682,033		121,132	100,734	96,132	2,614,473		24.0%
50	87	2071	2,614,473									2,784,414		125,756	104,579	100,756	2,715,229		24.5%
51	88	2072	2,715,229									2,891,719		130,603	108,609	105,603	2,820,832		25.0%
52	89	2073	2,820,832									3,004,186		135,682	112,833	110,682	2,931,514		25.5%
53	90	2074	2,931,514		3,122,062		141,006		117,261	116,006		3,047,520				26.0%
54																			26.5%
55																			27.0%
56																			27.5%
57																			28.0%
58																			28.5%
59																			29.0%
60																			29.5%
61																			30.0%
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