Copy equipment was acquired at the beginning of the year at a cost of $73,020 that has an estimated residual value of $6,600 and an estimated useful life of 5 years. It is estimated that the machine will output an estimated 1,107,000 copies. This year, 210,000 copies were made. a. Determine the depreciable cost. b. Determine the depreciation rate. Round your answer to two decimal places: per copy c. Determine the units-of-output depreciation for the year.

Copy equipment was acquired at the beginning of the year at a cost of $73,020 that has an estimated residual value of $6,600 and an estimated useful life of 5 years. It is estimated that the machine will output an estimated 1,107,000 copies. This year, 210,000 copies were made. a. Determine the depreciable cost. b. Determine the depreciation rate. Round your answer to two decimal places: per copy c. Determine the units-of-output depreciation for the year.

Name: Copy equipment was acquired at the beginning of the year at a cost of
Uploaded: 2024-03-05T11:50:36.000Z
Channel: Bartleby
Description: Copy equipment was acquired at the beginning of the year at a cost of $73,020 that has an estimated residual value of $6,600 and an estimated useful life of 5 years. Itis estimated that the machine will output an estimated 1,107,000 copies. This yea

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter9: Depreciation (deprec)

Section: Chapter Questions

Problem 5R: A truck was recently purchased for 75,000 with a salvage value of 5,000 and an estimated useful life...

See similar textbooks

Similar questions

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.
Montello Inc. purchases a delivery truck for $15,000. The truck has a salvage value of $3,000 and is expected to be driven for 120,000 miles. Montello uses the units-of-production depreciation method and in year one it expects to use the truck for 23,000 miles. Calculate the annual depreciation expense.
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.
A truck was recently purchased for 75,000 with a salvage value of 5,000 and an estimated useful life of eight years or 150,000 miles (24,000 miles per year for the first five years and 10,000 miles per year after that). Enter the new information in the Data Section of the worksheet. Again, make sure the totals for all three methods are in agreement. Print the worksheet. Save this new data as DEPREC5.
When depreciation is recorded each period, what account is debited? a. Depreciation Expense b. Cash c. Accumulated Depreciation d. The fixed asset account involved Use the following information for Multiple-Choice Questions 7-4 through 7-6: Cox Inc. acquired a machine for on January 1, 2019. The machine has a salvage value of $20,000 and a 5-year useful life. Cox expects the machine to run for 15,000 machine hours. The machine was actually used for 4,200 hours in 2019 and 3,450 hours in 2020.
Copy equipment was acquired at the beginning of the year at a cost of $25,200 that has an estimated residual value of $2,300 and an estimated useful life of 5 years. It is estimated that the machine will output an estimated 1,145,000 copies. This year, 246,000 copies were made. a. Determine the depreciable cost. b. Determine the depreciation rate. Round your answer to two decimal places. per copy c. Determine the units-of-activity depreciation for the year. LA ?
Copy equipment was acquired at the beginning of the year at a cost of $38,660 that has an estimated residual value of $3,500 and an estimated useful life of 5 years. It is estimated that the machine will output an estimated 1,172,000 copies. This year, 270,000 copies were made. a. Determine the depreciable cost. b. Determine the depreciation rate. Round your answer to two decimal places. per copy c. Determine the units-of-output depreciation for the year. Previous Next
Copy equipment was acquired at the beginning of the year at a cost of $52,140 that has an estimated residual value of $4,700 and an estimated useful life of 5 years. It is estimated that the machine will output an estimated 1,186,000 copies. This year, 239,000 copies were made. a. Determine the depreciable cost.$fill in the blank 1 b. Determine the depreciation rate. Round your answer to two decimal places.$fill in the blank 2 per copy c. Determine the units-of-output depreciation for the year.$fill in the blank 3
Copy equipment was acquired at the beginning of the year at a cost of $21,500 that has an estimated residual value of $2,000 and an estimated useful life of 5 years. It is estimated that the machine will output an estimated 975,000 copies. This year, 265,000 copies were made. a. Determine the depreciable cost. $ b. Determine the depreciation rate. Round your answer to two decimal places. $ per copy c. Determine the units-of-activity depreciation for the year.
Copy equipment was acquired at the beginning of the year at a cost of $62,460 that has an estimated residual value of $5,700 and an estimated useful life of 5 years. It is estimated that the machine will output an estimated 946,000 copies. This year, 267,000 copies were made. a. Determine the depreciable cost. b. Determine the depreciation rate. per copy c. Determine the units-of-output depreciation for the year.
A copy machine was purchased for $28,000. It is estimated that the machine will have a useful life of 4 years and a residual value of $4,000. It is estimated that the machine will make 2,000,000 copies. Using the units-of-activity method to depreciate the copy machine, how much will be depreciated if during the first year 550,000 copies were made? a. $24,000 Ob. $7,700 Oc. $6,600 d. $6,000
A utility vehicle purchased by Knox industries should last 110,000 miles . the accusation cost was 21,200 and the salvage value is 1,913. Using the units of production depreciation method given the annual usage information calculate the accumulated depreciation at the end of year to round your depreciation per unit to three decimal places run your answer to the nearest cent. year one 22,029. Your two 22,724. Year 3 23,420. year 4 23,188. Answer key A.3,976.70 B.4,098.50 C.7,831.78 D.13,368.23