Question

In: Finance

End of Year Stock Price $ Returns % 2007 $ 20.91 ------- 2008 14.06 -32.76% 2009...

End of Year Stock Price $ Returns %
2007 $ 20.91 -------
2008 14.06 -32.76%
2009 24.81 76.46
2010 35.57 43.37
2011 32.58 -8.41
2012 48.02 47.37
2013 67.43 40.42
2014 51.26 -23.98
2015 36.91 -27.99
2016 47.71 29.26
2017 44.55 -6.62

I received that correct answers, however I do not know how to solve them. Please write out equations for calculator use. Thank you.

a.) What is the average return?

ANSWER: 13.71%

How do you get that? Show Work.

b.) What is the standard deviation?

ANSWER: 38.19%

How do you get that? Show Work.

c.) What is the Variance of return?

ANSWER: 0.145870

How do you get that? Show Work.

Solutions

Expert Solution

a. Average Return -

Where,

N = No. of years

AR =Average Return

b. Standard Deviation (SD) -

c.) Variance of return

Hope this will help, please do comment if you need any further explanation. Your feedback would be appreciated.


Related Solutions

Consider the data in the following table: Year 2004 2005 2006 2007 2008 2009 Stock A...
Consider the data in the following table: Year 2004 2005 2006 2007 2008 2009 Stock A -10% 20% 5% -5% 2% 9% Stock B 21% 7% 30% -3% -8% 25% Use the above information to answer the following questions. Round your answers to four decimal places (i.e. 0.0105). 1. Estimate the average return for stock A. 2. Estimate the average return for stock B. 3. Estimate the volatility of stock A. 4.Estimate the volatility of stock B. 5 .Estimate the...
Balance Sheet as at year end 31st Dec 2005 2006 2007 2008 2009 CAPITAL AND LIABILITIES:...
Balance Sheet as at year end 31st Dec 2005 2006 2007 2008 2009 CAPITAL AND LIABILITIES: Equity share capital 400,000 600,000 500,000 400,000 600,000 Long term loan 500,000 250,000 300,000 400,000 300,000 Sundry creditors 200,000 300,000 350,000 340,000 250,000 Short term loan 50,000 40,000 60,000 115,000 50,000 ASSETS: Land and Building 300,000 500,000 600,000 700,000 450,000 Furniture 600,000 450,000 400,000 400,000 500,000 Cash at bank 50,000 60,000 70,000 50,000 70,000 Stock 140,000 150,000 100,000 80,000 120,000 Prepaid expenses 60,000 30,000...
Year Stock A Returns Stock B Returns 2008 -18.00% -14.50% 2009 33.00 21.80 2010 15.00 30.50...
Year Stock A Returns Stock B Returns 2008 -18.00% -14.50% 2009 33.00 21.80 2010 15.00 30.50 2011 -0.50 -7.60 2012 27.00 26.30 Calculate the average rate of return for each stock during the period 2008–2012. Assume that someone held a portfolio consisting of 50 percent Stock A and 50 percent Stock B. What would have been the realized rate of return on the portfolio in each year from 2008 through 2012? What would have been the average return on the...
7. Property taxes for an Ontario resident over the years are listed. Year: 2007 2008 2009...
7. Property taxes for an Ontario resident over the years are listed. Year: 2007 2008 2009 2010 2011 2012 Taxes: $2,900 $3,000 $3,150 $3,300 $3,400 $3,600 a) Draw/sketch a scatter diagram. b) Calculate the least squares equation. c) Predict the property tax for the year 2020.
The following information was reported by Gap, Inc. in its 2009 annual report. 2009 2008 2007...
The following information was reported by Gap, Inc. in its 2009 annual report. 2009 2008 2007 2006 2005 Total assets (millions) $7,985 $7,564 $7,838 $ 8,544 $ 8,821 Working capital 2,533 1,847 1,653 $ 2,757 $ 3,297 Current ratio 2.19:1 1.86:1 1.68: 2.21:1 2.70:1 Debt to total assets ratio .39:1 .42:1 .45: .39:1 .38:1 Earnings per share $1.59 $1.35 $1.05 $0.94 $1.26 (a) Determine the overall percentage decrease in Gap"s total assets from 2005 to 2009. What was the average...
This is a tableau question. Year Sales 2005 49387 2006 53412 2007 56783 2008 58436 2009...
This is a tableau question. Year Sales 2005 49387 2006 53412 2007 56783 2008 58436 2009 59994 2010 61515 2011 63182 2012 67989 2013 70448 2014 72601 2015 75482 2016 78341 2017 81111 2018 82517 2019 83275 2020 84005 I. (a) Determine the trend line using both linear and two nonlinear equations Hint: You can choose any two of the nonlinear options in edit trend lines within Tableau. (b) Write down the equations (coefficients). Hint: Double click on trend line...
Year A Returns B Returns 2005 -4.6 15.7 2006 1.7 -6.7 2007 -31.5 -26.5 2008 -11.6...
Year A Returns B Returns 2005 -4.6 15.7 2006 1.7 -6.7 2007 -31.5 -26.5 2008 -11.6 -3.7 2009 29.8 9.6 2010 26.9 8.6 2011 22.9 4.7 2012 50.7 42.7 2013 37.3 41.7 2014 30.5 39.2 The following​ table, LOADING...​, contains annual returns for the stocks of Company Upper A ​(Upper A​) and Company Upper B ​(Upper 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...
Using regression in excel to predict future population. Year Population 2007 301.23 2008 304.09 2009 306.77...
Using regression in excel to predict future population. Year Population 2007 301.23 2008 304.09 2009 306.77 2010 309.32 2011 311.56 2012 313.83 2013 315.99 2014 318.3
Year 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 Dividend $         7.46 $         7.91...
Year 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 Dividend $         7.46 $         7.91 $         8.38 $         8.80 $         9.24 $         9.70 $       10.28 $       10.79 $       11.33 $       12.01 Find both the arithmetic growth rate and the geometric growth rate of the dividends for Davy's Crock Pot Stores. Assuming the January​ 1, 2011 price of the stock is $110.00​, determine the current required rate of return for the company​ (use the geometric growth rate to calculate the...
Year Dividend 2007 $                      0.02 2008 $             &nbs
Year Dividend 2007 $                      0.02 2008 $                      0.03 2009 $                      0.04 2010 $                      0.05 2011 $                       0.06 current stock price $10.00 Number of stock shares                    400,000 Debt/Equity ratio 0.75 Interest Paid                    240,000 tax rate 36% Part A. Estimate the constant annual compounding growth rate based on the dividends 2007 through 2011. Growth rate Part B. Use the Gordon dividend model to estimate the cost of equity Cost of equity B. Calculate the WACC Cost of debt WACC
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT