Question

In: Finance

Suppose a firm has had the following historic sales figures. Year: 2009 2010 2011 2012 2013...

Suppose a firm has had the following historic sales figures.
Year: 2009 2010 2011 2012 2013
  Sales $ 2,500,000 $ 3,780,000 $ 4,340,000 $ 4,940,000 $ 5,510,000

  

What would be the forecast for next year’s sales using regression to estimate a trend?

Solutions

Expert Solution


Related Solutions

Suppose a firm has had the following historic sales figures. Year: 2009 2010 2011 2012 2013...
Suppose a firm has had the following historic sales figures. Year: 2009 2010 2011 2012 2013   Sales: $ 2,430,000. $ 3,850,000 $ 4,440,000 $ 4,920,000 $ 5,540,000 What would be the forecast for next year’s sales using regression to estimate a trend? Next years sales?
Suppose a firm has had the following historic sales figures. Year: 2016 2017 2018 2019 2020...
Suppose a firm has had the following historic sales figures. Year: 2016 2017 2018 2019 2020 Sales $1,450,000 $1,710,000 $1,600,000 $2,000,000 $1,850,000 What would be the forecast for next year’s sales using regression to estimate a trend?
Years 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 Retail Sales 5.2% 0.3%...
Years 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 Retail Sales 5.2% 0.3% -3.3% 3.0% 4.9% 3.9% 3.1% 4.2% 3.8% 3.9% 3.6% e-commerce Sales 19% 4.1% 2.8% 17.1% 17.5% 14.9% 13.0% 14.6% 14.7% 14.0% 16.0% Does Retail Stores Growth Reduced by E-commerce Growth? Null Hypothesis: Ho: Retail stores growth doesn’t reduce by E-commerce growth. Alternative Hypothesis: Ha: Retail stores growth does reduce by E-commerce growth Do the chi-square test for goodness of fit. with the level of...
year rA rB 2009 -20.50 -17.50 2010 20.50 29.30 2011 14.00 33.80 2012 -4.50 -7.10 2013...
year rA rB 2009 -20.50 -17.50 2010 20.50 29.30 2011 14.00 33.80 2012 -4.50 -7.10 2013 25.76 -3.25 Calculate the average rate of return for stock A during the period 2009 through 2013. Round your answer to two decimal places. %______ Calculate the average rate of return for stock B during the period 2009 through 2013. Round your answer to two decimal places. %_____ Assume that someone held a portfolio consisting of 50% of Stock A and 50% of Stock...
India's Current Account Assumptions​ (millions USD) 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013...
India's Current Account Assumptions​ (millions USD) 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 ​Goods: exports ​77,939 ​102,175 ​123,876 ​153,530 ​199,065 ​167,958 ​230,967 ​307,847 ​298,321 ​319,110 ​329,633 ​Goods: imports ​-95,539 ​-134,692 ​-166,572 ​-208,611 ​-291,740 ​-247,908 ​-324,320 ​-428,021 ​-450,249 ​-433,760 ​-415,529      Balance on goods ​-17,600 ​-32,517 ​-42,696 ​-55,081 ​-92,675 ​-79,950 ​-93,353 ​-120,174 ​-151,928 ​-114,650 ​-85,895 ​Services: credit ​38,281 ​52,527 ​69,440 ​86,552 ​106,054 ​92,889 ​117,068 ​138,528 ​145,525 ​148,649 ​156,252 ​Services: debit ​-35,641 ​-47,287 ​-58,514 ​-70,175 ​-87,739 ​-80,349 ​-114,739 ​-125,041...
You are given the following information about the economy. 2010 2011 2012 2013 u 0.03 0.09...
You are given the following information about the economy. 2010 2011 2012 2013 u 0.03 0.09 0.06 0.03 Y 2244 2343 1134 5678 The natural rate of unemployment is 0.04 and the Phillips curve relationship is ? = ?e - 2 (u - 0.04). Please show your work in answering the following questions: (a) Using the following formula ( Y(overbar)- Y)/ Y(overbar)= 2(u - u(overbar)) estimate full-employment level of output (Y(overbar)) in each year? (b) Calculate the growth rate of...
Year Annual Average CPI 2010 218.1 2011 224.9 2012 229.6 2013 232.9 2014 236.7 2015 237.0...
Year Annual Average CPI 2010 218.1 2011 224.9 2012 229.6 2013 232.9 2014 236.7 2015 237.0 2016 240.0 2017 245.1 2018 251.1 2019 255.6 From the table above, calculate the inflation rate from 2015 to 2016 (5 points) Use the table above to answer:  If you were earning $40,000/year in 2012, how much would you need to be earning in 2019 to have the same purchasing power?. (5 points) Use the table above to answer:  If average college tuition was $10,000 per...
Firm A had sales of $23 billion in 2012. Suppose you expected its sales to grow...
Firm A had sales of $23 billion in 2012. Suppose you expected its sales to grow at a rate of 10% in 2013, but then slow by 0.5% per year to the long-run growth rate that is characteristic of the industry—7.5%—by 2018. Based on Firm A’s past profitability and investment needs, you expect EBIT to be 10% of sales, increases in net working capital requirements to be 10% of any increase in sales, and capital expenditures to equal depreciation expenses....
- 2010 2011 2012 2013 2014 2015 2016 2017 2018 GREECE 129059 135314 153317 160986 168501...
- 2010 2011 2012 2013 2014 2015 2016 2017 2018 GREECE 129059 135314 153317 160986 168501 167036 175100 181261 190523 SPAIN 377095 403834 419865 397462 427672 447048 451255 485805 497812 FRANCE 316137 322254 303269 303031 298203 297880 292160 302840 308629 CROATIA 24329 21862 18972 19366 18603 18930 18551 20798 21573 ITALY 494091 499885 476823 457078 443141 458020 461990 475164 501958 Selected 5 ports. a) Calculate the mean, standard deviation, median, minimum, maximum values of gross weight of goods handled in...
Part A. Suppose that ABC had the following sales growth: Sales in 2012: $0.6M; Sales in...
Part A. Suppose that ABC had the following sales growth: Sales in 2012: $0.6M; Sales in 2013: $20M; Sales in 2014: $50M; Sales in 2015: $100M; Sales in 2016: $55M; settling to a constant growth rate of 2% forever. Thanks to its business model, the company has no inventory or accounts receivables. It books and collects 100% of all sales initially but needs to pay 70% of all sales to the creative entrepreneurs 60 days after the sale. Suppose ABC...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT