Question: 1) Calculate monthly and annualized average return from the given weekly return 2) Calculate the annualized risk or Standard Deviation of the weekly return Note:
1) Calculate monthly and annualized average return from the given weekly return
2) Calculate the annualized risk or Standard Deviation of the weekly return
Note: Please Show me the formula (especially converting weekly to annually) that you are using in Excel, I want to learn the process to work on a Project
| Date | Weekly return |
| 7/10/2022 | -0.67% |
| 7/3/2022 | -0.16% |
| 6/26/2022 | 0.78% |
| 6/19/2022 | -1.53% |
| 6/12/2022 | -0.84% |
| 6/5/2022 | 0.45% |
| 5/29/2022 | 3.42% |
| 5/22/2022 | -0.32% |
| 5/15/2022 | -4.68% |
| 5/8/2022 | -1.17% |
| 5/1/2022 | -0.19% |
| 4/24/2022 | -0.10% |
| 4/17/2022 | 1.18% |
| 4/10/2022 | -0.85% |
| 4/3/2022 | -1.73% |
| 3/27/2022 | 0.07% |
| 3/20/2022 | -0.19% |
| 3/13/2022 | 1.46% |
| 3/6/2022 | -0.42% |
| 2/27/2022 | -2.09% |
| 2/20/2022 | -2.17% |
| 2/13/2022 | -1.33% |
| 2/6/2022 | 0.89% |
| 1/30/2022 | -0.06% |
| 1/23/2022 | -1.10% |
| 1/16/2022 | 1.26% |
| 1/9/2022 | 0.43% |
| 1/2/2022 | 3.42% |
| 12/26/2021 | 0.81% |
| 12/19/2021 | -2.41% |
| 12/12/2021 | -1.67% |
| 12/5/2021 | 0.70% |
| 11/28/2021 | 1.23% |
| 11/21/2021 | -3.38% |
| 11/14/2021 | 1.37% |
| 11/7/2021 | 1.29% |
| 10/31/2021 | -2.20% |
| 10/24/2021 | -0.20% |
| 10/17/2021 | -2.31% |
| 10/10/2021 | -1.36% |
| 10/3/2021 | 0.19% |
| 9/26/2021 | 1.08% |
| 9/19/2021 | 0.31% |
| 9/12/2021 | -0.42% |
| 9/5/2021 | 3.98% |
| 8/29/2021 | 1.89% |
| 8/22/2021 | 1.34% |
| 8/15/2021 | 0.91% |
| 8/8/2021 | 1.57% |
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
