This exercise requires you to build a model that will be needed to answer questions in the next Assessment Test. To do so will require you to build some of the core important formulas discussed earlier, including for growth and ratio calculations, as well as a classical corkscrew structure.
This model must be built from scratch (there is not a partially-complete downloadable model available), in order to ensure that you have mastered all aspects required, and to consolidate your overall skills further.
The structure and logic of the following model should be largely self-explanatory given the earlier reading materials, exercises and quizzes:
Some points that can be highlighted include that the model:
With reference to some specific cells and calculations:
The formula used in each cell are as follows:
Some of the questions in the Assessment Test require you to change the value of some of the input assumptions in the model and to find the values of calculations and outputs as these changes are made. Please test your model before starting the quiz (for example, checking that dependent items all change appropriately as the input values are varied).