50.1K

Verified Solution

Link Copied!

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

Compute at least 2 betas. One using the U.S. index, one using the World index. Report your findings. How precise are your estimates? Report your 95% confidence intervals. Are the two betas different? Why that might be?

Compute the weighted average cost of capital. For this you need to find the market values of debt and equity, the cost of debt, the tax rate and your answers from previous question.

Answer & Explanation Solved by verified expert

See Answer