Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

For each stock of Company A and B, compute for the average annualized return and the annualized standard deviation of returns. Please show sample calculations

For each stock of Company A and B, compute for the average annualized return and the annualized standard deviation of returns. Please show sample calculations for each requirement. You may use Excel for this, but please show the formulas I need to follow and learn. Thanks.

Date Company A Company B
1/1/21 101.489998 387.829987
2/1/21 103.529999 499.429993
3/1/21 108.18 485.179993
4/1/21 119.519997 487.73999
5/1/21 119.970001 497.049988
6/1/21 115.029999 529.48999
7/1/21 131.389999 552.47998
8/1/21 131.029999 587.169983
9/1/21 122.309998 515.419983
10/1/21 124.940002 533.950012
11/1/21 122.839996 588.780029
12/1/21 138.860001 595.200012
1/1/22 125.169998 509.119995
2/1/22 122.580002 413.339996
3/1/22 118.529999 413.700012
4/1/22 117.010002 369.660004
5/1/22 121.470001 338.190002
6/1/22 113.510002 293.950012
7/1/22 122.540001 357.690002
8/1/22 111.239998 301.640015
9/1/22 106.339996 262.01001
10/1/22 118.25 283.220001
11/1/22 128.660004 270.279999
12/1/22 128.080002 256.410004
1/1/23 130.509995 316.179993

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_2

Step: 3

blur-text-image_3

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

Stock Market Trading For Beginners

Authors: Irvin Tarr

1st Edition

1491885327, 978-1491885321

More Books

Students also viewed these Finance questions