Microsoft KB Archive/131664

From BetaArchive Wiki
Knowledge Base


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

Article ID: 131664

Article Last Modified on 8/1/2007



APPLIES TO

  • 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



This article was previously published under Q131664


SUMMARY

The Investment Performance Report in Microsoft Money and the Total Annualized Return column in the Portfolio show the approximate annualized percentage return that you are receiving on each investment.

An annualized percentage return is the annual profit on an investment as a percentage of the amount invested. Money uses the Internal Rate of Return (IRR) formula to calculate the annualized percentage return on each investment.

MORE INFORMATION

The Internal Rate of Return (IRR) is a standard accounting formula that provides a reliable way to compare the performance of different types of investments.

The return is calculated over the full date range of transactions for the investment, which provides a more realistic approximation.

The IRR is defined as the discount rate at which the present value of all cash flows related to an investment sum to zero. IRR can be equated to the bank interest rate that would give the same performance as the investment in question. Represented mathematically, the IRR is:

           ----      1
           \     ---------- * F
     0 =   /            N      j
           ----    (1+i) j
             j


where 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.
       j

and   i = internal rate of return per period (day).
                

Because a cash flow may occur on any day of the year, the period must be one day. Therefore, the value for i, which results from this formula must 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 funds which come in from the income item are immediately used to purchase more securities. The income from the transaction affects the performance later, either as a sale or in the default return of capital item.


Additional query words: w_money 97 6.0 7.0 8.0 dolly money2k money2k1 moneycentral money2k3

Keywords: kbinfo kbmoneyinvest KB131664