Calculating Expected Returns of the Mutual Fund Portfolio

Mastering Mutual Fund Investment: Part 3 of 3 Calculating Metrics for a Mutual Fund Portfolio
7 minutes
Share the link to this page
Copied
  Completed
You need to have access to the item to view this lesson.
One-time Fee
$99.99
List Price:  $139.99
You save:  $40
€94.67
List Price:  €132.55
You save:  €37.87
£79.13
List Price:  £110.78
You save:  £31.65
CA$140.19
List Price:  CA$196.27
You save:  CA$56.08
A$153.90
List Price:  A$215.47
You save:  A$61.56
S$133.95
List Price:  S$187.54
You save:  S$53.58
HK$778.23
List Price:  HK$1,089.55
You save:  HK$311.32
CHF 88.29
List Price:  CHF 123.61
You save:  CHF 35.31
NOK kr1,103.93
List Price:  NOK kr1,545.55
You save:  NOK kr441.61
DKK kr706.23
List Price:  DKK kr988.76
You save:  DKK kr282.52
NZ$169.87
List Price:  NZ$237.82
You save:  NZ$67.95
د.إ367.25
List Price:  د.إ514.17
You save:  د.إ146.91
৳11,891.45
List Price:  ৳16,648.51
You save:  ৳4,757.05
₹8,441.95
List Price:  ₹11,819.06
You save:  ₹3,377.11
RM447.25
List Price:  RM626.17
You save:  RM178.92
₦166,762.32
List Price:  ₦233,473.92
You save:  ₦66,711.60
₨27,643.94
List Price:  ₨38,702.63
You save:  ₨11,058.68
฿3,455.42
List Price:  ฿4,837.72
You save:  ฿1,382.30
₺3,458.79
List Price:  ₺4,842.45
You save:  ₺1,383.65
B$580.06
List Price:  B$812.10
You save:  B$232.04
R1,807.38
List Price:  R2,530.41
You save:  R723.02
Лв185.40
List Price:  Лв259.56
You save:  Лв74.16
₩139,431.41
List Price:  ₩195,209.55
You save:  ₩55,778.14
₪373.90
List Price:  ₪523.47
You save:  ₪149.57
₱5,890.51
List Price:  ₱8,246.95
You save:  ₱2,356.43
¥15,375.85
List Price:  ¥21,526.80
You save:  ¥6,150.95
MX$2,023.49
List Price:  MX$2,832.97
You save:  MX$809.47
QR362.91
List Price:  QR508.09
You save:  QR145.18
P1,357.62
List Price:  P1,900.72
You save:  P543.10
KSh12,923.70
List Price:  KSh18,093.70
You save:  KSh5,170
E£4,953.11
List Price:  E£6,934.55
You save:  E£1,981.44
ብር12,318.34
List Price:  ብር17,246.17
You save:  ብር4,927.83
Kz91,240.87
List Price:  Kz127,740.87
You save:  Kz36,500
CLP$97,196.23
List Price:  CLP$136,078.61
You save:  CLP$38,882.38
CN¥723.96
List Price:  CN¥1,013.58
You save:  CN¥289.61
RD$5,995.75
List Price:  RD$8,394.29
You save:  RD$2,398.54
DA13,338.53
List Price:  DA18,674.48
You save:  DA5,335.94
FJ$226.94
List Price:  FJ$317.73
You save:  FJ$90.78
Q768.81
List Price:  Q1,076.37
You save:  Q307.55
GY$20,819.01
List Price:  GY$29,147.45
You save:  GY$8,328.43
ISK kr13,756.62
List Price:  ISK kr19,259.82
You save:  ISK kr5,503.20
DH996.34
List Price:  DH1,394.91
You save:  DH398.57
L1,817.34
List Price:  L2,544.35
You save:  L727.01
ден5,825.76
List Price:  ден8,156.30
You save:  ден2,330.54
MOP$797.89
List Price:  MOP$1,117.08
You save:  MOP$319.18
N$1,802.21
List Price:  N$2,523.16
You save:  N$720.95
C$3,662.39
List Price:  C$5,127.50
You save:  C$1,465.10
रु13,434.94
List Price:  रु18,809.46
You save:  रु5,374.51
S/378.24
List Price:  S/529.55
You save:  S/151.31
K400.31
List Price:  K560.45
You save:  K160.14
SAR375.36
List Price:  SAR525.52
You save:  SAR150.16
ZK2,744.04
List Price:  ZK3,841.77
You save:  ZK1,097.72
L471.18
List Price:  L659.67
You save:  L188.49
Kč2,396.54
List Price:  Kč3,355.25
You save:  Kč958.71
Ft38,535.91
List Price:  Ft53,951.82
You save:  Ft15,415.90
SEK kr1,097.18
List Price:  SEK kr1,536.10
You save:  SEK kr438.91
ARS$99,841.85
List Price:  ARS$139,782.59
You save:  ARS$39,940.73
Bs687.64
List Price:  Bs962.72
You save:  Bs275.08
COP$442,190.80
List Price:  COP$619,084.81
You save:  COP$176,894.01
₡50,678.85
List Price:  ₡70,952.42
You save:  ₡20,273.57
L2,513.64
List Price:  L3,519.20
You save:  L1,005.56
₲775,611.66
List Price:  ₲1,085,887.35
You save:  ₲310,275.69
$U4,292.93
List Price:  $U6,010.28
You save:  $U1,717.34
zł409.79
List Price:  zł573.73
You save:  zł163.93
Already have an account? Log In

Transcript

The first metric that we discuss is the expected return for the mutual fund portfolio. Now expected return for the mutual fund portfolio should give us how much return we can expect from the portfolio of the mutual funds that we have created. The formula for calculating expected returns of a mutual fund portfolio is to find the weighted sum of all the individual expected returns of the mutual funds in the mutual fund portfolio. We will use the following notation and expressing our formula for the expected return of a mutual fund portfolio. Now, er is the expected return of the mutual fund portfolio that we want to determine e ri is the expected return of the higher mutual fund in the mutual fund portfolio. And why is the weight of the higher mutual fund in the mutual fund portfolio.

So, we can write the formula as your is equal to summation over i is equal to one to n Off Wi Fi into E R is in a simpler form, we can write the formula as E r is equal to W one into er one plus w two into er two plus w three into year three, so on and so on up to WN into er n. Now, we will use Excel to calculate the expected returns of a mutual fund portfolio. In Excel we can simply use the function sum product. Now, let us see how we can find the expected return of a mutual fund portfolio using Excel. Now in this Excel, I have planted the different mutual funds which we have included in our portfolio. So you can see the different mutual funds are in the portfolio. Now for each of the mutual funds I have recorded the expected returns, which we have determined from the Economic Times website.

Now we give a location to each of the virtual funds. Let's say we start with a location Getting equal amount of funds to each of the mutual funds. So, we give 10% to each of the mutual funds. So, we are giving 10% to each of the mutual funds. So, this means that we have allocated hundred percent of the money in the 10 mutual funds. Now, let us calculate the expected returns, expected returns like we said can be calculated using the function sum product.

So, we say sum product. Now, we need to give the expected returns as the first parameter and the weights as a second parameter. So, the expected returns now we convert this into a percentage the expected return works out to be 12.4 Zero. Now, let us try to optimize our portfolio. So we go to solver, which is under data. Now, we set the objective function as we want to maximize the expected returns.

So, we select the cell which contains the expected returns and we say maximize, we say that all the values should be non negative. And the values which you want to change are the weights of the different mutual funds, we add the constraints that each weight should be greater than or equal to 5%. And each weight should be less than or equal to 25%. So we do this exercise we take the first weight, make it greater than or equal to the minimum allocation of 5%. So we add all the weights in the constraints with this particular constraint, that is the weight should be greater than 5% So we have to do this process for all the 10 weights. Now we check for that we have added all the weights or not, with this particular constraint that they should be greater than or equal to 5%.

We notice that we have taken from Sensi three from sale row row number three to row number 12. And we have added. Now let's add the constraint that all the weight should be less than or equal to 25%. So, now we have added all the constraints that are assessed have a final check, and we should have two constraints for each of the allocation cells. Once we have done that, select the simplex method now what exactly simplex method, you need to study operation research. Now, after you selected the method didn't say solve, when it says solve, it solves the linear programming problem and gives the solution that we should have under these allocation waters calculated We will get an expected return of 14.38% which is the maximum we can expect.

So, we have seen how to calculate the expected returns for a mutual fund portfolio and also we have seen how to optimize the portfolio so that we get the maximum expected returns. Thank you for listening. See you in the next lecture.

Sign Up

Share

Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.