Fund Management Fees Template
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABAC
1
Fund Management Fees Calculation Spreadsheet
2
Fund NameFund TickerNumber of SharesShare PriceValue% of PortfolioExpense RatioFront & Back-End LoadsAnnual Management FeesLoad Fees
3
Instructions: This is a read-only spreadsheet, so you need to save a copy of it to your own Google Drive before you are able to enter your own data by selecting "File/Make a Copy" or "File/Add to My Drive"
4
in the spreadsheet's pulldown menu above. AlphaGlider does not have access to the version of the file that you save to your Google Drive. Enter information about your funds in the cells highlighted in yellow.
5
Delete or insert new rows as needed for your portfolio.
6
7
ETFslookup at Morningstar.com
8
SPDR S&P 500 ETF TrustSPY250.000$282.01$70,50312.3%0.10%n/a$71n/a
9
PowerShares QQQ Trust, Series 1QQQ500.000$177.65$88,82515.6%0.20%n/a$178n/a
10
iShares Barclays Aggregate Bond FundAGG500.000$107.56$53,7809.4%0.05%n/a$27n/a
11
iShares MSCI Emerging Markets IndxEEM1,000.000$42.71$42,7107.5%0.72%n/a$308n/a
12
13
Mutual Fundslookup at Morningstar.com
14
Artisan Mid Cap Fund Investor ClassARTMX1,000.000$34.74$34,7406.1%1.18%$410
15
Artisan International Fund Investor ClassARTIX1,000.000$29.77$29,7705.2%1.18%$351
16
Fidelity Advisor® Biotechnology Fund Class AFBTAX2,000.000$26.78$53,5609.4%1.06%5.75%$568$3,080
17
Janus Henderson Research Fund Class DJNRFX1,000.000$46.70$46,7008.2%0.73%$341
18
Janus Henderson Overseas Fund Class TJAOSX1,000.000$30.05$30,0505.3%0.70%$210
19
DFA Emerging Markets Value Portfolio Institutional ClassDFEVX1,000.000$28.72$28,7205.0%0.57%$164
20
DFA International Small Cap Value Portfolio Institutional ClassDISVX2,000.000$18.10$36,2006.3%0.68%$246
21
First Eagle Global Fund Class ASGENX1,000.000$55.62$55,6209.7%1.11%5.00%$617$2,781
22
23
Total$571,178100.0%0.61%$3,490$5,861
24
Note: Fund names and share prices, and mutual fund expense ratios are pulled in from Google Finance. value of your portfolioyour portfolio's average expense ratioannual management feesload fees
25
26
AlphaGlider LLC
27
https://alphaglider.com
28
info@alphaglider.com
29
+1 415 967 8047
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
Loading...
Main menu