Withdrawing from TIPS Ladder  (Sheet1)
Initial WR	Withdrawal	40,000	41,200	42,436	43,709	45,020	46,371	47,762	49,195	50,671	52,191	53,757	55,369	57,030	58,741	60,504	62,319	64,188	66,114	68,097	70,140	72,244	74,412	76,644	78,943	81,312	83,751	86,264	88,852	91,517	94,263	Withdrawal
4.0%	Year	-1	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	Year
Inflation	Step -1	100,000																														Step -1
3.0%	Step 1	100,000	103,000																													Step 1
Real Rate	Step 2	100,000	103,000	106,090																												Step 2
1.3%	Step 3	100,000	103,000	106,090	109,273																											Step 3
	Step 4	100,000	103,000	106,090	109,273	112,551																										Step 4
	Step 5	100,000	103,000	106,090	109,273	112,551	115,927																									Step 5
	Step 6	100,000	103,000	106,090	109,273	112,551	115,927	119,405																								Step 6
	Step 7	100,000	103,000	106,090	109,273	112,551	115,927	119,405	122,987																							Step 7
	Step 8	100,000	103,000	106,090	109,273	112,551	115,927	119,405	122,987	126,677																						Step 8
	Step 9	100,000	103,000	106,090	109,273	112,551	115,927	119,405	122,987	126,677	130,477																					Step 9
	Step 10	73,000	75,190	77,446	79,769	82,162	84,627	87,166	89,781	92,474	95,248	98,106																				Step 10
	Step 11		74,828	77,073	79,386	81,767	84,220	86,747	89,349	92,030	94,790	97,634	100,563																			Step 11
	Step 12			76,696	78,997	81,367	83,808	86,322	88,912	91,579	94,327	97,156	100,071	103,073																		Step 12
	Step 13				78,603	80,962	83,390	85,892	88,469	91,123	93,857	96,672	99,572	102,560	105,636																	Step 13
	Step 14					80,551	82,967	85,456	88,020	90,661	93,381	96,182	99,067	102,039	105,101	108,254																Step 14
	Step 15						82,539	85,015	87,566	90,192	92,898	95,685	98,556	101,512	104,558	107,695	110,925															Step 15
	Step 16							84,568	87,105	89,718	92,410	95,182	98,037	100,979	104,008	107,128	110,342	113,652														Step 16
	Step 17								86,639	89,238	91,915	94,672	97,512	100,438	103,451	106,554	109,751	113,044	116,435													Step 17
	Step 18									88,751	91,414	94,156	96,981	99,890	102,887	105,973	109,153	112,427	115,800	119,274												Step 18
	Step 19										90,906	93,633	96,442	99,335	102,315	105,385	108,546	111,803	115,157	118,611	122,170											Step 19
	Step 20											56,817	58,522	60,277	62,086	63,948	65,867	67,843	69,878	71,974	74,134	76,358										Step 20
	Step 21												57,483	59,208	60,984	62,813	64,698	66,639	68,638	70,697	72,818	75,002	77,252									Step 21
	Step 22													58,124	59,867	61,664	63,513	65,419	67,381	69,403	71,485	73,629	75,838	78,113								Step 22
	Step 23														58,737	60,499	62,314	64,183	66,109	68,092	70,135	72,239	74,406	76,638	78,937							Step 23
	Step 24															59,319	61,098	62,931	64,819	66,764	68,767	70,830	72,955	75,143	77,398	79,720						Step 24
	Step 25																59,867	61,663	63,513	65,419	67,381	69,403	71,485	73,629	75,838	78,113	80,457					Step 25
	Step 25																					13,219	13,615	14,024	14,444	14,878	15,324					Step 25
	Step 26																	60,379	62,190	64,056	65,978	67,957	69,996	72,096	74,258	76,486	78,781	81,144				Step 26
	Step 26																						11,374	11,715	12,067	12,429	12,801	13,185				Step 26
	Step 27																		60,850	62,676	64,556	66,492	68,487	70,542	72,658	74,838	77,083	79,395	81,777			Step 27
	Step 27																							9,376	9,658	9,948	10,246	10,553	10,870			Step 27
	Step 28																			61,277	63,115	65,009	66,959	68,968	71,037	73,168	75,363	77,624	79,953	82,351		Step 28
	Step 28																								7,218	7,434	7,657	7,887	8,124	8,367		Step 28
	Step 29																				61,656	63,506	65,411	67,374	69,395	71,477	73,621	75,830	78,104	80,448	82,861	Step 29
	Step 29																									4,888	5,035	5,186	5,341	5,502	5,667	Step 29
	Year	-1	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	Year
Port b4 Interest Payment		1,000,000	1,002,190	1,003,239	1,003,060	1,001,563	998,650	994,219	988,163	980,369	970,716	959,079	945,324	929,311	910,893	889,913	866,207	839,604	809,920	776,965	740,538	700,425	656,405	608,242	555,690	498,490	436,368	350,805	264,170	176,668	88,528	Portfolio Before Interest Payment
Annual Interest		13,000	13,028	13,042	13,040	13,020	12,982	12,925	12,846	12,745	12,619	12,468	12,289	12,081	11,842	11,569	11,261	10,915	10,529	10,101	9,627	9,106	8,533	7,907	7,224	6,480	5,673	4,560	3,434	2,297	1,151	Annual Interest
Matured Proceeds		100,000	103,000	106,090	109,273	112,551	115,927	119,405	122,987	126,677	130,477	98,106	100,563	103,073	105,636	108,254	110,925	113,652	116,435	119,274	122,170	76,358	77,252	78,113	78,937	79,720	95,781	94,330	92,647	90,719	88,528	Matured Proceeds
Cash Now Available		113,000	116,028	119,132	122,312	125,571	128,910	132,330	135,834	139,422	143,097	110,574	112,852	115,154	117,478	119,822	122,186	124,567	126,964	129,374	131,797	85,463	85,786	86,021	86,161	86,200	101,454	117,124	127,867	133,202	132,614	Cash Now Available
Withdrawal		40,000	41,200	42,436	43,709	45,020	46,371	47,762	49,195	50,671	52,191	53,757	55,369	57,030	58,741	60,504	62,319	64,188	66,114	68,097	70,140	72,244	74,412	76,644	78,943	81,312	83,751	86,264	88,852	91,517	94,263	Withdrawal
Remainder to Buy TIPS		73,000	74,828	76,696	78,603	80,551	82,539	84,568	86,639	88,751	90,906	56,817	57,483	58,124	58,737	59,319	59,867	60,379	60,850	61,277	61,656	13,219	11,374	9,376	7,218	4,888						Remainder to Buy TIPS
Left in Cash after Step 25																											17,703	18,234				Left in Cash after Step 25
Left in Cash after Step 26																												30,860	31,786			Left in Cash after Step 26
Left in Cash after Step 27																													39,016	40,186		Left in Cash after Step 27
Left in Cash after Step 28																														41,684	42,935	Left in Cash after Step 28
Left in Cash after Step 29																															38,351	Left in Cash after Step 29