assetalloc.xls

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	Y	Z	AA
1	Fund name	Balance	Tax rate on	LG	LG	LV	LV	SG	SG	SV	SV	Intl Lg	Intl Lg	Intl Sm	Intl Sm	EM	EM	Bond	Bond	RE	RE	Cash	Cash
2			withdrawal	%	Value	%	Value	%	Value	%	Value	%	Value	%	Value	%	Value	%	Value	%	Value	%	Value
3	Total Stock Market in taxable	20,000.00	26%	40%	5,920	40%	5,920	10%	1,480	10%	1,480		0		0		0		0		0		0
4	Total International in 401(k)	10,000.00	30%		0		0		0		0	60%	4,200	15%	1,050	25%	1,750		0		0		0
5	Bond fund in Roth IRA	10,000.00	0%		0		0		0		0		0		0		0	100%	10,000		0		0
6					0		0		0		0		0		0		0		0		0		0
7					0		0		0		0		0		0		0		0		0		0
8					0		0		0		0		0		0		0		0		0		0
9					0		0		0		0		0		0		0		0		0		0
10					0		0		0		0		0		0		0		0		0		0
11					0		0		0		0		0		0		0		0		0		0
12					0		0		0		0		0		0		0		0		0		0
13					0		0		0		0		0		0		0		0		0		0
14					0		0		0		0		0		0		0		0		0		0
15					0		0		0		0		0		0		0		0		0		0
16					0		0		0		0		0		0		0		0		0		0
17					0		0		0		0		0		0		0		0		0		0
18					0		0		0		0		0		0		0		0		0		0
19					0		0		0		0		0		0		0		0		0		0
20					0		0		0		0		0		0		0		0		0		0
21					0		0		0		0		0		0		0		0		0		0
22					0		0		0		0		0		0		0		0		0		0	US Stock	Intl Stock	Bonds
23	TOTALS	31,800.00			5,920		5,920		1,480		1,480		4,200		1,050		1,750		10,000		0		0	14,800	7,000	10,000
24	Asset Allocation				19%		19%		5%		5%		13%		3%		6%		31%		0%		0%	47%	22%	31%
25	Target Totals				0		0		0		0		0		0		0		0		0		0	0	0	0
26	Target Allocation																							0%	0%	0%
27
28	Effective tax rate computation
29	Unrealized gain rate	8.00%
30	Taxable distribution rate	2.00%
31	Tax on distributions	0.40%
32	Long-term CG tax rate	20%
33	Years to withdrawal	30
34	EFFECTIVE TAX RATE	26%
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
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