12.1
Sales forecasts.
For the prior three years, sales for National Beverage Company have been
$22,059,000 (2011), $23,186,000 (2012), and $24,032,000 (2013). The company uses the prior two years' average growth rate to predict the coming year's sales.
1. Sales growth rate for 2012=(sales in 2012/sales in 2011)-1=(23186000/22059000)-1=5.11%
Sales growth rate for 2013=(sales in 2013/sales in 2012)-1=(24032000/23186000)-1=3.65%
2. Two year average rate=(5.11%+3.65%)/2=4.38%
Sales forcast for 2014=2013 sales*(1+4.38%)=24032000*1.0438=25,084,357
12.1 Sales forecasts. For the prior three years, sales for National Beverage Company have been $22,059,000...
12.2 Sales forecasts. For the prior three years, sales for California Cement Company have been $19,957,000 (2011), $21,003,000 (2012), and $22,956,000 (2013). The company uses the prior two years' average growth rate to predict the coming year's sales. What were the sales growth rates for 2012 and 2013? What is the expected sales growth rate using a two-year average for 2014? What is the sales forecast for2014? What was the sales growth rate for 2012?
Sales forecasts. For the prior three years, sales for California Cement Company have been $20,068,000 (2011), $21,073,000 (2012), and $22,809,000 (2013). The company uses the prior two years' average growth rate to predict the coming year's sales. What were the sales growth rates for 2012 and 2013? What is the expected sales growth rate using a two-year average for 2014? What is the sales forecast for 2014? What was the sales growth rate for 2012? (Round to two decimal places.)...
A company wants to forecast demand using the simple moving average. If the company uses three prior yearly sales values (i.e., year 2011 = 185, year 2012 = 215, and year 2013 = 230), what is the simple moving average forecast for year 2014?
Sales forecast based on external data. Raspberry Phones uses external data to forecast the coming year's sales. The company has 7.6% of all new-phone sales in the United States and 5.7% of all replacement-phone sales. Industry forecasts predict 18.1million new-phone buyers and 30.1million replacement-phone buyers in 2014. If the average Raspberry phone costs $84.20, what sales revenues is the company forecasting for 2014? $___(Round to the nearest dollar.)
E5.13. Converting Analysts' Forecasts to a Valuation: Nike, Inc. (Medium) Nike reported book value per share of $15.93 at the end of its 2008 fiscal year. Analysts were forecasting earnings of $3.90 per share for 2009 and $4.45 for 2010, and were also forecasting a five-year growth rate in EPS of 13 percent per year. Prepare a five-year pro forma of earnings based on these forecasts and convert the forecasts to a valuation with the added forecast that residual earnings...
12.5 Production cash outflow. National Beverage Company produces its products two months in advance of anticipated sales and ships to warehouse centers the month before sale. The inventory safety stock is 7% of the anticipated month's sale. Beginning inventory in October 2014 was 263,956 units. Each unit costs $0.24 to make. The average selling price is $0.68 per unit. The cost is made up of 37% labor, 48% materials, and 15% shipping (to the warehouse). The company pays for labor...
Suppose we have the following annual sales data for an automobile dealership: Year Sales Trend 2009 121 1 2010 187 2 2011 165 3 2012 134 4 2013 155 5 2014 167 6 2015 200 7 2016 206 8 2017 221 9 2018 231 10 We want to forecast sales for 2019 and 2020 using either a simple trend model or a quadratic trend model. Use a within sample forecasting technique...
Use Segment Information to Refine Sales Forecast To forecast sales growth for FY2018 for a publicly traded company in the retail sector, we begin with the following historical sales information. $ millions 2017 2016 2015 2014 2013 Net sales. ................ $46,021 $39,865 $37,536 $36,012 $34,553 Require a. Determine the sales-growth rate (in percentage) for 2014 to 2017. What trend do we observe? b. If we were to use the four-year average sales growth to forecast 2018 sales, what rate would...
[Related to Don't Let This Happen To Youll Use the data for the country of New Finlandia in the following table to calculate the following: REAL GDP PER CAPITA YEAR (2005 PRICES) 2010 $41,848 2011 42,648 2012 42,159 2013 43,459 2014 43,441 (HINT: Remember from the previous chapter that the average annual growth rate for relatively short periods can be approximated by averaging the growth rates of those years.) a. The percentage increase in real GDP per capita between 2010...
I have inserted the formulas needed to calculate the income statement. However I do not know how to enter the formulas for my assumptions that are highlighted on the right. I am trying to create a forecasted income statement in excel from 2011 (original data) -through 2017 (forecasted data) . Can you help me with this. Net sales 2011 2012 2013 2014 2015 2016 2017 Assumptions 965,922 forecast forecast forecast forecast forecast forecast Increase Year by 3% Maintain the 2011...