Need help with #3-4. please show work in excel. Thanks

asset data and has asked that your firm prepare a fixed asset schedule and answer various questions concerning the company to fived assets. in addition to the fixed asset data, Stacy inchuded the following information from the compary's fixed asset policies and procedures manyal. fined asset categories are detined as foliows: Land Vacant land parcels purchased for building aites, parking lots, or athef purposes Hand Improvements site improvements (other than buildings) such as fencing and parking lats. Buildings Permanent structures (including permanently attached fictures) Fquipment Self-explanatory. Furniture Self-explanatory. Note: This data analytics activity uses an anomymieed fixed asset record froct a small compary for the years of 1991 - 2014 and cantains approsimately 1300s records Data dictionary - RegionalArea: indicates the rezinnal locabion of the fixed aaset - Assetio: This Hield is a sequential number assigned at purchane. This it a unique identified. - Assetcategorya Indicatps the frxed auset 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 Accumulated Depreciason and Ending Book value.) - DeprMeth: The depreciation method used for the asset. NoDer. - Change the column names in the pivot table to match the headinga depreciated using the straighe-tre carnention depreciation is being calculated. SL indicates the asset is being listed above. - Useful Life: The useful life assigned by the company. - Sort the pivot table by book value in descendirit order. - BegAccumDepra Beginning accumulated depreciation as - Which region has the highest book vaiue? Highlight this value in Green. Requirements - How much depreciation was taken during the year for the entire company? Highlight tha value in Red To start the analytics project, go to the Fixed Assets tab in the Excel file. In cell 2. Which region(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 cost? in addition to the prot your Banner ID are "00"; please contact your instructor immediately. tabie, include a pivot chart and nlicer to answer this quesbion. 4. What is the maximum and minimum asset cost in each asiet catecory? For each of the following requirements, create a new plyot table in a new 5. In Word, prepare a memorandum addressed to Stacy Fisher, The memo worksheet. Name each new worksheet as "Req 1," "Req 2," etc. Format the should summarize the fixed asset schedule. It should also diacuss any areas dollar amounts in each pivot table or plvot chart using the accounting format that you deem important- Be 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 pivot tables, charts and worksheeta. The memo should pivot chart using the accounting format with zero decimal places. be in APA format, Times New Roman font sise 10, single-spsced (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. conditional format is Ce4l Formathing = Table = stofles undo leipboud rost Aligretent C11 13 fi furniture