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
- 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.arrow_forwardGimli 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.arrow_forwardMontello 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 it expects to use the truck for 26,000 miles. Calculate the annual depreciation expense.arrow_forward
- 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.arrow_forwardA machine costing 350,000 has a salvage value of 15,000 and an estimated life of three years. Prepare depreciation schedules reporting the depreciation expense, accumulated depreciation, and book value of the machine for each year under the double-declining-balance and sum-of-the-years-digits methods. For the double-declining-balance method, round the depreciation rate to two decimal places.arrow_forwardUnderwoods 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.arrow_forward
- 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.arrow_forwardIMPACT OF IMPROVEMENTS AND REPLACEMENTS ON THE CALCULATION OF DEPRECIATION On January 1, 20-1, two flight simulators were purchased by a space camp for 77,000 each with a salvage value of 5,000 each and estimated useful lives of eight years. On January 1, 20-2, the hydraulic system for Simulator A was replaced for 6,000 cash and an updated computer for more advanced students was installed in Simulator B for 9,000 cash. The hydraulic system is expected to extend the life of Simulator A three years beyond the original estimate. REQUIRED 1. Using the straight-line method, prepare general journal entries for depreciation on December 31, 20-1, for Simulators 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 simulator for 20-2 through 20-8.arrow_forwardA 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.arrow_forward
- Grandorf Company replaced the engine in a truck for 8,000 and expects the new engine will extend the life of the truck two years beyond the original estimated life. Related information is provided below. Cost of truck 65,000 Salvage value 5,000 Original estimated life 6 years The truck was purchased on January 1, 20-1. The engine was replaced on January 1, 20-6. Using straight-line depreciation, compute depreciation expense for 20-6.arrow_forwardTo 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.arrow_forwardSt. 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?arrow_forward
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage LearningPrinciples of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax CollegeIntermediate Financial Management (MindTap Course...FinanceISBN:9781337395083Author:Eugene F. Brigham, Phillip R. DavesPublisher:Cengage Learning
- EBK CONTEMPORARY FINANCIAL MANAGEMENTFinanceISBN:9781337514835Author:MOYERPublisher:CENGAGE LEARNING - CONSIGNMENT