Question: Please help! Include calculations if any. EA6-R2 Complete a Depreciation Schedule for High-Up Corp. In this exercise, you will create a depreciation schedule for High-Up
EA6-R2 Complete a Depreciation Schedule for High-Up Corp. In this exercise, you will create a depreciation schedule for High-Up Corp. using an Excel table. You will then sort, filter, and analyze the data. These fixed assets, with associated data as of 12/31/2015, were acquired prior to the current year Useful Life years) 7 Accumulated Depreciation $800 Fixed Asset Date of Acquisition 1/1/2014 Salvage Value Cost Office $2,900 $100 Furniture Machinery1/1/2011 Retail Equipment $2,500 $3,600 $5,100 $600 $9,200$200 1/1/2008 20 High-Up Corp. also acquired lobby furniture on 1/1/2016. The Lobby Furniture had a cost of $6,300, an estimated salvage value of $800, and an estimated useful life of eleven years. 1. Open a Blank Workbook and save the file in your Chapter 06 folder as: EA6-R2-Depreciation-[YourName] 2. Type High-Up Corp. in cell A1 and Depreciation Schedule in cell A2. 3. Enter the fixed-asset data in the range A4:F7. Include the Accumulated Depreciation header but exclude its amounts. Also exclude the newly acquired asset for now. Dark 2, and click OK. the table name, and tap Enter 4. Select cell A4, choose Home-Styles-Format as Table-Dark Blue, Table Style 5. Choose Table Tools-Design->Properties, enter Depreciation Schedule for
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
