FFJ Portfolio December 29 2017.xlsx
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
FFJ PORTFOLIO AS AT DECEMBER 29, 2017
2
3
SymbolQuantity as at DECEMBER 29, 2017Average CostMarket Price as at DECEMBER 29, 2017Book Value as at DECEMBER 29, 2017Market Value as at DECEMBER 29, 2017Variance Book Value and Market Value as at DECEMBER 29, 2017
4
INVESTMENT ACCOUNT #1
5
CANADIAN DOLLAR INVESTMENTS
6
BANK OF NOVA SCOTIABNS725$63.25$81.12$45,856.25 $58,812.00$12,955.75
7
BCE INC COM NEWBCE769$49.89$60.38$38,364.26 $46,432.22$8,067.96
8
BROOKFIELD ASSET MANAGEMENT INC CLASS A LTD VTG SHSBAM.A 196 $12.37$54.72$2,424.50 $10,725.12$8,300.62
9
BROOKFIELD BUSINESS PARTNERS L P LIMITED PARTNERSHIP UNITSBBU.UN 3 $25.82$43.29$77.46 $129.87$52.41
10
BROOKFIELD PROPERTY PARTNERS L PBPY.UN 7 $22.10$27.85$154.70 $194.95$40.25
11
SMART REAL ESTATE INVESTMENT TRUST VAR VTG UNITSRU.UN1104$28.33$30.91$31,272.68 $34,124.64$2,851.96
12
TRISURA GROUP LTD.TSU1$18.10$25.41$18.10 $25.41$7.31
13
TOTAL MARKET VALUE CANADIAN$118,167.94 $150,444.21 $32,276.27
14
CASH$277.62 $277.62$0.00
15
TOTAL MARKET VALUE CANADIAN PLUS CASH$118,445.56 $150,721.83 $32,276.27
16
17
US DOLLAR INVESTMENTS
18
CHEVRON CORPORATIONCVX886$112.10 $125.38$99,319.45 $111,086.68$11,767.23
19
CISCO SYSTEMS INCCSCO793$18.97 $38.30$15,043.45 $30,371.90$15,328.45
20
ISHARES GLOBAL ENERGY ETFIXC30$34.53 $35.57$1,035.86 $1,067.10$31.24
21
TOTAL MARKET VALUE US$115,398.76 $142,525.68 $27,126.92
22
CASH$287.73$287.73$0.00
23
TOTAL MARKET VALUE US PLUS CASH$115,686.49$142,813.41$27,126.92
24
25
INVESTMENT ACCOUNT #2
26
CANADIAN DOLLAR INVESTMENTS
27
CANADIAN NATIONAL RAILWAYCNR717$75.12 $103.63$53,861.04 $74,302.71$20,441.67
28
INTACT FINANCIALIFC150$92.30$104.60$13,845.00 $15,690.00$1,845.00
29
TOTAL MARKET VALUE CANADIAN$67,706.04 $89,992.71 $22,286.67
30
CASH$10,661.13 $10,661.13 $0.00
31
TOTAL MARKET VALUE CANADIAN PLUS CASH$78,367.17$100,653.84$22,286.67
32
33
INVESTMENT ACCOUNT #3
34
CANADIAN DOLLAR INVESTMENTS
35
BCE INC COM NEWBCE324$54.47$60.35$17,648.28 $19,553.40$1,905.12
36
ROYAL BANK OF CANADARY387$74.16$102.65$28,699.92 $39,725.55$11,025.63
37
TELUST274$45.84$47.58$12,560.16 $13,036.92$476.76
38
TOTAL MARKET VALUE CANADIAN$58,908.36 $72,315.87 $13,407.51
39
CASH$434.67 $434.67$0.00
40
TOTAL MARKET VALUE CANADIAN PLUS CASH$59,343.03$72,750.54$13,407.51
41
42
INVESTMENT ACCOUNT #4
43
US DOLLAR INVESTMENTS
44
AT&T INCT540$34.28 $38.90$18,511.20 $21,006.00$2,494.80
45
CHEVRON CORPORATIONCVX319$74.43 $125.39$23,743.17 $39,999.41$16,256.24
46
COLGATE PALMOLIVE COCL410$62.29 $75.50$25,538.90 $30,955.00$5,416.10
47
EXXON MOBIL CORPXOM318$69.79 $83.79$22,193.22 $26,645.22$4,452.00
48
JOHNSON & JOHNSONJNJ321$100.94 $139.84$32,401.74 $44,888.64$12,486.90
49
NIKE INC CL-BNKE505$52.06 $62.58$26,290.30 $31,602.90$5,312.60
50
3M COMPANYMMM389$151.66 $235.78$58,995.74 $91,718.42$32,722.68
51
VERIZON COMMUNICATIONSVZ525$53.42 $53.02$28,045.50 $27,835.50($210.00)
52
WAL MART STORES INCWMT416$59.50 $98.87$24,752.00 $41,129.92$16,377.92
53
TOTAL MARKET VALUE US$260,471.77 $355,781.01 $95,309.24
54
CASH$512.40 $512.40$0.00
55
TOTAL MARKET VALUE US PLUS CASH$260,984.17 $356,293.41 $95,309.24
56
57
INVESTMENT ACCOUNT #5
58
CANADIAN DOLLAR INVESTMENTS
59
ENBRIDGEENB409$52.87$49.16$21,622.73 $20,106.44($1,516.29)
60
TOTAL MARKET VALUE CANADIAN$21,622.73$20,106.44($1,516.29)
61
CASH$1,718.06$1,718.06$0.00
62
TOTAL MARKET VALUE CANADIAN PLUS CASH$23,340.79$21,824.50($1,516.29)
63
64
US DOLLAR INVESTMENTS
65
GENUINE PARTS COMPANYGPC302$82.50 $95.01$24,914.28 $28,693.02 $3,778.74
66
HORMEL FOODS CORPHRL403$35.11 $36.40$14,149.09 $14,669.20 $520.11
67
MASTERCARDMA400$130.12 $151.73$52,047.00 $60,692.00 $8,645.00
68
MICROSOFT CORPORATIONMSFT241$72.95 $85.54$17,579.82 $20,615.14 $3,035.32
69
SMUCKER J M COMPANYSJM404$125.98 $124.50$50,897.82 $50,298.00 ($599.82)
70
SMUCKER J M COMPANY $125 CALL EXPIRY JULY 20, 2018 (4 CONTRACTS)
$2.90 $7.30($1,160.00)($2,920.00)($1,760.00)
71
TOTAL MARKET VALUE US$158,428.00 $172,047.36 $13,619.36
72
CASH$0.00 $0.00 $0.00
73
TOTAL MARKET VALUE US PLUS CASH$158,428.00 $172,047.36 $13,619.36
74
75
GRAND TOTAL CANADIAN DOLLAR INVESTMENTS PLUS CASH
$279,496.55 $345,950.71 $66,454.16
76
GRAND TOTAL US DOLLAR INVESTMENTS PLUS CASH$535,098.66 $671,154.18 $136,055.52
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
 
 
 
Sheet1
 
 
Main menu