Deliverable 5 – Forecasting Methods and Applications Assignment Content Compete

Deliverable 5 – Forecasting Methods and Applications
Assignment Content
CompetencyEmploy accounting data for business analysis and prediction.
Student Success CriteriaView the grading rubric for this deliverable by selecting the “This item is graded with a rubric” link, which is located in the Details & Information pane.
ScenarioThe Corporate Controller has called you into a planning session and asked you to help with the preparation of an income statement forecast for the coming three years. You both discuss the project and decide that the data you will need it is:The last 5 years of income statements
A forecast of economic data for key economic indicators
The basic assumptions the company is making in their business plan
InstructionsThe Corporate Controller would like you to use Excel to prepare a high-level, 3-year forecast (income statement format) incorporating the historical, economic forecast, and assumptions provided by the Corporate Controller. The Corporate Controller also states that the Board of Directors loves to see “pictures” of summary data rather than a “bunch of numbers.” The Corporate Controller suggests that on a separate tab in Excel to use the graphing function to display total revenues and expenses for the periods covered.Create and Excel spreadsheet with two tabs labeled:Tab 1: 3-Year Income Statement Forecast
Tab 2: Graphs
On Tab 1: 3-Year Income Statement Forecast, use the same income statement format and titles as the historical data provided.
Financial Statements
Microsoft Excel is a great tool for business managers and the use of Excel is a requirement for this course. Therefore, you are required to use Excel to perform all of your calculations to demonstrate your work. Manual data entry will not be accepted.
Save your assignment as a Microsoft Excel file. (Mac users, please remember to append the “.xlsx” extension to the filename.) The name of the file should be your first initial and last name, followed by an underscore and the name of the assignment, and an underscore and the date (yyyy-mm-dd). An example is shown below:
Jstudent_exampleproblem_2024-06-27