Excel Applications for Accounting Principles
4th Edition
ISBN: 9781111581565
Author: Gaylord N. Smith
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 9, Problem 6R
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.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
A surface mount PCB placement/soldering line is to be installed for $1,600,000. It will have a salvage value of $150,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
-
Your answer is partially correct.
Determine the depreciation deduction and the resulting unrecovered investment during each year of the asset's life using
straight-line depreciation.
EOY
0
1
Depreciation
0
640000
Balances
1600000
960000
2
384000
576000
3
234110
345600
Freeport-McMoRan
Copper and Gold has purchased a
new ore grading unit for $80,000. The unit has an
anticipated life of 10 years and a salvage value of $
10,000. Use the DB and DDB methods to compare the
schedule of depreciation and book values for each year.
Solve by hand and by spreadsheet.
A surface mount PCB placement/soldering line is to be installed for $1,400,000. It will have a salvage value of $70,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.
ΕΟΥ
0
1
2
3
4
5
Sum depreciation
Depreciation
Balance
Chapter 9 Solutions
Excel Applications for Accounting Principles
Ch. 9 - Dunedin Drilling Company recently acquired a new...Ch. 9 - Open the file DEPREC from the website for this...Ch. 9 - In the space below, prepare the journal entry to...Ch. 9 - To test your formulas, assume the machine...Ch. 9 - A truck was recently purchased for 75,000 with a...Ch. 9 - Dunedin Drilling Company recently acquired a new...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- 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
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning
Principles of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax College
College Accounting, Chapters 1-27AccountingISBN:9781337794756Author:HEINTZ, James A.Publisher:Cengage Learning,
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Principles of Accounting Volume 1
Accounting
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax College
College Accounting, Chapters 1-27
Accounting
ISBN:9781337794756
Author:HEINTZ, James A.
Publisher:Cengage Learning,
Accounting for Derivatives_1.mp4; Author: DVRamanaXIMB;https://www.youtube.com/watch?v=kZky1jIiCN0;License: Standard Youtube License
Depreciation|(Concept and Methods); Author: easyCBSE commerce lectures;https://www.youtube.com/watch?v=w4lScJke6CA;License: Standard YouTube License, CC-BY