This article was previously published under Q131664
The Investment Performance Report in Microsoft Money and the Total Annualized Return column in the Portfolio show the approximateannualized percentage return that you are receiving on each investment.
An annualized percentage return is the annual profit on an investmentas a percentage of the amount invested. Money uses the Internal Rate ofReturn (IRR) formula to calculate the annualized percentage return oneach investment.
The Internal Rate of Return (IRR) is a standard accounting formula thatprovides a reliable way to compare the performance of different types ofinvestments.
The return is calculated over the full date range of transactions forthe investment, which provides a more realistic approximation.
The IRR is defined as the discount rate at which the present value ofall cash flows related to an investment sum to zero. IRR can be equatedto the bank interest rate that would give the same performance as theinvestment in question. Represented mathematically, the IRR is:
---- 1 \ ---------- * F 0 = / N j ---- (1+i) j jwhere N = number of periods (days) between cash flow number j j and the start of the reporting period.and F = amount of cash flow number j. jand i = internal rate of return per period (day).
Because a cash flow may occur on any day of the year, the period mustbe one day. Therefore, the value for i, which results from this formulamust be compounded for 365 days to become an annual return.
The following items are counted as cash flow:
Cost to buy an investment: The cost basis of the investment is a negative cash flow on the day the investment is purchased.
Dividends, Interest, Capital Gain Distributions, Other Income associated with an investment: The amount of any of these items is a positive cash flow on the transaction date.
Sale proceeds: The proceeds from a sale (price multiplied by quantity, less commission) is a positive cash flow on the transaction date.
Other expenses associated with an investment: This type of transaction is a negative cash flow on the transaction date.
Default Return of Capital: The ending market value of the investment is credited as a positive cash flow on the last day of the reporting period.
Reinvested dividends or interest are not counted as cash flow. Such transactions are sum-zero from a cash flow point of view. The fundswhich come in from the income item are immediately used to purchasemore securities. The income from the transaction affects the performancelater, either as a sale or in the default return of capital item.