Spreadsheet forecasting problem
Not what you're looking for?
I need to use excel to solve the problems.... Needs to be familiar with excel spreadsheets. Like in prob one you need to use the trend function in the formula bar to forecast sales in 2004.
Purchase this Solution
Solution Preview
Please see the attached file "forecast.xls" for details. I've also "copy and paste" into the body of this reply just in case you have problems in openning the file.
<br>
<br> 1/9/04
<br>
<br>Solution - 'Chapter 8. Ch 08-10 Build a Model
<br>
<br>Cumberland Industries' financial planners must forecast the company's financial results for the coming year. The forecast will be based o the percent of sales method, and any additional funds needed will be obtained as notes payable.
<br>
<br>
<br>
<br>a. Assuming the historical trend continues, what will sales be in 2004? Base your forecast on a spreadsheet regression
<br> analysis of the 1998-2003 sales data above, and include the summary output of the regression in your answer. By what
<br> percentage are sales predicted to increase in 2004 over 2003? Is the sales growth rate increasing or decreasing?
<br>
<br>Here are the company's historical sales. Hint: Use the Trend function to forecast sales for 2004.
<br>
<br>
<br> Year Sales Growth Rate
<br> 1998 129,215,000
<br> 1999 180,901,000 40.0%
<br> 2000 235,252,000 30.0%
<br> 2001 294,065,000 25.0%
<br> 2002 396,692,000 34.9%
<br> 2003 455,150,000 14.7%
<br> 2004 515,465,267
<br>
<br>
<br> % Increase in Predicted Sales for 2004 over 2003:
<br>
<br>2003Sales 455,150,000
<br>2004 Sales 515,465,267
<br>
<br>% increase 13.25% Note: This growth rate has been declining over time.
<br>
<br>
<br>b. Cumberland's management believes that the firm will actually experience a 20 percent increase in sales during 2004. Construct 2004 pro forma financial ...
Purchase this Solution
Free BrainMass Quizzes
Organizational Leadership Quiz
This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.
Business Ethics Awareness Strategy
This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.
Social Media: Pinterest
This quiz introduces basic concepts of Pinterest social media
Lean your Process
This quiz will help you understand the basic concepts of Lean.
SWOT
This quiz will test your understanding of the SWOT analysis, including terms, concepts, uses, advantages, and process.