Answered step by step
Verified Expert Solution
Link Copied!

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

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

Advanced Accounting

Authors: Joe Hoyle, Thomas Schaefer, Timothy Doupnik

10th edition

0-07-794127-6, 978-0-07-79412, 978-0077431808

Students also viewed these Finance questions