Trh CP ri riziko "korelaceA,B" I A 0.22 0.3 0.15 Rozhodnutí B 0.31 0.32 Trh Rp SigmaP ratio II A 0.26 0.29 -0.06 I 0.261589242 0.234659406 1.114761376 B 0.34 0.33 II 0.295148765 0.211251174 1.397146151 III A 0.18 0.2 0.09 III 0.224674321 0.183191507 1.226445067 B 0.41 0.38 Trh I Covar_M 0.09 0.0144 0.0144 0.1024 vps 0.18 0.0288 1 0 0.0288 0.2048 1 0 1 1 0 1 wi Rp VarP SigmaP 3.056234719 -3.056234719 0.537897311 1 0.537897311 0.261589242 0.055065037 0.234659406 -3.056234719 3.056234719 0.462102689 2 0.462102689 0.537897311 0.462102689 -0.110130073 lambda1 -0.110130073 zk 1 1 0 0 0 1 0 0 0 1 Trh II Covar_M 0.0841 -0.005742 -0.005742 0.1089 vps 0.1682 -0.011484 1 0 -0.011484 0.2178 1 0 1 1 0 1 wi Rp VarP SigmaP 2.445179085 -2.445179085 0.560640441 1 0.560640441 0.295148765 0.044627059 0.211251174 -2.445179085 2.445179085 0.439359559 2 0.439359559 0.560640441 0.439359559 -0.089254117 lambda1 -0.089254117 zk 1 Trh III Covar_M 0.04 0.00684 0.00684 0.1444 vps 0.08 0.01368 1 0 0.01368 0.2888 1 0 1 1 0 1 wi Rp VarP SigmaP 2.928772259 -2.928772259 0.805763824 1 0.805763824 0.224674321 0.033559128 0.183191507 -2.928772259 2.928772259 0.194236176 2 0.194236176 0.805763824 0.194236176 -0.067118257 lambda1 -0.067118257 zk 1 ##### Sheet/List 2 ##### Firma 1 Firma 2 Firma 3 Kovariance m 0.8 0.3 0.6 s1.2 -0.1 s 1.2 0.8 1.1 s1.3 -0.5 s2.3 0.3 Covar_M 0.332138842 0.379918494 0.287942664 1.44 -0.1 -0.5 -0.1 0.64 0.3 0.158855343 -0.012618569 -0.047818472 -0.5 0.3 1.21 -0.012618569 0.09237636 0.032818423 VPS -0.047818472 0.032818423 0.100322283 2.88 -0.2 -1 1 0 -0.2 1.28 0.6 1 0 0.296316751 -1 0.6 2.42 1 0 1 1 1 0 1 wi Rp VarP SigmaP 0.219575604 -0.230115233 0.010539629 0.332138842 1 0.332138842 0.55245222 0.296316751 0.544349842 1.014884505 -0.230115233 0.641160764 -0.411045531 0.379918494 2 0.379918494 0.010539629 -0.411045531 0.400505902 0.287942664 3 0.287942664 0.332138842 0.379918494 0.287942664 -0.592633502 lambda1 -0.592633502 zk 1 0.449225313 0.132816875 0.417957812 E(Rp) = 0.65 VPS 0.290596869 -0.00596647 -0.093878614 2.88 -0.2 -1 1 0.8 0 -0.00596647 0.011289806 0.016653555 -0.2 1.28 0.6 1 0.3 0 -0.093878614 0.016653555 0.211373367 -1 0.6 2.42 1 0.6 0 1 1 1 0 0 1 0.8 0.3 0.6 0 0 0.65 wi Rp VarP SigmaP 0.08400224 0.056001493 -0.140003733 -0.330968826 1.200298675 1 0.449225313 0.65 0.346876983 0.588962633 1.103635381 0.056001493 0.037334329 -0.093335822 1.779354116 -2.533134217 2 0.132816875 -0.140003733 -0.093335822 0.233339556 -0.44838529 1.332835542 3 0.417957812 -0.330968826 1.779354116 -0.44838529 -3.835982826 5.870823222 lambda1 -0.019947732 1.200298675 -2.533134217 1.332835542 5.870823222 -10.62684338 lambda2 -1.036624977 zk 1 ##### Sheet/List 3 ##### Emise CP1 CP2 CP3 CP4 CP5 CP6 CP7 ri (v %) CP1 80.5 82.7 85.3 85.1 123.9 22 3.5 1.9 CP2 82.7 184.7 131.5 69.4 49.5 58 -9.9 6.1 CP3 85.3 131.5 374.2 384.5 366.5 103.8 343.5 2.9 CP4 85.1 69.4 384.5 684.8 599.1 51.6 502.7 4 CP5 123.9 49.5 366.5 599.1 871.4 -21.2 520.4 5.7 CP6 22 58 103.8 51.6 -21.2 89.7 74.4 3.4 CP7 3.5 -9.9 343.5 502.7 520.4 74.4 574.6 4.9 2.137199771 0.04443472 -0.290668798 -0.230272848 -0.773325871 -1.12240341 1.235036437 VPS 161 165.4 170.6 170.2 247.8 44 7 1 0 367.6936402 7.85367765 -52.98983461 -41.8810356 -204.7759573 -52.77360681 9.238318563 165.4 369.4 263 138.8 99 116 -19.8 1 0 7.85367765 0.364679863 -1.698425925 -0.710108395 -1.700944652 -2.892673482 -0.543297127 170.6 263 748.4 769 733 207.6 687 1 0 -52.98983461 -1.698425925 31.61554051 25.73578923 82.38249347 33.86450601 -123.311882 170.2 138.8 769 1369.6 1198.2 103.2 1005.4 1 0 -41.8810356 -0.710108395 25.73578923 36.31192041 106.6853023 13.33648596 -142.9655466 247.8 99 733 1198.2 1742.8 -42.4 1040.8 1 0 -204.7759573 -1.700944652 82.38249347 106.6853023 521.1258721 -18.40125221 -497.0265612 44 116 207.6 103.2 -42.4 179.4 148.8 1 0 -52.77360681 -2.892673482 33.86450601 13.33648596 -18.40125221 113.0031104 -103.1339576 7 -19.8 687 1005.4 1040.8 148.8 1149.2 1 0 9.238318563 -0.543297127 -123.311882 -142.9655466 -497.0265612 -103.1339576 876.4459992 1 1 1 1 1 1 1 0 1 wi Rp VarP Sigma_P ratio 0.077541972 -0.006186729 0.008788437 -0.009709852 -0.037687458 -0.077748274 0.045001904 2.137199771 1 2.137199771 0.395249927 15.14374206 3.891496121 0.101567602 -0.006186729 0.007803096 -0.003616667 0.000167497 0.001056212 -0.000477668 0.001254258 0.04443472 2 0.04443472 0.008788437 -0.003616667 0.007543944 -0.002286279 -0.004259006 -0.008793788 0.00262336 -0.290668798 3 -0.290668798 -0.009709852 0.000167497 -0.002286279 0.004278044 0.004071768 0.010660407 -0.007181586 -0.230272848 4 -0.230272848 -0.037687458 0.001056212 -0.004259006 0.004071768 0.02058011 0.040174616 -0.023936242 -0.773325871 5 -0.773325871 -0.077748274 -0.000477668 -0.008793788 0.010660407 0.040174616 0.086382111 -0.050197403 -1.12240341 6 -1.12240341 0.045001904 0.001254258 0.00262336 -0.007181586 -0.023936242 -0.050197403 0.032435709 1.235036437 7 1.235036437 2.137199771 0.04443472 -0.290668798 -0.230272848 -0.773325871 -1.12240341 1.235036437 -30.28748412 lambda1 -30.28748412 zk 1 E(Rp) = 5% VPS 0.393500391 0.437029695 -0.655179483 -0.044328174 0.036014728 0.415333712 0.417629131 161 165.4 170.6 170.2 247.8 44 7 1 1.9 0 165.4 369.4 263 138.8 99 116 -19.8 1 6.1 0 12.46482586 14.22203112 -21.99148151 -1.484412384 1.755887217 3.595547509 0.575180292 170.6 263 748.4 769 733 207.6 687 1 2.9 0 14.22203112 35.27676809 -37.65277498 -1.344467347 0.779105534 10.52776359 -1.806911685 170.2 138.8 769 1369.6 1198.2 103.2 1005.4 1 4 0 -21.99148151 -37.65277498 160.6291498 11.16699892 -8.647974707 -28.24586151 -93.98917008 247.8 99 733 1198.2 1742.8 -42.4 1040.8 1 5.7 0 -1.484412384 -1.344467347 11.16699892 1.3456231 -0.956443464 -0.950006826 -9.306352769 44 116 207.6 103.2 -42.4 179.4 148.8 1 3.4 0 1.755887217 0.779105534 -8.647974707 -0.956443464 1.130258656 -0.317112373 7.827232162 7 -19.8 687 1005.4 1040.8 148.8 1149.2 1 4.9 0 3.595547509 10.52776359 -28.24586151 -0.950006826 -0.317112373 15.47343764 12.90508601 1 1 1 1 1 1 1 0 0 1 0.575180292 -1.806911685 -93.98917008 -9.306352769 7.827232162 12.90508601 100.2183368 1.9 6.1 2.9 4 5.7 3.4 4.9 0 0 5 wi Rp VarP Sigma_P ratio 0.016039416 0.007660609 -0.004068331 -0.00315134 -0.009140957 -0.023510276 0.01617088 2.286870663 -0.378674055 1 0.393500391 5 39.86212538 6.313645966 0.791935441 0.007660609 0.00468536 -0.000721958 -0.001309155 -0.00537105 -0.012689387 0.007745581 0.010736227 0.085258694 2 0.437029695 -0.004068331 -0.000721958 0.004856308 -0.000915259 0.001708481 0.002544365 -0.003403606 -0.259380927 -0.079159711 3 -0.655179483 -0.00315134 -0.001309155 -0.000915259 0.003578658 0.001027626 0.004876574 -0.004107102 -0.246233458 0.040381057 4 -0.044328174 -0.009140957 -0.00537105 0.001708481 0.001027626 0.00733021 0.01499997 -0.01055428 -0.842795834 0.175762112 5 0.036014728 -0.023510276 -0.012689387 0.002544365 0.004876574 0.01499997 0.038550595 -0.024771841 -1.254395478 0.333945838 6 0.415333712 0.01617088 0.007745581 -0.003403606 -0.004107102 -0.01055428 -0.024771841 0.018920369 1.305198807 -0.177513935 7 0.417629131 2.286870663 0.010736227 -0.259380927 -0.246233458 -0.842795834 -1.254395478 1.305198807 -30.65171899 0.921530536 lambda1 -26.04406632 -0.378674055 0.085258694 -0.079159711 0.040381057 0.175762112 0.333945838 -0.177513935 0.921530536 -2.331513485 lambda2 -10.73603689 zk 1 ##### Sheet/List 4 ##### Riziková portfolia A B C D 6.20% 4% 7.50% 8.40% rf 0.035 14.50% 9.70% 17% 20% 1 2 3 4 5 0.2 0.4 0.5 0.6 0.8 Portfolio 0.8 0.6 0.5 0.4 0.2 Rp Portfolio A 0.0566 0.0512 0.0485 0.0458 0.0404 B 0.039 0.038 0.0375 0.037 0.036 C 0.067 0.059 0.055 0.051 0.043 D 0.0742 0.0644 0.0595 0.0546 0.0448 VarP Portfolio A 0.013456 0.007569 0.00525625 0.003364 0.000841 B 0.00602176 0.00338724 0.00235225 0.00150544 0.00037636 C 0.018496 0.010404 0.007225 0.004624 0.001156 D 0.0256 0.0144 0.01 0.0064 0.0016 SigmaP Portfolio A 0.116 0.087 0.0725 0.058 0.029 B 0.0776 0.0582 0.0485 0.0388 0.0194 C 0.136 0.102 0.085 0.068 0.034 D 0.16 0.12 0.1 0.08 0.04 ratio A 0.487931034 0.588505747 0.668965517 0.789655172 1.393103448 B 0.50257732 0.652920962 0.773195876 0.953608247 1.855670103 C 0.492647059 0.578431373 0.647058824 0.75 1.264705882 D 0.46375 0.536666667 0.595 0.6825 1.12