Answered step by step
Verified Expert Solution
Question
1 Approved Answer
What is Starbuck's [SBUX] beta? Round to two decimal places. [Hint: Take S&P 500 as a proxy for the market, and use the beta formula
What is Starbuck's [SBUX] beta? Round to two decimal places. [Hint: Take S&P 500 as a proxy for the market, and use the beta formula from the book. You will need to use two Excel functions: STDEV.S and CORREL]
S&P500 DECK 7.4% SBUX -1.5% 19 Oct-19 Sep:19 Aup.19 NKE 0.1% 4.7% 11,4% -0.1% -5.796 - 11.2% 15.7% 2.29 1.9% -1.6% 1.49 -8.1% 2.0% 13.0% 10.7% 394 -3.99 4,0% 7.6% -0.6% 15.2% 19 0.4% Jun-19 May-19 Apr 19 Mar-19 Feb-19 Jan-19 Dec 18 Nov-18 Oc18 Sep-18 Aup-18 Jul-18 Jun-18 May-18 Apr-18 9.1% -12296 4.6% -1.8% 4.79 10.4% -10 0.1% -11.4% 3.3% 69 3.29 8.0% 3.15 5.89 -1046 -40% 14 5% 906 20 -6.8% 7.2% -2.7% 8.0% 0.6% 3.3% 7.1% 20% 7296 -111 3.79 110% 0.6% 21,3% 3.69% 50 12% 0.4% -0.6% 19 10.3% -0.9% -1.7% 94% 0.5% -3.79 5.7% 1.1% 3.5% -0.19 99% 5.44 319 2.14 Feb-18 Jan-18 Dec 17 Nov. 17 Oct 17 Sep 17 Aue-17 Jul-17 Jus 17 May-17 Apr 17 Mar 17 Feb-17 99% 61% -1.5% 10.6% -0.2% 7.1% -1.5% -5.0% 2.3% 2.1% 16 019 0.4% 2.1% 0.6% 113% 4% 0.3% .. 5996 10 3.1% 16.4% -0.2% 13.1% -33% 4.0% -6.9% 14.0 -12.4% .8.9% 0.1% 4.0% 1.9% 81% 27% 3.3% 02% . 926 20% 3.79 0.0% 0.1% 19 16 14.8% 0.3% 19 0.8% 00 -6.3% 19 -0.26 07 -2.4% 58 .9.0% 3.3% 5.99 14.4% 0 6.8% Des 16 Nov-16 Oct-16 Sep-16 Aug.16 Jul-16 Jun-16 May-16 Apr 16 Mar 16 Feb-16 Jan 16 De-15 Nov.15 Oct 15 Sep-15 Aug.15 Jul 15 Juris May-15 Apr 15 Mar 15 Feb. 15 Jan.15 1.246 -30% . 0.1% 8.4% .12.1% -4.1% .9.8% 11.6% 5946 1.06 686 10.06 -106 67% 10.1% 1.95 1.49 8.0 .6.0% 21% 3.5% 63% 299 -1.9% 1.1 1.09 479 1.6% -1.8% 12.496 -1.5 16 3 1.795 5.78 S&P500 DECK 7.4% SBUX -1.5% 19 Oct-19 Sep:19 Aup.19 NKE 0.1% 4.7% 11,4% -0.1% -5.796 - 11.2% 15.7% 2.29 1.9% -1.6% 1.49 -8.1% 2.0% 13.0% 10.7% 394 -3.99 4,0% 7.6% -0.6% 15.2% 19 0.4% Jun-19 May-19 Apr 19 Mar-19 Feb-19 Jan-19 Dec 18 Nov-18 Oc18 Sep-18 Aup-18 Jul-18 Jun-18 May-18 Apr-18 9.1% -12296 4.6% -1.8% 4.79 10.4% -10 0.1% -11.4% 3.3% 69 3.29 8.0% 3.15 5.89 -1046 -40% 14 5% 906 20 -6.8% 7.2% -2.7% 8.0% 0.6% 3.3% 7.1% 20% 7296 -111 3.79 110% 0.6% 21,3% 3.69% 50 12% 0.4% -0.6% 19 10.3% -0.9% -1.7% 94% 0.5% -3.79 5.7% 1.1% 3.5% -0.19 99% 5.44 319 2.14 Feb-18 Jan-18 Dec 17 Nov. 17 Oct 17 Sep 17 Aue-17 Jul-17 Jus 17 May-17 Apr 17 Mar 17 Feb-17 99% 61% -1.5% 10.6% -0.2% 7.1% -1.5% -5.0% 2.3% 2.1% 16 019 0.4% 2.1% 0.6% 113% 4% 0.3% .. 5996 10 3.1% 16.4% -0.2% 13.1% -33% 4.0% -6.9% 14.0 -12.4% .8.9% 0.1% 4.0% 1.9% 81% 27% 3.3% 02% . 926 20% 3.79 0.0% 0.1% 19 16 14.8% 0.3% 19 0.8% 00 -6.3% 19 -0.26 07 -2.4% 58 .9.0% 3.3% 5.99 14.4% 0 6.8% Des 16 Nov-16 Oct-16 Sep-16 Aug.16 Jul-16 Jun-16 May-16 Apr 16 Mar 16 Feb-16 Jan 16 De-15 Nov.15 Oct 15 Sep-15 Aug.15 Jul 15 Juris May-15 Apr 15 Mar 15 Feb. 15 Jan.15 1.246 -30% . 0.1% 8.4% .12.1% -4.1% .9.8% 11.6% 5946 1.06 686 10.06 -106 67% 10.1% 1.95 1.49 8.0 .6.0% 21% 3.5% 63% 299 -1.9% 1.1 1.09 479 1.6% -1.8% 12.496 -1.5 16 3 1.795 5.78
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started