RE:RE:RE:RE:Re new portfolioJohnWalker wrote: so for example for the the first item on the list (Rogers Communications Inc) I am calculating 6.2% of $499,580,203 as $30,973,973 and dividing that by $69.96 and entering a buy of 442,738 shares into my portfolio.
I did the same, but used 6.3% as the % of NAV rather than % of Portfolio. There is a cash allowance and also an equity adjustment since the portfolio ratios are only to one decimal place so there is a margin of error of at least 1%.
This was loaded into a
GoogleSheet if anyone wants to take a look and make a copy (you will need a Google account) or download to their own spreadsheet. Since it uses Google quotes, it will update during market hours.
To keep it up to date, one would have to enter the NAV from Brompton and copy the current prices to the Brompton Price column (Column G). It is necessary to use Paste Special > Values Only so that the formulas are not copied over.
There is a box in E5 labelled Growth with 0.00% underneath it. By typing in a new value, i.e. 1 or 2 or 3 you can see how much the NAV changes. Be sure to set it back to zero to see the current estimated NAV.
Underneath that is the growth required for the NAV to reach $15. Currently it shows $17,808,613 or 3.329% growth of the portfolio is required to reach $15.
To the far right is a projection of dividend income for DGS by holding, by month. The model currently shows the portfolio currently has a quarterly dividend income of $5,568,221 or 4.15% annualized.
In Columns G H I, Rows 39 to 49 is estimated cost of dividends, Class A distributions and fees on a monthly and quarterly basis.
Any errors, please advise.