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 of over 5.5% annually and to pay the holders of the preferred shares a certain price per preferred share on or about the termination date. Its investment objectives with respect to class A shares are to provide holders of class A shares with regular monthly cash distributions and to permit holders to participate in all growth in the net asset value of the Company for a specific price per unit, by paying holders on or about the termination date such amounts as remain in the Company after paying a specific price per preferred share. Its investment manager is Quadravest Capital Management Inc.

TSX:FFN - Post by User

North American Financial 15 Split Corp > FFN Dashboard on the Web!

<< Previous

Bullboard Posts

Next >>

Post by maxjacon Aug 20, 2024 7:04pm

651 Views

Post# 36188906

FFN Dashboard on the Web!

Hi all,

I promised a public dashboard for FFN investors. I've been working on it since late July and been testing it since August 1. So far, so good.

You can see it at https://dupli.ca/ffn

Please send me your feedback, suggestions, questions, corrections.

IMPORTANT: This is still a work in progress. It is meant for educational purposes only.

Couple of things:

Estimated NAV will likely not be "bang on" but should be within about 7 cents of the real number.
Exchange rate is from openexchangerates.org and is automatically updated hourly during weekdays.
Stock data for all stock is pulled automatically every 30 minutes from 9AM to 5PM on weekdays.
Dividend amounts for all stocks are updated automatically and will be included in the “Dividends Receivables” at the right time. This will increase the value of the fund and the NAV at the same time.
Shares outstanding for FFN and FFN.PR.A are also pulled automatically (those do not change very often).
The official NAV before and NAV after distribution is updated automatically whenever Quadravest updates the data on the “fund feature” page.
I use the official Quadravest weightings from the latest available quarter report. Those weightings are currently updated manually, each quarter, by looking at the “quarterly portfolio disclosure” PDF document or the semi-annual report, or the annual report.
I try to make AS LITTLE adjustments to weightings between quarter reports as possible. I'll do it when the cash weighting changes and when we need to adjust the total CAN % vs USA %. The idea is to have this dashboard as automated as possible. If I change a weighting for a specific stock, it will show in red.
The cash value is calculated using the % provided by Quadravest in their month-end “fund update” PDF document and is based on the $ value of the fund at the previous month-end. The cash value in $ will also recalculate (using the same % as the previous month-end) when Quadravest updates the NAV on the “fund feature” page (usually around the 15^th of the month).
When there is a holiday in one country but not the other, the dashboard will not be updated properly (I don't really think I'll spend time on this honestly).
Keep using your own spreadsheets if you have because there’s no guarantee that I will be maintaining this forever