Baird Moran manages the cutting department of Greene Benson Company. He purchased a tree-cutting machine on January 1, Year 2. for $370,000. The machine had an estimated useful life of 5 years and zero salvage value, and the cost to operate it is $85,000 per year. Technological developments resulted in the development of a more advanced machine available for purchase on January 1, Year 3, that would allow a 20 percent reduction in operating costs. The new machine would cost $198.000 and have a 4-year useful life and zero salvage value. The current market value of the old machine on January 1, Year 3, Is $210,000, and its book value is $296,000 on that date. Straight-line depreciation is used for both machines. The company expects to generate $240,000 of revenue per year from the use of either machine.

Baird Moran manages the cutting department of Greene Benson Company. He purchased a tree-cutting machine on January 1, Year 2. for $370,000. The machine had an estimated useful life of 5 years and zero salvage value, and the cost to operate it is $85,000 per year. Technological developments resulted in the development of a more advanced machine available for purchase on January 1, Year 3, that would allow a 20 percent reduction in operating costs. The new machine would cost $198.000 and have a 4-year useful life and zero salvage value. The current market value of the old machine on January 1, Year 3, Is $210,000, and its book value is $296,000 on that date. Straight-line depreciation is used for both machines. The company expects to generate $240,000 of revenue per year from the use of either machine.

Name: Baird Moran manages the cutting department of Greene Benson Company.
Uploaded: 2024-03-05T11:50:36.000Z
Channel: Bartleby
Description: Baird Moran manages the cutting department of Greene Benson Company. He purchased a tree-cutting machine on January 1, Year 2,for $370,000. The machine had an estimated useful life of 5 years and zero salvage value, and the cost to operate it is $85

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter9: Depreciation (deprec)

Section: Chapter Questions

Problem 1R: Dunedin Drilling Company recently acquired a new machine at a cost of 350,000. The machine has an...

See similar textbooks

Similar questions

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.
Gimli Miners recently purchased the rights to a diamond mine. It is estimated that there are one million tons of ore within the mine. Gimli paid $23,100,000 for the rights and expects to harvest the ore over the next ten years. The following is the expected extraction for the next five years. Year 1: 50,000 tons Year 2: 90,000 tons Year 3: 100,000 tons Year 4: 110,000 tons Year 5: 130,000 tons Calculate the depletion expense for the next five years, and create the journal entry for year one.
Urquhart Global purchases a building to house its administrative offices for $500,000. The best estimate of the salvage value at the time of purchase was $45,000, and it is expected to be used for forty years. Urquhart uses the straight-line depreciation method for all buildings. After ten years of recording depreciation, Urquhart determines that the building will be useful for a total of fifty years instead of forty. Calculate annual depreciation expense for the first ten years. Determine the depreciation expense for the final forty years of the assets life, and create the journal entry for year eleven.
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.
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.
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.
Alfredo Company purchased a new 3-D printer for $900,000. Although this printer is expected to last for ten years, Alfredo knows the technology will become old quickly, and so they plan to replace this printer in three years. At that point, Alfredo believes it will be able to sell the printer for $15,000. Calculate yearly depreciation using the double-declining-balance method.
St. Johns River Shipyards welding machine is 15 years old, fully depreciated, and has no salvage value. However, even though it is old, it is still functional as originally designed and can be used for quite a while longer. A new welder will cost 182,500 and have an estimated life of 8 years with no salvage value. The new welder will be much more efficient, however, and this enhanced efficiency will increase earnings before depreciation from 27,000 to 74,000 per year. The new machine will be depreciated over its 5-year MACRS recovery period, so the applicable depreciation rates are 20.00%, 32.00%, 19.20%, 11.52%, 11.52%, and 5.76%. The applicable corporate tax rate is 25%, and the project cost of capital is 12%. What is the NPV if the firm replaces the old welder with the new one?
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. Dunedin buys equipment frequently and wants to print a depreciation schedule for each assets life. Review the worksheet called DEPREC that follows these requirements. Since some assets acquired are depreciated by straight-line, others by units of production, and others by double-declining balance, DEPREC shows all three methods. You are to use this worksheet to prepare depreciation schedules for the new machine.
Underwoods Miners recently purchased the rights to a diamond mine. It is estimated that there are two million tons of ore within the mine. Underwoods paid $46,000,000 for the rights and expects to harvest the ore over the next fifteen years. The following is the expected extraction for the next five years. Year 1: 50,000 tons Year 2: 900,000 tons Year 3: 400,000 tons Year 4: 210,000 tons Year 5: 150,000 tons Calculate the depletion expense for the next five years and create the journal entry for year one.
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.
Walton Moran manages the cutting department of Greene Zachary Company. He purchased a tree-cutting machine on January 1, year 2, for $490,000. The machine had an estimated useful life of 5 years and zero salvage value, and the cost to operate it is $103,000 per year. Technological developments resulted in the development of a more advanced machine available for purchase on January 1, year 3, that would allow a 30 percent reduction in operating costs. The new machine would cost $330,000 and have a 4-year useful life and zero salvage value. The current market value of the old machine on January 1, year 3, is $260,000, and its book value is $392,000 on that date. Straight-line depreciation is used for both machines. The company expects to generate $240,000 of revenue per year from the use of either machine.Required Recommend whether to replace the old machine on January 1, year 3. Prepare income statements for four years (year 3 through year 6) assuming that the old machine is…