Performance Reports

Security IRR (Internal Rate of Return)
The security IRR report computes the returns on securities held in selected portfolios over the reporting period. Income and capital gains are totaled and a percentage return is computed based on the “weighted investment.” For investments held during the entire reporting period this is the value of the investment at the start of the reporting period. For investments that were bought or sold during the reporting period this is the value of the investment either at the beginning of the reporting period (if it was held at the beginning of the reporting period) or when it was purchased (if it was purchased during the reporting period) multiplied by the number of days held during the reporting period and divided by the number of days in the reporting period.

Weighted Investment = Starting value * Days Held / Total Days

Note: Security IRR is a raw percentage. It is not annualized and excludes cash and other assets and will therefore not match Portfolio IRR.

Portfolio IRR (Internal Rate of Return)
The Portfolio IRR report computes the internal rate of return (return on investment) for an entire portfolio over a given period of time. The computation is performed by adding all the income (i.e., interest, dividends, other income and both realized and unrealized capital gains) accrued in a portfolio and dividing it by the average net asset value of the portfolio during that period.

Hint: The accuracy of this report is dependent on complete and accurate data entry. If you fail to enter income items such as mutual fund dividend and capital gains distributions, the report will not reflect true returns. In addition, income items must be entered into the portfolio from which they were derived or they will be credited to the wrong portfolio.

Return On Investment
The Return On Investment (ROI) report lists the actual return including dividends on share lots that were held at any time during the reporting period. If the share lot was sold, the ROI reflects the annualized return during the period the shares were held. If the share lot was not sold, the ROI reflects the return from the purchase date to the ending date of the report.

Note: ROI will be listed as zero for share lots that were bought and sold on the same day and share lots having zero cost. ROI will also be listed as zero for any share lots with a present value of zero.

Return On Value
The Return On Value (ROV) report lists the actual return including dividends on share lots that were held during the entire reporting period or optionally, during any portion of the reporting period. The ROV computation differs from the Return On Investment in that ROV includes only the income and unrealized capital gains that were derived during the reporting period whereas the ROI report includes income and capital gains over the entire holding period.

Hint: While the ROI report shows how an investment has performed since it was purchased, the ROV report shows how an investment has performed over a specific holding period.

NOTE: If a holding was sold during the reporting period, any dividend income received after the sale date will not be included in the report since it cannot be assigned to an existing share lot. Therefore, income amounts may not agree with income amounts shown in the Security IRR report.

Theoretical Performance
The Theoretical Performance report computes the annualized yield over the reporting period for all stocks, bonds, options, savings and other assets. The Income Rate column of the report indicates the theoretical income that would be derived from the issue based on the defined annual dividend (for stocks and mutual funds), the coupon rate (for bonds), the interest rate (for savings) and appreciation rate for other assets. The Capital Gain column is based on changes in the price of securities over the period of the report.

Note: The performance is theoretical because the income rate is based on defined income rates and not on actual income received.

Portfolio Change
The Portfolio Change report lists the net worth, and the monetary and percentage change in net worth of selected portfolios between two user specified dates. MI converts the user specified dates to week-ending dates and either computes or retrieves the net worth for those two dates.

Note: Net worth values for the current week are always computed then stored in the Net Worth file. Historic net worth values (for weeks earlier than the current week) are computed only if a net worth value for the specific week is not already available in the Net Worth file. See Recomputing Historical Net Worth for more information.

Price Change
The Price Change report lists the prices and the monetary and percentage change in prices of all securities between two user specified dates.

Price List
The Price List report lists quoted prices (open, high, low, last) and volume for a specified security over a selected time period.

Hint: Use the Export option to create a file containing prices that can be imported by another program. The Export option can create a tab delimited text file that can be imported by most spreadsheet and database programs. You may want to use a text editor to remove page and column header lines before importing the prices into your spreadsheet or other application.