Download the excel file named the ticker of your company. It contains dates and the...

70.2K

Verified Solution

Question

Finance

Download the excel file named the ticker of your company. It contains dates and the $ rate of return of the stock listed on the New York Stock Exchange.

1/30/15 0.01829
2/27/15 0.125727
3/31/15 -0.0191
4/30/15 0.069416
5/29/15 0.033419
6/30/15 -0.05079
7/31/15 0.022931
8/31/15 -0.10248
9/30/15 -0.09039
10/30/15 0.085251
11/30/15 0.09494
12/31/15 -0.05018
1/29/16 -0.28846
2/29/16 0.163465
3/31/16 0.084803
4/29/16 0.03225
5/31/16 -0.02299
6/30/16 -0.1407
7/29/16 0.086931
8/31/16 0.094769
9/30/16 -0.03703
10/31/16 0.06807
11/30/16 0.042325
12/30/16 -0.02894
1/31/17 0.063927
2/28/17 0.023266
3/31/17 0.01479
4/28/17 0.00087
5/31/17 -0.04325
6/30/17 0.054748
7/31/17 0.057506
8/31/17 0.02444
9/29/17 0.016103
10/31/17 0.029935
11/30/17 -0.01273
12/29/17 0.012315
1/31/18 0.028322
2/28/18 -0.08299
3/29/18 0.022375
4/30/18 0.0278
5/31/18 0.061001
6/29/18 -0.02097
7/31/18 0.036565
8/31/18 0.014965
9/28/18 0.009654
10/31/18 -0.12935
11/30/18 0.055711
12/31/18 -0.25099
1/31/19 0.193434
2/28/19 -0.04486
3/29/19 0.031015
4/30/19 0.066609
5/31/19 -0.0971
6/28/19 0.160419
7/31/19 0.048452
8/30/19 -0.01669
9/30/19 0.021074
10/31/19 0.057169
11/29/19 0.067899
12/31/19 -0.0055

Add data on the risk-free rate of return in USD; a broad index that represents the U.S. equity market; a broad international index (for example the MSCI world). Describe the data: what is the minimum and maximum monthly returns, average returns over the period, compute the variance and the standard deviation. Plot histograms of the companys return, and 2 indexes of your choice. Plot the returns of the firm and the indexes over time.

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students