Question
In: Finance
Use the data for Starbucks (SBUX) and Google (GOOG) LOADING... to answer the following questions: a....
Use the data for Starbucks (SBUX) and Google (GOOG) LOADING... to answer the following questions:
a. What is the return for SBUX over the period without including its dividends? With the dividends?
b. What is the return for GOOG over the period?
c. If you have 30 % of your portfolio in SBUX and 70 % in GOOG, what was the return on your portfolio excluding dividends?
Date SBUX Dividend GOOG Dividend 2011-11-14 $43.64 $0.00 $613.00 $0.00 2012-02-06 $48.29 $0.17 $609.09 $0.00 2012-05-07 $55.48 $0.17 $607.55 $0.00 2012-08-06 $43.48 $0.17 $642.82 $0.00 2012-12-13 $53.18 $0.21 $659.05 $0.00
Solutions
Expert Solution
SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE
jeff jeffy answered 2 years agoRelated Solutions
Use the data for Starbucks (SBUX) and Google (GOOG) Date SBUX Dividend GOOG Dividend Copy to...
Use the data for Starbucks (SBUX) and Google (GOOG)
Date
SBUX
Dividend
GOOG
Dividend
Copy to Clipboard
+
Open in Excel
+
2011-11-14
$ 43.64$43.64
$ 0.00$0.00
$ 613.00$613.00
$ 0.00$0.00
2012-02-06
$ 48.29$48.29
$ 0.17$0.17
$ 609.09$609.09
$ 0.00$0.00
2012-05-07
$ 55.48$55.48
$ 0.17$0.17
$ 607.55$607.55
$ 0.00$0.00
2012-08-06
$ 43.48$43.48
$ 0.17$0.17
$ 642.82$642.82
$ 0.00$0.00
2012-12-13
$ 53.18$53.18
$ 0.21$0.21
$ 659.05$659.05
$ 0.00$0.00
to answer the following questions:
a. What is the return for SBUX over...
Use the data for Starbucks (SBUX) and Google (GOOG) Date SBUX Dividend GOOG Dividend 2011-11-14 $43.64...
Use the data for Starbucks (SBUX) and Google (GOOG)
Date
SBUX
Dividend
GOOG
Dividend
2011-11-14
$43.64
$0.00
$613.00
$0.00
2012-02-06
$48.29
$0.17
$609.09
$0.00
2012-05-07
$55.48
$0.17
$607.55
$0.00
2012-08-06
$43.48
$0.17
$642.82
$0.00
2012-12-13
$53.18
$0.21
$659.05
$0.00
to answer the following questions:
a. What is the return for SBUX over the period without including
its dividends? With the dividends?
b. What is the return for GOOG over the period?
c. If you have
29 %29%
of your portfolio...
For this homework assignment, you will use the google trends to answer the following questions: 1....
For this homework assignment, you will use the google trends to
answer the following questions:
1. Use https://www.google.com/trends/ (Links to an external
site.)Links to an external site. to find search trends for terms:
a. "iPhone X", and b. "iPhone 8 Plus" between May 1, 2017 to Jan 1,
2018.
2. Summarize the data and present your findings. Please take
screenshots of the results from Google Trends and reference these
screenshots when you present your findings. Create a Microsoft
Document for...
The following information is provided for Starbucks (SBUX) and McDonalds (MCD) for the fiscal year (2017)....
The following information is provided for Starbucks (SBUX) and
McDonalds (MCD) for the fiscal year (2017). All amounts are in
millions of USD.
SBUX
MCD
Net Sales
22,386.60
24,621.90
Cost of Goods Sold
9,038.20
11,698.80
Operating Expenses
9,605.30
5,178.60
Cash & Cash Equivalents
2,462.30
2,671.20
Short-term Investments
228.60
-
Accounts Receivable
870.40
1,569.00
Inventory
1,364.00
54.20
Other Current Assets
358.10
495.90
Total Current Assets
5,283.40
4,790.30...
Use the following data to answer the questions below:
Use the following data to answer the
questions below: Q
VC
MC
AVC
1
$10
___
___
2
16
___
___
3
20
___
___
4
25
___
___
5
31
___
___
6
38
___
___
7
46
___
___8
55
___
___9
65
___
___ a. Calculate the marginal cost and
average variable cost for each level of production.b. How much would the firm produce if
it could sell its product for...
The following table provides data for a project. Use the data to answer the following questions...
The following table provides data for a project. Use the
data to answer the following questions
Activity
Immediate
Predecessor
Time Estimates (weeks)
Optimistic
Most Likely
Pessimistic
Expected
Variance
A
-
6
7
14
B
-
8
10
12
C
A
2
3
4
D
A
6
7
8
E
B,C
5
5.5
9
F
B,C
5
7
9
G
D,E
4
6
8
H
F
2.5
3
3.5
Draw a network to represent the above project.
What is the critical...
The following table provides data for a project. Use the data to answer the following questions...
The following table provides data for a project. Use the
data to answer the following questions
Activity
Immediate
Predecessor
Time Estimates (weeks)
Optimistic
Most Likely
Pessimistic
Expected
Variance
A
-
6
7
14
B
-
8
10
12
C
A
2
3
4
D
A
6
7
8
E
B,C
5
5.5
9
F
B,C
5
7
9
G
D,E
4
6
8
H
F
2.5
3
3.5
Draw a network to represent the above project.
What is the critical...
The following table provides data for a project. Use the data to answer the following questions...
The following table provides data for a project. Use the
data to answer the following questions
Activity
Immediate
Predecessor
Time Estimates (weeks)
Optimistic
Most Likely
Pessimistic
Expected
Variance
A
-
6
7
14
B
-
8
10
12
C
A
2
3
4
D
A
6
7
8
E
B,C
5
5.5
9
F
B,C
5
7
9
G
D,E
4
6
8
H
F
2.5
3
3.5
Draw a network to represent the above project.
What is the critical...
Use the data given in the table to answer the following questions. The data represents the...
Use the data given in
the table to answer the following questions. The data represents
the average number of miles that a salesperson travels in a day
verses the number of sales made each month.
Miles, x
24
32
75
41
76
107
32
46
112
Sales, y
76
58
190
112
141
235
24
147
188
(a) What is the value
of the correlation coefficient for this set of data? Round to 3
decimal places.
(b) What is the...
Please answer all the questions. Thank you Use the following data to answer the questions below:...
Please answer all the questions. Thank you
Use the following data to answer the questions below:
Column 1
Column 2
Column 3
Y in $
C in $
0
500
500
850
1,000
1,200
1,500
1,550
2,000
1,900
2,500
2,250
3,000
2,600
What is mpc and mps? Compute mpc and mps.
Assume investment equals $ 100, government spending equals $
75, exports equal $ 50 and imports equal $ 35. Compute the
aggregate expenditure in column 3.
Draw a graph...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- 23- Celsius Corp. is conducting a capital budgeting analysis to decide whether to invest in a...
- Using energy level diagrams, predict the relative stability of a Br2 molecule as well as the...
- A 0.0038 kg leaf falls 16.8 m to the ground, where it lands with a speed...
- Problem 1: In the figure to the right, m1=20.0kg and α=53.1o . The coefficient of kinetic...
- A palindrome is a string whose reversal is identical to the string. For example, 110010011 is...
- Explain how the shape of the load duration curve for a particular system affects the selection...
- For physics discussion post. Please TYPE the response as I struggle with reading written information. Explain...
ADVERTISEMENT