How to calculate the annualized return in Money and in MSN Money Portfolio

This article was previously published under Q131664
This article has been archived. It is offered "as is" and will no longer be updated.
SUMMARY
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.
MORE INFORMATION
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.
w_money 97 6.0 7.0 8.0 dolly money2k money2k1 moneycentral money2k3
Properties

Article ID: 131664 - Last Review: 12/04/2015 11:31:18 - Revision: 3.0

Microsoft Money Plus Deluxe, Microsoft Money Plus Home & Business, Microsoft Money Plus Premium, Microsoft Money 2007 Deluxe, Microsoft Money 2007 Home & Business, Microsoft Money 2007 Premium, Microsoft Money 2006 Deluxe, Microsoft Money 2006 Premium, Microsoft Money 2006 Small Business, Microsoft Money 2006 Standard, Microsoft Money 2005 Deluxe Edition, Microsoft Money 2005 Premium Edition, Microsoft Money 2005 Small Business Edition, Microsoft Money 2005 Standard Edition, Microsoft Money 2004 Deluxe Edition, Microsoft Money 2004 Premium Edition, Microsoft Money 2004 Small Business Edition, Microsoft Money 2004 Standard Edition, Microsoft Money 2003 Deluxe Edition, Microsoft Money 2003 Deluxe and Business Edition, Microsoft Money 2003 Standard Edition, Microsoft Money 2002 Standard Edition, Microsoft Money 2002 Business & Personal Edition, Microsoft Money 2002 Deluxe and Business Edition, Microsoft Money 2001 Standard Edition, Microsoft Money 2001 Business and Personal Edition, Microsoft Money 2001 Deluxe and Business Edition, Microsoft Money 2000 Standard Edition, Microsoft Money 2000 Business & Personal Edition, Microsoft Money 99 Standard Edition, Microsoft Money 98 Standard Edition, Microsoft Money 98 Deluxe Edition, Microsoft Money 98 Financial Suite Edition, Microsoft Money 97 Standard Edition, Microsoft Money 3.0 Standard Edition, Microsoft Money 95

  • kbnosurvey kbarchive kbinfo kbmoneyinvest KB131664
Feedback