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

Question: 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.

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

Step by Step Solution

★★★★★

3.51 Rating (164 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Here are the steps to estimate the CAPM for Google and Apple stocks using the Excel data provided 1 ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

A tabular analysis of the transactions made during August 2022 by Wolfe Company during its first month of operations is shown as follows. Each increase and decrease in stockholders equity is...

The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...

Use (9.53) to estimate (1/r12) -1 for the ground-state He atom?

The file P11_45.xlsx contains monthly sales for a photography studio and the price charged per portrait during each month. Use regression to estimate an equation for predicting the current months...

Corporate Value at Risk (20 points) Consider the FTZ Company as discussed in Lecture 6 on Value-at-Risk. Due to economic uncertainty for next year, the financial price uncertainty faced by FTZ has...

I need two ratios provided based on the financial statement of a company (fullfinancial attached). I need the price-earnings ratio (the formula of price per share divided by earnings per share) and...

Go to www.bloomberg.comLinks to an external site. and highlight "Market Data" and select "Economic Calendar". I also posted a link in the Course Resources section. Here you will find important...

Create a time series plot of the original data (x1, x2, and x3) and the first principal component (PC1) from Question 16. All four series should be on one plot. Describe the relationship between PC1...

Again consider the stock market poll discussed in Exercise 7.47. a. Suppose we wish to use the poll's results to justify the claim that fewer than 50 percent of American investors in 1992 found the...

The data file shiller contains the stock market data in the book "Irrational Exuberance" by Robert Shiller. ${ }^{10}$ They comprise the monthly price and dividends of the S\&P Index (in logs) for...

8 Consider the following market data, with price for UK gilts and the LIFFE long gilt contract. Gilts pay semi-annual coupon on an act/act basis. Conversion factor UKT 5.75% 7 Dec 2009 102.732 8...

An equipotential surface must be perpendicular to the electric field at every point. equal to the inverse of the electric field at every point. equal to the electric field at every point. tangent to...

Calculate the effective rate, loan payment, payment per month, total cost and total interest paid? Car Negotiated Price 10% Downpayment Trade-In Value Loan Amount APR Effective Rate Term (Months)...

Which of these statements correctly describes differences between prelemed stock and long - term bonds? L interest paid by firms is a tax - deductible expense; dividends paid on preferred sack are...

The following financial statements apply to Robin Company. Required Calculate the following ratios for 2014 and 2015. When data limitations prohibit computing averages, use year-end balances in your...

Sun Corporation received a charter that authorized the issuance of 100,000 shares of $10 par common stock and 50,000 shares of $50 par, 5 percent cumulative preferred stock. Sun Corporation completed...

Refer to the computer solution to Problem 14 in Figure THE MANAGEMENT SCIENTIST SOLUTION FOR THE DIGITAL CONTROLS, INC., PROBLEM a. Interpret the ranges of optimality for the objective function...

At the end of the current year, the accounts receivable account of Glenns Nursery Supplies has a debit balance of $390,000. Credit sales are $2,800,000. Record the end-of-period adjusting entry on...

Sokov Companys income statement information follows. The average number of shares outstanding was 9,600 for 2014 and 8,000 for 2013. Required Compute the following ratios for Sokov for 2014 and 2013...

For the following exercises,a. evaluate f'(a), andb. graph the function f(x) and the tangent line atx=a.[T]f(x)=2x3+3x-x2,a=2[T]f(x)=1x-x2,a=1[T]f(x)=x2-x12+3x+2,a=0[T]f(x)=1x-x2,a=-1Find the...

The instructions are attached below. Please use an Excel file. Thanks 4E6 COURSEWORK 2016-17 Please submit Sections A and B separately via the respective online submission links on Moodle. Please use...

Your team has been hired by a multi-national conglomerate to assess two US public companies within the same industry. Your analysis will be used to decide on a major investment in one of the...

TERM PROJECT IS 601 - 03 Objective Implementing linear regression analysis on real-world data. Data US Stock Market data will be used. Below, we have the data item description. Yyymm is the date...

1.If you look at the S&P 500 index price, there was a local minimum of 757.13 in March 2009. What is the real rate of return on the capital gains of the S&P 500 from March 2009 to July 2021? What is...

QUESTION 1 FALSE or TRUE: Probability is the likelihood or chance an outcome or event will happen;it is typically represented in numerical form as a ratio or fraction,a decimal or percentage,but can...

PAST TEST: Consider a utility maximization problem of the representative consumer who makes a choice between consumption C and leisure l . Assume that the consumer's preferences are defined by the...