Software and hardware for optimizing the cell design of robotic picking lines have an installed cost of $78,000 with no residual value after 8 years. For years 2 and 7, use DDB (Double Declining Balance) book depreciation. The book value for year 2, (in $)

Software and hardware for optimizing the cell design of robotic picking lines have an installed cost of $78,000 with no residual value after 8 years. For years 2 and 7, use DDB (Double Declining Balance) book depreciation. The book value for year 2, (in $)

Principles of Accounting Volume 1

19th Edition

ISBN:9781947172685

Author:OpenStax

Publisher:OpenStax

Chapter11: Long-term Assets

Section: Chapter Questions

Problem 7EA: Alfredo Company purchased a new 3-D printer for $900,000. Although this printer is expected to last...

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.
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?
Newmarge Products Inc. is evaluating a new design for one of its manufacturing processes. The new design will eliminate the production of a toxic solid residue. The initial cost of the system is estimated at 860,000 and includes computerized equipment, software, and installation. There is no expected salvage value. The new system has a useful life of 8 years and is projected to produce cash operating savings of 225,000 per year over the old system (reducing labor costs and costs of processing and disposing of toxic waste). The cost of capital is 16%. Required: 1. Compute the NPV of the new system. 2. One year after implementation, the internal audit staff noted the following about the new system: (1) the cost of acquiring the system was 60,000 more than expected due to higher installation costs, and (2) the annual cost savings were 20,000 less than expected because more labor cost was needed than anticipated. Using the changes in expected costs and benefits, compute the NPV as if this information had been available one year ago. Did the company make the right decision? 3. CONCEPTUAL CONNECTION Upon reporting the results mentioned in the postaudit, the marketing manager responded in a memo to the internal audit department indicating that cash inflows also had increased by a net of 60,000 per year because of increased purchases by environmentally sensitive customers. Describe the effect that this has on the analysis in Requirement 2. 4. CONCEPTUAL CONNECTION Why is a postaudit beneficial to a firm?
Differential analysis for machine replacement Boyer Digital Components Company assembles circuit boards by using a manually operated machine to insert electronic components. The original cost of the machine is 60,000, the accumulated depreciation is 24,000, its remaining useful life is five years, and its residual value is negligible. On May 4 of the current year, a proposal was made to replace the present manufacturing procedure with a fully automatic machine that has a purchase price of 180,000. The automatic machine has an estimated useful life of five years and no significant residual value. For use in evaluating the proposal, the accountant accumulated the following annual data on present and proposed operations: a. Prepare a differential analysis dated May 4 to determine whether to continue with ( Alternative 1) or replace (Alternative 2) the old machine. Prepare the analysis over the useful life of the new machine. b. Based only on the data presented, should the proposal be accepted? c. What are some of the other factors that should be considered before a final decision is made?
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.
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.
IMPACT 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.
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.
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.
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.
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.
Filkins Fabric Company is considering the replacement of its old, fully depreciated knitting machine. Two new models are available: Machine 190-3, which has a cost of $190,000, a 3-year expected life, and after-tax cash flows (labor savings and depreciation) of $87,000 per year; and Machine 360-6, which has a cost of $360,000, a 6-year life, and after-tax cash flows of $98,300 per year. Knitting machine prices are not expected to rise because inflation will be offset by cheaper components (microprocessors) used in the machines. Assume that Filkins’ cost of capital is 14%. Should the firm replace its old knitting machine? If so, which new machine should it use? By how much would the value of the company increase if it accepted the better machine? What is the equivalent annual annuity for each machine?