Question

1 Approved Answer

Posted on Sep 07, 2024

Need Formulas For the highlighted sections. E SAUX L M TXN Average Monthly Return Monthly Standard Deviation Optimal Risky Portfolio Weight - SBUX Weicht-TXN Optimal

Need Formulas For the highlighted sections.

image text in transcribed

E SAUX L M TXN Average Monthly Return Monthly Standard Deviation Optimal Risky Portfolio Weight - SBUX Weicht-TXN Optimal Complete Portfo Weight - Risky Portfolio Weight - Riskfree Portfoli SAUX TXN Annualized Return Annualized Standard Deviation Annualized Risk Premium Correlation coefficient Portfolio Expected Return Portfolio Standard Deviation Portfolio Sharpe ratio Portfolio Expected Return Portfolio Standard Deviat Portfolio Sharpe ratio 9 Investor Utility SOUX TXN Variance-Covariance SBUX TXN Risk free rate 1.60% Investor's Risk aversion Coefficient A = A B C D 1 Adjusted Closing Monthly Return 2 Dale SOUX TXN 50UX TXN 3 7/1/2016 54.504204 64.170906 3.14% 4 8/1/2016 52.795393 64.320641 -3.28% 5 9/1/2016 51.010057 64.912605 -1.98% 6 10/1/2016 50.001926 65.532341 9.23% 7 11/1/2016 54,618652 68.381157 -3.78% 8 12/1/2016 52.552597 67.987015 -0.54% 1 /1/2017 52.268625 70.381531 2.99% 10 2/1/2017 53.830444 7 1.84095 3.14% 11 3/1/2017 55.51825 75.535217 2.86% 12 4/1/2017 57.10612174.24128 5.91% 13 5/1/2017 60.481525 77.824585 -7.95% 14 6/1/2017 55.670574 72.579041 -7.43% 15 7/1/2017 51.536572 75.777251 1.63% 16 8/1/2017 52.37674 78.61219 -1.65% 17 9/1/2017 51,510277 85.085686 2.1046 18 10/1/2017 52.593998 91.777489 5.43% 19 11/1/2017 55.451946 92.937988 0.15% 2012/1/2017 55.269698 99.769166 -1.02% 21 1/1/2018 54,771942 104.764214 0.51% 22 2/1/2018 55.05154 104.076073 1.93% 23 3/1/2018 56.115925 99.791992 -0.55% 24 4/1/2018 55.805733 97.429031 -1.56% 25 5/1/2018 54.933308 107.495644 -13.25% 26 6/1/2018 47.500578 105.538704 7.25% 27 7/1/2018 51.050041 107.572701 2.02% 28 8/1/2018 52.082928 109.217712 7.08% 29 9/1/2018 55,771816 104,252388 2.52% 30 10/1/2018 57.17494290.201782 14.50% 31 11/1/2018 65,4661481 97.858589 -2.95% 32 12/1/2018 63.52901592.615295 5.81% 33 1/1/2019 67.218427 99.672043 3.11% 34 2/1/2019 69.309759 104.463989 6.36% 35 3/1/2019 73.7173 104.750374 4.49% 36 4/1/2019 77,029335 116.364067 -2.09% 37 5/1/2019 75.422897 103.012268 10.73% 38 6/1/2019 83.513466 114.080109 12.95% 39 7/1/2019 94.332458 124.269386 0.23% 0.92% 0.95% 4.35% -0.58% 3.52% 2.07% 5.14% -1.71% 4.83% -6.74% 5.78% 2.39% 8.23% 7.86% 1.26% 7.35% 5.01% -0.66% 4.12% -2.37% 10.33% -0.89% 0.97% 1.53% -4.55% - 13,48% 8.49% -5.36% 6.54% 5.87% 0.27% 11.09% -11,47% 10.74% 8.93% Formulas Stdev Avg monthly return annualized return Annualized Standard Deviation Annualized Risk Premium Correlation Coefficient SBUX TXN Varianer-Covariance SBUX TXN 0 E SAUX L M TXN Average Monthly Return Monthly Standard Deviation Optimal Risky Portfolio Weight - SBUX Weicht-TXN Optimal Complete Portfo Weight - Risky Portfolio Weight - Riskfree Portfoli SAUX TXN Annualized Return Annualized Standard Deviation Annualized Risk Premium Correlation coefficient Portfolio Expected Return Portfolio Standard Deviation Portfolio Sharpe ratio Portfolio Expected Return Portfolio Standard Deviat Portfolio Sharpe ratio 9 Investor Utility SOUX TXN Variance-Covariance SBUX TXN Risk free rate 1.60% Investor's Risk aversion Coefficient A = A B C D 1 Adjusted Closing Monthly Return 2 Dale SOUX TXN 50UX TXN 3 7/1/2016 54.504204 64.170906 3.14% 4 8/1/2016 52.795393 64.320641 -3.28% 5 9/1/2016 51.010057 64.912605 -1.98% 6 10/1/2016 50.001926 65.532341 9.23% 7 11/1/2016 54,618652 68.381157 -3.78% 8 12/1/2016 52.552597 67.987015 -0.54% 1 /1/2017 52.268625 70.381531 2.99% 10 2/1/2017 53.830444 7 1.84095 3.14% 11 3/1/2017 55.51825 75.535217 2.86% 12 4/1/2017 57.10612174.24128 5.91% 13 5/1/2017 60.481525 77.824585 -7.95% 14 6/1/2017 55.670574 72.579041 -7.43% 15 7/1/2017 51.536572 75.777251 1.63% 16 8/1/2017 52.37674 78.61219 -1.65% 17 9/1/2017 51,510277 85.085686 2.1046 18 10/1/2017 52.593998 91.777489 5.43% 19 11/1/2017 55.451946 92.937988 0.15% 2012/1/2017 55.269698 99.769166 -1.02% 21 1/1/2018 54,771942 104.764214 0.51% 22 2/1/2018 55.05154 104.076073 1.93% 23 3/1/2018 56.115925 99.791992 -0.55% 24 4/1/2018 55.805733 97.429031 -1.56% 25 5/1/2018 54.933308 107.495644 -13.25% 26 6/1/2018 47.500578 105.538704 7.25% 27 7/1/2018 51.050041 107.572701 2.02% 28 8/1/2018 52.082928 109.217712 7.08% 29 9/1/2018 55,771816 104,252388 2.52% 30 10/1/2018 57.17494290.201782 14.50% 31 11/1/2018 65,4661481 97.858589 -2.95% 32 12/1/2018 63.52901592.615295 5.81% 33 1/1/2019 67.218427 99.672043 3.11% 34 2/1/2019 69.309759 104.463989 6.36% 35 3/1/2019 73.7173 104.750374 4.49% 36 4/1/2019 77,029335 116.364067 -2.09% 37 5/1/2019 75.422897 103.012268 10.73% 38 6/1/2019 83.513466 114.080109 12.95% 39 7/1/2019 94.332458 124.269386 0.23% 0.92% 0.95% 4.35% -0.58% 3.52% 2.07% 5.14% -1.71% 4.83% -6.74% 5.78% 2.39% 8.23% 7.86% 1.26% 7.35% 5.01% -0.66% 4.12% -2.37% 10.33% -0.89% 0.97% 1.53% -4.55% - 13,48% 8.49% -5.36% 6.54% 5.87% 0.27% 11.09% -11,47% 10.74% 8.93% Formulas Stdev Avg monthly return annualized return Annualized Standard Deviation Annualized Risk Premium Correlation Coefficient SBUX TXN Varianer-Covariance SBUX TXN 0