8) What SUP Partial Year Sum of the Year’s Digits Depreciation for Asset 1004 Create a new worksheet to calculate depreciation for a table purchased on August 1, 2017, for $95,000. It has an estimated salvage value of $2,000 and is to be depreciated over 10 years using the sum-of-the-year’s digits method. Follow the same process used in the chapter to calculate depreciation for partial periods.
Asset# 1004
Asset Table
Date acquired 8/1/2017
Cost $95,000.00
Depreciation method SYD
Salvage value $2,000.00
Estimated useful life 10
Days in 1st year 152
Year | Depreciation | Accumulated depreciation |
2017 | 16909.09 | 16909.09 |
2018 | 15218.18 | 32127.27 |
2019 | 13527.27 | 45654.55 |
2020 | 11836.36 | 57490.91 |
2021 | 10145.45 | 67636.36 |
2022 | 8454.55 | 76090.91 |
2023 | 6763.64 | 82854.55 |
2024 | 5072.73 | 87927.27 |
2025 | 3381.82 | 91309.09 |
2026 | 1690.91 | 93000 |
Year | Book value year start | Total cost Depreciable | Depreciation percent | Depreciation expense | Accumulated depreciation | Book value year end |
2017 | 95000 | 93000 | 7.5757% (5/12) x (10/55) |
7045.401 | 7045.401 | 85954.60 |
2018 | 85954.60 | 93000 | 17.4242% [(7/12) x (10/55)] + [(5/12) x (9/55)] |
16204.506 | 23249.907 | 69750.09 |
2019 | 69750.09 | 93000 | 15.606% [(7/12) x (9/55)] + [(5/12) x (8/55)] |
14513.58 | 37763.487 | 55236.51 |
2020 | 55236.51 | 93000 | 13.7879% [(7/12) x (8/55)] + [(5/12) x (7/55)] |
12822.747 | 50586.234 | 42413.77 |
2021 | 42413.77 | 93000 | 11.9697% [(7/12) x (7/55)] + [(5/12) x (6/55)] |
11131.821 | 61718.055 | 31281.95 |
2022 | 31281.95 | 93000 | 10.1515% [(7/12) x (6/55)] + [(5/12) x (5/55)] |
9440.895 | 71158.95 | 21841.05 |
2023 | 21841.05 | 93000 | 8.3333% [(7/12) x (5/55)] + [(5/12) x (4/55)] |
7749.969 | 78908.919 | 14091.08 |
2024 | 14091.08 | 93000 | 6.5151% [(7/12) x (4/55)] + [(5/12) x (3/55)] |
6059.043 | 84967.962 | 8032.04 |
2025 | 8032.04 | 93000 | 4.697% [(7/12) x (3/55)] + [(5/12) x (2/55)] |
4368.21 | 89336.172 | 3663.83 |
2026 | 3663.83 | 93000 | 2.8788% [(7/12) x (2/55)] + [(5/12) x (1/55)] |
2677.284 | 92013.456 | 986.54 |
2027 | 986.54 | 93000 | 1.061% [(7/12) x (1/55)] |
986.73 | 93000.186 | 0 |
8) What SUP Partial Year Sum of the Year’s Digits Depreciation for Asset 1004 Create a...
40. If the asset is depreciated under the sum-of the-years'-digits method, the denominator of the depreciation rate would be a. 55 b. 20 c. 15 d. 5 41. If the asset is acquired on January 1, 2016, and is depreciated under the sum-of-the-years'-digits method, first-year depreciation (rounded) would be a. $81,667 b. $60,000 c. $49,000 d. $20,417 Under any GAAP depreciation method, the maximum depreciation permitted over the asset's life is... 42. a. $255,000 b. $250,000 c. $245,000 d. $200,000...
40. If the asset is depreciated under the sum-of-the-years-digits method, the denominator of the depreciation rate would be... a. 55 b. 20 c. 15 d. 5 41. If the asset is acquired on January 1, 2016, and is depreciated under the sum-of-the-years'-digits method, first-year depreciation (rounded) would be... a. $81,667 b. $60,000 c. $49.000 d. $20,417 42. Under any GAAP depreciation method, the maximum depreciation permitted over the asset's life is ... a. $255,000 b. $250,000 c. $245,000 d. $200,000...
Chapter 4 Assignments 1 Modify What SUP's Straight-Line Depreciation Schedule You are to add another depreciation schedule for What SUP. Use the ch4-01_SLN_student_name.xls worksheet you created in this chapter. Add a new depreciation worksheet, labeled Asset 1003, using the Move or Copy Shortcut menu. The asset to be depreciated is a forge purchased on January 1, 2018, for $85,000. It has an estimated salvage value of $4,000 and is to be depreciated over 3 years using the straight-line method. Update...
E11-6 (L01,2) (Depreciation Computations-Five Methods, Partial Periods) Muggsy Bogues Company purchased equip ment for $212,000 on October 1, 2017. It is estimated that the equipment will have a useful life of 8 years and a salvage value of $12,000. Estimated production is 40.000 units and estimated working hours are 20,000. During 2017, Bogues uses the equipment for 525 hours and the equipment produces 1,000 units. Instructions Compute depreciation expense under each of the following methods. Bogues is on a calendar-year...
deprecaion ror partial periods. Save the worbook as ha-OS student name (replacing student name with your name). Print the newly created worksheet Chapter 4 Case Problem 1: KELLY'S BOUTIQUE Kelly's Boutique owned the following fixed assets as of December 31, 2018: Description 102 103 101 Asset # Building Computer System Phone System Asset Date acquired Cost $625,000 $95,000 $25,000 $4,000 25 years $84,000 $5,000 5 years Salvage value Estimated useful life 4 years Excel for Part 1 08 You are...
P11-11. (Depreciation for Partial Periods—SL, Act., SYD, and DDB) (LO 1, 2) On January 1, 2015, a machine was purchased for $90,000. The machine has an estimated salvage value of $6,000 and an estimated useful life of 5 years. The machine can operate for 100,000 hours before it needs to be replaced. The company closed its books on December 31 and operates the machine as follows: 2015, 20,000 hours; 2016, 25,000 hours; 2017, 15,000 hours; 2018, 30,000 hours; and 2019,...
Exercise 11-12 Depreciation methods; disposal; partial periods [LO11-2] Howarth Manufacturing Company purchased a lathe on June 30, 2014 at a cost of $105,000. The residual value of the lathe was estimated to be $9,000 at the end of a five-year life. The lathe was sold on March 31, 2018. for $27,000. Howarth uses the straight line depreciation method for all of its plant and equipment. Partial year depreciation is calculated based on the number of months the asset is in...
30. What is sum-of-the-vears'-digits depreciation for 2018 $586,667 b. $660,000 c. $720,000 d. $781,485 a. 31. If, at the end of 2019, Davis Company decides the equipment still has five more years of life beyond 12/31/19, with a salvage value of $200,000, what is straight-line depreciation for 2019? (Assume straight-line used in all years.) a. $240,000 b. $256.667 c. $290,000 d. $440,000 32. Property, plant and equipment is usually presented in the balance sheet at: Replacement costs less accumulated depreciation....
Exercise 12-29 Value of Accelerated Depreciation: Sum-of-Years'-Digits (SYD) and Double Declining. Balance (DDB) Methods (LO 12-3) Freedom Corporation acquired a fixed asset for $100,000. Its estimated life at time of purchase was 4 years, with no estimated salvage value. Assume a discount rate of 8% and an income tax rate of 40%. (Use Exhibit 124. Appendix C. TABLE 1 and Appendix C. TABLE 2) Required: 1. What is the incremental present value of the tax benefits resulting from calculating depreciation...
EA6-A2 Complete a Depreciation Schedule for Furniture Resellers In this exercise, you will create a depreciation schedule for Furniture Resellers as of 12/31/2016 using 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 Asset Date of Cost Salvage Useful Life Accumulated Acquisition Value (years) Depreciation Machinery 1/1/2007 $8,200 $700 10 $6,750 1/1/2009 $8,400 Garage Equipment $11,000 $200...