a) Compute the historical return and standard deviation for each company b) Compute Coefficient of variation for both stocks To solve (c-e), assume a portfolio of $60,000 invested in these two stocks: with $24,000 invested i Google and $36,000 invested in Coca-Cola. c) Compute the portfolio return earned in each year d) Compute the average portfolio return earned during the years (2013-2017) e) Compute the portfolio standard deviation

a) Compute the historical return and standard deviation for each company b) Compute Coefficient of variation for both stocks To solve (c-e), assume a portfolio of $60,000 invested in these two stocks: with $24,000 invested i Google and $36,000 invested in Coca-Cola. c) Compute the portfolio return earned in each year d) Compute the average portfolio return earned during the years (2013-2017) e) Compute the portfolio standard deviation

Financial Management: Theory & Practice

16th Edition

ISBN:9781337909730

Author:Brigham

Publisher:Brigham

Chapter3: Analysis Of Financial Statements

Section: Chapter Questions

Problem 8MC: Use the extended DuPont equation to provide a breakdown of Computrons projected return on equity....

See similar textbooks

Similar questions

An analyst gathered daily stock returns for Feburary 1 through March 31, calculated the Fama-French factors for each day in the sample (SMBt and HMLt), and estimated the Fama-French regression model shown in Equation 6-21. The estimated coefficients were ai = 0, bi = 1.2, ci = 0.4, and di = 1.3. On April 1, the market return was 10%, the return on the SMB portfolio (rSMB) was 3.2%, and the return on the HML portfolio (rHML) was 4.8%. Using the estimated model, what was the stocks predicted return for April 1?
Use the extended DuPont equation to provide a breakdown of Computrons projected return on equity. How does the projection compare with the previous years and with the industrys DuPont equation?
Using the Value Line Investment Survey report in Exhibit 11.5, find the following information for Apple. What was the amount of revenues (i.e., sales) generated by the company in 2017? What were the latest annual dividends per share and dividend yield? What is the earnings per share (EPS) projection for 2019? How many shares of common stock were outstanding? What were the book value per share and EPS in 2017? How much long-term debt did the company have in the third quarter of 2018?
Bartman Industries' and Reynolds Inc.'s stock prices and dividends, along with the Winslow 5000 Index, are shown here for the period 2015-2020. The Winslow 5000 data are adjusted to include dividends. Calculate the standard deviations of the returns for Bartman, Reynolds, and the Winslow 5000. (Hint: Use the sample standard deviation formula, STDEV function in Excel). Bartman Industries Reynolds Inc. Winslow 5000 Year Stock Price Dividend Holding period return Stock Price Dividend Holding period return Includes Divs. Holding period return 2020 $17.25 $1.15 $48.75 $3.00 11,663.98 2019 14.75 1.06 52.30 2.90 8,785.70 2018 16.50 1.00 48.75 2.75 8,679.98 2017 10.75 0.95 57.25 2.50 6,434.03 2016 11.37 0.90 60.00 2.25 5,602.28 2015 7.62 55.75 4,705.97
Please, 1. Calculate the average stock return from 2005–2007, the standard deviation and coefficient of variation over this period. The market price of the stock was $31 at year-end 2004, $35 at year-end 2005, $42 at year-end 2006, and $55 at year-end 2007. For valuation purposes, industry experts use the dividend valuation model to value the common equity interest of industry firms. Potential investors’ required rate of return for this firm is 14 percent; growth rate is 13 percent for 2010 and 2011, and then declines to 12 percent for all later years. Market Returns: The stock returns for the market as a whole were as follows: 15.7 percent in 2005, 8.2 percent in 2006, and 12.1 percent in 2007
In Capital IQ, find the monthly price data (Historical Price, HP) for stocks of Kellogg and IBM from January 2018 to December 2023. Compute the monthly returns, mean return, sample variance, sample standard deviation, sample covariance, and correlation statistics. Graph a monthly mean return and standard deviation frontier of the portfolios composed of these two stocks. The data for Kellogg and IBM is given below. Please provide everything correct as needed with explanations. Dates Kellanova (NYSE:K) - Share Pricing Jan-31-2018 68.11 Feb-28-2018 66.2 Mar-31-2018 65.01 Apr-30-2018 58.9 May-31-2018 64.39 Jun-30-2018 69.87 Jul-31-2018 71.03 Aug-31-2018 71.79 Sep-30-2018 70.02 Oct-31-2018 65.48 Nov-30-2018 63.65 Dec-31-2018 57.01 Jan-31-2019 59.01 Feb-28-2019 56.26 Mar-31-2019 57.38 Apr-30-2019 60.3 May-31-2019 52.56 Jun-30-2019 53.57 Jul-31-2019 58.22 Aug-31-2019…
Each stock's rate of return in a given year consists of a dividend yield (which might be zero) plus a capital gains yield (which could be positive, negative, or zero). Such returns are calculated for all the stocks in the S&P 500. A weighted average of those returns, using each stock's total market value, is then calculated, and that average return is often used as an indicator of the "return on the market."
Stocks A and B have the following historical returns: a. Calculate the average rate of return for each stock during the period 2013 through2017.b. Assume that someone held a portfolio consisting of 50% of Stock A and 50% ofStock B. What would the realized rate of return on the portfolio have been eachyear? What would the average return on the portfolio have been during thisperiod?c. Calculate the standard deviation of returns for each stock and for the portfolio.d. Calculate the coefficient of variation for each stock and for the portfolio.e. Assuming you are a risk-averse investor, would you prefer to hold Stock A, Stock B, orthe portfolio? Why?
You are given the following information regarding prices for a sample of stocks. PRICE PER SHARE Stock Number of Shares Jan December Honda 20 000 170 200 Nissan 40 000 130 155 Toyota 90 000 138 145 i.) Construct a price-weighted index for these three stocks for January and December ii.) Construct a value weighted index for the securities above for January and December iii) Construct an equal-weighted index by assuming $1,000 is invested in each stock. What is the percentage change in wealth for this portfolio?
(Calculating rates of return) The S&P stock index represents a portfolio comprised of 500 large publicly traded companies. On December 24, 2007, the index had a value of 1,410 and on December 24, 2008, the index was approximately 926. If the average dividend paid on the stocks in the index is approximately 4.0 percent of the value of the index at the beginning of the year, what is the rate of return earned on the S&P index? What is your assessment of the relative riskiness of investing in a single stock such as Google compared to investing in the S&P index (recall from Chapter 2 that you can purchase mutual funds that mimic the returns of the index)? Question content area bottom Part 1 The rate of return earned on the S&P 500 is enter your response here%. (Round to two decimal places.)
Stocks for Fumbeshi and Mundashi have the following historical returns: Year Fumbeshi Mundashi 2010 -18% -14.50% 2011 33% 21.80% 2012 15% 30.50% 2013 -0.50% -7.60% 2015 27% 26.30% (i) What is the average return rate of return for each stock during the period 2010 through 2015?(ii) Assuming someone held a portfolio consisting of 50 percent of stocks Fumbeshi and 50 percent stocks of Mundashi, what would have been the realized return on the portfolio during this period? (iii) What is the standard deviation of each stock during the period 2010 through 2015?
(b) Stocks for Fumbeshi and Mundashi have the following historical returns: Year Fumbeshi Mundashi 2010 -18% -14.5% 2011 33% 21.8% 2012 15% 30.5% 2013 -0.5% -7.6% 2015 27% 26.3% (i) What is the average return rate of return for each stock during the period 2010 through 2015? ( (ii) Assuming someone held a portfolio consisting of 50 percent of stocks Fumbeshi and 50 percent stocks of Mundashi, what would have been the realized return on the portfolio during this period? (iii) What is the standard deviation of each stock during the period 2010 through 2015?