In this exercise, you will create a depreciation schedule for Furniture Resellers as of 12/31/2016using an Excel table. You will then sort, filter, and analyze the data in the table. These fixed assets,with associated data as of 12/31/2015, were acquired prior to the current year.Fixed AssetDate ofCostSalvageValueUseful LifeAccumulatedAcquisition(years)DepreciationMachinery1/1/2007$8,200$70010$6,750GarageEquipment1/1/2009$11,000S200$8,400Computers1/1/2013$4,000so$2,400Furniture 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 italicformatting.3. Enter the fixed-asset data in the range A4:F7; for the accumulated depreciation, enterthe title but not the dollar amounts.

Depreciation: Depreciation is the process of deducting the total cost of the asset of the company.…

Answered: In this exercise, you will create a…

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Determining asset cost, preparing depreciation schedules (3 methods), and identifying depreciation results that meet management objectives On January 3, 2018, Speedy Delivery Service purchased a truck at a cost of $67,000. Before placing the truck in service, Speedy spent $3,000 painting it, $1,200 replacing tires, and $3,500 overhauling the engine. The truck should remain in service for five years and have a residual value of $5,100. The truck’s annual mileage is expected to be 20,000 miles in each of the first four years and 12,800 miles in the fifth year—92,800 miles in total. In deciding which depreciation method to use, Alec Rivera, the general manager, requests a depreciation schedule for each of the depreciation methods (straight-line, units-of-production, and double-declining-balance). Requirements Prepare a depreciation schedule for each depreciation method, showing asset cost depreciation expense, accumulated depreciation, and asset book value. Speedy prepares financial…
Before you begin this assignment, review the Tying It All Together feature in the chapter iHeartMedia , Inc. in their annual report for the year ending December 31, 2015, state that the plant assets reported on its balance sheet includes the following: Depreciation is computed using the straight-line method. Requirements 1. Suppose iHeartMedia, Inc. purchases a new advertising structure for $100,000 on August 1. The residual value of the structure is $4,000 and the useful life is 10 years. How would iHeartMedia record the depreciation expense on December 31 in the first year of use? What about the second year of use? 2. What would be the book value of the structure at the end of the first year? What would be the book value of the structure at the end of the second year? 3. What would be the impact on iHeartMedia, Inc. financial statements if they failed to record the adjusting entry related to the structure?
Equipment acquired on January 8, 20Y1, at a cost of $675,000, has an estimated useful life of 17 years and an estimated residual value of $135,000. What was the annual amount of depreciation for the years 20Y1, 20Y2, and 20Y3, using the straight-line method of depreciation? Round annual depreciation to the nearest dollar and use this amount in your follow-on calculations. Depreciation expense 20Y1$ 20Y2$ 20Y3$
Cullumber Company had the following assets on January 1, 2022. Useful Life (in years) Salvage Value $ 0 Item Cost Purchase Date Machinery $72,000 Jan. 1, 2012 10 Forklift 31,000 Jan. 1, 2019 Truck 37,400 Jan. 1, 2017 8. 3,000 During 2022, each of the assets was removed from service. The machinery was retired on January 1. The forklift was sold on June 30 for $12,100. The truck was discarded on December 31. Journalize all entries required on the above dates, indluding entries to update depreciation, where applicable, on disposed assets. The company uses straight-line depreciation. All depreciation was up to date as of December 31, 2021. (Credit account titles are automatically indented when the amount is entered. Do not indent manually. If no entry is required, select "No Entry" for the account titles and enter 0 for the amounts.) Date Account Titles and Explanation Debit Credit (To record depreciation expense on forklift) (To record sale of forklift) (To record depreciation expense on…
Equipment was acquired on January 1, 2025 at a cost of $162,000. The equipment was originally estimated to have a salvage value of $8,200 and an estimated life of 10 years. Depreciation has been recorded through December 31, 2027 using the straight-line method. On January 1, 2028, the estimated salvage value was revised to $14,200 and the useful life was revised to a total of 8 years. Prepare the journal entry to record depreciation expense for 2028. (If no entry is required, select "No Entry" for the account titles and enter o for the amounts. Credit account titles are automatically indented when the amount is entered. Do not indent manually. List all debit entries before credit entries.) Depreciation expense for 2028 $ Adjusting journal entry at 12/31/28: Date Account Titles and Explanation Dec. 31 eTextbook and Media List of Accounts Save forlater Debit Credit
Victor Mineli, the new controller of Splish Brothers Inc. has reviewed the expected useful lives and salvage values of selected depreciable assets at the beginning of 2022. Here are his findings: Type of Asset Building Warehouse Date Acquired Jan 1, 2014 Jan 1, 2017 Cost $824,000 107,000 Accumulated Depreciation Jan. 1, 2022 $156,800 Revised annual depreciation $ Useful life (in years) Building Old 40 20.540 25 $ Proposed 58 20 Warehouse Salvage Value Old Proposed $37,200 All assets are depreciated by the straight-line method. Splish Brothers Inc. uses a calendar year in preparing annual adjusting entries and financial statements. After discussion, management has agreed to accept Victor's proposed changes. (The "Proposed" useful life is total life, not remaining life) Compute the revised annual depreciation on each asset in 2022. (Round answers to O decimal places, e.g. 5.125.) $40,000 4,300 12.960 SUPPORT
Computing Depreciation Expense. Equipment costing $440,000, with an expected scrap value of $40,000 and an estimated useful life of 5 years, was purchased on January 1, 20 Calculate the depreciation expense for years 2012 to 2016 using: (a) the straight-line method and (b) the double-declining-balance method. Round to the nearest whole number. 2012 2013 2014 2015 2016 Straight-line depreciation Double declining balance (0) without straight-line switch-over s (b) with straight-line switch-over 80,000 v$ 80,000 vS 80,000 vs 80,000 v S 80,000 176,000 vs 176,000 vs 105,600 S 63,360 vs 38,016 $ 17,024 105,600 vs 80,000 x $ 80,000 x s 80,000 x Which method is typically preferred for: A) income tax purposes? Double-dedining balance o thi financial reporting purposes? Straight-line method
Now change the Cost, Life of the Asset, and Salvage Value for all of the assets listed in the table in your worksheet to match the information below: Asset No. 1-001 1-002 1-003 1-004 1-005 1-006 1-007 Fixed Asset Name Desktop computer 13" Laptop Laptop 15" Tablet 4-person Workstation Office chairs (set of 4) 70" Flat Screen TV - Straight-Line Double-Declining Straight-Line Double-Declining Straight-Line Double-Declining Total Depreciation Year 1 $ 1,940 Cost $1,700 $1,100 $2,700 $ 650 Be sure to also check the Cost in both of your Depreciation Method tables in your worksheet so that it matches the updated information. Total Accumulated Depreciation Year 1 $3,100 $1,000 $1,500 Required: 2a. Complete the chart below that shows comparisons of the two depreciation methods. (Round your answers to the nearest whole dollar.) Total Net Book Value Year 1 Life of Asset 5 Total Depreciation Year 2 55510105 Total Accumulated Depreciation Year 2 Salvage Value $ 0 $ 0 Total Net Book Value Year 2…
Victor Minell, the new controller of Sheridan Company, has reviewed the expected useful lives and salvage values of selected depreciable assets at the beginning of 2022. Here are his findings: Type of Asset Building Warehouse Date Acquired Jan 1, 20 Jan 1, 2017 Cost $810,000 Revised annual depreciation $ eTextbook and Media List of Accounts Dec. 31 110,000 Compute the revised annual depreciation on each asset in 2022 Accumulated Depreciation Jan. 1, 2022 $153,200 Building Date Account Titles and Explanation Useful life (in years) Old Proposed 40 21,180 25 All assets are depreciated by the straight-line method. Sheridan Company uses a calendar year in preparing annual adjusting entries and financial statements. After discussion, management has agreed to accept Victor's proposed changes. (The "Proposed" useful life is total life, not remaining life.) 58 20 Warehouse Salvage Value Old $44,000 Debit 4,100 Prepare the entry to record depreciation on the building in 2022. (Credit account…
Victor Mineli, the new controller of Ivanhoe Company, has reviewed the expected useful lives and salvage values of selected depreciable assets at the beginning of 2025. Here are his findings: Type of Asset Building Warehouse Date Acquired (a) Jan. 1. 2017 Jan, 1, 2020 Cost $857,000 129,500 Accumulated Depreciation, Jan. 1, 2025 $159,100 Revised annual depreciation $ 24,960 Useful Life (in years) Old Proposed 40 58 20 Building 25 All assets are depreciated by the straight-line method. Ivanhoe Company uses a calendar year in preparing annual financial statements. After discussion, management has agreed to accept Victor's proposed changes. (The "Proposed" useful life is total life, not remaining life.) Salvage Value Old $61,500 4,700 Compute the revised annual depreciation on each asset in 2025. (Round answers to 0 decimal places. e.g. 125.) Warehouse Proposed $35,600 5,300
With direct write off, one writes off amounts from sales in the past are determined to be uncollectible. An estimate writes off estimated amounts of current sales that are expected to be uncollectible. Does that help you determine the accounting principle used for estimates? And a fixed asset question: when an asset is fully depreciated (think Kate's Cards after four years when the equipment with cost of $4,800 has accumulated depreciation of $4,800), should a company keep it on the books? Why or why not?
Saved Help Save & Exi Check Required information Enter your search term E8-4 (Algo) Determining Financial Statement Effects of an Asset Acquisition and Depreciation (Straight- Line Depreciation) LO8-2, 8-3 [The following information applies to the questions displayed below.] During Year 1, Ashkar Company ordered a machine on January 1 at an invoice price of $23,000. On the date of delivery, January 2, the company paid $6,000 on the machine, with the balance on credit at 9 percent interest due in six months. On January 3, it paid $600 for freight on the machine. On January 5, Ashkar paid installation costs relating to the machine amounting to $2,800. On July 1, the company paid the balance due on the machine plus the interest. On December 31 (the end of the accounting period), Ashkar recorded depreciation on the machine using the straight-line method with an estimated useful life of 10 years and an estimated residual value of $4,200. E8-4 Part 5 5. What would be the net book value of…

SEE MORE QUESTIONS

Recommended textbooks for you

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis…

Accounting

ISBN:

9780134475585

Author:

Srikant M. Datar, Madhav V. Rajan

Publisher:

PEARSON

Intermediate Accounting

Accounting

ISBN:

9781259722660

Author:

J. David Spiceland, Mark W. Nelson, Wayne M Thomas

Publisher:

McGraw-Hill Education

Financial and Managerial Accounting

Accounting

ISBN:

9781259726705

Author:

John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS