Retirement Opportunity Cost - Investment Expenses

	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Retirement Opportunity Cost - Investment Expenses
2	Without Annual Advisory Fee
3
4
5	Portfolio Expenses			Category Averages					Low Cost Index Alternative
6				Fund Name		Symbol	Value	Expense Ratio	Fund Name		Symbol	Value	Expense Ratio
7				Intermediate Term Bond Funds			$2,250.00	0.86%	Vanguard Total Bond Market Index		VBMFX	$2,250.00	0.20%
8				World Bond Funds			$750.00	1.06%	Vanguard Total International Bond Index		VTIBX	$750.00	0.23%
9				Large Blend Stock Funds			$5,250.00	1.09%	Vanguard Total Stock Market Index		VTSMX	$5,250.00	0.17%
10				Foreign Large Blend Stock Funds			$1,750.00	1.19%	Vanguard Total International Stock Index		VGTSX	$1,750.00	0.22%
11				Total and Average			$10,000.00	1.05%	Total and Average			$10,000.00	0.19%
12
13	Assumptions
14		Current Calendar Year											2016
15		Portfolio Starting Balance											$10,000.00
16		Category Average Expense Ratio											1.05%
17		Low Cost Index Alternative Expense Ratio											0.19%
18		Gross Rate of Return											8.33%
19		Annual Additions											$5,000.00
20		Inflation Rate											3.34%
21
22	Calculations			Category Average Portfolio					Low Cost Index Portfolio
23		Year	Period	Starting Balance	Investment Return	Expenses	Additions	Ending Balance	Starting Balance	Investment Return	Expenses	Additions	Ending Balance	Net Difference
24		2016	1	$10,000.00	$833.00	$114.13	$5,000.00	$15,718.87	$10,000.00	$833.00	$20.58	$5,000.00	$15,812.42	$93.54
25		2017	2	$15,718.87	$1,309.38	$179.39	$5,167.00	$22,015.86	$15,812.42	$1,317.17	$32.55	$5,167.00	$22,264.05	$248.18
26		2018	3	$22,015.86	$1,833.92	$251.26	$5,339.58	$28,938.11	$22,264.05	$1,854.59	$45.83	$5,339.58	$29,412.39	$474.29
27		2019	4	$28,938.11	$2,410.54	$330.26	$5,517.92	$36,536.31	$29,412.39	$2,450.05	$60.54	$5,517.92	$37,319.83	$783.51
28		2020	5	$36,536.31	$3,043.47	$416.97	$5,702.22	$44,865.03	$37,319.83	$3,108.74	$76.81	$5,702.22	$46,053.97	$1,188.94
29		2021	6	$44,865.03	$3,737.26	$512.03	$5,892.67	$53,982.94	$46,053.97	$3,836.30	$94.79	$5,892.67	$55,688.15	$1,705.21
30		2022	7	$53,982.94	$4,496.78	$616.08	$6,089.49	$63,953.12	$55,688.15	$4,638.82	$114.62	$6,089.49	$66,301.84	$2,348.72
31		2023	8	$63,953.12	$5,327.29	$729.87	$6,292.88	$74,843.42	$66,301.84	$5,522.94	$136.47	$6,292.88	$77,981.19	$3,137.77
32		2024	9	$74,843.42	$6,234.46	$854.16	$6,503.06	$86,726.78	$77,981.19	$6,495.83	$160.51	$6,503.06	$90,819.58	$4,092.79
33		2025	10	$86,726.78	$7,224.34	$989.78	$6,720.26	$99,681.61	$90,819.58	$7,565.27	$186.93	$6,720.26	$104,918.18	$5,236.57
34		2026	11	$99,681.61	$8,303.48	$1,137.62	$6,944.72	$113,792.18	$104,918.18	$8,739.68	$215.95	$6,944.72	$120,386.63	$6,594.45
35		2027	12	$113,792.18	$9,478.89	$1,298.66	$7,176.67	$129,149.08	$120,386.63	$10,028.21	$247.79	$7,176.67	$137,343.72	$8,194.64
36		2028	13	$129,149.08	$10,758.12	$1,473.92	$7,416.37	$145,849.65	$137,343.72	$11,440.73	$282.69	$7,416.37	$155,918.13	$10,068.48
37		2029	14	$145,849.65	$12,149.28	$1,664.52	$7,664.08	$163,998.48	$155,918.13	$12,987.98	$320.92	$7,664.08	$176,249.27	$12,250.78
38		2030	15	$163,998.48	$13,661.07	$1,871.64	$7,920.06	$183,707.97	$176,249.27	$14,681.56	$362.77	$7,920.06	$198,488.12	$14,780.15
39		2031	16	$183,707.97	$15,302.87	$2,096.58	$8,184.59	$205,098.85	$198,488.12	$16,534.06	$408.54	$8,184.59	$222,798.23	$17,699.37
40		2032	17	$205,098.85	$17,084.73	$2,340.70	$8,457.95	$228,300.84	$222,798.23	$18,559.09	$458.58	$8,457.95	$249,356.69	$21,055.86
41		2033	18	$228,300.84	$19,017.46	$2,605.50	$8,740.45	$253,453.25	$249,356.69	$20,771.41	$513.24	$8,740.45	$278,355.31	$24,902.06
42		2034	19	$253,453.25	$21,112.66	$2,892.55	$9,032.38	$280,705.73	$278,355.31	$23,187.00	$572.93	$9,032.38	$310,001.76	$29,296.03
43		2035	20	$280,705.73	$23,382.79	$3,203.57	$9,334.06	$310,219.01	$310,001.76	$25,823.15	$638.07	$9,334.06	$344,520.90	$34,301.89
44		2036	21	$310,219.01	$25,841.24	$3,540.39	$9,645.82	$342,165.68	$344,520.90	$28,698.59	$709.12	$9,645.82	$382,156.20	$39,990.52
45		2037	22	$342,165.68	$28,502.40	$3,904.99	$9,967.99	$376,731.08	$382,156.20	$31,833.61	$786.58	$9,967.99	$423,171.22	$46,440.13
46		2038	23	$376,731.08	$31,381.70	$4,299.47	$10,300.92	$414,114.23	$423,171.22	$35,250.16	$871.00	$10,300.92	$467,851.30	$53,737.07
47		2039	24	$414,114.23	$34,495.72	$4,726.11	$10,644.97	$454,528.82	$467,851.30	$38,972.01	$962.96	$10,644.97	$516,505.32	$61,976.50
48		2040	25	$454,528.82	$37,862.25	$5,187.34	$11,000.51	$498,204.24	$516,505.32	$43,024.89	$1,063.11	$11,000.51	$569,467.62	$71,263.38
49		2041	26	$498,204.24	$41,500.41	$5,685.79	$11,367.93	$545,386.80	$569,467.62	$47,436.65	$1,172.12	$11,367.93	$627,100.09	$81,713.29
50		2042	27	$545,386.80	$45,430.72	$6,224.26	$11,747.62	$596,340.87	$627,100.09	$52,237.44	$1,290.74	$11,747.62	$689,794.40	$93,453.53
51		2043	28	$596,340.87	$49,675.19	$6,805.78	$12,139.99	$651,350.28	$689,794.40	$57,459.87	$1,419.78	$12,139.99	$757,974.48	$106,624.20
52		2044	29	$651,350.28	$54,257.48	$7,433.58	$12,545.47	$710,719.65	$757,974.48	$63,139.27	$1,560.12	$12,545.47	$832,099.11	$121,379.46
53		2045	30	$710,719.65	$59,202.95	$8,111.13	$12,964.48	$774,775.94	$832,099.11	$69,313.86	$1,712.68	$12,964.48	$912,664.76	$137,888.82
54
55
56
57
58
59
60
61
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