|Course 506: Calculating Your Personal Rate of Return|
|How to Do It|
Here's what you need to calculate personal returns for a single year:
• Your ending balance from the preceding year (for a single fund or for a portfolio of funds). For the sake of our example, let's say the preceding year's balance is $2,500.
• Your ending balance from the year for which you're calculating the returns. In our example, we'll use a final balance of $5,250.
• How much you invested during the year and the months in which you made the investments. In our example, the investments were $1,000 in May and $1,500 in November.
Note that the beginning balance and the investments during the year are negative numbers when you're using a financial calculator or spreadsheet. That's because you're trying to figure out the internal return represented by the difference between the $5,250 you ended up with and the $5,000 you invested ($2,500 beginning balance plus two investments during the year of $1,000 and $1,500).
If you're using a financial calculator, here's what to do:
1. Make a chart of your monthly cash flows. For a portfolio, pool together the cash flows for all of your funds. Assume that all investments during a month are made at the beginning of that month. Sum your initial balance and any January investment for the first month's entry. Also, determine the value of your fund at the end of the holding period. Locate the cash-flow function on your financial calculator and clear the memory of any old data.
2. As your calculator prompts you, enter cash flows. (Inflows are negative and outflows are positive.) Enter 0 for months with no cash flows and enter your ending balance as the final, positive cash flow.
3. Choose the IRR (internal rate of return—another term for personal rate of return) function on your calculator and compute. The result is your monthly personal rate of return.
4. (1) Divide your monthly IRR by 100. (2) Add 1. (3) Raise the number to the 12th power (12 months in a year). (4) Subtract 1. (5) Multiply by 100 to get the annual percentage.
With a spreadsheet program such as Excel, enter the months and cash flows as follows:
Select the IRR function, and you’ll get the monthly personal rate of return for your portfolio. Follow step four above to calculate the Annual IRR.
Next: What Personal Returns Tell You >>
|Learn how to invest like a pro with Morningstar’s Investment Workbooks (John Wiley & Sons, 2004, 2005), available at online bookstores.|
If you have questions or comments please contact Morningstar.