Need help with #3 & 4. Please show work or provide step by step instructions. Thanks!
asset data and has asked that your firm prepare a fixed asset schedule and answer various questions concerning the comparyy's fiwed assets. In addition to the fixed asset data, Stacy included the following information from the compary's fixed asset policies and procedures manyal. faved asset categories are detined as foliows: Land Vacant land parcels purclased for building altes, parking lots, or ather purpeses Land Improvements Site improvements (other than buildings) such as fencing and parking lats. Buildings Permanent structures (inchading permanently attached fictures). Fquipment Self-explanatory. Furniture Self-explanatory Note: This data analytics activity uses an anonymited fixed asset record from a small company for the years of 1991 - 2014 and contains approsimately 1,500 s records Data dictionary - RegionalArea: Indicates the reginnal locabion of the fived asset - Asseti0- This field is a sequendial number assigned at purchaif. This it a unique identified. - Assetcategorya indicates the foxed aiset category. - InsveDate: This is the date the asset was put into service, - Cost: The purchase price of the asset. - SalvageValue: The salvage value assigned by the company. (Hint: Create a calculated field for Ending Acrumulated Depreciation and Ending Book Value.) - DeprMeth: The depreciation method used for the asset. NoDep indicates that no depreciation is being calculated. SL indicates the asset is being - Change the column names in the pivot table to match the headinga listed above. depreciated using the straight-line convention. - Useful tife: The useful life assigned by the company. - Sort the pivot table by book value in descendinit order. - BegAccumDepri Beginning accumulated depreciation as o. - Which region has the highest book vaiue? Highlight this value in Green. Requirements - How much depreciation was taken during the vear for the entire company? Highlight that value in Red To start the analytics project, go to the Fixed Assets tab in the Excel file. In cell 2. Which repon(s) does not have land? 13, enter the last two (2) digits of your banner ID. If the last two (2) digits of 3. Which asset category has the highest total coat? in addition to the prot your Banner ID are "00", please contact your instructor immediately. tabie, include a pivot chart and slicer to wrawer this quesbion. 4. What is the maximum and minimum asset cost in each aset category? For each of the following requirements, create a new plvot table in a new 5. In Word, prepare a memorandum addressed to 5tacy Fisher, The memo worksheet. Name each new worksheet as "Req 1," "Req 2, " etc. Format the should sammarize the fixed asset schedule. It should also discuss any areat dollar amounts in each pivot table or pivot chart using the accounting format that you deem important. Ae sure to discuss the overall stary that you see with zero decimal places. Format non-currency numbers in each pivot table or emerging from the plvot tables, charts and worksheete. The memo should pivot chart using the accounting format with zero decimal places. be in APA format, Times New Roman font siae 10, singlespoced (double 1. Prepare a fixed asset schedule that contains the totals for cost, beginning accumulated depreciation, current year depreciation, ending accumulated depreciation, and ending book value by regional areas
