Concept explainers
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
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
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
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.
Want to see the full answer?
Check out a sample textbook solutionChapter 9 Solutions
Excel Applications for Accounting Principles
- A surface mount PCB placement/soldering line is to be installed for $1,000,000. It will have a salvage value of $90,000 after 5 years. Determine the depreciation deduction and the resulting unrecovered investment during each year of the asset's life. Click here to access the MACRS-GDS Table Calculator Part a Determine the depreciation deduction and the resulting unrecovered investment during each year of the asset's life using declining balance depreciation using double declining balance switching to straight line depreciation. EOY Depreciation Balance 1 3 4 Sum depreciation Round entry to two decimal places. The tolerance is ±10.arrow_forwardA drilling rig was purchased for 1.8 million dollars. It has an estimated life of 10 years, and the salvage value at that time is expected to be $500,000. After 5 years what will be the total depreciation charged for a) straight line depreciation, b) sum of the years' digit depreciation.arrow_forwardA surface mount PCB placement/soldering line is to be installed for $1,800,000. It will have a salvage value of $90,000 after 5 years. Determine the depreciation deduction and the resulting unrecovered investment during each year of the asset’s life. Determine the depreciation deduction and the resulting unrecovered investment during each year of the asset’s life using declining balance depreciation using double declining balance switching to straight line depreciation.arrow_forward
- A surface mount PCB placement/soldering line is to be installed for $1.6 million. It will have a salvage value of $100,000 after 5 years. Determine the depreciation deduction and the resulting unrecovered investment during each year of the asset’s life. Use straight-line depreciation.arrow_forwardThe Erley Equipment Company purchased a machine 5 years ago at a cost of $100,000. The machine had an expected life of 10 years at the time of purchase, and an expected salvage value of $10,000 at the end of the 10 years. It is being depreciated by the straight-line method toward a salvage value of $10,000, or by $9,000 per year. Anew machine can be purchased for $150,000, including installation costs. During its 5- year life, it will reduce cash operating expenses by $50,000 per year. Sales are not expected to change. At the end of its useful life, the machine is estimated to be worthless. MACRS depreciation will be used, and the machine will be depreciated over its 3-year class life rather than its 5-year economic life so the applicable depreciation rates are 33 percent, 45 percent, 15 percent, and 7 percent. The old machine can be sold today for $65,000. The firm’s tax rate is 35 percent. The appropriate discount rate is 16 percent. d. What is the NPV of this project? e.…arrow_forwardThe Erley Equipment Company purchased a machine 5 years ago at a cost of $100,000. The machine had an expected life of 10 years at the time of purchase, and an expected salvage value of $10,000 at the end of the 10 years. It is being depreciated by the straight-line method toward a salvage value of $10,000, or by $9,000 per year. Anew machine can be purchased for $150,000, including installation costs. During its 5- year life, it will reduce cash operating expenses by $50,000 per year. Sales are not expected to change. At the end of its useful life, the machine is estimated to be worthless. MACRS depreciation will be used, and the machine will be depreciated over its 3-year class life rather than its 5-year economic life so the applicable depreciation rates are 33 percent, 45 percent, 15 percent, and 7 percent. The old machine can be sold today for $65,000. The firm’s tax rate is 35 percent. The appropriate discount rate is 16 percent. a. If the new machine is purchased, what is…arrow_forward
- An underground rock mechanics testing device is to be double declining depreciated. It has a first cost of $25,000 and an estimated salvage of $2,500 after 12 years. (a) What is book value and market value ? (b)Calculate the depreciation and book value for years 1 and 4. (c) Calculate the implied salvage value after 12 years.arrow_forwardA draw bench for precision forming and strengthening of carbon steel tubing has a cost of $900,000. It will have a salvage value of $88,000 after a useful life of 10 years. Part a Using the formulas, determine the depreciation charge for year 2 and the book value at the end of year 2 if straight-line depreciation is used. Depreciation charge: Book value: $ $arrow_forwardIn early 2014, Sosa Enterprises purchased a new machine for $10,000 to make cork stoppers for wine bottles. The machine has a 3-year recovery period and is expected to have a salvage value of $2,000. Develop a depreciation schedule for this asset using the MACRS depreciation percentages in Table 4.2.arrow_forward
- Your company is considering the purchase of a secondhand scanning microscope at a cost of $10,500, with an estimated salvage value of $500 and a projected useful life of 4 years. Determine the straight-line (SL), and double declining balance (DDB) depreciation schedules.arrow_forwardUniversity has pruchased a new machine for their new proposed labs for $135,000. The unit has an anticipated life of 4 years and a salvage value of $20,000. Use the DB and DDB methods to compare the schedule depreciation and book values for each year.arrow_forwardSolve the following problems. Show clean and complete details of your work for each number. Problem 1: The initial cost of a paint sand mill, including its installation is P 800,000. The depreciable life of this machine is 10 years with an estimated salvage value of P 50,000. Using SL Method -Compute the annual depreciation charge. -Compute the total depreciation after 6 years. -Compute the book value after 6 years.arrow_forward
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage LearningPrinciples of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax CollegeCollege Accounting, Chapters 1-27AccountingISBN:9781337794756Author:HEINTZ, James A.Publisher:Cengage Learning,