Accounting homework help

/in /by

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)
  5. Fixed Asset Register Fictitious Manufacturing Firm June 30 2010
    Melbourne
    Individual Asset cost price Asset ID Asset Item Date of Purchase Depreciation Method Depreciation Rate Accumulated Depreciation Value Carrying amount
    BUILDINGS
    600,000 17765 80 01/01/2009 straight line 20,000 30,000 570,000
    LAND
    750,000 20976 50 30/06/2008 nil nil nil 750,000
    MOTOR VEHICLES
    10,000 45876 100 01/01/2010 straight line 500 250 9,750
    OFFICE EQUIPMENT
    50 12873 90 01/01/2009 straight line 10 15 35
    Sydney
    BUILDINGS
    700,000 17764 70 01/01/2009 straight line 30,000 45,000 655,000
    LAND
    800,000 20977 70 01/01/2008 nil nil nil 800,00
    MOTOR VEHICLES
    10,000 45877 50 01/01/2010 straight line 500 250 9,750
    OFFICE EQUIPMENT
    50 12874 50 01/01/2009 straight line 10 15 35
    Adelaide
    BUILDINGS
    500,000 17762 50 01/01/2009 straight line 15,000 22,500 477,500
    LAND
    600,000 20978 80 01/01/2008 nil nil nil 600,000
    MOTOR VEHICLES
    10,000 45878 50 01/01/2010 straight line 500 250 9,750
    OFFICE EQUIPMENT
    50 12875 60 01/01/2009 straight line 10 15 35