Close

The Bottom Line: How to Calculate Your Portfolio's Return

The Bottom Line: How To Calculate Your Portfolio's Return Splash image

The question every investor wants to know is:

How well am I doing?

Although some people are satisfied simply watching the dollars grow, most investors want that translated into a performance figure.

Bragging rights aside, there is good reason to determine your own portfolio’s performance: Measuring the performance of your total portfolio is useful to see if the long-term terminal value that you hope to achieve with your investment program is realistic.

In general, you should be examining the return on your portfolio to make sure it is within the target range you expected, based on the investment mix you have settled upon. If it isn’t, you may need to make some adjustments, switching out of underperforming (relative to peers) segments of your portfolio, or you may need to make changes in your future projections—for instance, you may have to increase your savings rate, you may have to take on more risk to achieve the target that you set, or you may simply have to adjust your target value downward, settling for less in the future.

There are two ways you can calculate the return of your portfolio; both are illustrated in Table 1, which provides an example of the calculations.

The Sum of the Parts

The first method is a sum of the individual parts: First, the return for each holding is multiplied by the percentage of the total portfolio market value that the holding represented at the beginning of the period; these “weighted” returns are then added together for the total portfolio return.

The information needed for this calculation method is relatively easy to obtain—if you are monitoring the individual holdings in your portfolio (as you should be), this information should be right at your fingertips.

The market values for your holdings at the beginning and ending of the period are on mutual fund and brokerage account statements.

For the returns of mutual fund holdings, you can use one of the many publications that provide information on mutual fund performance, including AAII’s annual Individual Investor’s Guide to the Top Mutual Funds. If you are investing in stocks on your own, you can use the equations shown in the accompanying box on page 20 for your own stock portfolio return, using the beginning and ending market values for the period on your brokerage account statements. The approximation equation (described more fully in the next section) should be used if you have made additions or withdrawals to your stock portfolio. If you have not made additions or withdrawals, the return equation is your actual return rather than an approximation. Of course, if you have a computer, investment software and websites are available that can perform precise calculations.

Table 1 illustrates the sum-of-the-parts calculation. The first part of the table presents a listing of this investor’s total portfolio holdings during the first quarter. The market value of each holding at the start and end of the period is indicated, along with the percentage of the total portfolio that each holding represents.

The period return column indicates the return over the time period for each portfolio. For the mutual fund holdings, the returns indicated in the table are simply examples. For the individual stock portfolio, the return was calculated using the approximation method because of the net addition to the stock portfolio.

The equation labeled Return Calculation #1 shows how the portfolio return was determined:

 

  • For each holding, the portfolio percentages at the beginning of the period were multiplied by the period returns, and
  • The results for each holding were added together, providing a portfolio return for the period of 4.5%.

Table 1. Measuring Portolio Performance
  Beginning Period
Market Value of Holdings
Return
Over Period
Net Additions
(Withdrawals)
Ending Period
Market Value of Holdings
Current Holdings
(Category)
($) (%) (%) ($) ($) (%)
Balanced Fund
(Balanced: 60%/40%)
30,236.97 18 7.8 -4,000.00 28,439.45 17
Total Return Fund
(Growth & Income)
17,437.94 10 6.6   18,588.84 11
Small-Cap Growth Fund
(Small Cap)
18,396.73 11 2.7   18,893.44 11
Large-Cap Growth Fund
(Growth)
15,387.69 9 3.4   15,910.87 9
International Fund
(International)
14,976.92 9 0.1   14,991.90 9
Individual stock portfolio
(Small Cap)
23,846.94 14 9.4* 1,800.00 27,967.51 16
Bond Fund
(General Bond)
25,968.03 16 4.1   27,032.72 16
Sector Fund 5,578.93 3 –10.0   5,021.04 3
Money Market Fund 16,095.85 10 2.1 -1,800.00 14,614.96 8
Total 167,926.00 100   -4,000.00 171,460.73 100
Return Calculation #1:
[(18% × 7.8) + (10% × 6.6) + (11% × 2.7) + (9% × 3.4) + (9% × 0.1) + (14% × 9.4) + (16% × 4.1) + (3% × –10.0) + (10% × 2.1)] = 4.5%
Return Calculation #2:
171,460.73 - 0.50(-4,000)
167,926.00 + 0.50(-4000)
- 1.00 x 100 = 4.5%


*Return calculation for stock portfolio:
$27,967.51 - 0.50($1,800)
$23,846.94 + 0.50($1,800)
- 1.00 x 100 = 9.4%

The Beginning vs. the End

The second method uses an approximation equation that compares the total market value of all holdings at the end of the period to the total market value of all holdings at the beginning; it also adjusts for the impact of net additions or withdrawals to the overall portfolio.

The approximation equation is shown in the accompanying box. [Note that if there are no additions or withdrawals, there is no need to use an “approximation” equation; you would simply use the first return equation, which is your actual return.]

SPECIAL OFFER: Get AAII membership FREE for 30 days!
Get full access to AAII.com, including our market-beating Model Stock Portfolio, currently outperforming the S&P 500 by 4-to-1. Plus 60 stock screens based on the winning strategies of legendary investors like Warren Start your trial now and get immediate access to our market-beating Model Stock Portfolio (beating the S&P 500 4-to-1) plus 60 stock screens based on the strategies of legendary investors like Warren Buffett and Benjamin Graham. PLUS get unbiased investor education with our award-winning AAII Journal, our comprehensive ETF Guide and more – FREE for 30 days
sign-up

Adjusting for the impact of any net additions or withdrawals is important because money added to the original investment is not part of the investment’s return, but anything the addition earns is part of the return. Also, the timing of the addition or withdrawal can make a difference. For example, if you add $1,000 to a portfolio at the beginning of the year, it works for you (or against you if the investment sours) for a longer time than if you were to put it in at the end of the year, yet in both situations you have added the same amount—$1,000—to the same original portfolio value.

In the approximation equation, the adjustment for additions or withdrawals is made by decreasing the ending value and increasing the beginning value by 50% of the net additions or withdrawals. This method creates a midpoint average for the cash flows no matter when they were actually made. However, the equation is more accurate when additions and withdrawals are relatively periodic, and are not large (greater than 10%) relative to the total portfolio value.

The calculation is illustrated in Table 1 (Return Calculator #2) using the same portfolio as in Calculation #1.

In the example shown here, you can see that there were several withdrawals and additions to individual holdings. However, the overall portfolio had a net withdrawal of $4,000, as this investor apparently decided to use some savings for consumption.

Here’s how Calculation #2 was made:

 

  • The portfolio was valued at $167,926.00 at the beginning of the period, and it was valued at $171,460.73 at the end of the period.
  • The adjusted ending value is $173,460.73 [$171,460.73 – (50% × –$4,000)]; note that subtracting a negative figure is the same as adding a positive number;
  • The adjusted beginning value is $165,926.00 [$167,926.00 + (50% × –4,000)]; note that adding a negative figure is the same as subtracting a positive figure.
  • Dividing the adjusted ending value by the adjusted beginning value indicates the change in value for the period ($173,460.73 ÷ $165,926.00); in this example the ending value is 1.045 times the beginning value.
  • Subtracting 1.00 eliminates the beginning value, so the answer is in the form of an increase in value—the return—which in this example is a gain of 0.045, or 4.5% for the period. The result is the same as the return determined by the first method.

Of course, the resulting answers using the approximation method will not always be precise; in fact, the longer the time period covered, the less precise the approximation. However, it will be close enough for an individual to make informed decisions.

If the ending value after adjusting for net withdrawals or additions is less than the beginning value, the division will produce a figure that is less than 1.00 (for example 0.80); subtracting 1.00 then produces a negative figure [0.80 – 1.00 = –0.20, or –20%], and the return represents a loss.

Calculating Returns
Return Equation
No Additions or Withdrawals:
Ending Value
Beginning Value
- 1.00 x 100 = Return (%)
Approximate Return Equation
Adjusting for Net Additions or Withdrawals:
Ending Value - 0.50(Net Additions*)
Beginning Value + 0.50(Net Additions*)
- 1.00 x 100 = Return
* Use net withdrawals, a negative number, if total withdrawals are greater than total additions.

Performance Comparisons

Measuring the performance of your total portfolio helps you assess the accuracy of the long-term return assumptions you made when determining your asset allocation mix.

While you can compare your portfolio’s actual performance to your assumptions, you should also compare the assumptions and your portfolio performance to an index. Of course, indexes exist for asset classes, not entire portfolios, so you need to “create” your own index. You can do this following the method used in the first return calculation:

 

  • First, determine the percentage of your portfolio that is allocated to each asset class, and multiply the percentage by the total return for the appropriate index (be sure the return reflects price changes and any income generated);
  • The sum of these weighted returns is an appropriate index return that you can use to judge your portfolio’s actual return.

You should also compare this customized index return with the long-term return assumptions you used when you determined your asset allocation mix. If they are close, but your own portfolio returns are off, the individual holdings should be reviewed.

On the other hand, if your long-term assumptions are different than the customized index return, you may want to rethink your original assumptions.

Keep the Outlook Long Term

Taking stock of your total portfolio is necessary to make sure that you will meet your long-term goal.

How often should this be done?

The equations shown here can be used for any length of time—weekly, quarterly, or annually. However, portfolio measurement does not need to be done frequently—once a year is sufficient for most individuals.

If you do measure your portfolio’s performance more frequently—for instance, quarterly—you can determine the annual return by:

 

  • Adding 1.00 to each quarterly return figure (in decimal form),
  • Multiplying the four numbers, and
  • Subtracting 1.00 from the final figure. The result is the annual return in decimal form.

For instance, if the period returns in Table 1 were quarterly, and the prior three quarters were 3%, 1.2%, and 0.2%, the annual return would be: [1.03 × 1.012 × 1.002 × 1.045] – 1.00 = 0.091, or 9.1%.

However, if you measure portfolio performance frequently, don’t make hasty decisions based on short-term results. Use the short-term results to satisfy your curiosity and as a possible warning signal.

But keep in mind that you are assessing a long-term strategy.


Discussion

sri from IA posted over 3 years ago:

Website link is not working.


Jean from IL posted over 3 years ago:

The link to the top portfolio tracking websites has been fixed. Thank you.


Pasi from Finland posted over 2 years ago:

Why not just use TWR (Time-Weighted-Return) calculation instead? There's no need for proxies then.


Elneta from CO posted over 2 years ago:

EZROR is a program which accurately calculates internal rate of return. The only inputs required are the portfolio balance values on the begining and ending dates for the period to be calculated and any intervening additions to or withdrawals from the portfolio. A free 10 day trial version may be downloaded from HamiltonSoftware.com or purchased for $59.95.


James from GA posted over 2 years ago:

What this article is discussing is making an interest rate adjusted discounted cash flow analysis.

Instead of buying ANY software to do this calculation, there is all kinds of FREE software that will do these kinds of calculations.

A related subject (in a corporate environment) is the capital budgeting decision process. It's kind of the same thing from a reverse point of view. In capital budgeting, one spends money now to generate future anticipated cash flows which get interest rate adjusted back to a net present value.

Microsoft Excel (as part of the Microsoft office product) has a TON of financial routines (functions) that do this kind of analysis. Again, we are talking free.

If you have ANY OTHER office product (including Word Perfect), I am sure those products all have the same basic functionality - including the "open source" (free) software available on the web (if you are NOT inclined to pay for any office product).

Happy Trails.


Vaidy Bala from AB posted about 1 month ago:

Greetings to the Investor Professor. This is an important metric that all individual investors are encouraged to do and keep track of. This measure ultimately measures all our decisions made and their effects on dollars as cash flow. The math is not that difficult for most. Excel template, like someone pointed out will just do by entering a few strokes.

I wonder why many of the fee based discount brokerage accounts giving direct computer entry of orders to buy/sell do not provide this software. I am going to suggest to DirectInvesting Royal Bank in Canada.
Thanks for explaining the steps in the calculation.


You need to log in as a registered AAII user before commenting.
Create an account

Log In