Homework Answers
| Date | SBUX | Dividend | GOOG | Dividend | |
| 14-11-2011 | 43.64 | 0 | 613 | 0 | |
| 06-02-2012 | 48.29 | 0.17 | 609.09 | 0 | |
| 07-05-2012 | 55.48 | 0.17 | 607.55 | 0 | |
| 06-08-2012 | 43.48 | 0.17 | 642.82 | 0 | |
| 13-12-2012 | 53.18 | 0.21 | 659.05 | 0 | |
| a) | |||||
| Return for SBUX without including the dividends | |||||
| (53.18 - 43.64)/(43.64) | |||||
| 21.86% | |||||
| With the dividends | |||||
| (53.18 - 43.64 + .17 + .17 + .17 + .21)/(43.64) | |||||
| 23.51% | |||||
| b) | |||||
| Return for GOOG over the period | |||||
| (659.05 - 613)/(613) | |||||
| 7.51% | |||||
| c) | |||||
| expected return on a portfolio = XaRa + XbRb | |||||
| where Xa and Xb are the proportions of the total portfolio in assets A&B | |||||
| Ra and Rb are the expected returns on the two securities | |||||
| Ra | 21.86% | ||||
| Rb | 7.51% | ||||
| Xa | 0.25 | ||||
| Xb | 0.75 | ||||
| Expected return on portfolio | .25*.2186 + .75*.0751 | ||||
| Expected return on portfolio | 0.110993 | ||||
| The return on your portfolio excluding dividends is | |||||
| 11.10% | |||||
Add Answer to:
Use the data for Starbucks (SBUX) and Google (GOOG) B to answer the following questions: a....
pleasee help Use the data for Starbucks (SBUX) and Google (GOOG) E to answer the following...
pleasee help
Use the data for Starbucks (SBUX) and Google (GOOG) E 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 25% of your portfolio in SBUX and 75% in GOOG, what was the return on your portfolio excluding dividends? a. What is the return for SBUX over the period without including its...
Download monthly stock prices for Dollar General (DG) and Starbucks (SBUX) between 1/1/2012 and 1/5/2013 using...
Download monthly stock prices for Dollar General
(DG) and Starbucks (SBUX) between 1/1/2012 and 1/5/2013 using
Yahoo Finance (not Google Finance). Use the ADJUSTED closing prices
(not the closing prices) to perform the computations for this
problem.
Hint: Assume that the data that you download is a
sample.
a. Estimate the mean return of Dollar General.
b. Estimate the standard deviation of Dollar
General returns.
c. Estimate the mean return of Starbucks.
d. Estimate the standard deviation of Starbucks
returns...
Day (Related to Checkpoint 3.3) (Analyzing the cash flow Statement) Google, Inc. (GOOG), is one of...
Day (Related to Checkpoint 3.3) (Analyzing the cash flow Statement) Google, Inc. (GOOG), is one of the most successful Internet firms, and it experienced very rapid growth in revenues from 2011 through 2014. The cash flow statements for Google, Inc. spanning the period are found here: Answer the following questions using the information found in these statements: a. Is Google generating positive cash flow from its operations? b. How much did Google invest in new capital expenditures over the period?...
Find five years of monthly returns for two mutual funds, Vanguard’s U.S. Growth Fund and U.S....
Find five years of monthly returns for two mutual funds, Vanguard’s U.S. Growth Fund and U.S. Value Fund, as well as corresponding returns for the S&P 500 and the Treasury-bill rate. (Use Spreadsheet.xls) a. Calculate each fund’s excess rate of return over T-bills in each month. (Negative values should be indicated by a minus sign. Leave no cells blank - be certain to enter "0" wherever required. Do not round intermediate calculations. Round your answers to 2 decimal places.) Total...
Use the following tide table to answer the questions in the Assessing Your Learning section of...
Use the following tide table to answer the questions in the
Assessing Your Learning section of this lab. This tide table shows
the predicted ocean heights for Santa Cruz/Monterey Bay, California
during December 2011.
1. A visit to Santa Cruz/Monterey Bay, California is planned
during the week of December 4-10 to view the tide pools. To observe
intertidal animals during the daytime at the lowest possible tide,
the best time to visit the beach is on _________________ at
_________________. (4...
Please use the following data to answer the questions. The ticker symbols are for Tesla Inc...
Please use the following data to answer the questions. The ticker symbols are for Tesla Inc (TSLA), Barrick Gold Corporation (GOLD) and Apple Inc (AAPL). The prices shown are the closing stock prices for the date shown. Your first task is to compute the monthly holding period returns for each stock for each month, using the Holding Period Return formula, which is HPR = (P1 - P0)/P0, where P1 is the end of period price and P0 is the start...
Use the data in the following table: Year End S&P 500 Index Dividends Paid* S&P 500...
Use the data in the following table: Year End S&P 500 Index
Dividends Paid* S&P 500 Realized Return Microsoft Realized
Return 1-Month T-Bill Return 2004 1211.92 2005 1248.29 23.15 4.90%
-0.90% 3.00% 2006 1418.3 27.16 15.80% 15.80% 4.80% 2007 1468.36
27.86 5.50% 20.80% 4.70% 2008 903.25 21.85 -37.00% -44.40% 1.50%
2009 1115.1 27.19 26.50% 60.50% 0.10% 2010 1257.64 25.44 15.10%
-6.50% 0.10% 2011 1257.61 26.59 2.10% -4.50% 0.00% 2012 1426.19
32.67 16.00% 5.80% 0.10% 2013 1848.36 39.75 32.40% 44.30% 0.00%...
The following table, contains annual returns for the stocks of ABC Corp. (ABC) and Company B...
The following table, contains annual returns for the stocks of ABC Corp. (ABC) and Company B (B). The returns are calculated using end-of-year prices (adjusted for dividends and stock splits) retrieved from http://www.finance.yahoo.com/. Use the information to create an Excel spreadsheet that calculates the standard deviation of annual returns over the 10-year period for ABC, B, and of the equally-weighted portfolio of ABC and B over the 10-year period. (Hint: Review the Excel screenshot on page 173.) The average annual...
Use the following historical stock returns for GAF, Inc. to answer questions 19 and 20: Annual...
Use the following historical stock returns for GAF, Inc. to answer questions 19 and 20: Annual Stock Return Year 2005 13% 2006 1% 2007 -6% 2008 19% 2009 39% 2010 46% 2011 6% 2012 -4% 2013 14% 2014 -6% 2015 8% 0% 2016 2017 16% 2018 22% 19. What was the average annual historical return for GAF, Inc. over the 14 year period? 20. What was the standard deviation of retuns for GAF, Inc. stock over the 14 year time...
Use the following historical stock returns for GAF, Inc. to answer questions 19 and 20: Year...
Use the following historical stock returns for GAF, Inc. to answer questions 19 and 20: Year Annual Stock Return 2005 13% 2006 1% 2007 -6% 2008 19% 2009 39% 2010 46% 2011 6% 2012 -4% 2013 14% 2014 -6% 2015 8% 2016 0% 2017 16% 2018 22% 19. What was the average annual historical return for GAF, Inc. over the 14 year period? 20. What was the standard deviation of returns for GAF, Inc. stock over the 14 year time...
pleasee help
Use the data for Starbucks (SBUX) and Google (GOOG) E 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 25% of your portfolio in SBUX and 75% in GOOG, what was the return on your portfolio excluding dividends? a. What is the return for SBUX over the period without including its...
Download monthly stock prices for Dollar General
(DG) and Starbucks (SBUX) between 1/1/2012 and 1/5/2013 using
Yahoo Finance (not Google Finance). Use the ADJUSTED closing prices
(not the closing prices) to perform the computations for this
problem.
Hint: Assume that the data that you download is a
sample.
a. Estimate the mean return of Dollar General.
b. Estimate the standard deviation of Dollar
General returns.
c. Estimate the mean return of Starbucks.
d. Estimate the standard deviation of Starbucks
returns...
Day (Related to Checkpoint 3.3) (Analyzing the cash flow Statement) Google, Inc. (GOOG), is one of the most successful Internet firms, and it experienced very rapid growth in revenues from 2011 through 2014. The cash flow statements for Google, Inc. spanning the period are found here: Answer the following questions using the information found in these statements: a. Is Google generating positive cash flow from its operations? b. How much did Google invest in new capital expenditures over the period?...
Use the following tide table to answer the questions in the
Assessing Your Learning section of this lab. This tide table shows
the predicted ocean heights for Santa Cruz/Monterey Bay, California
during December 2011.
1. A visit to Santa Cruz/Monterey Bay, California is planned
during the week of December 4-10 to view the tide pools. To observe
intertidal animals during the daytime at the lowest possible tide,
the best time to visit the beach is on _________________ at
_________________. (4...
Use the data in the following table: Year End S&P 500 Index
Dividends Paid* S&P 500 Realized Return Microsoft Realized
Return 1-Month T-Bill Return 2004 1211.92 2005 1248.29 23.15 4.90%
-0.90% 3.00% 2006 1418.3 27.16 15.80% 15.80% 4.80% 2007 1468.36
27.86 5.50% 20.80% 4.70% 2008 903.25 21.85 -37.00% -44.40% 1.50%
2009 1115.1 27.19 26.50% 60.50% 0.10% 2010 1257.64 25.44 15.10%
-6.50% 0.10% 2011 1257.61 26.59 2.10% -4.50% 0.00% 2012 1426.19
32.67 16.00% 5.80% 0.10% 2013 1848.36 39.75 32.40% 44.30% 0.00%...
The following table, contains annual returns for the stocks of ABC Corp. (ABC) and Company B (B). The returns are calculated using end-of-year prices (adjusted for dividends and stock splits) retrieved from http://www.finance.yahoo.com/. Use the information to create an Excel spreadsheet that calculates the standard deviation of annual returns over the 10-year period for ABC, B, and of the equally-weighted portfolio of ABC and B over the 10-year period. (Hint: Review the Excel screenshot on page 173.) The average annual...
Use the following historical stock returns for GAF, Inc. to answer questions 19 and 20: Annual Stock Return Year 2005 13% 2006 1% 2007 -6% 2008 19% 2009 39% 2010 46% 2011 6% 2012 -4% 2013 14% 2014 -6% 2015 8% 0% 2016 2017 16% 2018 22% 19. What was the average annual historical return for GAF, Inc. over the 14 year period? 20. What was the standard deviation of retuns for GAF, Inc. stock over the 14 year time...
Use the following historical stock returns for GAF, Inc. to answer questions 19 and 20: Year Annual Stock Return 2005 13% 2006 1% 2007 -6% 2008 19% 2009 39% 2010 46% 2011 6% 2012 -4% 2013 14% 2014 -6% 2015 8% 2016 0% 2017 16% 2018 22% 19. What was the average annual historical return for GAF, Inc. over the 14 year period? 20. What was the standard deviation of returns for GAF, Inc. stock over the 14 year time...
Most questions answered within 3 hours.
-
Need to do in Python? Can do in Javascript but not in Python
Write a function...
asked 8 minutes ago -
Industry: Telecommunications in India
Here, you need to discuss the sources of the growth pattern
and...
asked 1 hour ago -
Hydrobromic acid
dissolves solid iron according to the followiaung reaction:
Fe(s)+2HBr(aq)→
FeBr2(aq)+ H2(g)
Part A. What...
asked 3 hours ago -
Verify the following vector identity in SPHERICAL
COORDINATES.
div(curl(A)) = 0
asked 4 hours ago -
The work function (Φ) for a metal is 7.50×10-19 J.
What is the longest wavelength (nm)...
asked 5 hours ago -
1. Would the following procedural changes cause the
calculated mass percent Ni2+ ion in Ni(NH3)nCl2 to...
asked 7 hours ago -
1. Why does the voltage of the capacitor vary with frequency?
where does this missing voltage...
asked 8 hours ago -
p p please write each step out clearly
3. A manager of a company is considering...
asked 7 hours ago -
On October 1, Ebony Ernst organized Ernst Consulting; on October
3, the owner contributed $83,540 in...
asked 8 hours ago -
A.)As an electron moves through a region of space, its speed
decreases from 9.60 × 106...
asked 8 hours ago -
In java with the netbeans program do:
Through object programming
Create a class "ContadorP", which is...
asked 8 hours ago -
Pattern Corporation acquired all of Science
Company's outstanding stock on January 1, 2016 for $600,000 cash....
asked 8 hours ago