Answered step by step
Verified Expert Solution
Question
1 Approved Answer
what is the Accumulated Depreciation for the Newly acquired asset (Lobby Furniture) if its not given to me like the other fixed assets in the
what is the Accumulated Depreciation for the Newly acquired asset (Lobby Furniture) if its not given to me like the other fixed assets in the chart? Or do I leave this blank in my excel worksheet? with associated data as of 12/31/2015, were acquired prior to the current year. $700 Fixed Asset Date of Cost Salvage Useful Life Accumulated Acquisition Value (years) Depreciation Machinery 1/1/2007 $8,200 $6,750 Garage 1/1/2009 $11,000 $200 $8,400 Equipment Computers 1/1/2013 $4,000 $0 $2,400 Furniture Resellers also acquired lobby furniture on 1/1/2016. The lobby furniture had a cost of $2,000, an estimated salvage value of $400, and an estimated useful life of eight years. 1. Open a Blank Workbook and save the file in your Chapter 06 folder as: EA6-A2-Depreciation-[YourName) 2. Enter appropriate bank reconciliation headers in the range A1:A2, apply italic formatting. 3. Enter the fixed-asset data in the range A4:F7; for the accumulated depreciation, enter the title but not the dollar amounts. lipboard 5 Font Alignment Number X cDE Furniture Resellers Depreciation Schedule 1 Fixed Asset Machinery Garage Equipment Computers Lobby Furniture Total Date of Salvage Acquisition Cost Value 1 /1/2007 $ 8,200 $ 700 1/1/2009 $ 11,000 $ 200 1/1/2013 $ 4,000 $ 1/1/2016 $ 2,000 $ 400 $ 25,200 $ 1,300 Useful Life Accumulated Depreciation Year-End (Years) Depreciation Expense Book Value 10 $ 7,500 $ 750 9 $ 9,600 $ 1,200 $1,400,00 5 $ 3,200 $ 800 S H00.00 8 + I$ 200 $2.000,00 8 $ 20,300 $ 2,950 Year-End Book Value Lobby Furniture Computers 17 18 19 Serage Equipment 21 Machinery Sheet1
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started