FIREDraws

	B	C	D	E	F	G	H	I
1
2
3	Variables					Note	Orange = Variables
4	Required drawdown ex SP & Other income			Edit to update table	£70,000	Annual Budget
5	Annual Growth %			Edit to update table	4.00%	Conservative - Revise this?
6	Inflation				2%
7
8				ISA
9			Start of Year	Start of Year	During Year	Start of Year	During Year	End of Year
10	Year - I Turn	Age	Net Worth	Savings Balance	Money in/out Savings	Pension Balance	Money into/Out Pension	Net Worth
11	2028	53	£600,000	£180,000	£0	£420,000	-£40,000	£584,000
12	2029	54	£584,000	£187,200	£0	£396,800	-£40,000	£567,360
13	2030	55	£567,360	£194,688	£0	£372,672	-£40,000	£550,054
14	2031	56	£550,054	£202,476	£0	£347,579	-£40,000	£532,057
15	2032	57	£532,057	£210,575	£0	£321,482	-£40,000	£513,339
16	2033	58	£513,339	£218,998	£0	£294,341	-£40,000	£493,872
17	2034	59	£493,872	£227,757	£0	£266,115	-£40,000	£473,627
18	2035	60	£473,627	£236,868	£0	£236,760	-£40,000	£452,572
19	2036	61	£452,572	£246,342	£0	£206,230	-£40,000	£430,675
20	2037	62	£430,675	£256,196	£0	£174,479	-£40,000	£407,902
21	2038	63	£407,902	£266,444	£0	£141,458	-£40,000	£384,218
22	2039	64	£384,218	£277,102	£0	£107,117	-£40,000	£359,587
23	2040	65	£359,587	£288,186	£0	£71,401	-£40,000	£333,971
24	2041	66	£333,971	£299,713	£0	£34,257	-£40,000	£307,329
25	2042	67	£307,329	£311,702	£0	-£4,372	-£40,000	£279,623
26	2043	68	£279,623	£324,170	£0	-£44,547	-£10,000	£280,808
27	2044	69	£280,808	£337,137	£0	-£56,329	-£10,000	£282,040
28	2045	70	£282,040	£350,622	£0	-£68,582	-£10,000	£283,321
29	2046	71	£283,321	£364,647	£0	-£81,326	-£10,000	£284,654
30	2047	72	£284,654	£379,233	£0	-£94,579	-£10,000	£286,040
31	2048	73	£286,040	£394,402	£0	-£108,362	-£10,000	£287,482
32	2049	74	£287,482	£410,178	£0	-£122,696	-£10,000	£288,981
33	2050	75	£288,981	£426,585	£0	-£137,604	-£10,000	£290,541
34	2051	76	£290,541	£443,649	£0	-£153,108	-£10,000	£292,162
35	2052	77	£292,162	£461,395	£0	-£169,233	-£10,000	£293,849
36	2053	78	£293,849	£479,851	£0	-£186,002	-£10,000	£295,603
37	2054	79	£295,603	£499,045	£0	-£203,442	-£10,000	£297,427
38	2055	80	£297,427	£519,006	£0	-£221,580	-£10,000	£299,324
39	2056	81	£299,324	£539,767	£0	-£240,443	-£10,000	£301,297
40	2057	82	£301,297	£561,357	£0	-£260,061	£0	£313,349
41	2058	83	£313,349	£583,812	£0	-£270,463	£0	£325,883
42	2059	84	£325,883	£607,164	£0	-£281,281	£0	£338,918
43	2060	85	£338,918	£631,451	£0	-£292,533	£0	£352,475
44	2061	86	£352,475	£656,709	£0	-£304,234	£0	£366,574
45	2062	87	£366,574	£682,977	£0	-£316,403	£0	£381,237
46	2063	88	£381,237	£710,296	£0	-£329,060	£0	£396,486
47	2064	89	£396,486	£738,708	£0	-£342,222	£0	£412,345
48	2065	90	£412,345	£768,256	£0	-£355,911	£0	£428,839
49	2066	91	£428,839	£798,986	£0	-£370,147	£0	£445,993
50	2067	92	£445,993	£830,946	£0	-£384,953	£0	£463,833
51	2068	93	£463,833	£864,184	£0	-£400,351	£0	£482,386
52	2069	94	£482,386	£898,751	£0	-£416,365	£0	£501,681
53	2070	95	£501,681	£934,701	£0	-£433,020	£0	£521,748
54	2071	96	£521,748	£972,089	£0	-£450,341	£0	£542,618
55	2072	97	£542,618	£1,010,973	£0	-£468,354	£0	£564,323
56	2073	98	£564,323	£1,051,412	£0	-£487,088	£0	£586,896
57	2074	99	£586,896	£1,093,468	£0	-£506,572	£0	£610,372
58	2075	100	£610,372	£1,137,207	£0	-£526,835	£0	£634,787
59	2076	101	£634,787	£1,182,695		-£547,908	£0	£660,178
60	2077		£660,178	£1,230,003		-£569,825	£0	£686,585
61	2078		£686,585	£1,279,203		-£592,618	£0	£714,049
62	2079		£714,049	£1,330,371		-£616,322	£0	£742,611
63	2080		£742,611	£1,383,586		-£640,975	£0	£772,315
64	2081		£772,315	£1,438,929		-£666,614	£0
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