The return of two securities for the last five years is given below

Subscribe Now!

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

My Ads

The return of two securities for the last five years is given below:

Year20102011201220132014
Stock-A10%3%13%-2%10%
Stock-B4%5%10%-4%20%

From the above information you are required to calculate the following:

d. Portfolio standard deviation if you invest equally in Stock A and Stock B.

a. Arithmetic mean of two stocks,

b. The standard deviation of two stocks,

c. Covariance between two stocks,


Workings Table

Let 7de41da1 b01d 4b55 950d ea30f66791a7 years.

YearRARB(RA−RˉA​)(RB−RˉB​)(RA−RˉA​)2(RB−RˉB​)2(RA−RˉA​)(RB−RˉB​)
2010104e744cd9c 9163 4043 81ae 04d834e4b9c556dee9d2 e0f2 482a a8ff e0cedac2f70710.249.00-9.60
201135c006f607 cc8c 4107 b0e8 f38e457acceb7de49ede cfbc 4dd6 9de9 f2629acc85eb14.444.007.60
201213102e676cc9 7296 4d7b a3b4 2f0c71ae8c73a6ca3526 2eb7 468f b960 19feff43613638.449.0018.60
2013-2-453c82867 6b60 434b 95ba 8781e0ecb07b3b5140dc 5fc6 4366 b944 3a55aa5dbbd477.44121.0096.80
20141020789d5b56 6a61 4ad2 a677 66c480efa716d5f88885 9bbe 4270 be3d 90c8c0e1b8ba10.24169.0041.60
a3ef3a63 d3ba 4987 9ae6 0c2de871f2a234350.00.0150.80312.00155.00

Solution

a. Arithmetic Mean (e81b11d9 7ef2 4074 a989 71d48283a651)

image 169
  • Stock A:
image 162
  • Stock B:
image 165

b. Standard Deviation (a44946f6 91bf 498b a084 1d33ca1fc15e)

(Using sample formula 88398a8c 309a 47f9 acc7 f4bc5194b916 for historical series data):

image 168
  • Stock A:
image 168
  • Stock B:
image 164

(Note: If using population formula 32b5447b 4575 4ed6 a3f5 ac11a9584903, 794f547e ca5c 4042 a9ab 581094d20e9a and a87dcd03 e0dc 460f bed3 81e4365204da

My Ads

).

c. Covariance (e0fa415c fae8 4283 b615 04b80d7af347)

My Ads

image 166
image 163

(Note: If using population formula 0499eb31 565d 47e5 bb0c f6a47bde8acb, d47218dc cee0 45dd 81a0 390b68c72eb0).

d. Portfolio Standard Deviation (92a81673 63f1 4ee4 8881 4783e9692101)

For equal investment (6d95e61a 075f 4eed baf2 00069136f503, 0dc5c847 9c2c 4d09 aeab a03862af03ec):

image 170
image 167
image 172
image 171

(Note: If using population formula 2344c5b5 591e 42de 9291 f6b785a3f71c, a2533977 95a3 42b0 a178 0f1553d4e0bc).

Summary Table

RequirementMetricResult
a. Mean ReturnStock A / Stock B6.80% / 7.00%
b. Standard DeviationStock A / Stock B6.14% / 8.83%
c. Covariance674b7ef4 c05f 4210 a15d a6a1bf74426738.75
d. Portfolio Standard Deviation78a8065c f30d 4a45 84d2 084d04f312ac (50:50 allocation)6.95%

আরো পড়ুন:

My Ads

Leave a Comment

My Ads