Portfolio Rebalance Example

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	1) Fill out the "Current Allocation" on this sheet.
2	In the "Security" column, maintain the hyperlink function so that you can obtain the Morningstar metadata (e.g. Class, Bond Term, etc.)
3	2) Copy the "Security" thru "Growth/Value" columns to the "Target Allocation"
4	3) Initially, set each Target "Balance" to the Current "Balance". Use the cell value formula (e.g. "=G12")
5	4) Go to the "Class" sheet, and fill out the yellow fields
6	Now you have your baseline
7	5) Make tweaks in the "Target Allocation" of the "Details" sheet until you get the "Target Allocation Difference" column of the "Class" sheet to near zero.
8	6) Make additional tweaks until you get the "%Total" column of the "Category" sheet to desired levels
9	Current Allocation								Target Allocation
10	Security	Class	Bond Term	Bond Quality	Cap	Growth /Value	Balance	Morningstar Rating	Security	Class	Bond Term	Bond Quality	Cap	Growth /Value	Balance

11	Husband - Trad IRA						6,215	updated							6,215
12	SCZ: iShares MSCI EAFE Small-Cap ETF	Int. Eq	Small	Blend			4,253	4	SCZ: iShares MSCI EAFE Small-Cap ETF	Int. Eq	Small	Blend			4,253
13	FLTR: Market Vectors Investment Grade Floating Rate ETF	Domestic Bond	Short	High			1,880	4	FLTR: Market Vectors Investment Grade Floating Rate ETF	Domestic Bond	Short	High			1,880
14	-Cash-	Cash					82		-Cash-	Cash					82
15	Husband - Roth IRA						34,514	updated							34,514
16	DBEF: Deutsche X-trackers MSCI EAFE Hedged Eq	Int. Eq			Large	Blend	6,448	5	DBEF: Deutsche X-trackers MSCI EAFE Hedged Eq	Int. Eq			Large	Blend	6,643
17	SCHD: Schwab US Dividend Equity ETF	Domestic Eq			Large	Value	3,461	4	SCHD: Schwab US Dividend Equity ETF	Domestic Eq			Large	Value	3,461
18	SCHG: Schwab US Large-Cap Growth ETF	Domestic Eq			Large	Growth	6,616	4	SCHG: Schwab US Large-Cap Growth ETF	Domestic Eq			Large	Growth	6,616
19	PCY: PowerShares Emerging Markets Sov Dbt ETF	Int. Bond	Intermediate	Low			2,221	3	EMHY: iShares Emerging Markets High Yield Bond	Int. Bond	Intermediate	Low			2,221
20	FLTR: Market Vectors Investment Grade Floating Rate ETF	Domestic Bond	Short	High			5,108	4	FLTR: Market Vectors Investment Grade Floating Rate ETF	Domestic Bond	Short	High			5,108
21	VSTCX: Vanguard Strategic Small-Cap Equity Inv	Domestic Eq			Small	Blend	6,732	4	VSTCX: Vanguard Strategic Small-Cap Equity Inv	Domestic Eq			Small	Blend	6,732
22	VOE: Vanguard Mid-Cap Value ETF	Domestic Eq			Mid	Value	3,733	4	VOE: Vanguard Mid-Cap Value ETF	Domestic Eq			Mid	Value	3,733
23	-Cash-	Cash					196		-Cash-	Cash
24	Wife - Trad IRA						29,749	updated							29,749
25	QQQ: PowerShares QQQ ETF	Domestic Eq			Large	Growth	7,894	5	QQQ: PowerShares QQQ ETF	Domestic Eq			Large	Growth	8,052
26	RYF: Guggenheim S&P 500 Eq Weight Fincl ETF	Domestic Eq			Large	Value	3,075	4	RYF: Guggenheim S&P 500 Eq Weight Fincl ETF	Domestic Eq			Large	Value	3,075
27	SCHD: Schwab US Dividend Equity ETF	Domestic Eq			Large	Value	2,308	4	SCHD: Schwab US Dividend Equity ETF	Domestic Eq			Large	Value	2,308
28	XLE: Energy Select Sector SPDR ETF	Domestic Eq			Large	Value	4,379	5	XLE: Energy Select Sector SPDR ETF	Domestic Eq			Large	Value	4,379
29	TGLMX: TCW Total Return Bond I	Domestic Bond	Intermediate	Low			7,339	4	TGLMX: TCW Total Return Bond I	Domestic Bond	Intermediate	Low			7,339
30	VBK: Vanguard Small-Cap Growth ETF	Domestic Eq			Small	Growth	3,518	3	VBK: Vanguard Small-Cap Growth ETF	Domestic Eq			Small	Growth	3,518
31	EWRE: GUGENHM S&P 500 EQL WGT RL ESTT ETF	Domestic Eq			Mid	Growth	1,078	-	EWRE: GUGENHM S&P 500 EQL WGT RL ESTT ETF	Domestic Eq			Mid	Growth	1,078
32	-Cash-	Cash					158		-Cash-	Cash
33	Wife - Roth IRA						31,572	updated							31,572
34	DBEF: Deutsche X-trackers MSCI EAFE Hedged Eq	Int. Eq			Large	Blend	7,770	5	DBEF: Deutsche X-trackers MSCI EAFE Hedged Eq	Int. Eq			Large	Blend	7,901
35	PCY: PowerShares Emerging Markets Sov Dbt ETF	Int. Bond					2,464	3	EMHY: iShares Emerging Markets High Yield Bond	Int. Bond					2,464
36	SCHG: Schwab US Large-Cap Growth ETF	Domestic Eq			Large	Growth	4,716	4	SCHG: Schwab US Large-Cap Growth ETF	Domestic Eq			Large	Growth	4,716
37	FLTR: Market Vectors Investment Grade Floating Rate ETF	Domestic Bond	Short	High			5,107	4	FLTR: Market Vectors Investment Grade Floating Rate ETF	Domestic Bond	Short	High			5,107
38	VSTCX: Vanguard Strategic Small-Cap Equity Inv	Domestic Eq			Small	Blend	5,785	4	VSTCX: Vanguard Strategic Small-Cap Equity Inv	Domestic Eq			Small	Blend	5,785
39	VOE: Vanguard Mid-Cap Value ETF	Domestic Eq			Mid	Value	5,598	4	VOE: Vanguard Mid-Cap Value ETF	Domestic Eq			Mid	Value	5,598
40	-Cash-	Cash					130		-Cash-	Cash
41	Joint - Taxable - FOR REFERENCE PURPOSES ONLY						53,624	updated							53,624
42	PDP: PowerShares DWA Momentum ETF	Leave blank					11,772	3	PDP: PowerShares DWA Momentum ETF	Leave blank					11,772
43	RPG: Guggenheim S&P 500 Pure Growth ETF	Leave blank					3,625	4	RPG: Guggenheim S&P 500 Pure Growth ETF	Leave blank					3,625
44	TGLMX: TCW Total Return Bond I	Leave blank					11,784	4	TGLMX: TCW Total Return Bond I	Leave blank					11,784
45	VCSH: Vanguard Short-Term Corporate Bond ETF	Leave blank					14,355	5	VCSH: Vanguard Short-Term Corporate Bond ETF	Leave blank					14,355
46	VEIPX: Vanguard Equity-Income Inv	Leave blank					6,282	5	VEIPX: Vanguard Equity-Income Inv	Leave blank					6,282
47	VOE: Vanguard Mid-Cap Value ETF	Leave blank					5,805	4	VOE: Vanguard Mid-Cap Value ETF	Leave blank					5,805
48	-Cash-	Leave blank					0		-Cash-	Leave blank					0