Join Early Retirement Today
Thread Tools Search this Thread Display Modes
Asset Allocation Spreadsheet on Google Drive
Old 09-08-2015, 07:51 PM   #1
sengsational's Avatar
Join Date: Oct 2010
Posts: 5,861
Asset Allocation Spreadsheet on Google Drive

I am sharing an Excel sheet that calculates an asset allocation across multiple accounts and investment vehicles. It also provides a section where proposed rebalancing actions can be entered, and the resulting new allocation is presented.

The sheet has some formatting that doesn't come through on Google docs, so downloading and running in your spreadsheet software might be advised if you plan to get serious about using the sheet. Running directly on Google is probably good enough for window shopping.

Just for a quick once-over, if you open the sheet you can see the positions within accounts. Each position is split into it's allocation based on the percentages to the right.

You can show rows 40 through 78 and see that US Equities is high by $128K, Hard Assets is $133K low, etc. Yellow signifies numbers out of range. Looking at row 78, those numbers are all in range (not highlighted in color). Now find 30 and -30 in column S. Change those to 20 and -20. That would signify a transfer plan of 10K less from VFINX to EPP. Notice that the asset allocation plan of the sample was originally in range, and now there is one value that's out of range. Rather arbitrarily, I've set this sheet to highlight cells that are more than $12K out of whack.

My motivation for this spreadsheet was how very simple some of the asset allocation spreadsheets available on the Internet seemed to be (not that I looked real hard or anything). What I'm sharing here is just a simplified version of what I really use. This one has 9 asset classes and 29 positions. The asset classes are not exactly what I use. The positions, target asset allocation percents, accounts, investment vehicle allocations, balances, everything is just made-up as an example.

If there's an easier way to get all this done, I'd like to hear about it. But for now, this is pretty much how I do my AA. This is not "automated", so it's a trial and error thing. And each positive entry must have a negative entry of the same amount in order to give the output any meaning. What makes the problem harder is that one can't transfer from any account to any other account since that would have serious tax consequences and might not even be possible/legal. So you must stay in the bounds of your account, and that account may or may not have an investment vehicle that has what you need to get in balance.
sengsational 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 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!


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
Get 2GB extra in Google Drive with security check target2019 Other topics 31 04-21-2015 07:07 PM
Google Drive app & Google Docs steelyman Other topics 19 03-14-2014 05:07 PM
Tracking basis with spreadsheet, how to structure the spreadsheet? bamsphd FIRE and Money 13 08-03-2009 10:31 AM
Asset Allocation spreadsheet w/ 35 years data... Cb FIRE and Money 3 05-20-2007 10:01 AM
Check out the "google" at the top of the google page cute fuzzy bunny Other topics 0 03-17-2006 09:40 PM

» Quick Links

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