StockCentral :: Community

Join in on the discussion with other like-minded investors in our community forums. Learn about the fundamental investing methodology and participate in educational workshops in the Investing forums, stay up-to-date on StockCentral news and make suggestions to the StockCentral team in Central Square, and discuss your favorite stock or recent market news in our A-Z ticker-based forums.

Subject: Investment Account Manager Workshop 2
Prev Topic Next Topic
Note: You must be a StockCentral subscriber and logged in to post messages.
Author Messages

Matt Willms


04/22/2008 9:51 AM  

Hi Again Everyone,

 

Thanks for following along with this introductory workshop regarding our latest release of Investment Account Manager (www.investmentaccountmanager.com). In today’s workshop, we’ll review just a few (of the many) reports and graphs provided by IAM v2.  These reports are comprehensive and provide the information to help you make more educated decisions about what you own, rebalancing changes, and tax planning.

 

Using the supplied data in IAM 2.0, let’s begin by printing one of the most commonly referenced reports, the Appraisal Report.  Select the Reports and Graphs Menu | Portfolio | Appraisal.  Notice a report setup form is shown that allows you to select a report period, add a title, select one or more portfolios to combine for the report, and the asset types to include on the report.  It is important to mention that IAM excels at tracking multiple portfolios, and allows users to combine as they like portfolios for reporting purposes.  Thus, if you have several taxable and nontaxable portfolios, you can track them uniquely but easily combine them for aggregate details.  Select the Report button to create the Appraisal Report (see attached pdf file: iam appraisal report).  The Appraisal – Current Value Report accumulates and values a portfolio, or combination of portfolios, based on the market prices and reporting period selected. The report segregates securities according to type, and provides totals with weighted averages where appropriate.  Note: when selecting 2 or more portfolios for the Appraisal Report, you’ll have the additional option to ‘Segregate Portfolios’ for the report. This option will list all holdings for selected portfolios on a per portfolio basis, with grand totals. 

 

Listed below are other reports for review in today’s workshop.  Sample PDF’s have been provided for each of these.  As before, select the Reports and Graphs Menu | Portfolio | then the listed report. 

 

The Security Basis Report is a useful tax-planning tool, organizing securities according to type and listing each security by purchase lot. Users can filter this report by portfolio or individual asset. The report also acts as an asset allocation tool, identifying the total percentage and dollar amount of asset types in the portfolio.  Note: * on the report indicates reinvestment transactions.  (see attached pdf file: iam basis report).  The attached sample report has been filtered for an individual asset to exemplify the multiple lot/reinvestment tracking tools provided by IAM.   Notice this report illustrates the advantage of dollar cost averaging, a proven method for building long-term success.

The Sold Securities Report compiles important information regarding the sales of securities for a given portfolio. Users can filter this report by portfolio or individual asset.  Sales activity is separated based on Short Term Activity or Long Term Activity.  This is an ideal report for tax planning and filing needs.  By organizing your investments and accounting for sales during the course of the year, investors can then plan year end tax selling as necessary.  (see attached pdf file: iam sold report)

The Income Received Report tracks the investment income and capital gain distributions received by securities in your portfolio. Users can filter this report by portfolio or individual asset.  The report segregates securities according to type, and provides totals based on the range selected for the report.  This is another report helpful for tax planning and filing needs. (see attached pdf file: iam income report)

The Portfolio Allocation Summary Report compiles summary allocation information for the portfolio, identifying allocation by asset class, sector, size and investment objective. This report is segregated in four sections, each section listing allocation. For combined portfolios, benchmark allocation targets will also be shown if ‘combined allocation targets’ have been entered. Users can also select to ‘only show current allocations’ for a single portfolio if they have not entered portfolio targets, or would like to review current allocations only.  (see attached pdf file: iam allocation summary report).  You might also like to print using the demo copy of IAM the individual allocation reports (sector, size, type) to see further details. 

The Portfolio Performance Report calculates the Internal Rate of Return for individual assets and the entire portfolio(s), for various user-defined periods.  The attached sample report shows performance since inception for the sample data (see attached pdf file: iam performance report).  Users can create specific performance reports for user defined periods once historical price library dates have been created. 

I suggest you print other reports provided by IAM.  Feel free to ask any questions you might have on the information provided.  Tomorrow we’ll review the use of StockCentral data with Investment Account Manager.

 

Matt

 



Attachment: iam_allocation_summary_report.pdf
Attachment: iam_appraisal_report.pdf
Attachment: iam_income_report.pdf
Attachment: iam_income_report.pdf
Attachment: iam_performance_report.pdf
Attachment: iam_sold_report.pdf


Bob Weber


04/22/2008 10:18 AM  
I am not able to open any attachments in Matt's workshop # 2. Suggestions appreciated to open pdf attachments.

Thanks

Bob Weber

Peter Upton


04/22/2008 1:24 PM  
The original batch of pdf attachments aren't opening for me either. The two replacements are opening.

By the way, what time zone is this server in? It's 1:23 EDT as I write this and the last post are showing a time of 3:22. Strange!

Peter

ron Dombcik


04/22/2008 2:30 PM  
Just a comment on the performance report. I do not like to show an IRR annualized, not really a revelant statistic. I don't see where we have the option to make that choice since no report editing available.

Matt Willms


04/22/2008 2:36 PM  

Hi Ron,

Thanks for the question. Actually the annualized IRR is very helpful, especially when derived for periods in excess of one year. By annualizing the total return, you much more able to compare how you've done on an actual annual basis. Makes it easy to be able to compare to the suggested 14.9% needed to double every 5 years. In regards to periods less than 1 year, yes, the annualized result is more hypothetical in that it is derived using the elapsed time thus far, less than 1 year. Shorter time frames are less useful than those closing in on 1 year.

Hope that helps...

Matt


ron Dombcik


04/22/2008 2:40 PM  
Matt, I did a performance report that included a new security addition and there is no beginning value (a spin off PM from MO) so MO has a negative - 8.43 IRR for period and PM has an 8000^ IRR for period. Is that the only way this can be displayed?

Matt Willms


04/22/2008 2:48 PM  

Hi Ron,

Based on the report range, if this is using a start date before the spinoff, there would be no beginning value for Philip Morris Int'l since it was still part of Altria. But the report should be showing you that during the date range, if entered properly, the withdrawals from MO and the additions to PM for the spinoff, and correct ending market values for both for the report cutoff date. Check your historic prices and values and you should be seeing accurate results, provided entered correctly. Since you are requesting more along the lines of specific technical support, if you wish to contact me directly on your entries, etc., feel free to use our techsupport email address. That's probably a better place than here in this workshop.

Regards,

Matt


ron Dombcik


04/22/2008 3:05 PM  
Thanks Matt. I really love the program, much better than Captools I used for 8 years and slowly getting a handle on it. I appreciate all you support and attention. Great job.

Matt Willms


04/22/2008 3:10 PM  
Hey Ron,

Thanks for the comments. They are much appreciated! Glad you have found IAM a better replacement for your discontinued Captools program. You know where to find us if you need further help.

Regards,

Matt

Bob Weber


04/22/2008 7:22 PM  

Matt,

Yes I have Abode Reader and the resent 2 attachments opened.  Would you repost the remaining attachments that wouldn't open?

Bob Weber

 

 


Joe Craig
Ellicott City, MD
StockCentral Administrator

04/22/2008 8:32 PM  

I've fixed the attachments to Matt's original message.  They should open now.  The problem was the spaces in the file names confused Acrobat Reader.  You should all be able to click on the links, download, and open the files.

I deleted several of Matt's replies with other attachments.  Now there is only one set of attachments, and I tested them.  Please let me know if there are problems.

 

As for Peter Upton's question -- this server is in the Eastern Time Zone.  There are places where you can set the time zone to yours.  Let me know if you need help with this ...

 

Actually, it's more appropriate to note that messages should be stamped correctly per Eastern time.  My message was posted at 8:32 pm today, and edited at 8:35.


Joe

Matt Willms


04/23/2008 9:54 AM  

Thanks Joe for fixing those pdf files...  Matt

Note: You must be a StockCentral subscriber and logged in to post messages.
Forums > Investing > Workshops > Investment Account Manager Workshop 2



ActiveForums 3.7
 



SIGN UP
I cannot access my account.


Register today for a free 45-day trial!

 

Investment Club Tools Investor Advisory Service Historical data by Historical prices by Instant Stock Analysis by About ICLUBcentral Inc.
myiclubBadge.gif IASBadge.gif HemscottBadge.gif CSIBadge.gif TakeStockBadge.gif ICLUBcentralBadge.gif