Switch To
Product Links
Languages
Themes
Feedback
Sign Up Now
VBA Editor
Coriander Green
Metallic Grey
Coriander Green
Metallic Grey
Loading...
Updating...
Please wait to edit...
Ready for editing
X
Local File
URL
Name of the Document:
Note:-
- Supported file formats: xls, xlsx, sxc, ods, csv and tsv
- Only unprotected files will be imported
CSV files have data in a structured format similar to a database table. Choose the desired import option based on the recommendations provided below:
Import as...
Tabular Data
Recommended for...
- Creating PIVOT Tables and Charts
- Faster loading and performance
- Auto Filters and Freeze Columns
Normal Spreadsheet
Useful for...
- Formatting options
- Formulas & Calculations, and
- Other regular spreadsheet operations
NOTE:
There will be no option inside the document to toggle between these two views.
Spreadsheet Name:
Template Name:
Save As New Document...
Save As New Template...
Mark As New Version...
New Template
From Templates List
Show Text Only
Show Icons Only
Show Icons & Text
Money Market Fund: After Tax A...
by
thefinancebuff
830 views
Embed in Website/Blog
Tags:
Macro recorded successfully
View Macro
Macros List
|
Unsupported actions
|
Macro Recording in progress
Stop Recording
Cancel
|
Unsupported actions
|
Arial
Arial Black
Book Antiqua
Calibri
Comic Sans MS
Courier New
Garamond
Georgia
Lucida Console
MingLiU
MS Gothic
MS P Gothic
MS Mincho
MS P Mincho
MS Sans Serif
SimHei
Tahoma
Times New Roman
Trebuchet MS
Verdana
8
9
10
11
12
14
16
18
20
24
26
$
Macros
Auto Filter
Freeze Columns
This worksheet is a tabular data. Regular spreadsheet operations like cut/copy/paste, undo/redo, range selection, formulas and formatting are restricted in this mode.
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
Edit
|
Publish
|
Revert Publish
|
URL
|
Clone
Money Market Fund: After Tax, After Inflation
Copyright: The Finance Buff
Assumptions
Marginal Tax Rate
15%
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
Year
Return Before Tax (1)
Return After Tax
Inflation (2)
Return After Tax, After Inflation
2007
5.14%
4.37%
4.08%
0.28%
2006
4.88%
4.15%
2.54%
1.57%
2005
3.01%
2.56%
3.42%
-0.83%
2004
1.11%
0.94%
3.26%
-2.24%
2003
0.90%
0.77%
1.88%
-1.09%
2002
1.65%
1.40%
2.38%
-0.95%
2001
4.17%
3.54%
1.55%
1.96%
2000
6.29%
5.35%
3.39%
1.89%
1999
5.01%
4.26%
2.68%
1.54%
1998
5.38%
4.57%
1.61%
2.92%
1997
5.44%
4.62%
1.70%
2.88%
1996
5.29%
4.50%
3.32%
1.14%
1995
5.82%
4.95%
2.54%
2.35%
1994
4.08%
3.47%
2.67%
0.78%
1993
3.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
0 Viewing
Export (.xls)
Export (.pdf)
Export (.xls)
Export (.pdf)
Export (.xls)
Export (.pdf)
Processing...
Assign Macro
Change Macro
View Code
Edit Label
More