Switch To Product Links Languages Themes Feedback Sign Up Now
Loading...
Updating...
Please wait to edit...
Ready for editing X
Money Market Fund: After Tax A... by thefinancebuff  794 views
Embed in Website/Blog
$ Macros
 
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
Money Market Fund: After Tax, After Inflation
Copyright: The Finance Buff
Assumptions
Marginal Tax Rate15%This spreadsheet calculates the after-tax, after-inflation return of a
money market fund. For more info, see
Breaking The Buck Is Not a Big Deal
Calculations
YearReturn Before Tax (1)Return After TaxInflation (2)Return After Tax, After Inflation
20075.14%4.37%4.08%0.28%
20064.88%4.15%2.54%1.57%
20053.01%2.56%3.42%-0.83%
20041.11%0.94%3.26%-2.24%
20030.90%0.77%1.88%-1.09%
20021.65%1.40%2.38%-0.95%
20014.17%3.54%1.55%1.96%
20006.29%5.35%3.39%1.89%
19995.01%4.26%2.68%1.54%
19985.38%4.57%1.61%2.92%
19975.44%4.62%1.70%2.88%
19965.29%4.50%3.32%1.14%
19955.82%4.95%2.54%2.35%
19944.08%3.47%2.67%0.78%
19933.01%2.56%2.75%-0.19%
(1) Vanguard Prime Money Market Fund. Source: Vanguard.com
(2) Consumer Price Index. Source: Bureau of Labor Statistics.
Sheet1
 
     
Processing...
Assign Macro Edit Label More