10 11 17 13 14 15 16 17 18 P24 19 20 21 23 23 24 25 26 27 28 1 GR1) 2 SD1 30 31 32 34 36 37 58 39 40 43 44 45 46 47 50 5

[answerhappygod]

10 11 17 13 14 15 16 17 18 P24 19 20 21 23 23 24 25 26 27 28 1 Gr1 2 Sd1 30 31 32 34 36 37 58 39 40 43 44 45 46 47 50 5 1 (518.08 KiB) Viewed 23 times

10 11 17 13 14 15 16 17 18 P24 19 20 21 23 23 24 25 26 27 28 1 GR1) 2 SD1 30 31 32 34 36 37 58 39 40 43 44 45 46 47 50 51 52 53 54 55 56 57 58 59 2 Home 60 0 61 62 Paste A Compon w1 A 8 0.097364 0.24869 0.439438 Insert Draw Page Layout X AutoSave ON OR X Sp с Ready Calibri (Body) BIU 2012 902 4 |201p) 0.359058 330% -230.00% 0.7982664 325% -224.68 % 0.78429862 0.353006 ORP 320% -220.00% 0.7714013 0.347676 315% 215.00% 0.7575526 0.341985 310% -210.00% 0.7439281 0.336293 305% -205.00% 0.7302293 0.330602 300% -200.00% 0.7165576 0.324911 295% -195.00% 07029146 0.31923 290% -190.00% 0.6893019 0.313529 285% -185.00% 0.6757215 0.307837 DOME 280% -180.00% 0.6621752 0.302146 275% -175.00% 0.64R5653 0.296455 fx 270% -170.00% 0.635194 0.290764 265% -165.00% 0.6217639 0.785071 260% -160.00% 0.6083777 0.279382 255% -155.00% 0.595033 0.37369 250% 150.00% 0.581749 0.267999 245% -145.00% 0.5685133 0.752308 240 % 140.00% 0.555335 0.256617 235% -135.00% 0.5422184 0.250925 230 % 130.00% 0.5291679 0.245234 225% -125.00% 0.5161886 0.219543 220% 120.00% 0.503286 0.233852 215% -115.00% 0.4904662 0.228161 210% -110.00% 0.4777359 0.22247 205% -105.00% 0.4651023 0.216778 200% -100.00% 0.4525736 0.211087 195% 190 % 15.00% 0.4401588 0.205395 90.00% 0.4278677 0.199705 185% 45.00% 0.415/113 0.194014 180% -80.00% 0.4037019 0.188323 175% -75.00% 0.3918528 0.182631 170% -70.00% 0.3801792 0.17694 165% -65.00% 0.3685976 0.171249 60.00% 0.3574266 0.165558 160% wwww 155% -55.00% 0.3463867 0.159867 -50.00% 0.3355007 0.154175 150% 145% 45.00% 0.325094 0.148484 140% -10.00% 0.3148944 0.147791 135% 35.00% 0.3050329 0.137102 130% -30.00% 02955431 0.111411 125% 120% 115 % -10.00% 0.2620874 25.00% 0.2864621 0.125719 20.00% 0.37783 0.130028 15.00% 0.2696898 0.114337 110% -10.00% 105% 100% 95% 90% 10.00% 0.218034 0.085881 0.2630874 0.108645 5.00% 0.255071 0.102955 C09.SI 11.00% 0.24869 0.097764 5.00% 0.2429946 0.091572 85% 15.00% 0.2338549 0.08019 NO% 20.00% 0.2304998 0.074499 75% 25.00% 0.2280052 0.068808 70% 30.00% 0.226.1995 0.063116 65% 35.00% 0.2257016 0.057425 64% 36.31% 0.2256702 0.055935 MVP 60% 40.00% 0.22592 0.051734 0231153 anne Sheet1 P. C... 04 S W1- W2= AL F -41 -0.01656 0.290734 2.9120% last update 28 Jun 2022 17:15 GMT+0) 12 G + Minimum Variance Portfolio Variance of Stock- Variance of Stock2 Covariance of Stock and stock 2- 0.031775 0.636508 0.363092 Formulas MVP ✓ H 13 Α Α΄ A 0.061847 0.084526 I 36% E(Rp) 14 Data Review CON C09.SI - Saved ✓ = = = ab ✓ 三三三 Optimum Risky Portfolo(ORP) 1.9651603 L Portfolio Valances OF Expected Portfolio Retum Rp STANDARD DEVIATION OF THE PORTFOLIO Portfolio Standard Deviation ORP D EXPECTED RETURN OF THE MINIMUM VARIANCE PORTFOLIO(MVP) View Tell me M OF % Number N c) 0.055935 0.050927 5.0927% 0.77567 22.57% 0 Conditional Formatting ✓ Format as Table Cell Styles v P QR A 圓 Cells Share Editing S T U V W Comments ₁ M Analyse Data X 58% Y