Supreme Auto Service opened a new service center three decades ago. At the time the center was preparing to open, new equipment was purchased totaling $355,000. Residual value of the equipment was estimated to be $45,000 after 20 years. The company accountant has been using straight-line depreciation on the equipment. (a) How much was the annual depreciation for the original equipment (in $)? $   (b) If the hydraulic lift had originally cost $14,200, what would its residual value (in $) be after 20 years? $  (c) After six years of operation, the original hydraulic lift was replaced with a new model that cost $23,000. Book value was allowed for the old machine as a trade-in. What was the old hydraulic lift's book value when the replacement machine was bought (in $)? $  (d) What was the book value of the equipment inventory at the six-year point, substituting the new hydraulic lift for the original after the new lift had joined the inventory (in $)? $

Montello Inc. purchases a delivery truck for $25,000. The truck has a salvage value of $6,000 and is expected to be driven for 125,000 miles. Montello uses the units-of-production depreciation method, and in year one the company expects the truck to be driven for 26,000 miles; in year two, 30,000 miles; and in year three, 40,000 miles. Consider how the purchase of the truck will impact Montellos depreciation expense each year and what the trucks book value will be each year after depreciation expense is recorded.

Dunedin Drilling Company recently acquired a new machine at a cost of 350,000. The machine has an estimated useful life of four years or 100,000 hours, and a salvage value of 30,000. This machine will be used 30,000 hours during Year 1, 20,000 hours in Year 2, 40,000 hours in Year 3, and 10,000 hours in Year 4. With DEPREC5 still on the screen, click the Chart sheet tab. This chart shows the accumulated depreciation under all three depreciation methods. Identify below the depreciation method that each represents. Series 1 _____________________ Series 2 _____________________ Series 3 _____________________ When the assignment is complete, close the file without saving it again. Worksheet. The problem thus far has assumed that assets are depreciated a full year in the year acquired. Normally, depreciation begins in the month acquired. For example, an asset acquired at the beginning of April is depreciated for only nine months in the year of acquisition. Modify the DEPREC2 worksheet to include the month of acquisition as an additional item of input. To demonstrate proper handling of this factor on the depreciation schedule, modify the formulas for the first two years. Some of the formulas may not actually need to be revised. Do not modify the formulas for Years 3 through 8 and ignore the numbers shown in those years. Some will be incorrect as will be some of the totals. Preview the printout to make sure that the worksheet will print neatly on one page, and then print the worksheet. Save the completed file as DEPRECT. Hint: Insert the month in row 6 of the Data Section specifying the month by a number (e.g., April is the fourth month of the year). Redo the formulas for Years 1 and 2. For the units of production method, assume no change in the estimated hours for both years. Chart. Using the DEPREC5 file, prepare a line chart or XY chart that plots annual depreciation expense under all three depreciation methods. No Chart Data Table is needed; use the range B29 to E36 on the worksheet as a basis for preparing the chart if you prepare an XY chart. Use C29 to E36 if you prepare a line chart. Enter your name somewhere on the chart. Save the file again as DEPREC5. Print the chart.

During the current year, Arkells Inc. made the following expenditures relating to plant machinery. Renovated seven machines for $250,000 to improve efficiency in production of their remaining useful life of eight years Low-cost repairs throughout the year totaled $79,000 Replaced a broken gear on a machine for $6,000 A. What amount should be expensed during the period? B. What amount should be capitalized during the period?

Sand River Sales has a fork truck used in its warehouse operations. The truck had an original useful life of five years. However, after depreciating the asset for three years, the company makes a major repair that extends the life by four years. What is the remaining useful life after the major repair?

Colquhoun International purchases a warehouse for $300,000. The best estimate of the salvage value at the time of purchase was $15,000, and it is expected to be used for twenty-five years. Colquhoun uses the straight-line depreciation method for all warehouse buildings. After four years of recording depreciation, Colquhoun determines that the warehouse will be useful for only another fifteen years. Calculate annual depreciation expense for the first four years. Determine the depreciation expense for the final fifteen years of the assets life, and create the journal entry for year five.

During the current year, Arkells Inc. made the following expenditures relating to plant machinery. Renovated five machines for $100,000 to improve efficiency in production of their remaining useful life of five years Low-cost repairs throughout the year totaled $70,000 Replaced a broken gear on a machine for $10,000 A. What amount should be expensed during the period? B. What amount should be capitalized during the period?

IMPACT OF IMPROVEMENTS AND REPLACEMENTS ON THE CALCULATION OF DEPRECIATION On January 1, 20-1, Dans Demolition purchased two jackhammers for 2,500 each with a salvage value of 100 each and estimated useful lives of four years. On January 1, 20-2, a stronger blade to improve performance was installed in Jackhammer A for 800 cash and the compressor was replaced in Jackhammer B for 200 cash. The compressor is expected to extend the life of Jackhammer B one year beyond the original estimate. REQUIRED 1. Using the straight-line method, prepare general journal entries for depreciation on December 31, 20-1, for Jackhammers A and B. 2. Enter the transactions for January 20-2 in a general journal. 3. Assuming no other additions, improvements, or replacements, calculate the depreciation expense for each jackhammer for 20-2 through 20-4.

Tree Lovers Inc. purchased 2,500 acres of woodland in which it intends to harvest the complete forest, leaving the land barren and worthless. Tree Lovers paid $5,000,000 for the land. Tree Lovers will sell the lumber as it is harvested and it expects to deplete it over ten years (150 acres in year one, 300 acres in year two, 250 acres in year three, 150 acres in year four, and 100 acres in year five). Calculate the depletion expense for the next five years and create the journal entry for year one.

To test your formulas, assume the machine purchased had an estimated useful life of three years (20,000, 30,000, and 50,000 hours, respectively). Enter the new information in the Data Section of the worksheet. Does your depreciation total 320,000 under all three methods? There are three common errors made by students completing this worksheet. Lets clear up two of them. One, an asset that has a three-year life should have no depreciation claimed in Year 4. This can be corrected using an =IF statement in Year 4. For example, the correct formula in cell C32 is =IF(B32D9,0,(D7D8)/D9) or =IF(B32D9, 0, SLN(D7, D8, D9)). You may wish to edit what you have already entered rather than retype it. Two, as mentioned in requirement 2, the double-declining-balance calculation needs to be modified in the last year of the assets life. Assuming you have already modified the formula for Year 4 (per instructions in step 2), alter the formula for Year 3 also. If you corrected any formulas, test their correctness by trying different estimated useful lives (between 3 and 8) in cell E9. Then reset the Data Section to the original values, save the revised file as DEPREC2, and reprint the worksheet to show the correct formulas. The third common error doesnt need to be corrected in this problem. The general form of the double-declining-balance formula needs to be modified to check the net book value of the asset each year to make sure it does not go below salvage value. =DDB does this automatically, but if you are writing your own formulas, this gets very complicated and is beyond the scope of the problem.