Case and equation to one of the questions attached.

Question

Sumit · Accepted Answer

Adj Rate
	Date	Adj Close Disney	Monthtly Return	Risk Free Rate	Excess Rate		Adj Close S&P	Monthtly Return	Risk Free Rate	Excess Rate
	2007-01	29.12		0.44%			1438.24		0.44%
	2007-02	28.36	-2.62%	0.44%	-3.06%		1406.82	-2.18%	0.44%	-2.63%
	2007-03	28.51	0.53%	0.44%	0.08%		1420.86	1.00%	0.44%	0.55%
	2007-04	28.96	1.60%	0.44%	1.15%		1482.37	4.33%	0.44%	3.89%		Beta	1.19
	2007-05	29.34	1.32%	0.44%	0.87%		1530.62	3.25%	0.44%	2.81%		Alpha	0.62%
	2007-06	28.65	-2.35%	0.44%	-2.79%		1503.35	-1.78%	0.44%	-2.22%
	2007-07	27.70	-3.34%	0.44%	-3.78%		1455.27	-3.20%	0.44%	-3.64%
	2007-08	28.20	1.82%	0.46%	1.36%		1473.99	1.29%	0.46%	0.83%
	2007-09	28.86	2.35%	0.46%	1.89%		1526.75	3.58%	0.46%	3.12%
	2007-10	29.07	0.70%	0.42%	0.28%		1549.38	1.48%	0.42%	1.06%
	2007-11	27.82	-4.27%	0.40%	-4.68%		1481.14	-4.40%	0.40%	-4.81%
	2007-12	27.09	-2.62%	0.44%	-3.06%		1468.36	-0.86%	0.44%	-1.30%
	2008-01	25.32	-6.56%	0.33%	-6.89%		1378.55	-6.12%	0.33%	-6.44%
	2008-02	27.50	8.61%	0.26%	8.35%		1330.63	-3.48%	0.26%	-3.74%
	2008-03	26.62	-3.18%	0.24%	-3.42%		1322.70	-0.60%	0.24%	-0.84%
	2008-04	27.51	3.35%	0.25%	3.10%		1385.59	4.75%	0.25%	4.51%
	2008-05	28.51	3.61%	0.22%	3.39%		1400.38	1.07%	0.22%	0.85%
	2008-06	26.47	-7.14%	0.22%	-7.36%		1280.00	-8.60%	0.22%	-8.82%
	2008-07	25.75	-2.72%	0.22%	-2.95%		1267.38	-0.99%	0.22%	-1.21%
	2008-08	27.45	6.59%	0.22%	6.37%		1282.83	1.22%	0.22%	1.00%
	2008-09	26.04	-5.13%	0.33%	-5.47%		1166.36	-9.08%	0.33%	-9.41%
	2008-10	21.98	-15.58%	0.41%	-15.99%		968.75	-16.94%	0.41%	-17.35%
	2008-11	19.11	-13.08%	0.17%	-13.26%		896.24	-7.48%	0.17%	-7.66%
	2008-12	19.25	0.75%	0.15%	0.61%		903.25	0.78%	0.15%	0.64%
	2009-01	17.81	-7.49%	0.07%	-7.57%		825.88	-8.

Case and equation to one of the questions attached.

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment