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

Expert Solution

orchestra answered 1 year ago

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....

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.

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...

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...

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 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

Machlin provided the following data for 2008 and 2009: Inventory December 31, 2007 $174,000 December 31,...

Machlin provided the following data for 2008 and 2009: Inventory December 31, 2007 $174,000 December 31, 2008 187,000 December 31, 2009 196,000 Cost of goods sold 2008 $547,000 2009 586,000 Gross margin 2008 $253,000 2009 291,000 Do not round until your final answers. Round all calculations to two decimal places. (a) Calculate the inventory turnover ratio for 2008 and 2009. 2008 ___ times 2009 ____ times (b) Calculate the gross margin return on inventory investment for 2008 and 2009. 2008...

Use Excel to develop a regression model for the Hospital Database to predict the number of...

Use Excel to develop a regression model for the Hospital Database to predict the number of Personnel by the number of Births. How many residuals are within 1 standard error? Write your answer as a whole number. Personnel Births 792 312 1762 1077 2310 1027 328 355 181 168 1077 3810 742 735 131 1 1594 1733 233 257 241 169 203 430 325 0 676 2049 347 211 79 16 505 2648 1543 2450 755 1465 959 0 325...

Question