I have the answer and question below but I just needf to know how to work it out Solve the problem. Round unit depreciation to nearest cent when making the schedule, and round final results to the nearest cent. A construction company purchased a piece of equipment for $1,710. The expected life is 7,000 hours, after which it will have a salvage value of $280. Find the amount of depreciation for the first year if the piece of equipment was used for 1,600 hours. Use the units-of-production method of depreciation. Answer: ($320)

I have the answer and question below but I just needf to know how to work it out Solve the problem. Round unit depreciation to nearest cent when making the schedule, and round final results to the nearest cent. A construction company purchased a piece of equipment for $1,710. The expected life is 7,000 hours, after which it will have a salvage value of $280. Find the amount of depreciation for the first year if the piece of equipment was used for 1,600 hours. Use the units-of-production method of depreciation. Answer: ($320)

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter9: Depreciation (deprec)

Section: Chapter Questions

Problem 4R: To test your formulas, assume the machine purchased had an estimated useful life of three years...

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.
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.
You have just bought a new pusher dozer for your equipment fleet. Its cost is $100,000. It has salvage value of $12,000 at the end of its service life. a) Calculate the depreciation using the straight-line method. Show the table with the book value and the depreciation for each year. b) Calculate the depreciation using the DDB method. Show the table with the book value and the depreciation for each year. c) The new pusher dozers $35,000/year for your company during its service life. Determine the tax amount owed at the end of each year if your marginal tax rate is 25% for the income made using this new equipment. Perform this tax calculation separately, once using straight-line depreciation and then using DDB depreciation. d) Based on your calculations for part (c), which depreciation method would you use to file the taxes.
Solve 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.
Albertus Natural Stone Quarry purchased a computer-controlled face-cutter saw for $80,000. The unit has an anticipated life of 5 years and a salvage value of $10,000. (a) Compare the schedules for annual depreciation and book value using two methods: DB at 150% of the straight line rate and at the DDB rate. (b) How is the estimated $10,000 salvage value used?
Your company has decided to purchase a special tool with a first cost of $8,500, a salvage value of $1,400, and a useful life of five (5) years. Develop a depreciation schedule using straight line, double declining balance, and sum of years’ digits. What is the value of cell #14?
LLED has purchased a new chip making machine for $1,500,000 with a salvage value of $100,000 in 10 years. The LLED company is trying to determine the best method of depreciation. Create a table and calculate the deprecation amount for each year using straight line, double declining balance, and MACRS (10 yr property class). For SL and DDB we will not depreciate below the salvage value. Using a MARR of 10% calculate the present worth of the depreciation deductions. Which is the preferred method of depreciation for LLED?
A bioengineer is evaluating methods used to apply an adhesive to microporous paper tape that is commonly used after surgery. The machinery costs $200,000, has no salvage value, and the CFBT estimate is $75,000 per year for up to 10 years. The Te = 38% and i = 8% per year. The two depreciation methods to consider are: MACRS with n = 5 years and SL with n = 8 years (neglect the halfyear convention effect). For a study period of 8 years, (a) determine which depreciation method and recovery period offers the better tax advantage, and (b) demonstrate that the same total taxes are paid for MACRS and SL depreciation.
A construction company is considering changing its depreciation from the MACRS method to the historical SL method for a general purpose hauling truck. The cost basis of the truck is $100,000, and the expected salvage value for depreciation purposes is $8,000. The company will use the truck for eight years and will depreciate it over this period of time with the SL method.What is the difference in the amount of depreciation that would be claimed in year five (i.e., MACRS versus SL)?
PLEASE SOLVE THIS TWO PROBLEMS ASAP. THANK YOU! A. A machine costs P388868 with a salvage value of P18029 is expected to last for 28537 hours in 5 years. In the first year of service it was used for 8077 hours. Compute the book value at the end of the first year. B.The cost of a certain asset is P486042 , its life is 5 years and scrap value is P9050 . Find the cost of depreciation after the first year using a constant percentage method.
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.
I need to solve the question in handwriting and in clarity please The following are the cost of a system and the useful life is five years. The salvage value for depreciation purpose is equal to 25% of the hardware cost Item Hardware Training Installation Cost $170,000 $18,000 $18,000 a) What is the book value of the system at the end of year three if Straight line method is used? b) Suppose that after depreciation of the system for two years with straight line, the company decides to switch to the decline method for the reminder of the system life (depreciation rate 30%). What is the system Book Value at the end of four years?