fundamentals of finance - course project problem 2cc.oulu.fi/~jope/fof/cp/p2.pdf · course project...
TRANSCRIPT
![Page 1: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/1.jpg)
Course project – Problem 2
Problem 2
1
2
3
60
61
62
63
64
65
66
67
I J K L M N O P Q R
1. Calculate the logarithmic returns of the five stocks.
J2: = LN(B2)−LN(B1)
0.1823 0.2353 0.3687 0.1478 0.3159
0.0075 0.0328− 0.0224 0.0644 0.1754
0.0342− 0.0424− 0.0771 0.0298− 0.1128
0.3786− 0.1588− 0.2047− 0.1444− 0.0762−
Jukka Perttunen Fundamentals of finance
![Page 2: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/2.jpg)
Course project – Problem 2
Problem 2
1
2
3
60
61
62
63
64
65
66
67
I J K L M N O P Q R
1. Calculate the logarithmic returns of the five stocks.
J2: = LN(B2)−LN(B1)
0.1823 0.2353 0.3687 0.1478 0.3159
0.0075 0.0328− 0.0224 0.0644 0.1754
0.0342− 0.0424− 0.0771 0.0298− 0.1128
0.3786− 0.1588− 0.2047− 0.1444− 0.0762−
Jukka Perttunen Fundamentals of finance
![Page 3: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/3.jpg)
Course project – Problem 2
Problem 2
1
2
3
60
61
62
63
64
65
66
67
I J K L M N O P Q R
1. Calculate the logarithmic returns of the five stocks.
J2: = LN(B2)−LN(B1)
0.1823
0.2353 0.3687 0.1478 0.3159
0.0075 0.0328− 0.0224 0.0644 0.1754
0.0342− 0.0424− 0.0771 0.0298− 0.1128
0.3786− 0.1588− 0.2047− 0.1444− 0.0762−
Jukka Perttunen Fundamentals of finance
![Page 4: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/4.jpg)
Course project – Problem 2
Problem 2
1
2
3
60
61
62
63
64
65
66
67
I J K L M N O P Q R
1. Calculate the logarithmic returns of the five stocks.
J2: = LN(B2)−LN(B1)
0.1823 0.2353 0.3687 0.1478 0.3159
0.0075 0.0328− 0.0224 0.0644 0.1754
0.0342− 0.0424− 0.0771 0.0298− 0.1128
0.3786− 0.1588− 0.2047− 0.1444− 0.0762−
Jukka Perttunen Fundamentals of finance
![Page 5: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/5.jpg)
Course project – Problem 2
Problem 2
1
2
3
60
61
62
63
64
65
66
67
I J K L M N O P Q R
0.1823 0.2353 0.3687 0.1478 0.3159
0.0075 0.0328− 0.0224 0.0644 0.1754
0.0342− 0.0424− 0.0771 0.0298− 0.1128
0.3786− 0.1588− 0.2047− 0.1444− 0.0762−
2. Calculate the logarithmic market returns.
P2: = LN(G2)−LN(G1)
0.0960
0.0280
0.0026
0.2035−
Jukka Perttunen Fundamentals of finance
![Page 6: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/6.jpg)
Course project – Problem 2
Problem 2
1
2
3
60
61
62
63
64
65
66
67
I J K L M N O P Q R
0.1823 0.2353 0.3687 0.1478 0.3159
0.0075 0.0328− 0.0224 0.0644 0.1754
0.0342− 0.0424− 0.0771 0.0298− 0.1128
0.3786− 0.1588− 0.2047− 0.1444− 0.0762−
2. Calculate the logarithmic market returns.
P2: = LN(G2)−LN(G1)
0.0960
0.0280
0.0026
0.2035−
Jukka Perttunen Fundamentals of finance
![Page 7: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/7.jpg)
Course project – Problem 2
Problem 2
1
2
3
60
61
62
63
64
65
66
67
I J K L M N O P Q R
0.1823 0.2353 0.3687 0.1478 0.3159
0.0075 0.0328− 0.0224 0.0644 0.1754
0.0342− 0.0424− 0.0771 0.0298− 0.1128
0.3786− 0.1588− 0.2047− 0.1444− 0.0762−
2. Calculate the logarithmic market returns.
P2: = LN(G2)−LN(G1)
0.0960
0.0280
0.0026
0.2035−
Jukka Perttunen Fundamentals of finance
![Page 8: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/8.jpg)
Course project – Problem 2
Problem 2
1
2
3
60
61
62
63
64
65
66
67
I J K L M N O P Q R
0.1823 0.2353 0.3687 0.1478 0.3159
0.0075 0.0328− 0.0224 0.0644 0.1754
0.0342− 0.0424− 0.0771 0.0298− 0.1128
0.3786− 0.1588− 0.2047− 0.1444− 0.0762−
2. Calculate the logarithmic market returns.
P2: = LN(G2)−LN(G1)
0.0960
0.0280
0.0026
0.2035−
Jukka Perttunen Fundamentals of finance
![Page 9: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/9.jpg)
Course project – Problem 2
Problem 2
63
64
65
66
67
68
69
70
71
72
73
74
75
I J K L M N O P Q R
3. Calculate the first row of the annualized covariance matrix of the stock returns.
J63: = 12*COVARIANCE.S($J2:$J61;J2:J61)
0.1497 0.0728 0.0465 0.0582 0.0406
Jukka Perttunen Fundamentals of finance
![Page 10: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/10.jpg)
Course project – Problem 2
Problem 2
63
64
65
66
67
68
69
70
71
72
73
74
75
I J K L M N O P Q R
3. Calculate the first row of the annualized covariance matrix of the stock returns.
J63: = 12*COVARIANCE.S($J2:$J61;J2:J61)
0.1497 0.0728 0.0465 0.0582 0.0406
Jukka Perttunen Fundamentals of finance
![Page 11: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/11.jpg)
Course project – Problem 2
Problem 2
63
64
65
66
67
68
69
70
71
72
73
74
75
I J K L M N O P Q R
3. Calculate the first row of the annualized covariance matrix of the stock returns.
J63: = 12*COVARIANCE.S($J2:$J61;J2:J61)
0.1497
0.0728 0.0465 0.0582 0.0406
Jukka Perttunen Fundamentals of finance
![Page 12: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/12.jpg)
Course project – Problem 2
Problem 2
63
64
65
66
67
68
69
70
71
72
73
74
75
I J K L M N O P Q R
3. Calculate the first row of the annualized covariance matrix of the stock returns.
J63: = 12*COVARIANCE.S($J2:$J61;J2:J61)
0.1497 0.0728 0.0465 0.0582 0.0406
Jukka Perttunen Fundamentals of finance
![Page 13: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/13.jpg)
Course project – Problem 2
Problem 2
63
64
65
66
67
68
69
70
71
72
73
74
75
I J K L M N O P Q R
0.1497 0.0728 0.0465 0.0582 0.0406
4. Calculate the second row of the annualized covariance matrix of the stock returns.
J64: = 12*COVARIANCE.S($K2:$K61;J2:J61)
0.0728 0.1751 0.0649 0.0332 0.0330
Jukka Perttunen Fundamentals of finance
![Page 14: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/14.jpg)
Course project – Problem 2
Problem 2
63
64
65
66
67
68
69
70
71
72
73
74
75
I J K L M N O P Q R
0.1497 0.0728 0.0465 0.0582 0.0406
4. Calculate the second row of the annualized covariance matrix of the stock returns.
J64: = 12*COVARIANCE.S($K2:$K61;J2:J61)
0.0728 0.1751 0.0649 0.0332 0.0330
Jukka Perttunen Fundamentals of finance
![Page 15: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/15.jpg)
Course project – Problem 2
Problem 2
63
64
65
66
67
68
69
70
71
72
73
74
75
I J K L M N O P Q R
0.1497 0.0728 0.0465 0.0582 0.0406
4. Calculate the second row of the annualized covariance matrix of the stock returns.
J64: = 12*COVARIANCE.S($K2:$K61;J2:J61)
0.0728
0.1751 0.0649 0.0332 0.0330
Jukka Perttunen Fundamentals of finance
![Page 16: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/16.jpg)
Course project – Problem 2
Problem 2
63
64
65
66
67
68
69
70
71
72
73
74
75
I J K L M N O P Q R
0.1497 0.0728 0.0465 0.0582 0.0406
4. Calculate the second row of the annualized covariance matrix of the stock returns.
J64: = 12*COVARIANCE.S($K2:$K61;J2:J61)
0.0728 0.1751 0.0649 0.0332 0.0330
Jukka Perttunen Fundamentals of finance
![Page 17: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/17.jpg)
Course project – Problem 2
Problem 2
63
64
65
66
67
68
69
70
71
72
73
74
75
I J K L M N O P Q R
0.1497 0.0728 0.0465 0.0582 0.0406
0.0728 0.1751 0.0649 0.0332 0.0330
5. Calculate the third row of the annualized covariance matrix of the stock returns.
J65: = 12*COVARIANCE.S($L2:$L1;J2:J61)
0.0465 0.0649 0.1161 0.0327 0.0479
Jukka Perttunen Fundamentals of finance
![Page 18: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/18.jpg)
Course project – Problem 2
Problem 2
63
64
65
66
67
68
69
70
71
72
73
74
75
I J K L M N O P Q R
0.1497 0.0728 0.0465 0.0582 0.0406
0.0728 0.1751 0.0649 0.0332 0.0330
5. Calculate the third row of the annualized covariance matrix of the stock returns.
J65: = 12*COVARIANCE.S($L2:$L1;J2:J61)
0.0465 0.0649 0.1161 0.0327 0.0479
Jukka Perttunen Fundamentals of finance
![Page 19: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/19.jpg)
Course project – Problem 2
Problem 2
63
64
65
66
67
68
69
70
71
72
73
74
75
I J K L M N O P Q R
0.1497 0.0728 0.0465 0.0582 0.0406
0.0728 0.1751 0.0649 0.0332 0.0330
5. Calculate the third row of the annualized covariance matrix of the stock returns.
J65: = 12*COVARIANCE.S($L2:$L1;J2:J61)
0.0465
0.0649 0.1161 0.0327 0.0479
Jukka Perttunen Fundamentals of finance
![Page 20: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/20.jpg)
Course project – Problem 2
Problem 2
63
64
65
66
67
68
69
70
71
72
73
74
75
I J K L M N O P Q R
0.1497 0.0728 0.0465 0.0582 0.0406
0.0728 0.1751 0.0649 0.0332 0.0330
5. Calculate the third row of the annualized covariance matrix of the stock returns.
J65: = 12*COVARIANCE.S($L2:$L1;J2:J61)
0.0465 0.0649 0.1161 0.0327 0.0479
Jukka Perttunen Fundamentals of finance
![Page 21: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/21.jpg)
Course project – Problem 2
Problem 2
63
64
65
66
67
68
69
70
71
72
73
74
75
I J K L M N O P Q R
0.1497 0.0728 0.0465 0.0582 0.0406
0.0728 0.1751 0.0649 0.0332 0.0330
0.0465 0.0649 0.1161 0.0327 0.0479
6. Calculate the fourth row of the annualized covariance matrix of the stock returns.
J66: = 12*COVARIANCE.S($M2:$M1;J2:J61)
0.0582 0.0332 0.0327 0.0640 0.0159
Jukka Perttunen Fundamentals of finance
![Page 22: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/22.jpg)
Course project – Problem 2
Problem 2
63
64
65
66
67
68
69
70
71
72
73
74
75
I J K L M N O P Q R
0.1497 0.0728 0.0465 0.0582 0.0406
0.0728 0.1751 0.0649 0.0332 0.0330
0.0465 0.0649 0.1161 0.0327 0.0479
6. Calculate the fourth row of the annualized covariance matrix of the stock returns.
J66: = 12*COVARIANCE.S($M2:$M1;J2:J61)
0.0582 0.0332 0.0327 0.0640 0.0159
Jukka Perttunen Fundamentals of finance
![Page 23: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/23.jpg)
Course project – Problem 2
Problem 2
63
64
65
66
67
68
69
70
71
72
73
74
75
I J K L M N O P Q R
0.1497 0.0728 0.0465 0.0582 0.0406
0.0728 0.1751 0.0649 0.0332 0.0330
0.0465 0.0649 0.1161 0.0327 0.0479
6. Calculate the fourth row of the annualized covariance matrix of the stock returns.
J66: = 12*COVARIANCE.S($M2:$M1;J2:J61)
0.0582
0.0332 0.0327 0.0640 0.0159
Jukka Perttunen Fundamentals of finance
![Page 24: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/24.jpg)
Course project – Problem 2
Problem 2
63
64
65
66
67
68
69
70
71
72
73
74
75
I J K L M N O P Q R
0.1497 0.0728 0.0465 0.0582 0.0406
0.0728 0.1751 0.0649 0.0332 0.0330
0.0465 0.0649 0.1161 0.0327 0.0479
6. Calculate the fourth row of the annualized covariance matrix of the stock returns.
J66: = 12*COVARIANCE.S($M2:$M1;J2:J61)
0.0582 0.0332 0.0327 0.0640 0.0159
Jukka Perttunen Fundamentals of finance
![Page 25: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/25.jpg)
Course project – Problem 2
Problem 2
63
64
65
66
67
68
69
70
71
72
73
74
75
I J K L M N O P Q R
0.1497 0.0728 0.0465 0.0582 0.0406
0.0728 0.1751 0.0649 0.0332 0.0330
0.0465 0.0649 0.1161 0.0327 0.0479
0.0582 0.0332 0.0327 0.0640 0.0159
7. Calculate the fifth row of the annualized covariance matrix of the stock returns.
J67: = 12*COVARIANCE.S($N2:$N1;J2:J61)
0.0406 0.0330 0.0479 0.0159 0.1407
Jukka Perttunen Fundamentals of finance
![Page 26: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/26.jpg)
Course project – Problem 2
Problem 2
63
64
65
66
67
68
69
70
71
72
73
74
75
I J K L M N O P Q R
0.1497 0.0728 0.0465 0.0582 0.0406
0.0728 0.1751 0.0649 0.0332 0.0330
0.0465 0.0649 0.1161 0.0327 0.0479
0.0582 0.0332 0.0327 0.0640 0.0159
7. Calculate the fifth row of the annualized covariance matrix of the stock returns.
J67: = 12*COVARIANCE.S($N2:$N1;J2:J61)
0.0406 0.0330 0.0479 0.0159 0.1407
Jukka Perttunen Fundamentals of finance
![Page 27: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/27.jpg)
Course project – Problem 2
Problem 2
63
64
65
66
67
68
69
70
71
72
73
74
75
I J K L M N O P Q R
0.1497 0.0728 0.0465 0.0582 0.0406
0.0728 0.1751 0.0649 0.0332 0.0330
0.0465 0.0649 0.1161 0.0327 0.0479
0.0582 0.0332 0.0327 0.0640 0.0159
7. Calculate the fifth row of the annualized covariance matrix of the stock returns.
J67: = 12*COVARIANCE.S($N2:$N1;J2:J61)
0.0406
0.0330 0.0479 0.0159 0.1407
Jukka Perttunen Fundamentals of finance
![Page 28: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/28.jpg)
Course project – Problem 2
Problem 2
63
64
65
66
67
68
69
70
71
72
73
74
75
I J K L M N O P Q R
0.1497 0.0728 0.0465 0.0582 0.0406
0.0728 0.1751 0.0649 0.0332 0.0330
0.0465 0.0649 0.1161 0.0327 0.0479
0.0582 0.0332 0.0327 0.0640 0.0159
7. Calculate the fifth row of the annualized covariance matrix of the stock returns.
J67: = 12*COVARIANCE.S($N2:$N1;J2:J61)
0.0406 0.0330 0.0479 0.0159 0.1407
Jukka Perttunen Fundamentals of finance
![Page 29: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/29.jpg)
Course project – Problem 2
Problem 2
63
64
65
66
67
68
69
70
71
72
73
74
75
I J K L M N O P Q R
0.1497 0.0728 0.0465 0.0582 0.0406
0.0728 0.1751 0.0649 0.0332 0.0330
0.0465 0.0649 0.1161 0.0327 0.0479
0.0582 0.0332 0.0327 0.0640 0.0159
0.0406 0.0330 0.0479 0.0159 0.1407
8. Assign the initial weights for the stocks.
P71: = 0.20
0.200
P72: = 0.20
0.200
P73: = 0.20
0.200
P74: = 0.20
0.200
P75: = 0.20
0.200
Jukka Perttunen Fundamentals of finance
![Page 30: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/30.jpg)
Course project – Problem 2
Problem 2
63
64
65
66
67
68
69
70
71
72
73
74
75
I J K L M N O P Q R
0.1497 0.0728 0.0465 0.0582 0.0406
0.0728 0.1751 0.0649 0.0332 0.0330
0.0465 0.0649 0.1161 0.0327 0.0479
0.0582 0.0332 0.0327 0.0640 0.0159
0.0406 0.0330 0.0479 0.0159 0.1407
8. Assign the initial weights for the stocks.
P71: = 0.20
0.200
P72: = 0.20
0.200
P73: = 0.20
0.200
P74: = 0.20
0.200
P75: = 0.20
0.200
Jukka Perttunen Fundamentals of finance
![Page 31: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/31.jpg)
Course project – Problem 2
Problem 2
63
64
65
66
67
68
69
70
71
72
73
74
75
I J K L M N O P Q R
0.1497 0.0728 0.0465 0.0582 0.0406
0.0728 0.1751 0.0649 0.0332 0.0330
0.0465 0.0649 0.1161 0.0327 0.0479
0.0582 0.0332 0.0327 0.0640 0.0159
0.0406 0.0330 0.0479 0.0159 0.1407
8. Assign the initial weights for the stocks.
P71: = 0.20
0.200
P72: = 0.20
0.200
P73: = 0.20
0.200
P74: = 0.20
0.200
P75: = 0.20
0.200
Jukka Perttunen Fundamentals of finance
![Page 32: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/32.jpg)
Course project – Problem 2
Problem 2
63
64
65
66
67
68
69
70
71
72
73
74
75
I J K L M N O P Q R
0.1497 0.0728 0.0465 0.0582 0.0406
0.0728 0.1751 0.0649 0.0332 0.0330
0.0465 0.0649 0.1161 0.0327 0.0479
0.0582 0.0332 0.0327 0.0640 0.0159
0.0406 0.0330 0.0479 0.0159 0.1407
8. Assign the initial weights for the stocks.
P71: = 0.20
0.200
P72: = 0.20
0.200
P73: = 0.20
0.200
P74: = 0.20
0.200
P75: = 0.20
0.200
Jukka Perttunen Fundamentals of finance
![Page 33: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/33.jpg)
Course project – Problem 2
Problem 2
63
64
65
66
67
68
69
70
71
72
73
74
75
I J K L M N O P Q R
0.1497 0.0728 0.0465 0.0582 0.0406
0.0728 0.1751 0.0649 0.0332 0.0330
0.0465 0.0649 0.1161 0.0327 0.0479
0.0582 0.0332 0.0327 0.0640 0.0159
0.0406 0.0330 0.0479 0.0159 0.1407
8. Assign the initial weights for the stocks.
P71: = 0.20
0.200
P72: = 0.20
0.200
P73: = 0.20
0.200
P74: = 0.20
0.200
P75: = 0.20
0.200
Jukka Perttunen Fundamentals of finance
![Page 34: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/34.jpg)
Course project – Problem 2
Problem 2
63
64
65
66
67
68
69
70
71
72
73
74
75
I J K L M N O P Q R
0.1497 0.0728 0.0465 0.0582 0.0406
0.0728 0.1751 0.0649 0.0332 0.0330
0.0465 0.0649 0.1161 0.0327 0.0479
0.0582 0.0332 0.0327 0.0640 0.0159
0.0406 0.0330 0.0479 0.0159 0.1407
8. Assign the initial weights for the stocks.
P71: = 0.20
0.200
P72: = 0.20
0.200
P73: = 0.20
0.200
P74: = 0.20
0.200
P75: = 0.20
0.200
Jukka Perttunen Fundamentals of finance
![Page 35: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/35.jpg)
Course project – Problem 2
Problem 2
63
64
65
66
67
68
69
70
71
72
73
74
75
I J K L M N O P Q R
0.1497 0.0728 0.0465 0.0582 0.0406
0.0728 0.1751 0.0649 0.0332 0.0330
0.0465 0.0649 0.1161 0.0327 0.0479
0.0582 0.0332 0.0327 0.0640 0.0159
0.0406 0.0330 0.0479 0.0159 0.1407
8. Assign the initial weights for the stocks.
P71: = 0.20
0.200
P72: = 0.20
0.200
P73: = 0.20
0.200
P74: = 0.20
0.200
P75: = 0.20
0.200
Jukka Perttunen Fundamentals of finance
![Page 36: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/36.jpg)
Course project – Problem 2
Problem 2
63
64
65
66
67
68
69
70
71
72
73
74
75
I J K L M N O P Q R
0.1497 0.0728 0.0465 0.0582 0.0406
0.0728 0.1751 0.0649 0.0332 0.0330
0.0465 0.0649 0.1161 0.0327 0.0479
0.0582 0.0332 0.0327 0.0640 0.0159
0.0406 0.0330 0.0479 0.0159 0.1407
8. Assign the initial weights for the stocks.
P71: = 0.20
0.200
P72: = 0.20
0.200
P73: = 0.20
0.200
P74: = 0.20
0.200
P75: = 0.20
0.200
Jukka Perttunen Fundamentals of finance
![Page 37: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/37.jpg)
Course project – Problem 2
Problem 2
63
64
65
66
67
68
69
70
71
72
73
74
75
I J K L M N O P Q R
0.1497 0.0728 0.0465 0.0582 0.0406
0.0728 0.1751 0.0649 0.0332 0.0330
0.0465 0.0649 0.1161 0.0327 0.0479
0.0582 0.0332 0.0327 0.0640 0.0159
0.0406 0.0330 0.0479 0.0159 0.1407
8. Assign the initial weights for the stocks.
P71: = 0.20
0.200
P72: = 0.20
0.200
P73: = 0.20
0.200
P74: = 0.20
0.200
P75: = 0.20
0.200
Jukka Perttunen Fundamentals of finance
![Page 38: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/38.jpg)
Course project – Problem 2
Problem 2
63
64
65
66
67
68
69
70
71
72
73
74
75
I J K L M N O P Q R
0.1497 0.0728 0.0465 0.0582 0.0406
0.0728 0.1751 0.0649 0.0332 0.0330
0.0465 0.0649 0.1161 0.0327 0.0479
0.0582 0.0332 0.0327 0.0640 0.0159
0.0406 0.0330 0.0479 0.0159 0.1407
8. Assign the initial weights for the stocks.
P71: = 0.20
0.200
P72: = 0.20
0.200
P73: = 0.20
0.200
P74: = 0.20
0.200
P75: = 0.20
0.200
Jukka Perttunen Fundamentals of finance
![Page 39: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/39.jpg)
Course project – Problem 2
Problem 2
63
64
65
66
67
68
69
70
71
72
73
74
75
I J K L M N O P Q R
0.1497 0.0728 0.0465 0.0582 0.0406
0.0728 0.1751 0.0649 0.0332 0.0330
0.0465 0.0649 0.1161 0.0327 0.0479
0.0582 0.0332 0.0327 0.0640 0.0159
0.0406 0.0330 0.0479 0.0159 0.1407
8. Assign the initial weights for the stocks.
P71: = 0.20
0.200
P72: = 0.20
0.200
P73: = 0.20
0.200
P74: = 0.20
0.200
P75: = 0.20
0.200
Jukka Perttunen Fundamentals of finance
![Page 40: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/40.jpg)
Course project – Problem 2
Problem 2
63
64
65
66
67
68
69
70
71
72
73
74
75
I J K L M N O P Q R
0.1497 0.0728 0.0465 0.0582 0.0406
0.0728 0.1751 0.0649 0.0332 0.0330
0.0465 0.0649 0.1161 0.0327 0.0479
0.0582 0.0332 0.0327 0.0640 0.0159
0.0406 0.0330 0.0479 0.0159 0.1407
0.200
0.200
0.200
0.200
0.200
9. Copy the weights to a row vector.
J69: = P71
0.200
K69: = P72
0.200
L69: = P73
0.200
M69: = P74
0.200
N69: = P75
0.200
Jukka Perttunen Fundamentals of finance
![Page 41: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/41.jpg)
Course project – Problem 2
Problem 2
63
64
65
66
67
68
69
70
71
72
73
74
75
I J K L M N O P Q R
0.1497 0.0728 0.0465 0.0582 0.0406
0.0728 0.1751 0.0649 0.0332 0.0330
0.0465 0.0649 0.1161 0.0327 0.0479
0.0582 0.0332 0.0327 0.0640 0.0159
0.0406 0.0330 0.0479 0.0159 0.1407
0.200
0.200
0.200
0.200
0.200
9. Copy the weights to a row vector.
J69: = P71
0.200
K69: = P72
0.200
L69: = P73
0.200
M69: = P74
0.200
N69: = P75
0.200
Jukka Perttunen Fundamentals of finance
![Page 42: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/42.jpg)
Course project – Problem 2
Problem 2
63
64
65
66
67
68
69
70
71
72
73
74
75
I J K L M N O P Q R
0.1497 0.0728 0.0465 0.0582 0.0406
0.0728 0.1751 0.0649 0.0332 0.0330
0.0465 0.0649 0.1161 0.0327 0.0479
0.0582 0.0332 0.0327 0.0640 0.0159
0.0406 0.0330 0.0479 0.0159 0.1407
0.200
0.200
0.200
0.200
0.200
9. Copy the weights to a row vector.
J69: = P71
0.200
K69: = P72
0.200
L69: = P73
0.200
M69: = P74
0.200
N69: = P75
0.200
Jukka Perttunen Fundamentals of finance
![Page 43: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/43.jpg)
Course project – Problem 2
Problem 2
63
64
65
66
67
68
69
70
71
72
73
74
75
I J K L M N O P Q R
0.1497 0.0728 0.0465 0.0582 0.0406
0.0728 0.1751 0.0649 0.0332 0.0330
0.0465 0.0649 0.1161 0.0327 0.0479
0.0582 0.0332 0.0327 0.0640 0.0159
0.0406 0.0330 0.0479 0.0159 0.1407
0.200
0.200
0.200
0.200
0.200
9. Copy the weights to a row vector.
J69: = P71
0.200
K69: = P72
0.200
L69: = P73
0.200
M69: = P74
0.200
N69: = P75
0.200
Jukka Perttunen Fundamentals of finance
![Page 44: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/44.jpg)
Course project – Problem 2
Problem 2
63
64
65
66
67
68
69
70
71
72
73
74
75
I J K L M N O P Q R
0.1497 0.0728 0.0465 0.0582 0.0406
0.0728 0.1751 0.0649 0.0332 0.0330
0.0465 0.0649 0.1161 0.0327 0.0479
0.0582 0.0332 0.0327 0.0640 0.0159
0.0406 0.0330 0.0479 0.0159 0.1407
0.200
0.200
0.200
0.200
0.200
9. Copy the weights to a row vector.
J69: = P71
0.200
K69: = P72
0.200
L69: = P73
0.200
M69: = P74
0.200
N69: = P75
0.200
Jukka Perttunen Fundamentals of finance
![Page 45: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/45.jpg)
Course project – Problem 2
Problem 2
63
64
65
66
67
68
69
70
71
72
73
74
75
I J K L M N O P Q R
0.1497 0.0728 0.0465 0.0582 0.0406
0.0728 0.1751 0.0649 0.0332 0.0330
0.0465 0.0649 0.1161 0.0327 0.0479
0.0582 0.0332 0.0327 0.0640 0.0159
0.0406 0.0330 0.0479 0.0159 0.1407
0.200
0.200
0.200
0.200
0.200
9. Copy the weights to a row vector.
J69: = P71
0.200
K69: = P72
0.200
L69: = P73
0.200
M69: = P74
0.200
N69: = P75
0.200
Jukka Perttunen Fundamentals of finance
![Page 46: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/46.jpg)
Course project – Problem 2
Problem 2
63
64
65
66
67
68
69
70
71
72
73
74
75
I J K L M N O P Q R
0.1497 0.0728 0.0465 0.0582 0.0406
0.0728 0.1751 0.0649 0.0332 0.0330
0.0465 0.0649 0.1161 0.0327 0.0479
0.0582 0.0332 0.0327 0.0640 0.0159
0.0406 0.0330 0.0479 0.0159 0.1407
0.200
0.200
0.200
0.200
0.200
9. Copy the weights to a row vector.
J69: = P71
0.200
K69: = P72
0.200
L69: = P73
0.200
M69: = P74
0.200
N69: = P75
0.200
Jukka Perttunen Fundamentals of finance
![Page 47: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/47.jpg)
Course project – Problem 2
Problem 2
63
64
65
66
67
68
69
70
71
72
73
74
75
I J K L M N O P Q R
0.1497 0.0728 0.0465 0.0582 0.0406
0.0728 0.1751 0.0649 0.0332 0.0330
0.0465 0.0649 0.1161 0.0327 0.0479
0.0582 0.0332 0.0327 0.0640 0.0159
0.0406 0.0330 0.0479 0.0159 0.1407
0.200
0.200
0.200
0.200
0.200
9. Copy the weights to a row vector.
J69: = P71
0.200
K69: = P72
0.200
L69: = P73
0.200
M69: = P74
0.200
N69: = P75
0.200
Jukka Perttunen Fundamentals of finance
![Page 48: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/48.jpg)
Course project – Problem 2
Problem 2
63
64
65
66
67
68
69
70
71
72
73
74
75
I J K L M N O P Q R
0.1497 0.0728 0.0465 0.0582 0.0406
0.0728 0.1751 0.0649 0.0332 0.0330
0.0465 0.0649 0.1161 0.0327 0.0479
0.0582 0.0332 0.0327 0.0640 0.0159
0.0406 0.0330 0.0479 0.0159 0.1407
0.200
0.200
0.200
0.200
0.200
9. Copy the weights to a row vector.
J69: = P71
0.200
K69: = P72
0.200
L69: = P73
0.200
M69: = P74
0.200
N69: = P75
0.200
Jukka Perttunen Fundamentals of finance
![Page 49: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/49.jpg)
Course project – Problem 2
Problem 2
63
64
65
66
67
68
69
70
71
72
73
74
75
I J K L M N O P Q R
0.1497 0.0728 0.0465 0.0582 0.0406
0.0728 0.1751 0.0649 0.0332 0.0330
0.0465 0.0649 0.1161 0.0327 0.0479
0.0582 0.0332 0.0327 0.0640 0.0159
0.0406 0.0330 0.0479 0.0159 0.1407
0.200
0.200
0.200
0.200
0.200
9. Copy the weights to a row vector.
J69: = P71
0.200
K69: = P72
0.200
L69: = P73
0.200
M69: = P74
0.200
N69: = P75
0.200
Jukka Perttunen Fundamentals of finance
![Page 50: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/50.jpg)
Course project – Problem 2
Problem 2
63
64
65
66
67
68
69
70
71
72
73
74
75
I J K L M N O P Q R
0.1497 0.0728 0.0465 0.0582 0.0406
0.0728 0.1751 0.0649 0.0332 0.0330
0.0465 0.0649 0.1161 0.0327 0.0479
0.0582 0.0332 0.0327 0.0640 0.0159
0.0406 0.0330 0.0479 0.0159 0.1407
0.200
0.200
0.200
0.200
0.200
9. Copy the weights to a row vector.
J69: = P71
0.200
K69: = P72
0.200
L69: = P73
0.200
M69: = P74
0.200
N69: = P75
0.200
Jukka Perttunen Fundamentals of finance
![Page 51: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/51.jpg)
Course project – Problem 2
Problem 2
63
64
65
66
67
68
69
70
71
72
73
74
75
I J K L M N O P Q R
0.1497 0.0728 0.0465 0.0582 0.0406
0.0728 0.1751 0.0649 0.0332 0.0330
0.0465 0.0649 0.1161 0.0327 0.0479
0.0582 0.0332 0.0327 0.0640 0.0159
0.0406 0.0330 0.0479 0.0159 0.1407
0.200
0.200
0.200
0.200
0.200
0.200 0.200 0.200 0.200 0.200
10. Calculate the sum of the weights.
P69: = SUM(P71:P75)
1.000
Jukka Perttunen Fundamentals of finance
![Page 52: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/52.jpg)
Course project – Problem 2
Problem 2
63
64
65
66
67
68
69
70
71
72
73
74
75
I J K L M N O P Q R
0.1497 0.0728 0.0465 0.0582 0.0406
0.0728 0.1751 0.0649 0.0332 0.0330
0.0465 0.0649 0.1161 0.0327 0.0479
0.0582 0.0332 0.0327 0.0640 0.0159
0.0406 0.0330 0.0479 0.0159 0.1407
0.200
0.200
0.200
0.200
0.200
0.200 0.200 0.200 0.200 0.200
10. Calculate the sum of the weights.
P69: = SUM(P71:P75)
1.000
Jukka Perttunen Fundamentals of finance
![Page 53: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/53.jpg)
Course project – Problem 2
Problem 2
63
64
65
66
67
68
69
70
71
72
73
74
75
I J K L M N O P Q R
0.1497 0.0728 0.0465 0.0582 0.0406
0.0728 0.1751 0.0649 0.0332 0.0330
0.0465 0.0649 0.1161 0.0327 0.0479
0.0582 0.0332 0.0327 0.0640 0.0159
0.0406 0.0330 0.0479 0.0159 0.1407
0.200
0.200
0.200
0.200
0.200
0.200 0.200 0.200 0.200 0.200
10. Calculate the sum of the weights.
P69: = SUM(P71:P75)
1.000
Jukka Perttunen Fundamentals of finance
![Page 54: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/54.jpg)
Course project – Problem 2
Problem 2
63
64
65
66
67
68
69
70
71
72
73
74
75
I J K L M N O P Q R
0.1497 0.0728 0.0465 0.0582 0.0406
0.0728 0.1751 0.0649 0.0332 0.0330
0.0465 0.0649 0.1161 0.0327 0.0479
0.0582 0.0332 0.0327 0.0640 0.0159
0.0406 0.0330 0.0479 0.0159 0.1407
0.200
0.200
0.200
0.200
0.200
0.200 0.200 0.200 0.200 0.200 1.000
11. Calculate the weighted covariances.
J71: = $P71*J$69*J63
0.0060
0.0029
0.0019
0.0023
0.0016
0.0029
0.0070
0.0026
0.0013
0.0013
0.0019
0.0026
0.0046
0.0013
0.0019
0.0023
0.0013
0.0013
0.0026
0.0006
0.0016
0.0013
0.0019
0.0006
0.0056
Jukka Perttunen Fundamentals of finance
![Page 55: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/55.jpg)
Course project – Problem 2
Problem 2
63
64
65
66
67
68
69
70
71
72
73
74
75
I J K L M N O P Q R
0.1497 0.0728 0.0465 0.0582 0.0406
0.0728 0.1751 0.0649 0.0332 0.0330
0.0465 0.0649 0.1161 0.0327 0.0479
0.0582 0.0332 0.0327 0.0640 0.0159
0.0406 0.0330 0.0479 0.0159 0.1407
0.200
0.200
0.200
0.200
0.200
0.200 0.200 0.200 0.200 0.200 1.000
11. Calculate the weighted covariances.
J71: = $P71*J$69*J63
0.0060
0.0029
0.0019
0.0023
0.0016
0.0029
0.0070
0.0026
0.0013
0.0013
0.0019
0.0026
0.0046
0.0013
0.0019
0.0023
0.0013
0.0013
0.0026
0.0006
0.0016
0.0013
0.0019
0.0006
0.0056
Jukka Perttunen Fundamentals of finance
![Page 56: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/56.jpg)
Course project – Problem 2
Problem 2
63
64
65
66
67
68
69
70
71
72
73
74
75
I J K L M N O P Q R
0.1497 0.0728 0.0465 0.0582 0.0406
0.0728 0.1751 0.0649 0.0332 0.0330
0.0465 0.0649 0.1161 0.0327 0.0479
0.0582 0.0332 0.0327 0.0640 0.0159
0.0406 0.0330 0.0479 0.0159 0.1407
0.200
0.200
0.200
0.200
0.200
0.200 0.200 0.200 0.200 0.200 1.000
11. Calculate the weighted covariances.
J71: = $P71*J$69*J63
0.0060
0.0029
0.0019
0.0023
0.0016
0.0029
0.0070
0.0026
0.0013
0.0013
0.0019
0.0026
0.0046
0.0013
0.0019
0.0023
0.0013
0.0013
0.0026
0.0006
0.0016
0.0013
0.0019
0.0006
0.0056
Jukka Perttunen Fundamentals of finance
![Page 57: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/57.jpg)
Course project – Problem 2
Problem 2
63
64
65
66
67
68
69
70
71
72
73
74
75
I J K L M N O P Q R
0.1497 0.0728 0.0465 0.0582 0.0406
0.0728 0.1751 0.0649 0.0332 0.0330
0.0465 0.0649 0.1161 0.0327 0.0479
0.0582 0.0332 0.0327 0.0640 0.0159
0.0406 0.0330 0.0479 0.0159 0.1407
0.200
0.200
0.200
0.200
0.200
0.200 0.200 0.200 0.200 0.200 1.000
11. Calculate the weighted covariances.
J71: = $P71*J$69*J63
0.0060
0.0029
0.0019
0.0023
0.0016
0.0029
0.0070
0.0026
0.0013
0.0013
0.0019
0.0026
0.0046
0.0013
0.0019
0.0023
0.0013
0.0013
0.0026
0.0006
0.0016
0.0013
0.0019
0.0006
0.0056
Jukka Perttunen Fundamentals of finance
![Page 58: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/58.jpg)
Course project – Problem 2
Problem 2
63
64
65
66
67
68
69
70
71
72
73
74
75
I J K L M N O P Q R
0.1497 0.0728 0.0465 0.0582 0.0406
0.0728 0.1751 0.0649 0.0332 0.0330
0.0465 0.0649 0.1161 0.0327 0.0479
0.0582 0.0332 0.0327 0.0640 0.0159
0.0406 0.0330 0.0479 0.0159 0.1407
0.200
0.200
0.200
0.200
0.200
0.200 0.200 0.200 0.200 0.200 1.000
11. Calculate the weighted covariances.
J71: = $P71*J$69*J63
0.0060
0.0029
0.0019
0.0023
0.0016
0.0029
0.0070
0.0026
0.0013
0.0013
0.0019
0.0026
0.0046
0.0013
0.0019
0.0023
0.0013
0.0013
0.0026
0.0006
0.0016
0.0013
0.0019
0.0006
0.0056
Jukka Perttunen Fundamentals of finance
![Page 59: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/59.jpg)
Course project – Problem 2
Problem 2
63
64
65
66
67
68
69
70
71
72
73
74
75
I J K L M N O P Q R
0.1497 0.0728 0.0465 0.0582 0.0406
0.0728 0.1751 0.0649 0.0332 0.0330
0.0465 0.0649 0.1161 0.0327 0.0479
0.0582 0.0332 0.0327 0.0640 0.0159
0.0406 0.0330 0.0479 0.0159 0.1407
0.200
0.200
0.200
0.200
0.200
0.200 0.200 0.200 0.200 0.200 1.000
11. Calculate the weighted covariances.
J71: = $P71*J$69*J63
0.0060
0.0029
0.0019
0.0023
0.0016
0.0029
0.0070
0.0026
0.0013
0.0013
0.0019
0.0026
0.0046
0.0013
0.0019
0.0023
0.0013
0.0013
0.0026
0.0006
0.0016
0.0013
0.0019
0.0006
0.0056
Jukka Perttunen Fundamentals of finance
![Page 60: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/60.jpg)
Course project – Problem 2
Problem 2
63
64
65
66
67
68
69
70
71
72
73
74
75
I J K L M N O P Q R
0.1497 0.0728 0.0465 0.0582 0.0406
0.0728 0.1751 0.0649 0.0332 0.0330
0.0465 0.0649 0.1161 0.0327 0.0479
0.0582 0.0332 0.0327 0.0640 0.0159
0.0406 0.0330 0.0479 0.0159 0.1407
0.200
0.200
0.200
0.200
0.200
0.200 0.200 0.200 0.200 0.200 1.000
11. Calculate the weighted covariances.
J71: = $P71*J$69*J63
0.0060
0.0029
0.0019
0.0023
0.0016
0.0029
0.0070
0.0026
0.0013
0.0013
0.0019
0.0026
0.0046
0.0013
0.0019
0.0023
0.0013
0.0013
0.0026
0.0006
0.0016
0.0013
0.0019
0.0006
0.0056
Jukka Perttunen Fundamentals of finance
![Page 61: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/61.jpg)
Course project – Problem 2
Problem 2
63
64
65
66
67
68
69
70
71
72
73
74
75
I J K L M N O P Q R
0.1497 0.0728 0.0465 0.0582 0.0406
0.0728 0.1751 0.0649 0.0332 0.0330
0.0465 0.0649 0.1161 0.0327 0.0479
0.0582 0.0332 0.0327 0.0640 0.0159
0.0406 0.0330 0.0479 0.0159 0.1407
0.200
0.200
0.200
0.200
0.200
0.200 0.200 0.200 0.200 0.200 1.000
11. Calculate the weighted covariances.
J71: = $P71*J$69*J63
0.0060
0.0029
0.0019
0.0023
0.0016
0.0029
0.0070
0.0026
0.0013
0.0013
0.0019
0.0026
0.0046
0.0013
0.0019
0.0023
0.0013
0.0013
0.0026
0.0006
0.0016
0.0013
0.0019
0.0006
0.0056
Jukka Perttunen Fundamentals of finance
![Page 62: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/62.jpg)
Course project – Problem 2
Problem 2
69
70
71
72
73
74
75
76
77
78
79
80
81
I J K L M N O P Q R
0.200
0.200
0.200
0.200
0.200
0.200 0.200 0.200 0.200 0.200 1.000
0.0060
0.0029
0.0019
0.0023
0.0016
0.0029
0.0070
0.0026
0.0013
0.0013
0.0019
0.0026
0.0046
0.0013
0.0019
0.0023
0.0013
0.0013
0.0026
0.0006
0.0016
0.0013
0.0019
0.0006
0.0056
12. Calculate the volatility of the portfolio.
P77: = SQRT(SUM(J71:N75))
0.2480
Jukka Perttunen Fundamentals of finance
![Page 63: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/63.jpg)
Course project – Problem 2
Problem 2
69
70
71
72
73
74
75
76
77
78
79
80
81
I J K L M N O P Q R
0.200
0.200
0.200
0.200
0.200
0.200 0.200 0.200 0.200 0.200 1.000
0.0060
0.0029
0.0019
0.0023
0.0016
0.0029
0.0070
0.0026
0.0013
0.0013
0.0019
0.0026
0.0046
0.0013
0.0019
0.0023
0.0013
0.0013
0.0026
0.0006
0.0016
0.0013
0.0019
0.0006
0.0056
12. Calculate the volatility of the portfolio.
P77: = SQRT(SUM(J71:N75))
0.2480
Jukka Perttunen Fundamentals of finance
![Page 64: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/64.jpg)
Course project – Problem 2
Problem 2
69
70
71
72
73
74
75
76
77
78
79
80
81
I J K L M N O P Q R
0.200
0.200
0.200
0.200
0.200
0.200 0.200 0.200 0.200 0.200 1.000
0.0060
0.0029
0.0019
0.0023
0.0016
0.0029
0.0070
0.0026
0.0013
0.0013
0.0019
0.0026
0.0046
0.0013
0.0019
0.0023
0.0013
0.0013
0.0026
0.0006
0.0016
0.0013
0.0019
0.0006
0.0056
12. Calculate the volatility of the portfolio.
P77: = SQRT(SUM(J71:N75))
0.2480
Jukka Perttunen Fundamentals of finance
![Page 65: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/65.jpg)
Course project – Problem 2
Problem 2
69
70
71
72
73
74
75
76
77
78
79
80
81
I J K L M N O P Q R
0.200
0.200
0.200
0.200
0.200
0.200 0.200 0.200 0.200 0.200 1.000
0.0060
0.0029
0.0019
0.0023
0.0016
0.0029
0.0070
0.0026
0.0013
0.0013
0.0019
0.0026
0.0046
0.0013
0.0019
0.0023
0.0013
0.0013
0.0026
0.0006
0.0016
0.0013
0.0019
0.0006
0.0056
0.2480
13. Calculate the betas of the stocks.
J77: = COVARIANCE.S(J2:J61;$P2:$P61)/VAR.S($P2:$P61)
1.0960 1.3796 0.8848 0.5490 0.5595
Jukka Perttunen Fundamentals of finance
![Page 66: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/66.jpg)
Course project – Problem 2
Problem 2
69
70
71
72
73
74
75
76
77
78
79
80
81
I J K L M N O P Q R
0.200
0.200
0.200
0.200
0.200
0.200 0.200 0.200 0.200 0.200 1.000
0.0060
0.0029
0.0019
0.0023
0.0016
0.0029
0.0070
0.0026
0.0013
0.0013
0.0019
0.0026
0.0046
0.0013
0.0019
0.0023
0.0013
0.0013
0.0026
0.0006
0.0016
0.0013
0.0019
0.0006
0.0056
0.2480
13. Calculate the betas of the stocks.
J77: = COVARIANCE.S(J2:J61;$P2:$P61)/VAR.S($P2:$P61)
1.0960 1.3796 0.8848 0.5490 0.5595
Jukka Perttunen Fundamentals of finance
![Page 67: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/67.jpg)
Course project – Problem 2
Problem 2
69
70
71
72
73
74
75
76
77
78
79
80
81
I J K L M N O P Q R
0.200
0.200
0.200
0.200
0.200
0.200 0.200 0.200 0.200 0.200 1.000
0.0060
0.0029
0.0019
0.0023
0.0016
0.0029
0.0070
0.0026
0.0013
0.0013
0.0019
0.0026
0.0046
0.0013
0.0019
0.0023
0.0013
0.0013
0.0026
0.0006
0.0016
0.0013
0.0019
0.0006
0.0056
0.2480
13. Calculate the betas of the stocks.
J77: = COVARIANCE.S(J2:J61;$P2:$P61)/VAR.S($P2:$P61)
1.0960
1.3796 0.8848 0.5490 0.5595
Jukka Perttunen Fundamentals of finance
![Page 68: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/68.jpg)
Course project – Problem 2
Problem 2
69
70
71
72
73
74
75
76
77
78
79
80
81
I J K L M N O P Q R
0.200
0.200
0.200
0.200
0.200
0.200 0.200 0.200 0.200 0.200 1.000
0.0060
0.0029
0.0019
0.0023
0.0016
0.0029
0.0070
0.0026
0.0013
0.0013
0.0019
0.0026
0.0046
0.0013
0.0019
0.0023
0.0013
0.0013
0.0026
0.0006
0.0016
0.0013
0.0019
0.0006
0.0056
0.2480
13. Calculate the betas of the stocks.
J77: = COVARIANCE.S(J2:J61;$P2:$P61)/VAR.S($P2:$P61)
1.0960 1.3796 0.8848 0.5490 0.5595
Jukka Perttunen Fundamentals of finance
![Page 69: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/69.jpg)
Course project – Problem 2
Problem 2
69
70
71
72
73
74
75
76
77
78
79
80
81
I J K L M N O P Q R
0.200
0.200
0.200
0.200
0.200
0.200 0.200 0.200 0.200 0.200 1.000
0.0060
0.0029
0.0019
0.0023
0.0016
0.0029
0.0070
0.0026
0.0013
0.0013
0.0019
0.0026
0.0046
0.0013
0.0019
0.0023
0.0013
0.0013
0.0026
0.0006
0.0016
0.0013
0.0019
0.0006
0.0056
0.24801.0960 1.3796 0.8848 0.5490 0.5595
14. Calculate the expected returns of the stocks.
J78: = 0.03+0.04*J77
0.0738 0.0852 0.0654 0.0520 0.0524
Jukka Perttunen Fundamentals of finance
![Page 70: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/70.jpg)
Course project – Problem 2
Problem 2
69
70
71
72
73
74
75
76
77
78
79
80
81
I J K L M N O P Q R
0.200
0.200
0.200
0.200
0.200
0.200 0.200 0.200 0.200 0.200 1.000
0.0060
0.0029
0.0019
0.0023
0.0016
0.0029
0.0070
0.0026
0.0013
0.0013
0.0019
0.0026
0.0046
0.0013
0.0019
0.0023
0.0013
0.0013
0.0026
0.0006
0.0016
0.0013
0.0019
0.0006
0.0056
0.24801.0960 1.3796 0.8848 0.5490 0.5595
14. Calculate the expected returns of the stocks.
J78: = 0.03+0.04*J77
0.0738 0.0852 0.0654 0.0520 0.0524
Jukka Perttunen Fundamentals of finance
![Page 71: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/71.jpg)
Course project – Problem 2
Problem 2
69
70
71
72
73
74
75
76
77
78
79
80
81
I J K L M N O P Q R
0.200
0.200
0.200
0.200
0.200
0.200 0.200 0.200 0.200 0.200 1.000
0.0060
0.0029
0.0019
0.0023
0.0016
0.0029
0.0070
0.0026
0.0013
0.0013
0.0019
0.0026
0.0046
0.0013
0.0019
0.0023
0.0013
0.0013
0.0026
0.0006
0.0016
0.0013
0.0019
0.0006
0.0056
0.24801.0960 1.3796 0.8848 0.5490 0.5595
14. Calculate the expected returns of the stocks.
J78: = 0.03+0.04*J77
0.0738
0.0852 0.0654 0.0520 0.0524
Jukka Perttunen Fundamentals of finance
![Page 72: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/72.jpg)
Course project – Problem 2
Problem 2
69
70
71
72
73
74
75
76
77
78
79
80
81
I J K L M N O P Q R
0.200
0.200
0.200
0.200
0.200
0.200 0.200 0.200 0.200 0.200 1.000
0.0060
0.0029
0.0019
0.0023
0.0016
0.0029
0.0070
0.0026
0.0013
0.0013
0.0019
0.0026
0.0046
0.0013
0.0019
0.0023
0.0013
0.0013
0.0026
0.0006
0.0016
0.0013
0.0019
0.0006
0.0056
0.24801.0960 1.3796 0.8848 0.5490 0.5595
14. Calculate the expected returns of the stocks.
J78: = 0.03+0.04*J77
0.0738 0.0852 0.0654 0.0520 0.0524
Jukka Perttunen Fundamentals of finance
![Page 73: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/73.jpg)
Course project – Problem 2
Problem 2
69
70
71
72
73
74
75
76
77
78
79
80
81
I J K L M N O P Q R
0.200
0.200
0.200
0.200
0.200
0.200 0.200 0.200 0.200 0.200 1.000
0.0060
0.0029
0.0019
0.0023
0.0016
0.0029
0.0070
0.0026
0.0013
0.0013
0.0019
0.0026
0.0046
0.0013
0.0019
0.0023
0.0013
0.0013
0.0026
0.0006
0.0016
0.0013
0.0019
0.0006
0.0056
0.24801.0960 1.3796 0.8848 0.5490 0.5595
0.0738 0.0852 0.0654 0.0520 0.0524
15. Calculate the weighted expected returns of the stocks.
J80: = J69*J78
0.0148 0.0170 0.0131 0.0104 0.0105
Jukka Perttunen Fundamentals of finance
![Page 74: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/74.jpg)
Course project – Problem 2
Problem 2
69
70
71
72
73
74
75
76
77
78
79
80
81
I J K L M N O P Q R
0.200
0.200
0.200
0.200
0.200
0.200 0.200 0.200 0.200 0.200 1.000
0.0060
0.0029
0.0019
0.0023
0.0016
0.0029
0.0070
0.0026
0.0013
0.0013
0.0019
0.0026
0.0046
0.0013
0.0019
0.0023
0.0013
0.0013
0.0026
0.0006
0.0016
0.0013
0.0019
0.0006
0.0056
0.24801.0960 1.3796 0.8848 0.5490 0.5595
0.0738 0.0852 0.0654 0.0520 0.0524
15. Calculate the weighted expected returns of the stocks.
J80: = J69*J78
0.0148 0.0170 0.0131 0.0104 0.0105
Jukka Perttunen Fundamentals of finance
![Page 75: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/75.jpg)
Course project – Problem 2
Problem 2
69
70
71
72
73
74
75
76
77
78
79
80
81
I J K L M N O P Q R
0.200
0.200
0.200
0.200
0.200
0.200 0.200 0.200 0.200 0.200 1.000
0.0060
0.0029
0.0019
0.0023
0.0016
0.0029
0.0070
0.0026
0.0013
0.0013
0.0019
0.0026
0.0046
0.0013
0.0019
0.0023
0.0013
0.0013
0.0026
0.0006
0.0016
0.0013
0.0019
0.0006
0.0056
0.24801.0960 1.3796 0.8848 0.5490 0.5595
0.0738 0.0852 0.0654 0.0520 0.0524
15. Calculate the weighted expected returns of the stocks.
J80: = J69*J78
0.0148
0.0170 0.0131 0.0104 0.0105
Jukka Perttunen Fundamentals of finance
![Page 76: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/76.jpg)
Course project – Problem 2
Problem 2
69
70
71
72
73
74
75
76
77
78
79
80
81
I J K L M N O P Q R
0.200
0.200
0.200
0.200
0.200
0.200 0.200 0.200 0.200 0.200 1.000
0.0060
0.0029
0.0019
0.0023
0.0016
0.0029
0.0070
0.0026
0.0013
0.0013
0.0019
0.0026
0.0046
0.0013
0.0019
0.0023
0.0013
0.0013
0.0026
0.0006
0.0016
0.0013
0.0019
0.0006
0.0056
0.24801.0960 1.3796 0.8848 0.5490 0.5595
0.0738 0.0852 0.0654 0.0520 0.0524
15. Calculate the weighted expected returns of the stocks.
J80: = J69*J78
0.0148 0.0170 0.0131 0.0104 0.0105
Jukka Perttunen Fundamentals of finance
![Page 77: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/77.jpg)
Course project – Problem 2
Problem 2
69
70
71
72
73
74
75
76
77
78
79
80
81
I J K L M N O P Q R
0.200
0.200
0.200
0.200
0.200
0.200 0.200 0.200 0.200 0.200 1.000
0.0060
0.0029
0.0019
0.0023
0.0016
0.0029
0.0070
0.0026
0.0013
0.0013
0.0019
0.0026
0.0046
0.0013
0.0019
0.0023
0.0013
0.0013
0.0026
0.0006
0.0016
0.0013
0.0019
0.0006
0.0056
0.24801.0960 1.3796 0.8848 0.5490 0.5595
0.0738 0.0852 0.0654 0.0520 0.0524
0.0148 0.0170 0.0131 0.0104 0.0105
16. Calculate the expected return of the portfolio.
P80: = SUM(J80:N80)
0.0658
Jukka Perttunen Fundamentals of finance
![Page 78: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/78.jpg)
Course project – Problem 2
Problem 2
69
70
71
72
73
74
75
76
77
78
79
80
81
I J K L M N O P Q R
0.200
0.200
0.200
0.200
0.200
0.200 0.200 0.200 0.200 0.200 1.000
0.0060
0.0029
0.0019
0.0023
0.0016
0.0029
0.0070
0.0026
0.0013
0.0013
0.0019
0.0026
0.0046
0.0013
0.0019
0.0023
0.0013
0.0013
0.0026
0.0006
0.0016
0.0013
0.0019
0.0006
0.0056
0.24801.0960 1.3796 0.8848 0.5490 0.5595
0.0738 0.0852 0.0654 0.0520 0.0524
0.0148 0.0170 0.0131 0.0104 0.0105
16. Calculate the expected return of the portfolio.
P80: = SUM(J80:N80)
0.0658
Jukka Perttunen Fundamentals of finance
![Page 79: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/79.jpg)
Course project – Problem 2
Problem 2
69
70
71
72
73
74
75
76
77
78
79
80
81
I J K L M N O P Q R
0.200
0.200
0.200
0.200
0.200
0.200 0.200 0.200 0.200 0.200 1.000
0.0060
0.0029
0.0019
0.0023
0.0016
0.0029
0.0070
0.0026
0.0013
0.0013
0.0019
0.0026
0.0046
0.0013
0.0019
0.0023
0.0013
0.0013
0.0026
0.0006
0.0016
0.0013
0.0019
0.0006
0.0056
0.24801.0960 1.3796 0.8848 0.5490 0.5595
0.0738 0.0852 0.0654 0.0520 0.0524
0.0148 0.0170 0.0131 0.0104 0.0105
16. Calculate the expected return of the portfolio.
P80: = SUM(J80:N80)
0.0658
Jukka Perttunen Fundamentals of finance
![Page 80: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/80.jpg)
Course project – Problem 2
Problem 2
69
70
71
72
73
74
75
76
77
78
79
80
81
I J K L M N O P Q R
0.200
0.200
0.200
0.200
0.200
0.200 0.200 0.200 0.200 0.200 1.000
0.0060
0.0029
0.0019
0.0023
0.0016
0.0029
0.0070
0.0026
0.0013
0.0013
0.0019
0.0026
0.0046
0.0013
0.0019
0.0023
0.0013
0.0013
0.0026
0.0006
0.0016
0.0013
0.0019
0.0006
0.0056
0.24801.0960 1.3796 0.8848 0.5490 0.5595
0.0738 0.0852 0.0654 0.0520 0.0524
0.0148 0.0170 0.0131 0.0104 0.0105 0.0658
17. Calculate the Sharpe ratio of the portfolio.
P81: = (P80−0.03)/P77
0.1442
Jukka Perttunen Fundamentals of finance
![Page 81: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/81.jpg)
Course project – Problem 2
Problem 2
69
70
71
72
73
74
75
76
77
78
79
80
81
I J K L M N O P Q R
0.200
0.200
0.200
0.200
0.200
0.200 0.200 0.200 0.200 0.200 1.000
0.0060
0.0029
0.0019
0.0023
0.0016
0.0029
0.0070
0.0026
0.0013
0.0013
0.0019
0.0026
0.0046
0.0013
0.0019
0.0023
0.0013
0.0013
0.0026
0.0006
0.0016
0.0013
0.0019
0.0006
0.0056
0.24801.0960 1.3796 0.8848 0.5490 0.5595
0.0738 0.0852 0.0654 0.0520 0.0524
0.0148 0.0170 0.0131 0.0104 0.0105 0.0658
17. Calculate the Sharpe ratio of the portfolio.
P81: = (P80−0.03)/P77
0.1442
Jukka Perttunen Fundamentals of finance
![Page 82: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/82.jpg)
Course project – Problem 2
Problem 2
69
70
71
72
73
74
75
76
77
78
79
80
81
I J K L M N O P Q R
0.200
0.200
0.200
0.200
0.200
0.200 0.200 0.200 0.200 0.200 1.000
0.0060
0.0029
0.0019
0.0023
0.0016
0.0029
0.0070
0.0026
0.0013
0.0013
0.0019
0.0026
0.0046
0.0013
0.0019
0.0023
0.0013
0.0013
0.0026
0.0006
0.0016
0.0013
0.0019
0.0006
0.0056
0.24801.0960 1.3796 0.8848 0.5490 0.5595
0.0738 0.0852 0.0654 0.0520 0.0524
0.0148 0.0170 0.0131 0.0104 0.0105 0.0658
17. Calculate the Sharpe ratio of the portfolio.
P81: = (P80−0.03)/P77
0.1442
Jukka Perttunen Fundamentals of finance
![Page 83: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/83.jpg)
Course project – Problem 2
Problem 2
69
70
71
72
73
74
75
76
77
78
79
80
81
I J K L M N O P Q R
0.078−0.097
0.109
0.647
0.225
0.078− 0.097 0.109 0.647 0.225 1.000
0.0009
0.0005−0.0004−0.0029−0.0007−
0.0005−0.0016
0.0007
0.0021
0.0007
0.0004−0.0007
0.0014
0.0023
0.0012
0.0029−0.0021
0.0023
0.0268
0.0023
0.0007−0.0007
0.0012
0.0023
0.0071
0.21731.0960 1.3796 0.8848 0.5490 0.5595
0.0738 0.0852 0.0654 0.0520 0.0524
0.0058− 0.0082 0.0071 0.0336 0.0118 0.0550
0.1151
18. The minimum variance portfolio.
Jukka Perttunen Fundamentals of finance
![Page 84: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/84.jpg)
Course project – Problem 2
Problem 2
69
70
71
72
73
74
75
76
77
78
79
80
81
I J K L M N O P Q R
0.245
0.385
0.210
0.104
0.056
0.245 0.385 0.210 0.104 0.056 1.000
0.0090
0.0069
0.0024
0.0015
0.0006
0.0069
0.0260
0.0052
0.0013
0.0007
0.0024
0.0052
0.0051
0.0007
0.0006
0.0015
0.0013
0.0007
0.0007
0.0001
0.0006
0.0007
0.0006
0.0001
0.0004
0.28481.0960 1.3796 0.8848 0.5490 0.5595
0.0738 0.0852 0.0654 0.0520 0.0524
0.0181 0.0328 0.0137 0.0054 0.0029 0.0730
0.1508
19. The tangent portfolio.
Jukka Perttunen Fundamentals of finance
![Page 85: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/85.jpg)
Course project – Problem 2
Problem 2
69
70
71
72
73
74
75
76
77
78
79
80
81
I J K L M N O P Q R
0.000
0.078
0.111
0.595
0.216
0.000 0.078 0.111 0.595 0.216 1.000
0.0000
0.0000
0.0000
0.0000
0.0000
0.0000
0.0011
0.0006
0.0015
0.0006
0.0000
0.0006
0.0014
0.0022
0.0011
0.0000
0.0015
0.0022
0.0227
0.0020
0.0000
0.0006
0.0011
0.0020
0.0066
0.21851.0960 1.3796 0.8848 0.5490 0.5595
0.0738 0.0852 0.0654 0.0520 0.0524
0.0000 0.0066 0.0072 0.0309 0.0113 0.0561
0.1196
20. The minimum variance portfolio with the non-negativity constraint.
Jukka Perttunen Fundamentals of finance
![Page 86: Fundamentals of finance - Course project Problem 2cc.oulu.fi/~jope/FOF/CP/P2.pdf · Course project { Problem 2 Problem 2 1 2 3 60 61 62 63 64 65 66 67 I J K L M N O P Q R 1. Calculate](https://reader033.vdocuments.us/reader033/viewer/2022042307/5ed2e8384e7ab45be80cee15/html5/thumbnails/86.jpg)
Course project – Problem 2
Problem 2
69
70
71
72
73
74
75
76
77
78
79
80
81
I J K L M N O P Q R
0.245
0.385
0.210
0.104
0.056
0.245 0.385 0.210 0.104 0.056 1.000
0.0090
0.0069
0.0024
0.0015
0.0006
0.0069
0.0260
0.0052
0.0013
0.0007
0.0024
0.0052
0.0051
0.0007
0.0006
0.0015
0.0013
0.0007
0.0007
0.0001
0.0006
0.0007
0.0006
0.0001
0.0004
0.28481.0960 1.3796 0.8848 0.5490 0.5595
0.0738 0.0852 0.0654 0.0520 0.0524
0.0181 0.0328 0.0137 0.0054 0.0029 0.0730
0.1508
21. The tangent portfolio with the non-negativity constraint.
Jukka Perttunen Fundamentals of finance