Scenario One

Year	P/E10	Init balance	Init bal. 20	Init bal. 50	Init bal. 80	Init stocks	Init TIPS	Tot Withdr	From Stocks	From TIPS	Remain Stocks	Remain TIPS	Dividends	Interest	Income
0	14	100,000 (80% stocks)	100,000	100,000	100,000	80,000	20,000	0	0	0	80,000	20,000	3,600	400	4,000
1	12.6	97,314 (80% stocks)	100,828	99,071	97,314	76,914	20,400	0	0	0	76,914	20,400	3,846	408	4,254
2	9.7	84,145 (80% stocks)	98,929	91,435	84,145	64,293	19,852	0	0	0	64,293	19,852	4,176	397	4,573
3	11.7	107,828 (100% stocks)	106,081	105,217	103,428	107,828	0	0	0	0	107,828	0	5,806	0	5,806
4	14.5	142,586 (100% stocks)	114,617	123,227	130,513	142,586	0	0	0	0	142,586	0	6,195	0	6,195
5	7.5	92,327 (80% stocks)	106,236	97,004	84,509	63,239	29,088	0	0	0	63,239	29,088	5,312	582	5,894
6	4.4	58,159 (100% stocks)	100,073	80,025	59,828	58,159	0	0	0	0	58,159	0	8,327	0	8,327
7	6.4	90,287 (100% stocks)	112,730	102,928	86,507	90,287	0	0	0	0	90,287	0	8,888	0	8,888
8	7.2	107,690 (100% stocks)	118,879	113,877	100,193	107,690	0	0	0	0	107,690	0	9,423	0	9,423
9	8.2	131,204 (100% stocks)	125,973	127,448	118,096	131,204	0	0	0	0	131,204	0	10,080	0	10,080
10	9.1	156,168 (100% stocks)	132,782	140,847	136,544	156,168	0	0	0	0	156,168	0	10,812	0	10,812
11	10.7	194,954 (100% stocks)	141,502	159,746	164,220	194,954	0	0	0	0	194,954	0	11,479	0	11,479
12	10.8	210,435 (100% stocks)	146,013	167,686	175,309	210,435	0	0	0	0	210,435	0	12,275	0	12,275
13	10.2	212,271 (100% stocks)	148,604	170,094	177,234	212,271	0	0	0	0	212,271	0	13,111	0	13,111
14	9.7	215,728 (100% stocks)	151,466	173,180	180,252	215,728	0	0	0	0	215,728	0	14,011	0	14,011
15	10.5	248,039 (100% stocks)	158,427	187,881	202,571	248,039	0	0	0	0	248,039	0	14,882	0	14,882
16	8.4	212,471 (100% stocks)	156,418	176,289	180,143	212,471	0	0	0	0	212,471	0	15,935	0	15,935
17	8.1	218,731 (100% stocks)	159,842	180,649	185,110	218,731	0	0	0	0	218,731	0	17,012	0	17,012
18	7	202,974 (100% stocks)	160,097	175,949	175,182	202,974	0	0	0	0	202,974	0	18,268	0	18,268
19	7	215,505 (100% stocks)	164,635	183,140	184,535	215,505	0	0	0	0	215,505	0	19,395	0	19,395
20	7.2	235,941 (100% stocks)	170,392	193,655	199,273	235,941	0	0	0	0	235,941	0	20,645	0	20,645
21	6.8	237,635 (100% stocks)	173,363	196,287	201,214	237,635	0	0	0	0	237,635	0	22,016	0	22,016
22	5.4	202,969 (100% stocks)	171,079	183,933	178,536	202,969	0	0	0	0	202,969	0	23,680	0	23,680
23	6.3	254,405 (100% stocks)	182,487	209,078	215,445	254,405	0	0	0	0	254,405	0	25,441	0	25,441
24	7	299,303 (100% stocks)	191,848	229,618	246,725	299,303	0	0	0	0	299,303	0	26,937	0	26,937
25	10.2	467,112 (100% stocks)	216,430	296,284	358,376	467,112	0	0	0	0	467,112	0	28,851	0	28,851
26	10.1	496,121 (100% stocks)	222,581	308,447	377,615	496,121	0	0	0	0	496,121	0	30,946	0	30,946
27	5.5	286,500 (100% stocks)	207,333	246,369	251,485	286,500	0	0	0	0	286,500	0	32,817	0	32,817
28	5.8	323,430 (100% stocks)	215,995	264,711	278,424	323,430	0	0	0	0	323,430	0	35,131	0	35,131
29	6.1	362,610 (100% stocks)	224,684	283,391	306,520	362,610	0	0	0	0	362,610	0	37,450	0	37,450
30	5.8	368,796 (100% stocks)	229,046	288,642	311,929	368,796	0	0	0	0	368,796	0	40,059	0	40,059

Scenario Two

Year	P/E10	Init balance	Init bal. 20	Init bal. 50	Init bal. 80	Init stocks	Init TIPS	Tot Withdr	From Stocks	From TIPS	Remain Stocks	Remain TIPS	Dividends	Interest	Income
0	14	150,000 (50% stocks)	150,000	150,000	150,000	75,000	75,000	0	0	0	75,000	75,000	3,375	1,500	4,875
1	11.2	140,560 (50% stocks)	148,024	140,560	133,095	64,060	76,500	0	0	0	64,060	76,500	3,603	1,530	5,133
2	12.8	157,171 (50% stocks)	156,797	157,171	156,664	85,485	71,686	0	0	0	85,485	71,686	4,207	1,434	5,641
3	12.3	161,022 (50% stocks)	160,215	161,022	160,926	80,865	80,157	0	0	0	80,865	80,157	4,142	1,603	5,745
4	9.7	150,236 (50% stocks)	157,845	150,236	141,748	68,115	82,121	0	0	0	68,115	82,121	4,424	1,642	6,066
5	8.3	145,053 (50% stocks)	157,561	145,053	132,223	68,433	76,620	0	0	0	68,433	76,620	5,194	1,532	6,726
6	5.3	123,357 (50% stocks)	150,025	123,357	98,993	49,380	73,977	0	0	0	49,380	73,977	5,870	1,480	7,350
7	5	125,691 (50% stocks)	152,961	125,691	100,802	62,779	62,912	0	0	0	62,779	62,912	7,910	1,258	9,168
8	4.9	129,619 (50% stocks)	156,708	129,619	104,632	65,516	64,103	0	0	0	65,516	64,103	8,423	1,282	9,705
9	6.5	157,086 (50% stocks)	171,871	157,086	138,852	90,980	66,106	0	0	0	90,980	66,106	8,818	1,322	10,140
10	6.5	164,458 (50% stocks)	177,160	164,458	147,612	84,344	80,114	0	0	0	84,344	80,114	8,175	1,602	9,777
11	9.4	210,804 (50% stocks)	199,256	210,804	212,398	126,930	83,874	0	0	0	126,930	83,874	8,507	1,677	10,184
12	6.9	190,653 (50% stocks)	194,028	190,653	177,365	83,143	107,510	0	0	0	83,143	107,510	7,591	2,150	9,741
13	5.8	182,726 (50% stocks)	193,130	182,726	163,438	85,493	97,233	0	0	0	85,493	97,233	9,286	1,945	11,231
14	5.5	185,311 (50% stocks)	196,540	185,311	165,176	92,120	93,191	0	0	0	92,120	93,191	10,552	1,864	12,416
15	9.3	262,262 (50% stocks)	231,544	262,262	272,938	167,754	94,508	0	0	0	167,754	94,508	11,364	1,890	13,254
16	9.3	273,475 (50% stocks)	238,283	273,475	288,335	139,722	133,753	0	0	0	139,722	133,753	9,465	2,675	12,140
17	7.1	251,033 (50% stocks)	233,321	251,033	247,017	111,561	139,472	0	0	0	111,561	139,472	9,899	2,789	12,688
18	7.9	277,464 (50% stocks)	245,947	277,464	285,665	149,437	128,027	0	0	0	149,437	128,027	11,917	2,561	14,478
19	7.2	275,416 (50% stocks)	248,172	275,416	278,863	133,909	141,507	0	0	0	133,909	141,507	11,717	2,830	14,547
20	5.5	254,048 (50% stocks)	243,449	254,048	240,901	113,586	140,462	0	0	0	113,586	140,462	13,011	2,809	15,820
21	7.3	308,467 (50% stocks)	267,230	308,467	320,575	178,903	129,564	0	0	0	178,903	129,564	15,440	2,591	18,031
22	9.1	363,310 (50% stocks)	289,441	363,310	407,922	205,992	157,318	0	0	0	205,992	157,318	14,261	3,146	17,407
23	9.5	388,006 (50% stocks)	300,784	388,006	447,392	202,718	185,288	0	0	0	202,718	185,288	13,443	3,706	17,149
24	6.3	334,240 (50% stocks)	287,722	334,240	342,831	136,357	197,883	0	0	0	136,357	197,883	13,636	3,958	17,594
25	7.5	382,599 (50% stocks)	307,826	382,599	418,080	212,136	170,463	0	0	0	212,136	170,463	17,819	3,409	21,228
26	8.8	436,373 (50% stocks)	328,826	436,373	507,081	241,248	195,125	0	0	0	241,248	195,125	17,271	3,903	21,174
27	10.4	496,257 (50% stocks)	350,822	496,257	612,335	273,706	222,551	0	0	0	273,706	222,551	16,580	4,451	21,031
28	8.7	475,646 (50% stocks)	349,204	475,646	564,295	222,555	253,091	0	0	0	222,555	253,091	16,116	5,062	21,178
29	7.9	473,800 (50% stocks)	352,852	473,800	554,020	231,221	242,579	0	0	0	231,221	242,579	18,439	4,852	23,291
30	7	465,886 (50% stocks)	354,729	465,886	532,565	224,248	241,638	0	0	0	224,248	241,638	20,182	4,833	25,015