1. Update cells in grey with desired values. These should not change often and include details of your investments and your d 2. Update cells in blue each time you open the spreadsheet. This includes the new money you are investing and the current p 3. When you complete an investment transaction, add the details to the transaction log. The rest of the spreadsheet will auto 4. To add new investments you will need to add additional columns to the transaction log and update other formulas to inclu
ls of your investments and your desired weighting. ou are investing and the current price of each investment. e rest of the spreadsheet will automatically update. nd update other formulas to include them.
Portfolio Rebalancing Spreadsheet
New money being invested: $ 250.00 Target Market Value $ 2,807.31 $ 2,807.31 $ 4,210.97 $ 4,210.97
Fund Code / Ticker TDB909 TDB900 TDB902 TDB911
Name of Investment TD CDN Bond Index-e TD CDN Index-e TD US Index-e TD International Index-e
Target Weighting 20.00% 20.00% 30.00% 30.00%
Current Price $ 10.84 $ 18.13 $ 20.18 $ 9.22
Current Holdings 248.98 155.06 205.40 448.09
$ $ $ $
Market Value 2,698.94 2,811.27 4,144.93 4,131.42
Total Current Portfolio Value Total Portfolio Book Value Net gain / (loss) Percent gain / (loss) Transaction Log: Date Action 10/28/2009 Buy 10/30/2009 Buy 11/4/2009 DRIP [$9.56 @ 10.88] TDB909 Units Unit Cost Total Cost 232.293 10.88 2,527.35 15.808 10.87 171.83 0.879 -
$ 13,786.57 $ 13,661.77 $ 124.80 0.91%
Units 141.986 13.076
TDB900 Unit Cost 17.80 17.84
Purchase Units to Ending Amount Purchase Weighting $ 108.37 10.00 20.00% $ (3.96) (0.22) 20.00% $ 66.03 3.27 30.00% $ 79.55 8.63 30.00%
TDB900 Total Cost 2,527.35 233.28 Units 190.695 14.703
TDB902 Unit Cost Total Cost 19.88 3,791.02 19.95 293.32 -
TDB911 Units Unit Cost Total Cost 412.516 9.19 3,791.02 35.577 9.18 326.60 -