Deliverable 5 – Forecasting Methods and Applications

Assignment Content Competency 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. Scenario 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 Instructions 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: