Consider the stock market data provided in Excel file CAPM.xlsx. Use Excel to estimate the CAPM for Google stock price and for Apple stock price. Comment on the results of the estimated CAPM. Also, compare the estimated results for the two stocks (Apple vs. Google)

 

Date	Apple	Google	Rm	Rf
31-Mar-22	-2.40665767	-1.9656	-1.49184	0
1-Apr-22	-0.442452451	0.492822	0.122018	0
4-Apr-22	1.603941112	2.002556	0.762318	0
5-Apr-22	-1.966197183	-1.6318	-1.03511	0
6-Apr-22	-0.905082386	-1.42282	-0.28971	0
7-Apr-22	-0.035054919	-0.11711	0.571218	0
8-Apr-22	-1.577599255	-1.64404	-0.13061	0
11-Apr-22	-2.347223045	-2.33258	-1.12288	0
12-Apr-22	-0.815379122	-3.05845	-0.90455	0
13-Apr-22	1.18286636	1.290523	1.189951	0
14-Apr-22	-3.709998828	-2.60237	-1.27059	0
18-Apr-22	0.09760859	0.431677	0.138179	0
19-Apr-22	0.8302024	1.912867	1.63029	0
20-Apr-22	-1.505095994	-2.30804	-0.28643	0
21-Apr-22	-2.066189095	-3.40935	-2.12756	0
22-Apr-22	-3.38820137	-4.312	-2.60042	0
25-Apr-22	0.484111221	3.198526	0.958325	0
26-Apr-22	-3.938366718	-2.63951	-2.40619	0
27-Apr-22	-0.17959079	0.568331	-0.06115	0
28-Apr-22	2.135007849	1.963966	1.537449	0
29-Apr-22	-3.175976273	-2.21977	-2.86383	0
2-May-22	0.191436411	2.85313	0.599669	0
3-May-22	0.233955106	1.173347	0.377424	0
4-May-22	3.350660738	3.872881	2.845847	0
5-May-22	-4.894720781	-2.88637	-2.89339	0
6-May-22	0.352541504	0.121191	-0.117	0
9-May-22	-2.297811915	-0.19417	-2.20593	0
10-May-22	-1.099537037	-1.25819	-0.84581	0
11-May-22	-4.996742671	0.219858	-1.37591	0
12-May-22	-0.602367444	1.08987	0.669322	0
13-May-22	1.279479909	1.454071	1.513409	0
16-May-22	-0.460322913	-0.51135	-0.12484	0
17-May-22	-0.20153164	-0.4521	0.909427	0
18-May-22	-4.542049711	-2.46442	-3.16635	0
19-May-22	-2.259079211	-0.97461	0.045909	0
20-May-22	-1.531382558	-2.48015	-0.67214	0
23-May-22	3.389215473	1.425976	1.386174	0
24-May-22	-0.774092749	-0.42301	-0.03703	0
25-May-22	1.047460811	0.665779	1.250512	0
26-May-22	4.170609215	2.121641	1.838077	0
27-May-22	2.455464612	2.741598	1.981886	0
31-May-22	-0.610451466	0.848956	-0.45627	0
1-Jun-22	-1.247498332	-0.68737	-1.16994	0
2-Jun-22	1.819657715	3.117611	1.987835	0
3-Jun-22	-1.484002723	-1.23286	-0.70162	0
6-Jun-22	-1.061007958	0.231283	-0.32142	0
7-Jun-22	2.549359196	1.366191	1.567447	0
8-Jun-22	-0.868219141	0.308008	-0.75595	0
9-Jun-22	-3.460701659	-1.22056	-2.04381	0
10-Jun-22	-2.694610778	-1.19702	-1.8501	0
13-Jun-22	-1.196658388	-0.53048	-2.30632	0
14-Jun-22	-0.736122587	0.280662	-0.74505	0
15-Jun-22	0.387221684	1.368228	0.689151	0
16-Jun-22	-1.976075106	-1.39621	-1.64718	0
17-Jun-22	0.684246944	1.248357	0.243869	0
21-Jun-22	1.371608455	2.105743	1.331787	0
22-Jun-22	-0.044513688	0.782656	0.696325	0
23-Jun-22	0.599327584	-0.23904	0.556864	0
24-Jun-22	0.793423874	4.348592	2.35468	0
27-Jun-22	-1.184302733	-1.94232	-0.52668	0
28-Jun-22	-3.743052135	-3.24882	-2.33708	0
29-Jun-22	0.829332169	0.098083	-0.16366	0
30-Jun-22	-0.837887067	-1.02262	-0.01611	0.001
1-Jul-22	1.661276095	0.683035	1.172441	0.001
5-Jul-22	2.27916092	5.934332	1.022515	0.001
6-Jul-22	0.650866643	0.981681	0.34186	0.001
7-Jul-22	1.667946123	2.844582	1.134276	0.001
8-Jul-22	0.764147047	2.228839	0.285989	0.001
11-Jul-22	-1.002265394	-1.7952	-0.68308	0.001
12-Jul-22	-0.391053787	-1.70318	-0.8606	0.001
13-Jul-22	1.286803273	-0.3995	0.584972	0.001
14-Jul-22	2.574958356	0.550392	0.701118	0.001
15-Jul-22	-0.193617305	-0.1682	1.182818	0.001
18-Jul-22	-2.879129627	-3.11178	-1.3631	0.001
19-Jul-22	1.615738237	2.586593	1.967504	0.001
20-Jul-22	0.807305453	0.561108	0.6246	0.001
21-Jul-22	0.090614887	-0.04344	1.099237	0.001
22-Jul-22	-1.287084111	-3.08559	-0.92036	0.001
25-Jul-22	-1.142782936	-0.61536	0.028242	0.001
26-Jul-22	-0.886641272	-1.85237	-0.81377	0.001
27-Jul-22	2.287324682	3.649635	1.82668	0.001
28-Jul-22	-0.222958339	1.586879	1.149988	0.001
29-Jul-22	0.328702555	2.857143	1.051053	0.001
1-Aug-22	-0.149059065	-0.04328	0.15198	0.001
2-Aug-22	-0.512179888	1.284628	-0.31724	0.001
3-Aug-22	2.816463566	2.097301	1.149232	0.001
4-Aug-22	-0.578278417	0.481826	-0.07004	0.001
5-Aug-22	0.986459163	1.103224	0.712365	0.001
8-Aug-22	-1.214161207	-0.8227	-0.38186	0.001
9-Aug-22	0.231679064	-0.41529	-0.25743	0.001
10-Aug-22	0.608301527	0.886362	0.698873	0.001
11-Aug-22	-1.240738563	-1.85125	-0.47618	0.001
12-Aug-22	1.01872571	1.229779	1.304846	0.001
15-Aug-22	0.652985075	0.548237	0.650447	0.001
16-Aug-22	-0.173631207	0.15533	0.343553	0.001
17-Aug-22	0.711929154	-0.50442	-0.14858	0.001
18-Aug-22	-0.086330935	0.523996	0.248296	0.001
19-Aug-22	-1.190544992	-1.45991	-0.88671	0.001
22-Aug-22	-1.561671283	-0.88717	-1.36088	0.001
23-Aug-22	-0.227435959	0.393632	-0.10549	0.001
24-Aug-22	-0.191250299	0.218436	0.344598	0.001
25-Aug-22	0.420665956	2.214503	1.104193	0.001
26-Aug-22	-4.379433664	-3.89431	-3.36006	0.001
29-Aug-22	-0.173751164	-0.39718	-0.0984	0.003
30-Aug-22	-2.300622957	-1.00874	-1.36319	0.003
31-Aug-22	-2.239411141	-2.22163	-1.14156	0.003
1-Sep-22	0.523493361	1.236264	0.765102	0.003
2-Sep-22	-2.779342723	-2.38908	-1.76235	0.003
6-Sep-22	-1.553013357	-0.61032	-0.57748	0.003
7-Sep-22	0.413383284	2.524128	1.801797	0.003
8-Sep-22	-0.433264356	0.21982	1.167694	0.003
9-Sep-22	0.900495272	1.572013	1.104168	0.003
12-Sep-22	2.080330848	-0.10715	0.654803	0.003
13-Sep-22	-4.096310194	-3.28772	-2.58675	0.003
14-Sep-22	0.019381097	0.407815	0.133985	0.003
15-Sep-22	-1.784675073	-1.05704	-0.78985	0.003
16-Sep-22	-0.654718603	0.640963	-0.19634	0.003
19-Sep-22	3.134418324	1.27755	1.298212	0.003
20-Sep-22	1.955671447	-1.02061	-0.49803	0.003
21-Sep-22	-2.61217745	-2.18114	-2.10441	0.003
22-Sep-22	-0.085313033	1.126194	-0.64431	0.003
23-Sep-22	-0.820160063	-0.88947	-0.90981	0.003
26-Sep-22	0.420954163	0.202819	-0.75162	0.003
27-Sep-22	-0.955872725	-1.82164	-1.062	0.003
28-Sep-22	1.164995936	2.774944	1.83738	0.004
29-Sep-22	-2.785763176	-1.21853	-1.26227	0.004
30-Sep-22	-2.491506229	-1.6167	-1.31719	0.004
3-Oct-22	2.742203893	2.139477	1.901778	0.004
4-Oct-22	0.420602634	1.355899	1.73006	0.004
5-Oct-22	1.291039078	1.519515	0.800107	0.004
6-Oct-22	-0.576092175	0.729064	-0.72774	0.004
7-Oct-22	-2.034516627	-1.07303	-1.80968	0.004
10-Oct-22	-0.32046717	-1.14171	-0.96285	0.004
11-Oct-22	-0.972122945	-0.20356	-0.19522	0.004
12-Oct-22	-0.884065263	0.030528	-0.38431	0.004
13-Oct-22	5.593006889	3.940373	4.247849	0.004
14-Oct-22	-4.414108516	-3.4284	-2.90862	0.004
17-Oct-22	0.630892465	1.266077	1.080071	0.004
18-Oct-22	-1.512131418	-2.45334	-0.7015	0.004
19-Oct-22	1.206860047	-0.40715	-0.21468	0.004
20-Oct-22	-0.062928262	-0.28764	-0.63079	0.004
21-Oct-22	2.750752432	3.067235	2.61546	0.004
24-Oct-22	1.216115225	0.861985	0.939126	0.004
25-Oct-22	1.179292425	1.577928	1.570495	0.004
26-Oct-22	-1.377848437	-2.00496	0.121015	0.008
27-Oct-22	-2.519078814	-1.81317	-0.71427	0.008
28-Oct-22	4.75708502	4.376959	2.436808	0.008
31-Oct-22	-0.202402716	-1.16935	-0.25426	0.008
1-Nov-22	-3.166107815	-5.32482	-1.171	0.008
2-Nov-22	-2.940584089	-4.22396	-2.41922	0.008
3-Nov-22	-2.548219062	-3.3121	-0.35787	0.008
4-Nov-22	-2.758814836	1.39165	0.094771	0.008
7-Nov-22	1.166946248	1.499886	0.690082	0.008
8-Nov-22	-0.797663984	-0.28039	0.290541	0.008
9-Nov-22	-2.772563177	-1.28755	-1.6366	0.008
10-Nov-22	3.830359671	1.981806	2.499553	0.008
11-Nov-22	2.503085996	2.132827	0.736934	0.008
14-Nov-22	-0.617574008	0.554974	-0.52087	0.008
15-Nov-22	-1.583234792	0.050674	-0.36641	0.008
16-Nov-22	-0.382216858	0.989594	-0.45338	0.008
17-Nov-22	2.772655877	1.358304	0.69656	0.008
18-Nov-22	-0.820694636	-1.2221	-0.02647	0.008
21-Nov-22	-1.584976026	-1.77327	-0.15899	0.008
22-Nov-22	1.22865051	1.216722	0.960028	0.008
23-Nov-22	0.930076949	1.520444	0.673949	0.008
25-Nov-22	-0.289933248	-0.87345	0.069097	0.008
28-Nov-22	-0.785448532	-0.97737	-1.03411	0.008
29-Nov-22	-2.314782729	-0.58333	-0.16548	0.009
30-Nov-22	4.526166902	6.654752	3.106505	0.009
1-Dec-22	-0.08771338	-0.11834	-0.25862	0.009
2-Dec-22	1.109893121	1.469256	0.780413	0.009
5-Dec-22	-0.920349191	0.05009	-1.31243	0.009
6-Dec-22	-2.978173659	-2.36781	-1.38542	0.009
7-Dec-22	-1.026795133	-1.67407	0.016271	0.009
8-Dec-22	0.049171115	-1.81837	0.398197	0.009
9-Dec-22	-0.281017283	-0.88392	-0.50048	0.009
12-Dec-22	1.100210231	0.504888	1.301504	0.009
13-Dec-22	-2.842809365	-2.26369	-1.22205	0.009
14-Dec-22	-1.623667011	-0.24074	-0.50354	0.009
15-Dec-22	-3.415774927	-2.5016	-1.58196	0.009
16-Dec-22	-1.748481966	-0.37281	-0.99077	0.009
19-Dec-22	-2.176004737	-1.90361	-0.93752	0.009
20-Dec-22	0.54037598	1.014313	0.292615	0.009
21-Dec-22	1.699503685	0.579516	1.014458	0.009
22-Dec-22	-1.726832899	-0.7534	-0.80114	0.009
23-Dec-22	0.565230675	2.499429	0.778746	0.009
27-Dec-22	-1.179783833	-1.54518	-0.36661	0.009
28-Dec-22	-2.945939693	-1.18857	-1.21006	0.009
29-Dec-22	1.109461677	2.206136	1.151769	0.011
30-Dec-22	1.027957324	1.568223	0.272652	0.011
3-Jan-23	-4.144918637	-0.14472	-0.7565	0.011
4-Jan-23	-0.567420601	-2.52719	0.328355	0.011
5-Jan-23	-1.809171714	-1.4761	-0.82401	0.011
6-Jan-23	2.706134434	0.915751	1.875571	0.011
9-Jan-23	-0.398559056	-0.43727	-0.47893	0.011
10-Jan-23	0.207277752	2.905904	0.788979	0.011
11-Jan-23	1.554285714	2.442816	0.947525	0.011
12-Jan-23	-0.500448163	-0.5303	0.140789	0.011
13-Jan-23	1.908657123	1.387523	0.971822	0.011
17-Jan-23	0.667507231	-0.66825	-0.20779	0.011
18-Jan-23	-1.330214881	-1.24812	-1.83372	0.011
19-Jan-23	0.730906921	2.757413	-0.33207	0.011
20-Jan-23	1.759314015	3.470558	1.62623	0.011
23-Jan-23	2.005502462	2.098255	1.047474	0.011
24-Jan-23	1.425415152	-0.34154	0.380085	0.011
25-Jan-23	0.532330187	-0.48354	0.841387	0.011
26-Jan-23	0.398128099	0.895401	0.603308	0.011
27-Jan-23	1.781223806	1.675921	0.415421	0.011
30-Jan-23	-1.503863135	-0.81013	-0.77792	0.011
31-Jan-23	0.960056062	2.053955	1.386523	0.014

Answer rating: 100% (QA)

To estimate the CAPM Capital Asset Pricing Model for Google and Apple stock prices we need to calcul... View the full answer