PART B Group Assignment
Create a fixed assets register for a Fictitious Manufacturing Firm (financial year
end = end of June)
PART I. Set up a fixed assets register for this manufacturing firm using Microsoft
Excel with the following details:
 The company set up its asset register in year 2010.
 It must include at least four categories of assets.
 In each category of assets, it must have at least 200 items.
 Assets are located in 3 different branches, Melbourne, Sydney and Adelaide.
 It must include the individual asset cost price, asset ID, asset item, date of
purchase, depreciation method (straight line or diminishing value),
depreciation rate, accumulated depreciation value, and carrying amount (book
Value).

 If assets are disposed in the current year, disposal date and disposal value
are also needed.
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).
i. 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?
ii. Show all the assets in Melbourne branch which were purchased after
30 June 2012 and their respective cumulative carrying amount (book
value).

iii. 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).
iv. Show all the assets disposed from the Sydney branch in 2014 with
their respective accumulative depreciation and carrying amount (book
value).

PART III. Write a short report (maximum 600 words) stating the followings:
 Describe the movement of assets in the company from 2010 to 2015 based
on your findings in PART II and justify the choice of depreciation method
used.
 Explain how filtering, vlookup (hlookup) and pivot tables in Microsoft Excel
help you in your analysis.

For a custom-written paper on the above topic, place your order now!

What We Offer:

• On-time delivery guarantee

• PhD-level writers

• Automatic plagiarism check

• 100% money-back guarantee

• 100% Privacy and Confidentiality

• High Quality custom-written papers