It's important to be able to calculate the rate of return on your investment portfolio. This information is necessary to understand your past investment earnings, get a picture of your current financial status and help you make decisions in the future. Unfortunately, many investors do not understand how to accurately calculate their return on investment for their portfolios, especially when it comes to mixed investments and accounting for deposits and withdrawals. When done correctly, calculating your return on investment is very useful for any investor.
Things You'll Need
- Financial calculator
- Portfolio statements
Determine your portfolio balance for a set period of time. The best way to calculate your rate of return is annually, since that is how interest rates are calculated and it's information you should know for your taxes. For each of your investment accounts, look up your balance on the last day of the previous year and then on the first day of the year before that.
Write down the dates and amounts of any deposits and withdrawals for each of these accounts. You will need to account for these separately when calculating your rate of return. Write all the amounts from the year for which you're calculating the rate of return.
List your balances, deposits and withdrawals in terms of cash flow. Your initial balance and each deposit should be considered negative numbers since this is money coming out of your pocket. Similarly, your withdrawals and final balance are positive numbers since this is money going into your pocket.
Use a tool that evaluates the internal rate of return (IRR) equation to calculate your return on investment. A financial calculator will already have the equation programmed, as will Microsoft Excel and other financial computer programs. The IRR equation is complex and difficult to solve by hand with just pencil and paper, especially if you have several deposits and withdrawals.
Enter your initial investment, deposits and withdrawals and final balance in your tool in terms of cash flow as you listed them previously. If you use a financial calculator, enter these values using the cash flow entering instructions specific to your calculator. In Excel, simply enter each cash flow value into a unique cell, all in one column. Then, use the IRR function on your calculator or computer program to calculate the rate of return for your portfolio.
Tips & Warnings
- Rate of return will be displayed as a percentage.
- If you made money, your rate will be positive, and if you lost money, it will be negative.
- Photo Credit investment image by Kit Wai Chan from Fotolia.com a blue empty binder image by timur1970 from Fotolia.com accounts image by Alexey Klementiev from Fotolia.com Accounting and finance image by MAXFX from Fotolia.com
What Is Rate of Return?
Time is money, or so the saying goes. Money isn't spent in a capitalist society without someone looking for something in return,...
How to Calculate Value of Portfolio Returns
Portfolio return is the net change in a portfolio's value over a period. In the simplest case where the portfolio experiences neither...
How to Use Excel To Calculate Investment Portfolio Returns
Excel contains an internal rate of return formula that calculates your annual portfolio return rate.
How to Calculate Investment Rates of Return
Looking at a year-end statement that shows the "rate of return" on investments only tells part of the story on return. Whether...
How to Calculate Portfolio Returns & Deviations
At first glance, it might be hard to understand what portfolio returns have to do with deviations. In the world of investments,...
How to Calculate an IRA Return
An IRA is a retirement savings account where investors can invest in one of many types of investments. Each type of investment...
How to Calculate Portfolio Return
When you invest in a mutual fund, you receive quarterly and annual reports that outline the performance of the fund; but it...
What Is the Rate of Return on an Index Fund?
Index mutual funds take some of the guesswork away from investment decisions. These funds own a set basket of securities to mirror...