Report Request: Monthly Investment Performance
HelpRegister |
Report Request: Monthly Investment Performance As club Treasurer, every month I'm asked for a report that shows our club's investment performance for the month. And every month I explain that the best that Bivio can do is print the Investment Performance Report that shows the Annualized Internal Rate of Return. This report would be perfectly acceptable if Bivio would print the simple Monthly Return -- not the AIRR. I just don't understand why Bivio can't produce a simple report that shows a starting date's stock price, an ending date's stock price, and the percent gained or loss for each club holding. I'm not asking for number of shares or the value of the holdings -- just the stock price percentage change. Forget about the dividends -- just a simple report. I'd *love* to also have another report, similiar to my Fidelity Statement, that shows the starting balance, amount added, amount withdrawn, investment change, and the ending balance -- but that may be too complicated. Am I the only one that has requested such a report? Thanks, Dan L. Daniel I agree with you that club members want a monthly report like brokers provide that's why we hired a bookkeeper last month to provide club members with monthly change report. I also believe AIRR is a wonderful investment tool but it does not add to the monthly comfort level. Val ----- Original Message ----- From: "Daniel Lapp" <danl@bivio.com> To: <club_cafe@bivio.com> Sent: Saturday, January 13, 2007 2:40 PM Subject: club_cafe: Report Request: Monthly Investment Performance > As club Treasurer, every month I'm asked for a report that > shows our club's investment performance for the month. And > every month I explain that the best that Bivio can do is > print the Investment Performance Report that shows the > Annualized Internal Rate of Return. This report would be > perfectly acceptable if Bivio would print the simple Monthly > Return -- not the AIRR. > > I just don't understand why Bivio can't produce a simple > report that shows a starting date's stock price, an ending > date's stock price, and the percent gained or loss for each > club holding. I'm not asking for number of shares or the > value of the holdings -- just the stock price percentage > change. Forget about the dividends -- just a simple report. > > I'd *love* to also have another report, similiar to my > Fidelity Statement, that shows the starting balance, amount > added, amount withdrawn, investment change, and the ending > balance -- but that may be too complicated. > > Am I the only one that has requested such a report? > > Thanks, Dan L. Val, Club Accounting Online provides a compound annual return column on the valuation statement, which would be a better barometer than a monthly gain. Gene Rooks, Orlando I don't think it's unreasonable to ask for a monthly price change report. But most investment clubs are fundamental investors with a long-term horizon. Many of us find the daily and monthly gyrations of the market outside our focus. Especially seasonal companies, like our retailers or tax preparers whose earnings are better displayed quarter over quarter. In our club, we have stock watchers who are responsible for following the price of their particular stock. We also have Manifest (and so does everyone at Bivio now) to follow PAR. We we are putting in our resquests for this year's improvements, I'd also like to see a sector/industry classification, too! Lynn Ostrem, President garbagecop@earthlink,net Crow River Investment Club www.bivio.com/crowriver Daniel... I have to agree with many responders that a monthly change isn't too important to me, but I think it would help my partners retain their interest because they are interested in seeing how their investments are changing on month to month basis. A report that also shows the month to month changes over a yearly period and compares that to some other index such as the DJ IA, S&P500 or Russell 2000 would be of interest to us. It would be a tool to examine how our stock performs relative to others and to an index, though I don't know how important percentages are when they are broken down into monthly intervals. And, percentages can be misleading since downward and upward percentages are not equal. Keep in mind that a 50% loss required a 100% gain to just get back to the starting point, and in another example, a 30% loss requires a 43% gain to recover. And it also becomes misleading because time periods need to be taken into account. However, I think percentage change comparisons over some recurring time period )monthly/quarterly/annually) over a long time frame and compared to an index would be a great report to have for stock analysis. It would be similar to the investment performance report, but show a series of snapshots rather than a single snapshot in a single report. I agree with your last wish though, but I would add that it should include all asset and capital accounts. For reconciling, I would like a single report that shows by asset and capital account, from user selected starting and ending date inputs: the beginning accounts balances, all account transactions and, ending balances. This would facilitate statement reconciliation between bivio and banks and broker's statements. It would be a paper record to show the reconciliation and proper allocation of the member's deposits from month to month. I realize we have a member's status report, valuation statement and transaction journal, but these are awkward to use to reconcile, especially when viewing all the reports and broker's statements on-line. A single report would help since reconciling requires un-necessarily juggling through multiple open browser windows in bivio and in the broker's and bank's web sites. While I'm at it, a new field of check boxes for transactions, similar to what Quicken uses to indicate a transaction has been reconciled and reviewed would be a great additional feature. John Munn Cross Country Investment Club Capitol Investors Investment Club Daniel Lapp wrote: >As club Treasurer, every month I'm asked for a report that >shows our club's investment performance for the month....cut... > >I'd *love* ... another report, ... that shows the starting balance, amount >added, amount withdrawn, investment change, and the ending >balance ... > John Munn wrote: > A report that also shows the month > to month changes over a yearly period > and compares that to some other index > such as the DJ IA, S&P500 or Russell > 2000 would be of interest to us. You might want to check out the Performance Benchmark report to see your club performance during a time period vs. an index fund. That report is where I get the data for the charts at http://www.bivio.com/irw/files/PublicFiles/Benchmarking/IRRHistory/IRRHistory.html If, however, by "month to month changes over a yearly period" you mean to say you want to compare volatility, then the above won't help. -Jim Thomas >"Val, Club Accounting Online provides a compound annual return column on >the valuation statement, which would be a better barometer than a monthly gain. Gene Rooks, Orlando "< Gene you're assuming it's either or situation. Members want monthly change in addition to annual. Val |
|