Copy of ETF_Dividend_Tax_Drag_Calculator.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L
1	ETF Dividend Tax Drag Calculator
2	Choose LTCG and NIIT with dropdowns, type federal/state rates as percentages, and edit any fund row or the custom row below.
3
4	Scenario inputs			Auto-calculated tax rates			Definitions
5	LTCG rate	20.0%		Qualified dividend tax rate	33.1%		Yield	FTC	Qualified	Tax drag	After-tax yield	Tax efficiency
6	NIIT	3.8%		Non-qualified dividend tax rate	48.1%		Fund dividend yield	Foreign tax credit as % of yield	Qualified dividend %	Total dividend tax drag	Yield minus drag	1 − Drag/Yield
7	Marginal federal rate	35.0%
8	State rate	9.3%
9

10	Fund	Yield	FTC	Qualified	Qualified Yield	Tax on Qualified	Non-Qualified Yield	Tax on Non-Qualified	Pre-FTC Tax	FTC Credit	Total Tax Drag
11	AVUV	1.7%	0.0%	100.0%	1.68%	0.56%	0.00%	0.00%	0.56%	0.00%	0.56%
12	DFSV	1.6%	0.0%	100.0%	1.64%	0.54%	0.00%	0.00%	0.54%	0.00%	0.54%
13	AVDV	3.4%	8.0%	79.0%	2.68%	0.89%	0.71%	0.34%	1.23%	0.27%	0.96%
14	DISV	2.3%	11.1%	99.7%	2.28%	0.76%	0.01%	0.00%	0.76%	0.25%	0.50%
15	AVES	3.4%	11.8%	44.5%	1.50%	0.50%	1.88%	0.90%	1.40%	0.40%	1.00%
16	DFEV	3.0%	12.5%	57.9%	1.71%	0.57%	1.24%	0.60%	1.16%	0.37%	0.79%
17	Custom fund (edit me)
18
19
20	Portfolio examples			Formula used for each fund row
21	DFA 100% US (DFSV)	0.54%		Tax Drag = Yield × (Qualified% × Qualified tax rate + (1 − Qualified%) × Non-qualified tax rate − FTC%)
22	DFA 50:50 US/Intl	0.52%
23	DFA 50:25:25 US/Intl/EM	0.60%
24	Avantis 100% US (AVUV)	0.56%
25	Avantis 50:50 US/Intl	0.76%
26	Avantis 50:25:25 US/Intl/EM	0.77%
27	50:50 DFA/Avantis blend (50:25:25)	0.68%
28
29
30
31
32
33
34
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