How to Use the Portfolio Return Formula to Calculate Investment Performance

If you’re like most individuals, your funding portfolio’s efficiency is crucial gauge of how properly you’re doing out there and informs the sorts of returns you would possibly anticipate within the years to come back. 

But how precisely do you get an correct image of your portfolio’s efficiency?

Calculating the speed of return could look like a reasonably daunting job. That’s very true while you take a look at the comparatively intimidating formulation utilized in doing so. However, as you’ll discover under, efficiency calculations are literally comparatively easy when you get within the swing of issues.

The Portfolio Return Formula

There are a number of metrics you should use to calculate latest efficiency in addition to future progress potential. 

Since 2017, Masterworks has efficiently bought three work, every realizing a web anualized achieve of +30% per work. (This just isn’t a sign of Masterworks’ total efficiency and previous efficiency just isn’t indicative of future outcomes.)
Get Priority Access

One of probably the most generally used calculations for funding returns is called the portfolio return system. Not solely can you employ this system in its conventional sense to measure your funding success, or lack thereof, it may be expanded to account for inflows and outflows of money. 

Portolio Return Formula

In the portfolio return system above, RP stands for return of the portfolio, w stands for weight of funding, sigma n is the sum of the variety of information factors, r stands for fee of return of funding, and that i stands for particular person worth. 

To discover an correct complete return, you’ll want to search out the load and return of every particular person asset in your portfolio, then decide the weighted common of all particular person returns. 

How to Calculate Investment Performance (With the Portfolio Return Formula)

1. Calculate Expected Return for a Single Investment

Most portfolios are centered round diversification, consisting of a number of particular person investments. The first step to figuring out your portfolio’s return — and subsequently, its anticipated return sooner or later — is to evaluate every particular person asset within the portfolio. 

To achieve this, you’ll want the next:

  • Initial Investment Cost. Include all prices of the funding, together with the value of the asset when it was bought, brokerage charges, and some other charges related to the funding. 
  • Market Value. Next, you’ll want the present market worth to find out the person asset returns. 

Now that you’ve got each of those figures, use the next system to calculate your return:

IR = (MV ÷ II) – 1


  • IR is particular person asset return; 
  • MV is the present market worth of the asset; and 
  • II is the preliminary funding value. 

For instance, for those who invested $10,000 in ABC inventory and your funding grew to $11,000, the equation would lead to a person asset return of 10% and seem like this:

10% = ($11,000 ÷ $10,000) -1

Rinse and repeat the method till you realize the returns of every particular person asset in your portfolio. 

2. Find the Portfolio Weight of Each Asset

In order to find out the efficiency of your complete portfolio, you’ll have to know the load of every asset, or the share of the portfolio that’s allotted to every asset. To achieve this, use the next system:

Asset Value ÷ Total Portfolio Value = Weight

So, preserving with the instance above, if the $11,000 price of ABC inventory is a part of a $100,000 portfolio, the equation would seem like this:

$11,000 ÷ $100,000 = 11% weight

Rinse and repeat till you realize the load of every particular person asset in your portfolio. 

3. Calculate the Expected Return of a Portfolio

Now that you realize the speed of return and weight of every asset in your portfolio, you have got every thing you’ll want to find out the weighted return of your complete portfolio. The finest approach to calculate that is in a spreadsheet like Microsoft Excel or Google Sheets. 

Here’s arrange your sheet:

  • Column A. Asset Name.
  • Column B. Asset Value. 
  • Column C. Asset Weight. 
  • Column D. Asset Returns.
  • Column E. Asset Weighted Returns. 

Once you’ve named your columns, fill out the information in columns A and B utilizing a brand new row for every particular person funding in your portfolio. For instance, for those who’ve received investments in ABC inventory, XYZ inventory, JOSH inventory, DEF mutual fund, and GHI exchange-traded fund (ETF), your spreadsheet would possibly seem like this:

Next, you’ll want so as to add within the returns in your particular person property. Once you achieve this, your spreadsheet will look one thing like this:

Now, it’s time so as to add in weighted return calculations for every asset. To achieve this, you’ll have to multiply the portfolio weight by the asset returns. In the primary open house in column E, kind =C2*D2 and hit enter to have the software program multiply these two values. This is the weighted return of the primary asset in your spreadsheet. 

Now, merely copy the cell and paste the system into the cells within the E column subsequent to every asset. When you do, your spreadsheet will seem like this:

Now, it’s time to take all this information and switch it into the common return throughout your complete portfolio. To achieve this, use the SUM perform so as to add up all of the weighted asset returns. When you do, you’ll see your complete weighted portfolio return, which is 9.23% in our instance.

4. Add Cash Flow to the Mix

There is one important drawback with this system: It doesn’t account for money flows. If you contribute new cash to your funding portfolio, these contributions will seem to inflate the returns. On the opposite hand, while you take cash out of your portfolio, the deductions will lead to artificially deflated returns. 

That reality makes the normal portfolio return system finest when figuring out the returns on a portfolio that hasn’t seen any contributions or deductions through the time interval being coated. If there have been contributions or deductions, you’ll need to calculate every particular person asset’s return utilizing the money-weighted return fee calculation.  

Holding Period Returns – A Simple Approach to Gauging Portfolio Performance

Another approach to go about assessing the return of your portfolio — and arguably the most straightforward — is to calculate holding interval returns, or the returns generated in your portfolio all through the time you’ve held positions inside it. The system for doing so is:

(Income + (End of Period Value – Initial Value)) ÷ Initial Value = Holding Period Return 

For instance, let’s say you began an funding with $5,000. Over the course of a 12 months, you collected $53 in dividends, and the worth of the investments in your portfolio rose to $5,480. In this case, the system to find out your complete portfolio returns is as follows:

($53 + ($5,480 – $5,000)) ÷ $5,000 = 10.66% HPR

Not solely is that this a simplified approach to see how your portfolio is performing and what you possibly can anticipate sooner or later, it does what the extra advanced portfolio return system doesn’t do — it accounts for earnings from dividend and bond coupon funds. 

Calculating Annualized Returns

Rate of return calculations can be utilized over any time interval, and the holding interval you take a look at makes an enormous distinction. 

For instance, if I had been to say the 9.23% return within the portfolio above was generated in a single month, you’d seemingly be keen on how that was completed. On the opposite hand, if I mentioned the 9.23% return was generated over the course of 5 years, the returns would appear lackluster. 

The finest approach to drown out the noise of time is to at all times give attention to annual returns. 

To decide annualized returns, use the steps above to find out your fee of return for annually you’re working to evaluate. Then common every annual return by including them collectively and dividing the sum by the whole variety of years you’re assessing. This will outcome within the common annualized return over the time period that pursuits you. 

Why You Should Calculate Your Expected Return

Keeping tabs on the efficiency of your portfolio is necessary as a result of it exhibits you the way onerous your cash is working for you and the way onerous it’s more likely to be just right for you sooner or later. If you’re not preserving monitor of your returns, your investments could also be experiencing lackluster efficiency in comparison with main benchmarks just like the S&P 500. 

By calculating your returns, you’ll know whether or not your portfolio is doing properly, and if it’s not, you’ll see which property in your portfolio are underperforming and that are delivering. This offers you the chance to exit your positions in underperforming property and open new positions in property recognized to supply compelling returns. 

Ultimately, it’s all about alternative value. Why would you settle for menial positive factors when you have got the chance to supply returns at or above market averages?

Limitations of Performance Measurements

There are a couple of important limitations you must think about when assessing your portfolio’s efficiency:

Performance Metrics are Based on Historical Data

Any metric used to find out the efficiency of an asset, or complete portfolio for that matter, is dependent upon historic information. The basic perception is that historical past within the inventory market tends to repeat itself, and for probably the most half, that’s true. Stocks that carry out properly over lengthy intervals of time are more likely to proceed to carry out properly for the foreseeable future. 

However, though the thought tends to carry up, it’s not 100% correct. If historical past was at all times indicative of the long run, everybody could be wealthy by merely investing within the inventory that traditionally carried out one of the best. A inventory that climbed 50% final 12 months just isn’t assured to do the identical this 12 months. 

Cash Flows Aren’t Accounted For

Most efficiency metrics don’t account for inflows or outflows of money when figuring out the efficiency of your portfolio. Without accounting for money flows, if there have been contributions or withdrawals into or out of your portfolio through the time interval during which efficiency is being assessed, the outcomes of your calculations could seem artificially inflated or deflated. 

Income Should Be Included

Income generated by an funding must be included in any calculation of its efficiency. Unfortunately, earnings is nowhere to be discovered within the portfolio return system. 

One approach to deal with this problem is so as to add any earnings you’ve acquired to the present worth of property within the calculation. 

For instance, for those who personal $10,000 of ABC inventory and acquired $250 in money dividend funds, utilizing the portfolio return system you would use $10,250 as the present worth of ABC inventory to account for the dividends you’ve acquired. The money from the dividend is now not baked into ABC’s share value, however you possibly can hold monitor of it your self.

Final Word

While the system for calculating your returns could appear intimidating, you’ll rapidly get the grasp of it when you begin. It’s necessary to take the time and get to know simply how properly your portfolio is doing, as a result of if it’s not doing properly, addressing the problems as rapidly as doable will make an enormous distinction in your long-term returns. 

Never overlook the ability of compounding positive factors! 

If you haven’t assessed your portfolio shortly, now could be the time to evaluate it. Then, embrace efficiency evaluations as a part of your common rebalancing efforts.