Join Early Retirement Today
Reply
 
Thread Tools Search this Thread Display Modes
Calculating overall portfolio expenses.
Old 03-25-2016, 03:31 PM   #1
gone traveling
 
Join Date: Feb 2016
Posts: 34
Calculating overall portfolio expenses.

Need advice on how to calculate overall portfolio fund expenses, I must have 15 or 20 funds with various balances.


Sent from my iPad using Early Retirement Forum
__________________

__________________
Frankie1926 is offline   Reply With Quote
Join the #1 Early Retirement and Financial Independence Forum Today - It's Totally Free!

Are you planning to be financially independent as early as possible so you can live life on your own terms? Discuss successful investing strategies, asset allocation models, tax strategies and other related topics in our online forum community. Our members range from young folks just starting their journey to financial independence, military retirees and even multimillionaires. No matter where you fit in you'll find that Early-Retirement.org is a great community to join. Best of all it's totally FREE!

You are currently viewing our boards as a guest so you have limited access to our community. Please take the time to register and you will gain a lot of great new features including; the ability to participate in discussions, network with our members, see fewer ads, upload photographs, create a retirement blog, send private messages and so much, much more!

Old 03-25-2016, 03:38 PM   #2
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
pb4uski's Avatar
 
Join Date: Nov 2010
Location: Vermont & Sarasota, FL
Posts: 16,485
It will just be a weighted average of the fund level expense ratios plus any account level fees. What is your purpose for doing this calculation and what will you use it for?
__________________

__________________
If something cannot endure laughter.... it cannot endure.
Patience is the art of concealing your impatience.
Slow and steady wins the race.
pb4uski is offline   Reply With Quote
Old 03-25-2016, 04:21 PM   #3
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
 
Join Date: Jun 2005
Posts: 8,627
This is easily done with Morningstar Instant X-ray tool or the Vanguard Portfolio Watch tool.

The M* tool is easily found; the Vanguard tool requires you to be a client.
__________________
LOL! is offline   Reply With Quote
Old 03-25-2016, 06:19 PM   #4
Full time employment: Posting here.
Markola's Avatar
 
Join Date: Nov 2013
Posts: 545
There is also the free tool Personal Capital, which I signed up for and have been enjoying. You just have to fend off a couple of calls asking to manage your money but they aren't obnoxious about it.
__________________
Markola is offline   Reply With Quote
Old 03-25-2016, 06:37 PM   #5
Thinks s/he gets paid by the post
target2019's Avatar
 
Join Date: Dec 2008
Posts: 3,709
Column a, enter fund names. Column b enter $ balances. Column c enter expense ratio. Column d is b times column c.
SUM column c to get total expenses.
__________________
target2019 is offline   Reply With Quote
Old 03-25-2016, 10:22 PM   #6
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
pb4uski's Avatar
 
Join Date: Nov 2010
Location: Vermont & Sarasota, FL
Posts: 16,485
Quote:
Originally Posted by target2019 View Post
Column a, enter fund names. Column b enter $ balances. Column c enter expense ratio. Column d is b times column c.
SUM column c to get total expenses.
better yet =SUMPRODUCT(column b, column c) will get total expenses. But I think the weighted average expense ratio is more relevant and that would be =SUMPRODUCT(column b, column c)/SUM(column b).
__________________
If something cannot endure laughter.... it cannot endure.
Patience is the art of concealing your impatience.
Slow and steady wins the race.
pb4uski is offline   Reply With Quote
Old 03-26-2016, 06:37 AM   #7
gone traveling
 
Join Date: Feb 2016
Posts: 34
Thanks for the excel formulas, I will give it a whirl on a rainy day.


Sent from my iPad using Early Retirement Forum
__________________

__________________
Frankie1926 is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Be careful calculating your expenses Rich_by_the_Bay FIRE and Money 38 08-04-2010 07:50 PM
What Overall Rate of Return do you use in your financial projections Arc FIRE and Money 45 03-26-2008 07:15 PM
Figuring overall portfolio expense? hogtied FIRE and Money 3 01-07-2008 10:41 PM
Do HSA contributions count as an expense when calculating yearly expenses? ron244 FIRE and Money 4 05-23-2007 08:06 PM
Whats your overall expense ratio? cute fuzzy bunny FIRE and Money 58 03-18-2006 12:42 PM

 

 
All times are GMT -6. The time now is 01:17 AM.
 
Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2017, vBulletin Solutions, Inc.