Do-It-Yourself Income Portfolio
The following DIY income portfolio was started in June, 2010 with $100,000.00 invested. All interest and dividend income received is credited to the account and maintained as a cash balance. The income is assumed to be retained and reinvested by the portfolio as per the Investment Policy Statement (IPS).
Bonds and Guaranteed Investment Certificates (31-December-2017)
| Quantity $ |
Investment Description | Credit Rating |
Average Cost |
Book Value |
Current Price |
Market Value |
Annual Yield* |
Est. Annual Income |
| (Interest) | ||||||||
| $15,454
|
Cash Balance Interest/Dividends Received |
$1.00
|
$15,454.08
|
$1.00
|
$15,454.08
|
0.00%
|
$0.00
|
|
| $6,000 | TMX Group Ltd.
3.253% Bond, Matures: 03-Oct-2018 |
A
(high) |
$100.76 | $6,045.40 | $100.67 | $6,040.02 | 3.10% | $195.18 |
| $11,000
|
Province of Nova Scotia
4.15% Bond, Matures: 25-Nov-2019 |
A
(high) |
$99.91
|
$10,990.10
|
$103.57
|
$11,393.03
|
4.16%
|
$456.50
|
| $15,000 | Bell Canada 3.25% Bond, Matures: 17-Jun-2020 |
BBB
(high) |
$97.87 | $14,680.28 | $101.41 | $15,210.90 | 3.58% | $487.50 |
| $10,000 | Coast Capital Savings CU
1.75% GIC, Matures: 31-Mar-2021 |
AAA | $100.00 | $10,000.00 | $100.00 | $10,000.00 | 1.75% | $175.00 |
| $12,000 | Telus Corp.
2.35% Bond, Matures: 28-Mar-2022 |
BBB
(high) |
$100.62 | $12,074.13 | $98.20 | $11,784.24 | 2.34% | $282.00 |
| $12,000 | Empire Life Insurance
2.87% Bond, Matures: 31-May-2023 |
A
(low) |
$100.14 |
$12,016.92 | $100.13 | $12,015.24 | 2.87% | $344.40 |
| $12,000 | Telus Corp.
3.35% Bond, Matures: 01-Apr-2024 |
BBB
(high) |
$97.48 | $11,697.76 | $101.16 | $12,138.72 | 3.67% | $402.00 |
| $12,000 | Bank of Nova Scotia
2.62% Bond, Matures: 02-Dec-2026 |
AA
(low) |
$100.17 | $12,020.16 | $97.35 | $11,681.40 | 2.62% | $314.40 |
| Bonds & GIC Totals: | $89,518.56 | $90,263.55 | 2.97% | $2,656.98 |
Preferred Shares
| # of
Shares |
Investment Description | Credit Rating |
Average Cost |
Book Value |
Market Price |
Market Value |
Annual Yield* |
Est. Annual Income |
| (Dividends) | ||||||||
| 220 | IGM Financial Inc.
5.90%, Preferred (IGM.PR.B) Perpetual Shares |
Pfd-2(high) | $24.10 | $5,302.00 | $25.35 | $5,577.00 | 6.12% | $324.50 |
| 250 | George Weston Ltd.
5.20%, Preferred (WN.PR.D) Perpetual Shares |
Pfd-3 | $20.69 | $5,172.50 | $24.20 | $6,050.00 | 6.28% | $325.00 |
| 210 | Power Corp.
4.60%, Preferred (POW.PR.G) Perpetual Shares |
Pfd-2(high) | $24.73 | $5,193.30 | $25.15 | $5,281.50 | 5.66% | $294.00 |
| 210 | Westcoast Energy
5.20%, Preferred (W.PR.M) Fixed Minimum Rate-Reset Shares |
Pfd-2(low) | $25.00 | $5,250.00 | $25.83 | $5,424.30 | 5.20% | $273.00 |
| 260 | Canadian Utilities Ltd
5.25%, Preferred (CU.PR.G) Perpetual Shares |
Pfd-2 | $23.75 | $6,175.00 | $21.42 | $5,569.20 | 4.74% | $292.50 |
| Preferred Share Totals: | $27,092.80 | $27,902.00 | 5.57% | $1,509.00 | ||||
| Income Portfolio Totals: | $132,065.44 | $133,619.63 | 3.15% | $4,165.98 |
Bond pricing = The “Bid” price on the last trading day in the quarter. Data provided by CBID™ fixed income marketplace.
Preferred share pricing = closing trade on the last trading day in the quarter. Data provided by Google Finance.
*Yield calculation is based on the portfolio’s purchase cost. We are only interested in what the portfolio earns from its investment, not the yield based on the current market price.