Bullboard - Stock Discussion Forum North American Financial 15 Split Corp T.FFN

Alternate Symbol(s): FNCSF

North American Financial 15 Split Corp. is a Canada-based mutual fund corporation, which invests in a portfolio of over 15 financial services companies. It offers two types of shares, such as Preferred Shares and Class A Shares. Its investment objectives with respect to preferred shares are to provide holders of preferred shares with cumulative preferential monthly cash dividends in the amount... see more

Add To Watchlist

TSX:FFN - Post Discussion

North American Financial 15 Split Corp > Jul 12 Weighting to generate Estimated % for each Stock

View:

Post by CDNINV1 on Jul 12, 2024 6:27pm

Jul 12 Weighting to generate Estimated % for each Stock

HI bitrock Hope this helps !!

This is how I generate MY CALCULATED ESTIMATED UNIT NAV EACH DAY

Known No of shares * closing price = Fair Value per Stock. eg. BMO Totsl Fair Value per Stock $27,979,936 / Total No of Shares 236880 = Share Weighting that I use. I THEN USE THIS WEIGHTING * CLOSING PRICE TO GENERATE THE CLOSING VALUE OF OF ALL STOCKS + THE DIVIDENDS RECEIVABLE / AVG LISTED SHARES OUT 53362.092 MILLION = MY CALCULATED ESTIMATED UNIT NAV EACH DAY

		cdn\us exch rate		1.3633
		us\cdn exch rate		0.7335
	SHARES		$ VALUE	CDN PRICE
Bank of Montreal	236880		27979936	$118.12	3.3%
Bank of Nova Scotia	365600		23456218	$64.16	2.7%
CIBC	459200		30713500	$66.88	3.6%
CI Financial Corp.	123850		1949399	$15.74	0.2%
Great-West Lifeco Inc.	105700		4235399	$40.07	0.5%
MFC	1329750		49183528	$36.99	5.7%
National Bank of Canada	254100		28878465	$113.65	3.4%
Royal Bank of Canada	489500		74199124	$151.58	8.6%
Sun Life Financial Inc.	613300		42032162	$68.53	4.9%
Toronto-Dominion Bank	484300		37469700	$77.37	4.4%
Bank of America Corp.	1462022		82917676	$56.71	9.6%
Citigroup Inc.	739537		65056067	$87.97	7.6%
Goldman Sachs	136100		89046695	$654.27	10.4%
JPM	317708		88771990	$279.41	10.3%
Wells Fargo	976540		75274126	$77.08	8.8%
US Bancorp	411500		23635303	$57.44	2.7%
Fifth Third Bancorp.	189973		9966136	$52.46	1.2%
Morgan Stanley	475400		67460135	$141.90	7.8%
			822225560		95.58%
			27781273		4.42%
					100.00%
			850006833	15.9290387828
	US			58.37%
	CDN			37.21%

174

Comment

Comment by CDNINV1 on Jul 12, 2024 7:00pm

I had to estimate a change to November 2023 Annual Report number of shares for BAC, C ,and USB at the end of February 2024 to match Quadravest Quarterly Portfolio Disclosure. The Semi Annual Report as at May 31 2024 s/b available at the end of July and I will adjust to the new numbers!! https://www.quadravest.com/ffn-fund-documents Citigroup Inc.https://www.quadravest.com/ffn-fund-documents

109

Comment

Comment by mouserman on Jul 13, 2024 5:04pm

FFN documents from that link are still to FEB. 2024...that was what i based my spreadsheeet on , but you must equal the % of USD vs CAD banks in the June monthend report to be accurate.

Comment

Comment by CDNINV1 on Jul 26, 2024 2:07am

Closing.FFN unit NAV net of dist for Jul 25 = $16.073 REVISED AFTER I UPDATED JUNE 28TH WEIGHTINGS AS PER MAY 31ST SEMI ANNUAL REPORT. MY ADJUSTMENTS TO BAC CITIGROUP AND US BANCORP to match Quadravest Quarterly Portfolio Disclosure AT THE END OF FEBRUARY WERE VERY CLOSE TO THE ACTUALS AS PER MAY 31ST SEMI ANNUAL REPORT. THERE WERE OTHER SMALL CHANGES TO CIBC, SLF, GS ...more

Comment

North American Financial 15 Split Corp