QUESTION II

PART II. Set up the solutions for the following queries based on the fixed assets register created in part a (Microsoft Excel functions i.e. filtering, vlookup (hlookup) and pivot tables must be used at least once in the solution).

1. What are the total depreciation expense (from 1 July 2014 to 30 June 2015 only), accumulative depreciation and net asset value at the end of the financial year, 30 June 2015 for the respective assets in each location and category?

2. Show all the assets in Melbourne branch which were purchased after 30 June 2012 and their respective cumulative carrying amount (book value).

3. Predict the depreciation expense and total carrying amount (book value) at the end of June 2016 and at the end of June 2017, assuming no additional purchase or disposal after 30 June 2015 for each branch (show the subtotal amount for each categories in each branch).

4. Show all the assets disposed from the Sydney branch in 2014 with their respective accumulative depreciation and carrying amount (book value).

    

   Need by 6pm Australia, Melbourne Time 

   so in about 2 hours