Reference no: EM132392824
Assignment -
1. Actuals vs. Forecast Creation & Analysis
Utilizing the "Actuals" information please build out and populate the Q4 Actuals in the "Q4 Financials" tab using excel formulas.
The variances to forecast will automatically populate once you have built the Q4 actuals
Please provide variance commentaries based on the Actuals incurred and the Forecast details provided.
Your commentary in Column R should be at the Account Roll up level and should be rich enough to facilitate a 'Risks & Opportunities' conversation with Finance Management.
2. Executive Presentation
Please provide 15 minute presentation outlining:
Insights into variances between actual and forecast.
Data and insights can be summarized as candidate sees fit.
To be presented in slide format to GM of Adobly
Please provide xls sheet that supports the presentation.
Please note any assumptions you have made.
Attachment:- Assignment File.rar