Answered step by step
Verified Expert Solution
Question
1 Approved Answer
what would have been some differences in return and risks charactersistics of your portfolio, if you had weighted the amount invested in the stocks differently
what would have been some differences in return and risks charactersistics of your portfolio, if you had weighted the amount invested in the stocks differently ( in terms of optimum risk and return) . The excel spread sheet is just a data collected from yahoo finance to solve the problem. of risk and return of those 5 stock ( BABA, APHA, TESLA, CHWY, MSFT)
===== w % 68 Clipboard Conditional Format as Formatting Table St Styles Font IS Alignment 12 Number 12 fr APHA 0.018395891 0.135631453 2.1254% 63.04% A B D G H 1 Date Open High Low Close Adj Close Volume returns 1/15/2021 13.75 1401 12.27 1242 1242 53879800 APHA 1/19/2021 13 13.64 1201 1361 13.61 28398200 9.1497% variance 4 1/20/2021 13 35 13 888 12.89 1307 13.07 16925800 4.0485% std dev 5 1/21/2021 12.91 13.1 1222 1268 12 68 18062400 -3.0294% expected return 5 1/22/2021 12 13 13025 12 08 1292 1292 11367100 1.8751X HPR 7 1/25/2021 12.89 131 1188 1201 12.01 16034400 1/20/2021 -7.3037% 12.14 13232 121 1297 1297 18300800 7.6899% 9 1/27/2021 12:36 13.41 12 23 13.01 1301 16783800 0.3079% 10 1/28/2021 1295 13679 12.76 1296 12 96 13772800 -0.3851% 1/29/2021 1292 13.13 12.09 12 18 12 18 19045500 -6.2072% 12 2/1/2021 124 1263 12 12 125 125 9737300 13 212/2021 2.5933% 1285 14.96 127 14.74 14.74 30028500 16.4836% 14 2/3/2021 15 58 175 15 15 16.6 166 46917900 11.8838% 15 214/2021 165 17:18 15.65 18.440001 16.440001 19398900 -0.9685% 2/5/202 16 84 17 200001 18 25 16,67 16,67 14259800 1.3893% 17 2/8/2021 1707 19 139999 16.870001 18.98 18.98 26305900 12.977596 2/9/2021 20 620001 24 139999 20.040001 2375 23.75 57289900 19 22.419736 2/10/2021 31 030001 32 290001 22 530001 26 299999 26 299999 119165300 20 2/11/2021 10.1986% 245 245 16.459999 16.879999 16.879999 105575000 44.3439% 21 2/12/2021 15 51 19 549999 14.58 16.940001 16 940001 78426900 0.3548% 2/16/2021 1933 21 74 18.42 2173 21.73 59827600 24.9016% 23 2/17/2021 20 35 22 389999 19 20.610001 20.610001 24 2118/2021 38999800 21.85 S.2917% 22.58 19 19.23 370B0800 6.93059 25 2/19/2021 19 T00001 20.57 18 91 20 25 20.25 21800200 5.1683% 26 27 TESLA MSFT BABA CHWY 1923 HE Type here to search O 100% Calibri General F Paste 11 AA = a. A. BIU > $% 98.98 Conditional Format as CE Formatting Table Style Styles Clipboard Font Alignment Number 12 TSLA 0.000716341 HPR 0.02676455 -0.24279 A B D G H 1 Date Open High Low Close Adj Close Volume returns 2 1/5/2021 852 859.900024 819 099976 820.159973 828 159973 38777600 TSLA 3 1/19/2021 837.799988 850 833 844.549988 844 549988 25387000 2.2016% variance 1/20/2021 858.73999 8595 837 280029 850 450012 850 450012 25865900 0.6962% std dev 5 1/21/2021 855 855.719971 841.419983 844 90999 844 98999 20598100 -0.6441% expected return 1/22/2021 834 309998 848 828 819995 846,640015 846 640015 20066500 0.1951% 7 1/25/2021 B55 900.400024 838 820007 880.799988 880.799988 41173400 3.9555% 8 1/26/2021 891 380005 895 900024 871.599976 883 090027 883.090027 23131600 0.2597% 1/27/2021 870 349976 8915 858 659973 864.159973 864.159973 27334000 -2.1669% 10 1/28/2021 820 848 801 835 429993 835.429993 26378000 -3.3811% 11 1/29/2021 830 842 409973 780.099976 793.530029 793 530029 34990800 5.1455% 12 2/1/2021 814289978 842 795.559998 839 B09998 839 809998 25391400 5.6684% 12 272/2021 844.679993 8805 84220 012 872789978 872789978 24346200 3.8519% 14 2/3/2021 877.02002 878 080017 853 059998 854 690002 854 690002 18343500 2.0956% 15 2/4/2021 855 856.5 833.419983 849.98999 849.98999 15812700 -0.5514% 16 2/5/2021 845 864.77002 838.989971 852 22998 852 22998 18524800 0.2632% 17 2/8/2021 869.669983 877.77002 854.75 863 419983 863.419983 20161700 1.3045% 2/9/2021 855 119995 859.799988 841.75 849 460022 849.460022 15157700 -1.6300% 19 2/10/2021 843.640015 844 820007 800.02002 804.820007 804,820007 36216100 -5.3982% 20 2/11/2021 812440002 829 880005 801.72998 811.659973 811659973 21580700 0.846395 21 2/12/2021 801 26001 817 330017 785.330017 816.119995 816.119995 23701700 0.5480% 2/16/2021 818 821 792.440002 796 219971 796 219971 19802300 2.4686% 2/17/2021 779 090027 799 840027 76201001 798 150024 798.150024 25998500 0.242196 24 2/18/2021 780.900024 794 690002 776 27002 787 380005 787 380005 17957100 -1.3586% 25 2/19/2021 795 798.789978 777 369995 781 299988 781 299988 18958300 -0.7752 26 APHA TESLA MSFT BABA CHWY Calibri 11-AA AR General PH Paste BI U . FE += $ % -38-28 Conditional Format as Formatting Table Sty Styles Clipboard Font Alignment Number 15 12 fx MSFT 0.000201433 0.014192693 0.543696 13.32% B D G H Date Open High Low Close Adj Close Volume returns 1/15/2021 213 520004 214.509995 212.029999 212649994 212.161346 31748100 MSFT 3 1/19/2021 213.75 216 979996 212 630005 216.440002 215942642 30480900 1.7666% variance 4 1/20/2021 217,699997 225 789993 217 289993 224 339996 223.824493 37777300 3.5849% std dev 1/21/2021 224 699997 226 300003 222.419998 224970001 224 453049 30749800 0.2804% expected return 1/22/2021 227 080002 230,070007 225 800003 225 949997 225.430786 30172700 0.4347X HPR 1/25/2021 229.119995 229.779999 224 220001 229.529999 229 002563 33152100 1.5720% 1/25/2021 231 860001 234.179993 230.080002 232330002 231.796143 49169800 1.2125% 1/27/2021 238 240 440002 230.139999 232 899994 232 364822 69870600 0.2450% 10 1/28/2021 235 610001 242 639999 235 089996 238.929993 238 380968 49111200 2.5561% 11 1/29/2021 235 990005 238 020004 231350006 231.960007 231.426987 42468900 -2.9606% 12 2/1/2021 235 059998 2425 232.429993 239 649994 239.099304 33314200 3.2615% 13 2/2/2021 241 300003 242 309998 238 690002 239509995 238.959625 25916300 -0.0584% 14 2/3/2021 239 570007 245 089998 239 259995 243 242 44162 27158100 1.4466% 15 214/2021 242 660004 243 240005 240.369995 242009995 241.453888 25296100 -0.408296 16 2/5/2021 242 229996 243 279999 240 419998 242 199997 241.643448 18043900 0.0785% 17 2/8/2021 243.149994 243 679993 240 809998 242470001 241.912842 22211900 0.1114% 13 2/9/2021 241.899995 244.759995 241.380005 243.770004 243 209854 23565000 0.5347% 2/10/2021 245 245 919998 240.889999 242 820007 242202039 22186700 0.3905% 20 244 779999 2/11/2021 245 149994 242 149994 244 490005 0.6854 243.928192 15742200 243 929993 245.300003 2/12/2021 242.729996 244.427048 2440005 18552000 0.2043% 2/16/2021 22 245 020999 246 130005 242 919998 243.099997 243.139999 26728500 -0.5279% 2/17/2021 241.320007 240 940002 244 309998 244.199997 012050725 244 1567997 21653500 24 2/18/2021 16925800 0.1680X 241 B00003 240 880001 243 929993 243.789993 243.789993 11635 2/19/2021 243 75 243 860001 240970001 240.179993 240.970001 25262500 26 TESLA MSFT + BABA CHWY Ready Paste BIU a. A $ % 9 8-98 $% 98.98 Conditional Format as CE Formatting Table Style Styles Clipboard Font Alignment Number 12 TSLA 0.000716341 HPR 0.02676455 -0.24279 A B D G H 1 Date Open High Low Close Adj Close Volume returns 2 1/5/2021 852 859.900024 819 099976 820.159973 828 159973 38777600 TSLA 3 1/19/2021 837.799988 850 833 844.549988 844 549988 25387000 2.2016% variance 1/20/2021 858.73999 8595 837 280029 850 450012 850 450012 25865900 0.6962% std dev 5 1/21/2021 855 855.719971 841.419983 844 90999 844 98999 20598100 -0.6441% expected return 1/22/2021 834 309998 848 828 819995 846,640015 846 640015 20066500 0.1951% 7 1/25/2021 B55 900.400024 838 820007 880.799988 880.799988 41173400 3.9555% 8 1/26/2021 891 380005 895 900024 871.599976 883 090027 883.090027 23131600 0.2597% 1/27/2021 870 349976 8915 858 659973 864.159973 864.159973 27334000 -2.1669% 10 1/28/2021 820 848 801 835 429993 835.429993 26378000 -3.3811% 11 1/29/2021 830 842 409973 780.099976 793.530029 793 530029 34990800 5.1455% 12 2/1/2021 814289978 842 795.559998 839 B09998 839 809998 25391400 5.6684% 12 272/2021 844.679993 8805 84220 012 872789978 872789978 24346200 3.8519% 14 2/3/2021 877.02002 878 080017 853 059998 854 690002 854 690002 18343500 2.0956% 15 2/4/2021 855 856.5 833.419983 849.98999 849.98999 15812700 -0.5514% 16 2/5/2021 845 864.77002 838.989971 852 22998 852 22998 18524800 0.2632% 17 2/8/2021 869.669983 877.77002 854.75 863 419983 863.419983 20161700 1.3045% 2/9/2021 855 119995 859.799988 841.75 849 460022 849.460022 15157700 -1.6300% 19 2/10/2021 843.640015 844 820007 800.02002 804.820007 804,820007 36216100 -5.3982% 20 2/11/2021 812440002 829 880005 801.72998 811.659973 811659973 21580700 0.846395 21 2/12/2021 801 26001 817 330017 785.330017 816.119995 816.119995 23701700 0.5480% 2/16/2021 818 821 792.440002 796 219971 796 219971 19802300 2.4686% 2/17/2021 779 090027 799 840027 76201001 798 150024 798.150024 25998500 0.242196 24 2/18/2021 780.900024 794 690002 776 27002 787 380005 787 380005 17957100 -1.3586% 25 2/19/2021 795 798.789978 777 369995 781 299988 781 299988 18958300 -0.7752 26 APHA TESLA MSFT BABA CHWY Calibri 11-AA AR General PH Paste BI U . FE += $ % -38-28 Conditional Format as Formatting Table Sty Styles Clipboard Font Alignment Number 15 12 fx MSFT 0.000201433 0.014192693 0.543696 13.32% B D G H Date Open High Low Close Adj Close Volume returns 1/15/2021 213 520004 214.509995 212.029999 212649994 212.161346 31748100 MSFT 3 1/19/2021 213.75 216 979996 212 630005 216.440002 215942642 30480900 1.7666% variance 4 1/20/2021 217,699997 225 789993 217 289993 224 339996 223.824493 37777300 3.5849% std dev 1/21/2021 224 699997 226 300003 222.419998 224970001 224 453049 30749800 0.2804% expected return 1/22/2021 227 080002 230,070007 225 800003 225 949997 225.430786 30172700 0.4347X HPR 1/25/2021 229.119995 229.779999 224 220001 229.529999 229 002563 33152100 1.5720% 1/25/2021 231 860001 234.179993 230.080002 232330002 231.796143 49169800 1.2125% 1/27/2021 238 240 440002 230.139999 232 899994 232 364822 69870600 0.2450% 10 1/28/2021 235 610001 242 639999 235 089996 238.929993 238 380968 49111200 2.5561% 11 1/29/2021 235 990005 238 020004 231350006 231.960007 231.426987 42468900 -2.9606% 12 2/1/2021 235 059998 2425 232.429993 239 649994 239.099304 33314200 3.2615% 13 2/2/2021 241 300003 242 309998 238 690002 239509995 238.959625 25916300 -0.0584% 14 2/3/2021 239 570007 245 089998 239 259995 243 242 44162 27158100 1.4466% 15 214/2021 242 660004 243 240005 240.369995 242009995 241.453888 25296100 -0.408296 16 2/5/2021 242 229996 243 279999 240 419998 242 199997 241.643448 18043900 0.0785% 17 2/8/2021 243.149994 243 679993 240 809998 242470001 241.912842 22211900 0.1114% 13 2/9/2021 241.899995 244.759995 241.380005 243.770004 243 209854 23565000 0.5347% 2/10/2021 245 245 919998 240.889999 242 820007 242202039 22186700 0.3905% 20 244 779999 2/11/2021 245 149994 242 149994 244 490005 0.6854 243.928192 15742200 243 929993 245.300003 2/12/2021 242.729996 244.427048 2440005 18552000 0.2043% 2/16/2021 22 245 020999 246 130005 242 919998 243.099997 243.139999 26728500 -0.5279% 2/17/2021 241.320007 240 940002 244 309998 244.199997 012050725 244 1567997 21653500 24 2/18/2021 16925800 0.1680X 241 B00003 240 880001 243 929993 243.789993 243.789993 11635 2/19/2021 243 75 243 860001 240970001 240.179993 240.970001 25262500 26 TESLA MSFT + BABA CHWY Ready Paste BIU a. A $ % 9 8-98Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started