| Cdn Trading | RRSP | Mthly | Annual | ||||||||||||||||||||||||||
| Year | 1 | 2 | 3 | 4 | 5 | 1 | 2 | 3 | 4 | 5 | CPP | $1,012.50 | $12,150.00 | ||||||||||||||||
| Need from | 01-Feb-13 | 01-Jan-14 | 02-Jan-15 | 02-Jan-16 | 01-Jan-17 | 01-Feb-13 | 01-Jan-14 | 02-Jan-15 | 02-Jan-16 | 01-Jan-17 | OAS | $546.00 | $6,552.00 | ||||||||||||||||
| to end of | 31-Dec-13 | 31-Dec-14 | 01-Jan-16 | 31-Dec-16 | 31-Dec-17 | 31-Dec-13 | 31-Dec-14 | 01-Jan-16 | 31-Dec-16 | 31-Dec-17 | Pension | $1,000.00 | $12,000.00 | ||||||||||||||||
| Budget WS | $46,277.00 | $51,998.52 | $53,558.48 | $55,165.23 | $56,820.19 | $10,000.00 | $10,500.00 | $11,000.00 | $11,500.00 | $12,500.00 | $2,558.50 | $30,702.00 | |||||||||||||||||
| Bud. To yr end | Budget | Budget | Budget | Budget | $0.00 | ||||||||||||||||||||||||
| From RRSP | $10,000.00 | $10,500.00 | $11,000.00 | $11,500.00 | $12,500.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Budget | $4,207.00 | $50,484.00 | ||||||||||||||||
| Income Est | $8,533.00 | $10,373.16 | $10,995.55 | $11,655.28 | $12,354.60 | $8,533.00 | $9,786.00 | $10,373.16 | $10,995.55 | $11,655.28 | |||||||||||||||||||
| MM | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $2,000.00 | $0.00 | $0.00 | $0.00 | $0.00 | Year | 2013 | |||||||||||||||||
| Cash | $1,118.03 | $1,532.28 | $1,728.13 | $2,113.88 | $2,693.20 | $2,901.50 | $3,446.36 | $2,740.56 | $2,120.06 | $1,620.45 | RRSP | $10,000.00 | |||||||||||||||||
| CPP, OAS, Pension | $28,143.50 | $31,316.04 | $31,942.36 | $32,581.21 | $33,232.83 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Income | $9,786.00 | |||||||||||||||||
| Total | $47,794.53 | $53,721.48 | $55,666.04 | $57,850.37 | $60,780.63 | $13,434.50 | $13,232.36 | $13,113.72 | $13,115.61 | $13,275.74 | Pension | $30,702.00 | |||||||||||||||||
| Difference | $1,517.53 | $1,722.96 | $2,107.56 | $2,685.14 | $3,960.44 | $3,434.50 | $2,732.36 | $2,113.72 | $1,615.61 | $775.74 | $50,488.00 | ||||||||||||||||||
| Stock Purchase/Sale | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||
| Net | $1,517.53 | $1,722.96 | $2,107.56 | $2,685.14 | $3,960.44 | $3,434.50 | $2,732.36 | $2,113.72 | $1,615.61 | $775.74 | $4,207.00 | ||||||||||||||||||
| 01-Feb-13 | 01-Feb-13 | ||||||||||||||||||||||||||||
| CDN T MM | $0.00 | $2,000.00 | Div | $1,253.00 | |||||||||||||||||||||||||
| CDN T Cash | $104.56 | $2,901.50 | Pension | $2,558.50 | |||||||||||||||||||||||||
| Bank | $1,001.14 | $12.33 | <-int on Acct | 1.35% | Total | $3,811.50 | |||||||||||||||||||||||
| Need | $395.50 | ||||||||||||||||||||||||||||
| Trading A | RRSP | ||||||||||||||||||||||||||||
| Cssh | $500.00 | Cash | $1,648.03 | ||||||||||||||||||||||||||
| Int | $0.06 | Int | $0.47 | ||||||||||||||||||||||||||
| withdrawal | -$395.50 | Div | $1,253.00 | ||||||||||||||||||||||||||
| Return on cash | 0.15% | 0.15% | 0.30% | 0.30% | 0.30% | 0.15% | 0.15% | 0.30% | 0.30% | 0.30% | Left | $104.56 | Total | $2,901.50 | |||||||||||||||
| MMF & Int Inc $ | $0.14 | $6.71 | |||||||||||||||||||||||||||
| Pension Inc yrly | 2.00% | 2.00% | 2.00% | 2.00% | Bank | ||||||||||||||||||||||||
| Budget Inc yrly | 3.00% | 3.00% | 3.00% | 3.00% | Balance | $1,000.00 | |||||||||||||||||||||||
| Income Inc Yrly | red. later in yr-> | 6.00% | 6.00% | 6.00% | 6.00% | red. later in yr-> | 6.00% | 6.00% | 6.00% | 6.00% | Int | 1.14 | |||||||||||||||||
| New Bal | $1,001.14 | ||||||||||||||||||||||||||||
| No. | Stock | Code | Sh | Divs R | Yrly Div | No | Jan #1 | Feb #2 | Mar #3 | Apr #1 | May #2 | Jun #3 | Jul #1 | Aug #2 | Sep #3 | Oct #1 | Nov #2 | Dec #3 | Total | % of Tot | Day | Yield | Curr Price | Worth | % of Tot | AR | |||
| 0 | |||||||||||||||||||||||||||||
| 1 | Bank of Nova Scotia | BNS | 300 | $2.28 | $684.00 | 4 | $171.00 | $171.00 | $171.00 | $171.00 | $684.00 | 6.99% | 4.11% | $55.53 | $16,659.00 | 6.81% | Oct | Jan | $1,253.00 | ||||||||||
| 2 | Canadian Nat. Railway | CNR | 200 | $1.50 | $300.00 | 4 | $75.00 | $75.00 | $75.00 | $75.00 | $300.00 | 3.07% | 30 | 1.65% | $90.67 | $18,134.00 | 7.41% | Dec | Feb | $504.00 | |||||||||
| 3 | Emera | EMA | 500 | $1.40 | $700.00 | 4 | $175.00 | $175.00 | $175.00 | $175.00 | $700.00 | 7.15% | 15 | 4.11% | $34.10 | $17,050.00 | 6.97% | Dec | Mar | $689.50 | |||||||||
| 4 | IGM Financial | IGM | 400 | $2.15 | $860.00 | 4 | $215.00 | $215.00 | $215.00 | $215.00 | $860.00 | 8.79% | 30 | 5.35% | $40.18 | $16,072.00 | 6.57% | Dec | Apr | $1,253.00 | |||||||||
| 5 | Metro Inc | MRU | 300 | $0.86 | $258.00 | 4 | $64.50 | $64.50 | $64.50 | $64.50 | $258.00 | 2.64% | 2 | 1.40% | $61.60 | $18,480.00 | 7.55% | Sep | May | $504.00 | |||||||||
| 6 | Pembina | PPL | 700 | $1.62 | $1,134.00 | 12 | $94.50 | $94.50 | $94.50 | $94.50 | $94.50 | $94.50 | $94.50 | $94.50 | $94.50 | $94.50 | $94.50 | $94.50 | $1,134.00 | 11.59% | 15 | 5.85% | $27.70 | $19,390.00 | 7.92% | Dec | Jun | $689.50 | |
| 7 | Power Corp | POW | 700 | $1.16 | $812.00 | 4 | $203.00 | $203.00 | $203.00 | $203.00 | $812.00 | 8.30% | 30 | 4.75% | $24.40 | $17,080.00 | 6.98% | Dec | Jul | $1,253.00 | |||||||||
| 8 | Reitman | RET.A | 1500 | $0.80 | $1,200.00 | 4 | $300.00 | $300.00 | $300.00 | $300.00 | $1,200.00 | 12.26% | 6.93% | $11.55 | $17,325.00 | 7.08% | Jan | Aug | $504.00 | ||||||||||
| 9 | RioCan | REI.UN | 700 | $1.38 | $966.00 | 12 | $80.50 | $80.50 | $80.50 | $80.50 | $80.50 | $80.50 | $80.50 | $80.50 | $80.50 | $80.50 | $80.50 | $80.50 | $966.00 | 9.87% | 8 | 5.00% | $27.59 | $19,313.00 | 7.89% | Dec | Sep | $689.50 | |
| 10 | Saputo | SAP | 400 | $0.84 | $336.00 | 4 | $84.00 | $84.00 | $84.00 | $84.00 | $336.00 | 3.43% | 20 | 1.72% | $48.81 | $19,524.00 | 7.98% | Mar | Oct | $1,253.00 | |||||||||
| 11 | SNC-Lavalin | SNC | 400 | $0.88 | $352.00 | 4 | $88.00 | $88.00 | $88.00 | $88.00 | $352.00 | 3.60% | 27 | 2.33% | $37.75 | $15,100.00 | 6.17% | Dec | Nov | $504.00 | |||||||||
| 12 | Sun Life | SLF | 600 | $1.44 | $864.00 | 4 | $216.00 | $216.00 | $216.00 | $216.00 | $864.00 | 8.83% | 2 | 5.33% | $27.03 | $16,218.00 | 6.63% | Dec | Dec | $689.50 | |||||||||
| 13 | TD Bank | TD | 200 | $3.08 | $616.00 | 4 | $154.00 | $154.00 | $154.00 | $154.00 | $616.00 | 6.29% | 1 | 3.83% | $80.36 | $16,072.00 | 6.57% | Oct | |||||||||||
| 14 | TransCanada | TRP | 400 | $1.76 | $704.00 | 4 | $176.00 | $176.00 | $176.00 | $176.00 | $704.00 | 7.19% | 31 | 3.84% | $45.86 | $18,344.00 | 7.49% | Dec | |||||||||||
| Annual Inc | $9,786.00 | $1,253.00 | $504.00 | $689.50 | $1,253.00 | $504.00 | $689.50 | $1,253.00 | $504.00 | $689.50 | $1,253.00 | $504.00 | $689.50 | $9,786.00 | 100% | 4.00% | $244,761.00 | 100.00% | $9,786.00 | ||||||||||
| Monthly Inc Ave | $815.50 | ||||||||||||||||||||||||||||
| Cycle 1 | Jan | Apr | Jul | Oct | |||||||||||||||||||||||||
| Cycle 2 | Feb | May | Aug | Nov | |||||||||||||||||||||||||
| Cycle 3 | Mar | Jun | Sep | Dec | |||||||||||||||||||||||||
| No. | Stock | Code | Sh | Divs R | Yrly Div | No | Jan #1 | Feb #2 | Mar #3 | Apr #1 | May #2 | Jun #3 | Jul #1 | Aug #2 | Sep #3 | Oct #1 | Nov #2 | Dec #3 | Total | % of Tot | Day | Yield | Curr Price | Worth | % of Tot | AR | |||
| 0 | |||||||||||||||||||||||||||||
| 1 | Bank of Nova Scotia | BNS | 300 | $2.28 | $684.00 | 4 | $171.00 | $171.00 | $171.00 | $171.00 | $684.00 | 6.99% | 4.11% | $55.53 | $16,659.00 | 6.81% | Oct | Jan | $1,253.00 | ||||||||||
| 2 | Canadian Nat. Railway | CNR | 200 | $1.50 | $300.00 | 4 | $75.00 | $75.00 | $75.00 | $75.00 | $300.00 | 3.07% | 30 | 1.65% | $90.67 | $18,134.00 | 7.41% | Dec | Feb | $504.00 | |||||||||
| 3 | Emera | EMA | 500 | $1.40 | $700.00 | 4 | $175.00 | $175.00 | $175.00 | $175.00 | $700.00 | 7.15% | 15 | 4.11% | $34.10 | $17,050.00 | 6.97% | Dec | Mar | $689.50 | |||||||||
| 4 | IGM Financial | IGM | 400 | $2.15 | $860.00 | 4 | $215.00 | $215.00 | $215.00 | $215.00 | $860.00 | 8.79% | 30 | 5.35% | $40.18 | $16,072.00 | 6.57% | Dec | Apr | $1,253.00 | |||||||||
| 5 | Metro Inc | MRU | 300 | $0.86 | $258.00 | 4 | $64.50 | $64.50 | $64.50 | $64.50 | $258.00 | 2.64% | 2 | 1.40% | $61.60 | $18,480.00 | 7.55% | Sep | May | $504.00 | |||||||||
| 6 | Pembina | PPL | 700 | $1.62 | $1,134.00 | 12 | $94.50 | $94.50 | $94.50 | $94.50 | $94.50 | $94.50 | $94.50 | $94.50 | $94.50 | $94.50 | $94.50 | $94.50 | $1,134.00 | 11.59% | 15 | 5.85% | $27.70 | $19,390.00 | 7.92% | Dec | Jun | $689.50 | |
| 7 | Power Corp | POW | 700 | $1.16 | $812.00 | 4 | $203.00 | $203.00 | $203.00 | $203.00 | $812.00 | 8.30% | 30 | 4.75% | $24.40 | $17,080.00 | 6.98% | Dec | Jul | $1,253.00 | |||||||||
| 8 | Reitman | RET.A | 1500 | $0.80 | $1,200.00 | 4 | $300.00 | $300.00 | $300.00 | $300.00 | $1,200.00 | 12.26% | 6.93% | $11.55 | $17,325.00 | 7.08% | Jan | Aug | $504.00 | ||||||||||
| 9 | RioCan | REI.UN | 700 | $1.38 | $966.00 | 12 | $80.50 | $80.50 | $80.50 | $80.50 | $80.50 | $80.50 | $80.50 | $80.50 | $80.50 | $80.50 | $80.50 | $80.50 | $966.00 | 9.87% | 8 | 5.00% | $27.59 | $19,313.00 | 7.89% | Dec | Sep | $689.50 | |
| 10 | Saputo | SAP | 400 | $0.84 | $336.00 | 4 | $84.00 | $84.00 | $84.00 | $84.00 | $336.00 | 3.43% | 20 | 1.72% | $48.81 | $19,524.00 | 7.98% | Mar | Oct | $1,253.00 | |||||||||
| 11 | SNC-Lavalin | SNC | 400 | $0.88 | $352.00 | 4 | $88.00 | $88.00 | $88.00 | $88.00 | $352.00 | 3.60% | 27 | 2.33% | $37.75 | $15,100.00 | 6.17% | Dec | Nov | $504.00 | |||||||||
| 12 | Sun Life | SLF | 600 | $1.44 | $864.00 | 4 | $216.00 | $216.00 | $216.00 | $216.00 | $864.00 | 8.83% | 2 | 5.33% | $27.03 | $16,218.00 | 6.63% | Dec | Dec | $689.50 | |||||||||
| 13 | TD Bank | TD | 200 | $3.08 | $616.00 | 4 | $154.00 | $154.00 | $154.00 | $154.00 | $616.00 | 6.29% | 1 | 3.83% | $80.36 | $16,072.00 | 6.57% | Oct | |||||||||||
| 14 | TransCanada | TRP | 400 | $1.76 | $704.00 | 4 | $176.00 | $176.00 | $176.00 | $176.00 | $704.00 | 7.19% | 31 | 3.84% | $45.86 | $18,344.00 | 7.49% | Dec | |||||||||||
| Annual Inc | $9,786.00 | $1,253.00 | $504.00 | $689.50 | $1,253.00 | $504.00 | $689.50 | $1,253.00 | $504.00 | $689.50 | $1,253.00 | $504.00 | $689.50 | $9,786.00 | 100% | 4.00% | $244,761.00 | 100.00% | $9,786.00 |