Answered step by step
Verified Expert Solution
Question
1 Approved Answer
show steps on excel begin{tabular}{|c|c|c|} hline Date & R(JN) & R(CVX) hline 3/1/2020 & 14.42% & 21.97% hline 4/1/2020 & 0.86% & 0.33%
show steps on excel \begin{tabular}{|c|c|c|} \hline Date & R(JN) & R(CVX) \\ \hline 3/1/2020 & 14.42% & 21.97% \\ \hline 4/1/2020 & 0.86% & 0.33% \\ \hline 5/1/2020 & 4.80% & 1.27% \\ \hline 6/1/2020 & 3.65% & 5.93% \\ \hline 7/1/2020 & 5.25% & 0.01% \\ \hline 8/1/2020 & 2.31% & 12.98% \\ \hline 9/1/2020 & 7.91% & 3.47% \\ \hline 10/1/2020 & 5.52% & 23.24% \\ \hline 11/1/2020 & 9.53% & 1.71% \\ \hline 12/1/2020 & 3.65% & 0.89% \\ \hline 1/1/2021 & 1.92% & 6.76% \\ \hline 2/1/2021 & 0.02% & 0.92% \\ \hline 2/10/2021 & & \\ \hline & & \\ \hline Average & 234% & 234% \\ \hline St. Dev. & 6.13% & 10% \\ \hline \end{tabular} 2. Based on the table above, if you had invested $25,000 into each of the securities (JNJ and CVX), what would be the cumulated value of your investment at the end of this time period? a. $25,585 each b. $32,998 each c. $26,533 from JNJ and $27,638 from CVX d. $32,361 from JNJ, and $31,222 from CVX
show steps on excel
Step 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