2012 Round 2: Asset Schedule
Originally published: 23/07/2018 14:49
Publication number: ELQ-44674-1
View all versions & Certificate

2012 Round 2: Asset Schedule

Excel training/competition model from the 2012 Financial Modeling World Championships

This workbook is taken from the 2nd round of the 2012 Modeloff financial modeling world chamionships.

Follow the instructions in order to complete the model:


You've been asked to prepare model the forecast asset schedules for a new business. As part of the analysis you are required to analyze the impact on the forecast deferred tax. To help you prepare the analysis you have been provided with following information:


All capex amounts (presented in the table in the attached PDF) are specified in provided in real 2012 US$m. All Capital expenditure is incurred at the first day of each calendar year.


You have been advised that the inflation rate is forecast to be 3% per annum.


For accounting purposes, depreciation on the Capex is calculated on a straight line basis over 12 years.


For taxation purposes, depreciation on Capex is calculated using the diminishing value method at a rate of 40% per annum. The taxation rate is currently 30% per annum but is forecast to moving down to 28% from the start of 2016.


In developing your model, you are expected to adhere to the ModelOff style conventions. At the end of this section you will be required to submit the model you built when answering this question.

Allotted time: 35 minutes

Once finished, feel free to upload your model to your own dedicated author channel!

This Best Practice includes
1 Excel Workbook, 1 PDF

ModelOff now Full Stack Modeller offers you this Best Practice for free!

download for free

Add to bookmarks


4.9 / 5 (7 votes)

please wait...