forecasting methods 2

Scenario

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

  1. The last 5 years of income statements
  2. A forecast of economic data for key economic indicators
  3. The basic assumptions the company is making in their business plan

Instructions

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

RUBRIC:

F

F

C

B

A

0

1

2

3

4

Did not Submit

No Pass

Competence

Proficiency

Mastery

Not Submitted

Did not provide a mid or high-level Excel spreadsheet that includes a thoroughly completed 3-year forecast; did not use income statement format for the forecast.

Provided a sufficient high-level 3-year forecast; used income statement format.

Provided a well-developed high-level 3-year forecast; used income statement format.

Provided a detailed high-level 3-year forecast; used income statement format.

Not Submitted

Did not include a summary of 5 years of data and assumptions from income statements.

Included a basic summary of 5 years of data and assumptions from income statements.

Included an expanded summary of 5 years of data and assumptions from income statements.

Included a detailed summary of 5 years of data and assumptions from income statements.

Not Submitted

Did not provide economic data for key economic indicators in the forecast.

Provided basic economic data for the key economic indicators included in the forecast.

Provided expanded economic data for key economic indicators included in the forecast.

Provided comprehensive economic data for key economic indicators included in forecast.

Not Submitted

Did not provide a separate Excel tab that includes a graph to display total revenues and expenses for the time periods covered in the forecast.

Excel tab includes a basic graph to display total revenues and expenses for the time periods covered in the forecast.

Excel tab includes a well-developed graph to display total revenues and expenses for the time periods covered in the forecast.

Excel tab includes a detailed graph to display total revenues and expenses for the time periods covered in the forecast.

Template with 3 tabs is attached

"Is this question part of your assignment? We can help"

ORDER NOW