RE:Question on "Summary of Investment Portfolio"All Quadravest summaries and updates contain a number of "unknowns" to be considered, one of them being the value of Net Assets (Liabilities) that bring some difficulties to calculate (or better said: guesstimate) the NAV value.
While the year-end and mid-year summaries come with the proper numbers of outstanding shares, owned shares for each position and the cash value (plus or minus the assets/liabilities) and it is pretty easy to calculate the NAV, the unknown hits us with the quarterly and monthly updates because on top of the Net Assets (Liabilities) value we also have to guess: 1) the number of outstanding shares (there might be changes every month if we think about the DRIP program plus eventual remissions from stockholders and new emissions from Quadravest); 2) the number of shares in each holding, which can change any day as a result of option transactions; 3) taxes to be paid on dividends received by Quadravest; 4) capital gains (losses) resulting from selling stocks from holdings and from options; 5) fees that Quadravest cashes from each one of their funds (in this case FFN)... On top of these points, we also need to consider the rounding used for each one of the published values. In the case of the declared cash percentage shown in your May example, the percentage could be anywhere between 6.650 to 6.749: when we approach a total value of one Billion dollars, the difference between those two possible values amounts to a very large sum...
In my spreasheet I maintain another entry called, easy to guess, Adjustment, where I keep the difference given by the total declared value minus the sum of cash and the total holdings value (keeping steady the number of shares in each holding because it is too difficult and error prone to try to guess those numbers as well) and recalculating the number of outstanding shares based on the total value divided the declared stock value (which can be, as well, heavily rounded).
Up to now, my calculations have been pretty close to the reality, at most within 4-5 cents range.
All the best for your efforts, and I really like your dashboard!