The client has made the following changes to the job.
Client prefers freelancers from:
You are still able to submit a proposal for this job.
The client prefers freelancers from
a different location.
Calculate average ROACE (return on capital employed) for the period 2005-2010 for 13 New Zealand companies.
ROACE is a simple ratio:
Numerator = net profit after tax + post-tax finance costs (i.e. interest expense multiplied by 1- the NZ company tax rate)
Denominator = Average capital employed over the period (capital employed = book value of interest bearing debt + book value of equity)
The companies are:
Mighty River Power
Genesis Power Limited
The Warehouse Limited
Michael Hill Jeweller
All companies have publicly disclosed accounts
NZ company tax rates for the period were:
1 January 1996 to 31 December 2007 33%
1 January 2008 to 31 March 2011 30%
1 April 2011 28%
Output required is a spreadsheet with all data and calculations.
Work is required by 6...
Sign in or Register to see more