Download the excel file named the ticker of your company. It contains dates and the...
70.2K
Verified Solution
Link Copied!
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!