From the return of stock A and B over the past five years, determine the coefficient of variation

Subscribe Now!

সর্বশেষ চাকরির খবর মিস করবেন না! Subscribe - এ ক্লিক করে দেখুন নতুন নিয়োগ বিজ্ঞপ্তি।

From the return of stock A and B over the past five years, determine the coefficient of variation. Which stock would you like to invest in considering the coefficient of variation?

YearReturn AReturn B
20117%12%
20129%15%
201310%-16%
2014-12%20%
201516%18%

Workings Table

Let 20932328 4270 4139 ba98 377dbcb4b558 years.

YearRA​ (%)RB​ (%)(RA−RˉA​)(RB−RˉB​)(RA−RˉA​)2(RB−RˉB​)2
2011712f4eb5bee 97d7 42fa 8fba f69f16c472ee30213dd6 0388 49e9 ab3c 2881a3ff368714.84
20129153aef2ffc a5f2 4773 b52d 9b7c7655e1843a295df2 ae4c 44f0 8cf2 2908bbd15cdf927.04
201310-1602295706 bde1 4b4d 89f4 681caf43a06dd9575509 3a2a 4c66 b278 0ea1776be0b416665.64
2014-122032fe8b8b ccb3 4aa4 a3c0 6ddbeca5a6550384948a 4ea8 46c6 afaa a66cf4bc944a324104.04
2015161827f0613f 80af 4f37 86a9 df54741b94170124bd99 bbd9 4edd 980f 5c963c0a6d4010067.24
0c28712c cbdc 49ce 92fc 3bcd5bcdffdf304900450.00868.80

Solution

1. Mean Return (47134bf2 8e83 4f9c 884d 1170b260f6f8)

image 185
  • Stock A:
image 188
  • Stock B:
image 187

2. Standard Deviation (296cce7e 1eb9 4c81 a6ce ca732afc5385)

(Using sample formula 27df6fbe 7453 4289 acad 14c0e7d2944b for historical series data):

image 186
  • Stock A:
image 185
  • Stock B:
image 189

(Note: If using the population formula with 8804efca e706 4f19 a54d 257a7c341ed0, then 8a9d1ddd 5329 460d b18a faf97c4828b7 and 6d2f0df8 6b64 4a5c afa5 da543adba20a).

3. Coefficient of Variation (2b587771 08b7 4863 8f1e 4594850aa2e2)

image 186
  • Stock A:
image 186
  • Stock B:
image 190

(Note: Using the population standard deviation gives 683690fe 7bd8 42c0 a063 d2b0e82e7fd3 and 1746b574 ebb5 497d 93df ded2dfd04b09).

Decision & Recommendation

I would prefer to invest in Stock B.

Reason:

The Coefficient of Variation measures risk per unit of return. A lower CV indicates a better risk-return tradeoff. Since Stock B has a lower CV (f06f6dfa efe2 478d 9c94 370be864e739) than Stock A (dd3a83d1 2f11 4c19 83fd ef388a51aced), Stock B provides a higher return for every unit of risk taken.

আরো পড়ুন:

Leave a Comment