Formula to Calculate the Return of Total Portfolio

Portfolio return can be defined as the sum of the product of investment returns earned on the individual asset with the weight class of that individual asset in the entire portfolio. It represents a return on the portfolio and just not on an individual asset.

The expected return can be calculated with a product of potential outcomes (i.e., returns which is represented by r in below) by the weights of each asset in the portfolio (i.e., represented by w), and after that calculating the sum of those results.

You are free to use this image on you website, templates, etc., Please provide us with an attribution linkHow to Provide Attribution?Article Link to be HyperlinkedFor eg:Source: Portfolio Return Formula (wallstreetmojo.com)

Where  ∑ni=1 wi = 1

  • w is the weight of each assetr is the return of an asset

Calculation of Portfolio Return (Step by Step)

Examples

Example #1

Consider ABC Ltd, an asset management companyAsset Management CompanyAn Asset Management Company (AMC) refers to a fund house, which pools money from various sources and invests the same in purchasing capital on behalf of their investors.read more, has invested in 2 different assets along with their return earned last year. You are required to earn a portfolio return.

  • Get the individual asset return in which the funds have been invested in. For example, if an investor has invested in equity, then one needs to calculate the entire return, that is total return, including the interim cash flows, which, in the case of equities, would be a dividend. Calculate the weights of the individual asset in which funds are invested. This can be done by dividing the invested amount of that asset by total fund invested. Take the product of return that is calculated in step 1 with weight, which is calculated in step 2. The third step will be repeated until the calculations of all the assets are completed. Then finally, we need to add up the product of all the individual asset returns by its weight class, which shall be the portfolio return.

Solution:

We are given the individual asset return and along with that investment amount, therefore first we will find out the weights as follows,

  • Weight (Asset Class 1) = 1,00,000.00 / 1,50,000.00 =0.67

Similarly, we have calculated the weight of Asset Class 2

  • Weight (Asset Class 1) = 50,000.00 / 1,50,000.00 =0.33

Now for the calculation of portfolio return, we need to multiply weights with the return of the asset, and then we will sum up those returns.

  • WiRi (Asset ClassAsset ClassAssets are classified into various classes based on their type, purpose, or the basis of return or markets. Fixed assets, equity (equity investments, equity-linked savings schemes), real estate, commodities (gold, silver, bronze), cash and cash equivalents, derivatives (equity, bonds, debt), and alternative investments such as hedge funds and bitcoins are examples.read more 1) = 0.67*10% =6.67%

similarly, we have calculated WiRi for Asset class 2

  • WiRi (Asset Class 2) = 0.33*11%=3.67%

Calculation of portfolio return is as follows,

Portfolio Return

The portfolio return will be 10.33%

Example #2

JP Morgan chase, one of the largest investment banking firms, has made several investments in various asset classes. Mr. Dimon, the company chairman, is interested in knowing the returns on the overall investment done by the firm. You are required to calculate the Portfolio Return.

We are here only given the latest market value, and there are no returns given directly. Hence, first, we need to calculate return on individual assets.

We need to subtract the investment amount from market value to arrive at excess return, and then dividing the same by investment amount will yield our returns on the individual asset.

Note: For detailed calculation, please refer to the excel template.

We now have the individual asset return and along with that investment amount and now we will find out the weights using investment amount and not the market value as follows,

Weight of Equities = 300000000 / 756500000 = 0.3966

Similarly, we have calculated the weight of all the other particulars.

Hence the portfolio return earned by JP Morgan is 21.57%

Example #3

Gautam is an individual who has recently started investing in the market. He has invested in XYZ stock for 100,000, and it has been a year and since then, he has received a dividend of 5,000, and the current market value of XYZ stock is trading at a premium of 10%. Also, he has invested in a fixed deposit for 20,000, and the Bank provides a 7% return on it. And lastly, he has invested in land in his hometown for 500,000, and the current market value is 700,000. He has approached you to calculate portfolio return.

Note: For detailed Calculations, please refer to the excel template.

We now have the individual asset return and along with that investment amount, and now we will find out the weights using investment amount and not the market value.

  • Weight (XYZ Stock) = 1,00,000 / 6,20,000 = 0.1613

Similarly, we have calculated the weight for other particulars as well.

(XYZ Stock) WiRi = 0.15 * 0.1613 = 2.42%

Similarly, we calculated WiRi for other particular as well.

Hence the portfolio return earned by Mr. Gautam is 35.00%

Relevance and Use

It is crucial to understand the concept of the portfolio’s expected return formula as the same will be used by those investors so that they can anticipate the gain or the loss that can happen on the funds that are invested by them. Based on that expected return formulaExpected Return FormulaThe Expected Return formula is determined by applying all the Investments portfolio weights with their respective returns and doing the total of results. Expected return = (p1 * r1) + (p2 * r2) + ………… + (pn * rn), where, pi = Probability of each return and ri = Rate of return with probability. read more, an investor can make a decision as to invest in an asset given their probable returns.

Further, an investor will also be able to decide on the asset’s weight in a portfolio i.e., what proportion of the funds should be invested and then do the required change.

Also, an investor can make use of the expected return formula for ranking the individual asset and further eventually can invest the funds per the ranking and then finally include them in his portfolio. In other words, he would increase the weight of that asset class whose expected return is higher.

This has been a guide to Portfolio Return Formula. Here we discuss how to calculate the return of the total portfolio using its formula along with examples and a downloadable excel template. You can learn more about financial analysis from the following articles –

  • Formula for Rate of ReturnRate of ReturnAbnormal Return DefinitionAbnormal Return DefinitionAbnormal Returns are defined as a variance between the actual return for a stock or a portfolio of securities and the return based on market expectations in a selected time period. It is a key performance measure on which a portfolio manager or an investment manager is gauged.read moreCash Surrender ValueCash Surrender ValueCash surrender value is the money that the life insurance policyholder will receive if they actually withdraw before the completion of policy or his death. This value is at times, lower than the maturity value, depending upon the time passed from the date of initiation of the policy till the date of surrendering it.read more