Assignment: Logbook Exercise $3$

Financial Forecasting and Optimization

FINAL INDIVIDUAL ASSESSMENT

$($Due Date: $9$th June $2024)$

Required:

$1.$ Executive Summary: Develop your business forecasts that will require optimisation based of the business model which you are required to start from scratch $($Sales$,$ expected expenses, Decision Support Applications used, Ratios of focus, Reasons for the Sensitivity Analysis and Recommendation for Optimisation$).[10$ marks$]$

$2.$ Business Trends: Using Time Series with Business Trends, Cycles and Seasonality

develop forecasts for your sales and expenses for the next $5$ years $($Applying Correct Assumptions and valid Calculation$).[15$ marks$]$

$3.$ Decision Support: Include the forecast developed in Q$2$ in your model to the appropriate Decision Support Application $($Statement of Financial Position, P&L Statement, CF Statement etc$)$ that determine that current Financial State of the Business. $[10$ marks$]$

$4.$ Financial Ratios: Produce the appropriate Financial Ratios that will assist in making the business decisions for optimisation for the $5$ years. $[10$ marks$]$

$5.$ Sensitivity Analysis: Apply Sensitivity Analysis on the Ratios suggesting ways that

business can be optimised using the Solver Tool. $[15$ marks$]$

$($Total: $60$ marks$)$