Forecasting Methods And Applications Assignment Content Forecasting Methods and Applications Top of Form Competency Employ accounting data for busine

Forecasting Methods And Applications Assignment Content

Forecasting Methods and Applications

Top of Form

Competency

Employ accounting data for busine

Click here to Order a Custom answer to this Question from our writers. It’s fast and plagiarism-free.

Forecasting Methods And Applications Assignment Content

Forecasting Methods and Applications

Top of Form

Competency

Employ accounting data for business analysis and prediction.

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.

Bottom of Form

Place your order now for a similar assignment and have exceptional work written by one of our experts, guaranteeing you an A result.

Need an Essay Written?

This sample is available to anyone. If you want a unique paper order it from one of our professional writers.

Get help with your academic paper right away

Quality & Timely Delivery

Free Editing & Plagiarism Check

Security, Privacy & Confidentiality