Dividend 15 Split Corp T.DFN

My spreadsheet

[mouserman]

			DFN
	19.00%	2023-06-30	2023-07-10	% GAIN/L	$15.05	VALUE
RY	8.2	126.52	125.27	-0.0099	-0.0122	$1.23
TRP	7.3	53.54	51.78	-0.0329	-0.0361	$1.10
BCE	6.7	60.4	58.81	-0.0263	-0.027	$1.01
MFC	6.2	25.04	24.38	-0.0264	-0.0246	$0.93
TD	5.5	82.11	81.03	-0.0132	-0.0109	$0.83
SLF	5.7	69.06	67.06	-0.0290	-0.0248	$0.86
BMO	5.3	119.64	119.37	-0.0023	-0.0018	$0.80
ENB	4.6	49.24	48.01	-0.0250	-0.0173	$0.69
TRI	4.4	178.86	174.18	-0.0262	-0.017	$0.662
CM	4	56.56	55.62	-0.0166	-0.01000	$0.60
BNS	3.9	66.28	63.52	-0.0416	-0.0358	$0.86
NA	3.8	98.7	97.86	-0.0085	-0.005	$0.57
T	3.7	25.78	25.44	-0.0132	-0.0073	$0.56
TA	3.1	12.4	12.23	-0.0137	-0.0064	$0.47
EMA	2	54.56	52.95	-0.0295	-0.009	$0.301
L	1.9	121.28	118.77	-0.0207	-0.0059	$0.29
SU	1.6	38.86	38.83	-0.0008	-0.00019	$0.241
CIX	1.3	15.04	15.25	0.0140	0.00273	$0.20
AGF.b	1.1	7.86	7.49	-0.0471	-0.0078	$0.17
X	0.7	29.81	29.2	-0.0205	-0.002	$0.11
	81				-0.2582258446	$12.46

[mouserman]

Appears it should have been about 14.79 and not 14.78... somehow rounded it up an extra penny.

[AnEducator]

The discrepency seems to lie in the weightings we have assigned to the holdings, the true values of which is unknown to either of us. My weightings are a little more evenly dispersed after RY, and I've assumed DFN no longer holds AGF or X as an example. AGF as of the last quarterly disclosure was only 0.6% and X was only 0.3%, and this was a long time ago. My assumption is they are now zero

[mouserman]

Dfn has held the same group of holdings (DF as well) for a few years now. I doubt they removed AGF since of late they have moved up the lifecos on their weightings. Last sedate report showed all the same holdings as the previous 4 sedan reports,

[mouserman]

Sorry spellcheck does not seem to recognize Sedar 

[AnEducator]

I can't argue with that logic. I wish Quadravest would disclose their portolio more often; the last update was February - more than four months ago. I will make some adjustments to the portfolio once they update the NAV next week. 

[mouserman]

On my spreadsheet the only holding showing a positive move since JUNE 30th was CIX. If you attach a lower % to CIX and higher to the losers above, the NAV would not be higher. I recently adjusted the spreadsheet to make the UNIT NAV make sense  to my spreadsheet. The trend in many portfolios is to give a higher weighting to  renewable energy like TA....and less to oil plays like SUNCOR

[AnEducator]

Well therein lies the discrepency. Since CIX is in the top 15, I have assigned a significantly higher weighting to it than Loblaw, which has had a terrible week. In any case, we're all forced to make assumptions so it's never going to be an exact science. I'm satisfied so long as we're within a couple of cents of the true value.

[mouserman]

What is amazing is that we came up with the same numbers , with very different weightings.. LOL