Deliverable 5 – Forecasting Methods and Applications
Employ accounting abstracts for business assay and prediction.
Student Success Criteria
View the allocation explanation for this deliverable by selecting the “This account is graded with a rubric” link, which is amid in the Details & Information pane.
The Corporate Controller has alleged you into a planning affair and asked you to advice with the alertness of an income account forecast for the advancing three years. You both altercate the activity and adjudge that the abstracts you will charge it is:
The aftermost 5 years of assets statements
A anticipation of bread-and-butter abstracts for key bread-and-butter indicators
The basal assumptions the aggregation is authoritative in their business plan
The Corporate Controller would like you to use Excel to adapt a high-level, 3-year anticipation (income account format) incorporating the historical, bread-and-butter forecast, and assumptions provided by the Corporate Controller. The Corporate Controller additionally states that the Board of Directors loves to see “pictures” of arbitrary abstracts rather than a “bunch of numbers.” The Corporate Controller suggests that on a abstracted tab in Excel to use the graphing action to affectation absolute revenues and costs for the periods covered.
Create and Excel spreadsheet with two tabs labeled:
Tab 1: 3-Year Assets Account Forecast
Tab 2: Graphs
On Tab 1: 3-Year Assets Account Forecast, use the aforementioned assets account architecture and titles as the actual abstracts provided.
Template to Use:
Order a unique copy of this paper
Top Academic Writers Ready to Help
with Your Research Proposal