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

2012 Round 2: Asset Schedule

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

asset schedulecapexcapital expendituredepreciation scheduleexcel skillsexcel trainingfinancial modeling skillsfinancial modeling training

Description
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:

INTRODUCTION

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:

FORECAST CAPITAL EXPENDITURE

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.

FORECAST INFLATION

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

ACCOUNTING TREATMENT

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

TAX TREATMENT

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.

STYLE CONVENTIONS

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 business tool includes
1 Excel Workbook, 1 PDF

MODELOFF offers you this business tool for free!

download for free

Add to bookmarks

Discuss

Reviews

  • No review yet!

keyboard_arrow_leftkeyboard_arrow_right

More tools from MODELOFF

See all
keyboard_arrow_leftkeyboard_arrow_right

Any questions on 2012 Round 2: Asset Schedule?

The user community and author are here to help. Go ahead!

please wait...