Complete a depreciation schedule to enter fixed-asset data in an Excel table, calculate depreciation expense, and analyze the table data. (Chapter 6) Use this information, provided as of 1/31/2019, to create the depreciation schedule as of 1/31/2020 using appropriate headers and a table in which all pertinent information is displayed: Date of Salvage Useful Life Accumulated (years) 10 Fixed Asset Cost Value Acquisition 1/31/2014 Depreciation $15,000 Automobile Store Fixtures Office Equipment $32,000 $11,300 $6.900 $2,000 $1.300 $900 1/31/2018 $2.000 1/31/2015 6 $4.000 CratWorld, uses the straight-line method of depreciation. In addition to the fixed assets shown, the company acquired new furniture on 1/31/2019. It cost $3,100, has an estimated four-year useful life, and an estimated salvage value of $300. Create the table so each of the six categories shown above is displayed in a separate column (note that some figures may appear different in your 1/31/2020 table than in the 1/31/2019 chart). Include columns for the annual depreciation expense and year-end book value. Use a function to calculate depreciation expense and use structured references when calculating the year-end book value. Sort the table by accumulated depreciation in ascending order and include a total row to sum each column (except Salvage Value; display the average for that column). Filter the table to display only assets for which the cost is greater than $5,000. Last, use Quick Analysis to apply data bars to the figures in the Salvage Value column. (Hint: Begin by highlighting the figures for which you will display the data bars.)

Trinkle Company made several purchases of long-term assets during the year. The details of each purchase are presented here. New Office Equipment 1. List price: $42,600; terms: 2/10, n/30; paid within the discount period. 2. Transportation-in: $880. 3. Installation: $400. 4. Cost to repair damage during unloading: $630. 5. Routine maintenance cost after eight months: $150. Basket Purchase of Copier, Computer, and Scanner for $52,500 with Fair Market Values 1. Copier, $23,421. 2. Computer, $12,027. 3. Scanner, $27,852. Land for New Warehouse with an Old Building Torn Down 1. Purchase price, $83,800. 2. Demolition of building, $4,760. 3. Lumber sold from old building, $1,780. 4. Grading in preparation for new building, $7,900. 5. Construction of new building, $279,000.

What is the journal entry Declan's Designs recorded to recognize 2022 deprecation expense?   Question 5 options:   Dr. Accumulated Depreciation $3,000     Cr. Depreciation Expense $3,000   Dr. Depreciation Expense $2,000     Cr. Accumulated Depreciation $2,000   Dr. Depreciation Expense $3,000     Cr. Accumulated Depreciation $3,000   Dr. Depreciation Expense $1,000     Cr. Accumulated Depreciation $1,000

eBook   Show Me How Revision of Depreciation A building with a cost of $1,200,000 has an estimated residual value of $250,000, has an estimated useful life of 40 years, and is depreciated by the straight-line method.

Calculate depreciation and fill out the form 4562 for 2022 year based on the following information: Depreciable assets: Recovery Prior Description Placed in Service Cost Method Convention Period Depreciation $32,963 MACRS/ 01/01/2020 $85,000 HY 7 200DB 01/15/2021 $13,930 HY 7 $1,991 04/15/20XX $1,900 7 Tools Equipment Sprayer MACRS/ 200DB MACRS/ 200DB HY Prior AMT Depreciation $32,963 $1,492 The S corporation has elected not to take the Section 179 deduction for the full amount of the cost of the sprayer or bonus depreciation.

The fact that generally accepted accounting principles allow companies flexibility in choosing between certain allocation methods can make it difficult for a financial analyst to compare periodic performance from firm to firm. Suppose you were a financial analyst trying to compare the performance of two companies. Company A uses the double-declining- balance depreciation method. Company B uses the straight-line method. You have the following information taken from the 12/31/2021 year-end financial statements for Company B: Income Statement Depreciation expense $10,000 Balance Sheet Assets: Plant and equipment, at cost Less: Accumulated depreciation Net $ 200,000 (40,000) $ 160,000 You also determine that all of the assets constituting the plant and equipment of Company B were acquired at the same time, and that all of the $200,000 represents depreciable assets. Also, all of the depreciable assets have the same useful life and residual values are zero. Required: 1. In order to compare…

Choose the appropriate definition for each term. Term Long-lived assets Capitalization of cost Units-of-production method Definition Assets that will be used for more than a year. How expenses are reported in the income statement. A depreciation method that produces higher amounts of depreciation expense in the early years of an asset's life and lower amounts in the later years. Carrying value Asset impairment loss Depreciation

Computing Partial Period Depreciation under Multiple Depreciation Methods Compute depreciation expense for 2021 for each asset #1, #2, #3, and #4. Note: Do not round until your final answer. Round your final answer to the nearest whole dollar. Acquisition Acquisition Useful Salvage 2021 Depreciation Value Asset Date Depreciation Method Cost Life Expense #1 Jan. 1, 2020 Straight-line $4,000 4 years $200 $ 950 v #2 Aug. 30, 2020 Double-declining-balance 5,800 8 years 400 $ 1,125 x #3 Feb. 1, 2021 Sum-of-the-years'-digits 7,200 4 years 320 $ 1,147 x #4 Jul. 31, 2021 Straight-line 13,520 8 years 0 $

PLEASE provide Solutions

Answer it correctly and typed answer please. I ll rate.