Join Early Retirement Today
Reply
 
Thread Tools Display Modes
How is "Investment Expense" calculated?
Old 07-06-2018, 07:01 PM   #1
Confused about dryer sheets
 
Join Date: Jul 2018
Posts: 2
How is "Investment Expense" calculated?

Hi everyone,

First, I just discovered FIRECalc and the forum and really like the tool =)

My issue: I'm having trouble understanding how the "Investing Expense" column is calculated in the "single-year" spreadsheet when I check the box to "provide data and formulas in spreadsheet format." My understanding is that this represents, for example, the 0.18% investment fee I'd pay to Vanguard, and I assumed each entry in this column would be 0.18% x the amount in "Starting Portfolio." However, when I do the above multiplication, I always get a number that is close to, but not quite, the number in "Investment Expense."

I tried multiplying 0.18% by other columns that seemed similar to "Starting Portfolio" in magnitude, but still couldn't get the numbers to match.

I've attached my "single-year" spreadsheet and I'm hoping someone can tell me how "Investment Expense" is calculated. I added a column to the right (column V) with 0.18% x the amount in "Starting Portfolio," and highlighted it and the "Investment Expense" column to show what I mean when I say that they're close but not the same.

Thanks, any clarification is appreciated!

Andrew
drewb 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 07-07-2018, 06:50 AM   #2
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
pb4uski's Avatar
 
Join Date: Nov 2010
Location: Sarasota, FL & Vermont
Posts: 36,266
Just a guess that it would be based on the beginning of year portfolio less the annual withdrawal since I suspect that FIRECalc assumes that withdrawals occur at the beginning of the year.
__________________
If something cannot endure laughter.... it cannot endure.
Patience is the art of concealing your impatience.
Slow and steady wins the race.

Retired Jan 2012 at age 56
pb4uski is offline   Reply With Quote
Old 07-07-2018, 04:36 PM   #3
Confused about dryer sheets
 
Join Date: Jul 2018
Posts: 2
Thanks @pb4uski for the idea!

I checked it out and unfortunately that doesn't seem to be it; for some years, 0.18% x starting portfolio > Investment Expense, and in other years 0.18% x starting portfolio < Investment Expense.
drewb is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
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
401k (high expense ratio) vs. Non-Tax deferred account (low expense ratio) Mike54 FIRE and Money 15 11-11-2012 10:31 PM
How SS benefits are calculated mickeyd FIRE and Money 0 12-13-2006 10:49 AM
Deviation from calculated SWR Sam FIRE and Money 12 12-08-2006 05:53 PM
How is the SS income of a spouse calculated Alan FIRE and Money 5 08-22-2005 11:25 AM
meaning of calculated portfolio balance karlwk FIRE and Money 3 12-20-2004 11:48 AM

» Quick Links

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