Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

In this Assignment you must calculate various measures of Risk and Return. You must first use Yahoo Finance ( TESLA Company) to lower monthly prices

In this Assignment you must calculate various measures of Risk and Return. You must first use Yahoo Finance ( TESLA Company) to lower monthly prices from December 2019 to December 2022
image text in transcribed
\begin{tabular}{l|l|l|l|l|} \hline Cover & Return and Risk (8pts) & Correlation (4pts) & Beta (6pts) & CAPM (6pts) \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hline Vear-Month & \begin{tabular}{l} SAPS00 \\ Price \end{tabular} & \begin{tabular}{l} Compania \\ Prike \end{tabular} & \begin{tabular}{l} SAP500 \\ Return \end{tabular} & \begin{tabular}{l} Compaisia \\ Return \end{tabular} & \begin{tabular}{c} 1+ \\ S\&PS00 \\ Return \end{tabular} & \begin{tabular}{c} 1+ \\ Cempahia \\ Retarn \end{tabular} & & & \\ \hline 2019.12 & 3,244.67 & & & & & & \multicolumn{3}{|c|}{ Statistics for the year 2021} \\ \hline 2021M-al & 3,235,66 & & -0.00277606 & & 09972231 & & Measurvmest & 54P500 & Compania \\ \hline 202092 & 2.97428 & & 0.007k105 & & 0.919219 & & Gtonxtric Average of Monthly Returns & & \\ \hline 202003 & 2,49808 & & -0.16010598 & & 0.339894 & & Arithmetic Average of Monthly Retums & & \\ \hline 202004 & 2.869 .09 & & 0.1451062 & & 1.1455181 & & Standard Doviation of Monthly Retams & & \\ \hline 202005 & 3.088 .78 & & 0015914180 & & 10541442 & & & & \\ \hline 202006 & 3,105.92 & & 0.022094393 & & 10220944 & & \multicolumn{3}{|c|}{ Statisties for the three-year periad 2019.2021 } \\ \hline 202007 & 3.288 .26 & & 0.05307243 & & 1.0557072 & & Measurement & S.8:P500 & Compalia \\ \hline 202008 & 3.507+4 & & 0.066655313 & & 1.056653 & & Gtothetric Average of Monthly Returns & & \\ \hline 202009 & 3,255.87 & & 40.03404061 & & 0.9653394 & & Anthmetic Averaye of Monfhly Returns & & \\ \hline 2020-10 & 3,296.20 & & 0.0264ks99 & & 0.9735164 & & Standard Doviation of Monthly Ketaims & & \\ \hline 202011 & 3,6457 & & 0.106082762 & & 1.1060028 & & & & \\ \hline 202012 & 3,764.61 & & 0.032568355 & & 10325684 & & \\ \hline 202101 & 3,731.17 & & =0.005k8273 & & 0.9911173 & & & & \\ \hline 2021012 & 3,842.51 & & 0.0298+0505 & & 10298405 & & & & \\ \hline 202103 & 3,992,78 & & 0.07910725 & & 10391073 & & & & \\ \hline 202104 & 4,191.85 & & 0.040590052 & & 1.0498901 & & & & \\ \hline 202105 & 4,216.52 & & 0.00585+1036 & & 1005854 & & & & \\ \hline 2021=6 & 4.700 .73 & & 0.010971446 & & 10199714 & & & & \\ \hline 202147 & 4,406,36 & & 0.024677206 & & 10246772 & & & & \\ \hline 202105 & 4,528.90 & & 0.02767046 & & 1.0276205 & & & & \\ \hline 202109 & 4,317.16 & & -0.04673203 & & 0.553268 & & & & \\ \hline 2021.10 & 4,610.62 & & 0:067075243 & & 10570752 & & & & \\ \hline 202111 & 4,f022 & & 40.00169175 & & 0.9083083 & & & & \\ \hline 202112 & 4,7714 & & 0.0309093 & & 10350947 & & & & \\ \hline 202201 & 4.519 .57 & & .0 .0541152 & & 0.94584x & & & & \\ \hline 2022412 & 4,253.14 & & -0.0346117 & & 0.9653883 & & & & \\ \hline 202203 & 4.540 .32 & & 0.040608364 & & 1040 cuss & & & & \\ \hline 202204 & 4,130.61 & & 0.09023k13 & & 0.4097619 & & & & \\ \hline 2022-05 & 4.149 .78 & & 0.004640006 & & .00464 & & & & \\ \hline 202266 & 3,781.00 & & 0.06736 & & 09111326 & & & & \\ \hline 202217 & 4,112.18 & & 0.07643481 & & 1.0576455 & & & & \\ \hline 2022185 & 3.946 .73 & & -0.04271249 & & 0.4572875 & & & & \\ \hline 202209 & 3,609,78 & & 0.0305116 & & 0916948x & & & & \\ \hline 202210 & 3,401,79 & & 0.004127 & & 10 ososw41 & & & & \\ \hline 202211 & 4.087 .14 & & 0.047503kas & & 1.0475038 & & & & \\ \hline 202212 & 3,553.29 & & -0.05721605 & & 0.542784 & & & & \\ \hline \end{tabular} \begin{tabular}{l|l|l|l|l|} \hline Cover & Return and Risk (8pts) & Correlation (4pts) & Beta (6pts) & CAPM (6pts) \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hline Vear-Month & \begin{tabular}{l} SAPS00 \\ Price \end{tabular} & \begin{tabular}{l} Compania \\ Prike \end{tabular} & \begin{tabular}{l} SAP500 \\ Return \end{tabular} & \begin{tabular}{l} Compaisia \\ Return \end{tabular} & \begin{tabular}{c} 1+ \\ S\&PS00 \\ Return \end{tabular} & \begin{tabular}{c} 1+ \\ Cempahia \\ Retarn \end{tabular} & & & \\ \hline 2019.12 & 3,244.67 & & & & & & \multicolumn{3}{|c|}{ Statistics for the year 2021} \\ \hline 2021M-al & 3,235,66 & & -0.00277606 & & 09972231 & & Measurvmest & 54P500 & Compania \\ \hline 202092 & 2.97428 & & 0.007k105 & & 0.919219 & & Gtonxtric Average of Monthly Returns & & \\ \hline 202003 & 2,49808 & & -0.16010598 & & 0.339894 & & Arithmetic Average of Monthly Retums & & \\ \hline 202004 & 2.869 .09 & & 0.1451062 & & 1.1455181 & & Standard Doviation of Monthly Retams & & \\ \hline 202005 & 3.088 .78 & & 0015914180 & & 10541442 & & & & \\ \hline 202006 & 3,105.92 & & 0.022094393 & & 10220944 & & \multicolumn{3}{|c|}{ Statisties for the three-year periad 2019.2021 } \\ \hline 202007 & 3.288 .26 & & 0.05307243 & & 1.0557072 & & Measurement & S.8:P500 & Compalia \\ \hline 202008 & 3.507+4 & & 0.066655313 & & 1.056653 & & Gtothetric Average of Monthly Returns & & \\ \hline 202009 & 3,255.87 & & 40.03404061 & & 0.9653394 & & Anthmetic Averaye of Monfhly Returns & & \\ \hline 2020-10 & 3,296.20 & & 0.0264ks99 & & 0.9735164 & & Standard Doviation of Monthly Ketaims & & \\ \hline 202011 & 3,6457 & & 0.106082762 & & 1.1060028 & & & & \\ \hline 202012 & 3,764.61 & & 0.032568355 & & 10325684 & & \\ \hline 202101 & 3,731.17 & & =0.005k8273 & & 0.9911173 & & & & \\ \hline 2021012 & 3,842.51 & & 0.0298+0505 & & 10298405 & & & & \\ \hline 202103 & 3,992,78 & & 0.07910725 & & 10391073 & & & & \\ \hline 202104 & 4,191.85 & & 0.040590052 & & 1.0498901 & & & & \\ \hline 202105 & 4,216.52 & & 0.00585+1036 & & 1005854 & & & & \\ \hline 2021=6 & 4.700 .73 & & 0.010971446 & & 10199714 & & & & \\ \hline 202147 & 4,406,36 & & 0.024677206 & & 10246772 & & & & \\ \hline 202105 & 4,528.90 & & 0.02767046 & & 1.0276205 & & & & \\ \hline 202109 & 4,317.16 & & -0.04673203 & & 0.553268 & & & & \\ \hline 2021.10 & 4,610.62 & & 0:067075243 & & 10570752 & & & & \\ \hline 202111 & 4,f022 & & 40.00169175 & & 0.9083083 & & & & \\ \hline 202112 & 4,7714 & & 0.0309093 & & 10350947 & & & & \\ \hline 202201 & 4.519 .57 & & .0 .0541152 & & 0.94584x & & & & \\ \hline 2022412 & 4,253.14 & & -0.0346117 & & 0.9653883 & & & & \\ \hline 202203 & 4.540 .32 & & 0.040608364 & & 1040 cuss & & & & \\ \hline 202204 & 4,130.61 & & 0.09023k13 & & 0.4097619 & & & & \\ \hline 2022-05 & 4.149 .78 & & 0.004640006 & & .00464 & & & & \\ \hline 202266 & 3,781.00 & & 0.06736 & & 09111326 & & & & \\ \hline 202217 & 4,112.18 & & 0.07643481 & & 1.0576455 & & & & \\ \hline 2022185 & 3.946 .73 & & -0.04271249 & & 0.4572875 & & & & \\ \hline 202209 & 3,609,78 & & 0.0305116 & & 0916948x & & & & \\ \hline 202210 & 3,401,79 & & 0.004127 & & 10 ososw41 & & & & \\ \hline 202211 & 4.087 .14 & & 0.047503kas & & 1.0475038 & & & & \\ \hline 202212 & 3,553.29 & & -0.05721605 & & 0.542784 & & & & \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Bond Markets Analysis And Strategies

Authors: Frank J. Fabozzi

4th Edition

0130402664, 9780130402660

More Books

Students also viewed these Finance questions

Question

=+What is our leadership style like?

Answered: 1 week ago

Question

=+What are our core competencies or competitive advantages?

Answered: 1 week ago