Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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