Calculating Treynor Ratio of the Mutual Fund Portfolio

Mastering Mutual Fund Investment: Part 3 of 3 Calculating Metrics for a Mutual Fund Portfolio
1 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
€85.19
List Price:  €119.27
You save:  €34.08
£74.77
List Price:  £104.68
You save:  £29.91
CA$137.76
List Price:  CA$192.87
You save:  CA$55.11
A$150.31
List Price:  A$210.44
You save:  A$60.13
S$129.19
List Price:  S$180.88
You save:  S$51.68
HK$778.05
List Price:  HK$1,089.31
You save:  HK$311.25
CHF 79.75
List Price:  CHF 111.66
You save:  CHF 31.90
NOK kr1,013.63
List Price:  NOK kr1,419.13
You save:  NOK kr405.49
DKK kr636.11
List Price:  DKK kr890.58
You save:  DKK kr254.47
NZ$172.26
List Price:  NZ$241.17
You save:  NZ$68.91
د.إ367.21
List Price:  د.إ514.11
You save:  د.إ146.90
৳12,200.05
List Price:  ৳17,080.55
You save:  ৳4,880.50
₹9,057.54
List Price:  ₹12,680.92
You save:  ₹3,623.38
RM409.68
List Price:  RM573.58
You save:  RM163.89
₦145,242.47
List Price:  ₦203,345.27
You save:  ₦58,102.80
₨27,977.78
List Price:  ₨39,170.01
You save:  ₨11,192.23
฿3,144.12
List Price:  ฿4,401.89
You save:  ฿1,257.77
₺4,269.18
List Price:  ₺5,977.02
You save:  ₺1,707.84
B$541.88
List Price:  B$758.66
You save:  B$216.77
R1,687.37
List Price:  R2,362.39
You save:  R675.01
Лв166.49
List Price:  Лв233.10
You save:  Лв66.60
₩147,476.25
List Price:  ₩206,472.65
You save:  ₩58,996.40
₪322.26
List Price:  ₪451.18
You save:  ₪128.91
₱5,910.90
List Price:  ₱8,275.50
You save:  ₱2,364.60
¥15,574.94
List Price:  ¥21,805.54
You save:  ¥6,230.60
MX$1,801.20
List Price:  MX$2,521.76
You save:  MX$720.55
QR363.83
List Price:  QR509.38
You save:  QR145.55
P1,322.75
List Price:  P1,851.91
You save:  P529.15
KSh12,873.43
List Price:  KSh18,023.31
You save:  KSh5,149.88
E£4,753.52
List Price:  E£6,655.12
You save:  E£1,901.60
ብር15,598.69
List Price:  ብር21,838.79
You save:  ብር6,240.10
Kz91,690.83
List Price:  Kz128,370.83
You save:  Kz36,680
CLP$91,015.89
List Price:  CLP$127,425.89
You save:  CLP$36,410
CN¥705.37
List Price:  CN¥987.55
You save:  CN¥282.18
RD$6,384.36
List Price:  RD$8,938.36
You save:  RD$2,554
DA12,968.10
List Price:  DA18,155.86
You save:  DA5,187.76
FJ$227.15
List Price:  FJ$318.02
You save:  FJ$90.87
Q764.64
List Price:  Q1,070.52
You save:  Q305.88
GY$20,885.90
List Price:  GY$29,241.10
You save:  GY$8,355.19
ISK kr12,638.73
List Price:  ISK kr17,694.73
You save:  ISK kr5,056
DH918.43
List Price:  DH1,285.85
You save:  DH367.41
L1,687.62
List Price:  L2,362.74
You save:  L675.11
ден5,239.35
List Price:  ден7,335.30
You save:  ден2,095.95
MOP$800.52
List Price:  MOP$1,120.76
You save:  MOP$320.24
N$1,684.29
List Price:  N$2,358.08
You save:  N$673.78
C$3,674.23
List Price:  C$5,144.07
You save:  C$1,469.83
रु14,445.11
List Price:  रु20,223.73
You save:  रु5,778.62
S/336.11
List Price:  S/470.57
You save:  S/134.45
K425.87
List Price:  K596.24
You save:  K170.36
SAR375.18
List Price:  SAR525.27
You save:  SAR150.08
ZK2,303.63
List Price:  ZK3,225.17
You save:  ZK921.54
L433.54
List Price:  L606.98
You save:  L173.43
Kč2,066.70
List Price:  Kč2,893.46
You save:  Kč826.76
Ft32,795.72
List Price:  Ft45,915.32
You save:  Ft13,119.60
SEK kr926.89
List Price:  SEK kr1,297.69
You save:  SEK kr370.79
ARS$144,060.59
List Price:  ARS$201,690.59
You save:  ARS$57,630
Bs689.81
List Price:  Bs965.76
You save:  Bs275.95
COP$380,209.72
List Price:  COP$532,308.82
You save:  COP$152,099.10
₡49,937.50
List Price:  ₡69,914.50
You save:  ₡19,977
L2,628.31
List Price:  L3,679.75
You save:  L1,051.43
₲670,577.05
List Price:  ₲938,834.69
You save:  ₲268,257.64
$U3,917.97
List Price:  $U5,485.31
You save:  $U1,567.34
zł360.46
List Price:  zł504.66
You save:  zł144.20
Already have an account? Log In

Transcript

Hello, welcome back. As the last part of this section we discuss how to calculate treynor ratio for a mutual fund portfolio. Now, in case you are not aware of what is tender ratio, please refer to the course mastering mutual fund investment, part two of three, we have discussed the different ratios and indicators for mutual fund in that particular course. The formula for calculating treynor ratio is ra minus RF divided by beta p, where r is the expected return from the mutual fund portfolio, RF is the risk free rate and beta p is the beta of the mutual fund portfolio. We now see how to calculate return ratio for a mutual fund portfolio using Excel. So, here on these Excel we have our mutual fund portfolio.

So, here we have the expected return from the portfolio. This is a risk free rate 4% and here is the beta that we have calculated for the mutual fund portfolio. So, now we can put the formula for turnover ratio that is ra minus RF divided by beta. So, we get a trainer ratio of 0.1 to two for this mutual fund portfolio that we have created as a sample. So, we have seen how to calculate a ratio for a mutual fund portfolio. With this, we have come to the end of this section.

And in fact, we have come to the end of this course. Thank you for listening

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.