Click here to download an Excel
spreadsheet of the allocation made to each school.
Not exact matches
Previously, I kept track
of our asset
allocation on a
spreadsheet and it takes a lot
of manual data entry to get a big picture.
Deputy Assembly Budget Director Victor Franco testified he would «hide» public money Silver allocated to himself from a
spreadsheet listing
allocations to all members
of the Assembly, as was standard at the time.
I use a Google Docs
spreadsheet and update the value
of each
of my index mutual fund holdings 1x per month to calculate my asset
allocation levels.
He's created a custom
spreadsheet to help Couch Potatoes keep track
of their asset
allocation across multiple accounts.
So, I've been using a simple
spreadsheet I put together in Google Docs to do just that: provide an asset
allocation snapshot
of a portfolio.
Keeping track
of the asset
allocation and rebalancing with 10 funds rather than five will require some skill with a
spreadsheet.
Personally, I take a screen shot
of the result and save it to my computer hard drive, then enter the data into a
spreadsheet to track changes in
allocation from year to year.
Build a
spreadsheet with your asset
allocation, calculate what percentage each account represents
of the whole portfolio.
I have set up the
spreadsheet with a $ 100000 initial amount, a Stock A
allocation of 50 % and an Investment B
allocation of 40 %.
Since, the entire idea behind the Sleepy Mini Portfolio is to follow a mechanical investment strategy
of committing savings to the portfolio regularly, we will add another $ 1,000 to the portfolio and rebalance it to the original target
allocation — 20 % bonds, 20 % Canadian stocks, 30 % US stocks and 30 % international stocks — using this rebalancing
spreadsheet.
Every quarter (January, April, July, and October) the asset allocator models are automatically rebalanced (on the returns.xlsx
spreadsheets), so in order to keep up and reap the benefits
of asset
allocation, you'll need to rebalance.
The only places you'll see hypothetical returns are on the
spreadsheet «Models for Month Year.xlsx» (that you get when you buy them), the Model portfolio's «demo,» and those shown on the first row
of the table on the main asset
allocation page.