Major medical complexes and their service providers continue to move toward advanced health informatics - acquiring, managing,and using information to provide better healthcare. A new analyzer for researching and evaluating patient samples, and makinginformed recommendations in the treatment of complex blood cancers, is purchased for $270,000. It is estimated to have a useful lifeof 6 years and to be sold at the end of that time for $10,000.Part aDevelop a table showing the depreciation and book value for each year using both the Excel® DDB worksheet function and theExcel® SLN worksheet function such that the depreciation switches from double declining balance to straight-line at the optimumtime.Year12345Your answer is partially correct.6$LA$$LA$$$LADepreciation4333343333433344333343333LALA$$tA$43334 $Book Value226667183334140000966675333410000

Given, Cost = 270000 Salvage value = 10000 Useful life = 6 Depreciation calculated as Double…

medical complexes and their service providers continue to move toward advanced health informatics - acqui sing information to provide better healthcare. A new analyzer for researching and evaluating patient samples. med recommendations in the treatment of complex blood cancers, is purchased for $270,000. It is estimated t ears and to be sold at the end of that time for $10,000. a velop a table showing the depreciation and book value for each year using both the Excel® DDB worksheet fu el® SLN worksheet function such that the depreciation switches from double declining balance to straight-lin e. ar Your answer is partially correct. 1 $ Depreciation 43333 $ 10000 Book Value 226667 100001

medical complexes and their service providers continue to move toward advanced health informatics - acqui sing information to provide better healthcare. A new analyzer for researching and evaluating patient samples. med recommendations in the treatment of complex blood cancers, is purchased for $270,000. It is estimated t ears and to be sold at the end of that time for $10,000. a velop a table showing the depreciation and book value for each year using both the Excel® DDB worksheet fu el® SLN worksheet function such that the depreciation switches from double declining balance to straight-lin e. ar Your answer is partially correct. 1 $ Depreciation 43333 $ 10000 Book Value 226667 100001

ENGR.ECONOMIC ANALYSIS

14th Edition

ISBN:9780190931919

Author:NEWNAN

Publisher:NEWNAN

Chapter1: Making Economics Decisions

Section: Chapter Questions

Problem 1QTC

See similar textbooks

Similar questions

For its fabricated metal products, the Able Corp is paying $10,000 for special tools that have a 4-year useful life and no salvage value. Compute the depreciation for the SECOND year by each of the following methids: a. DDB b. Sum of Year's Digits c. MACRS
An automotive manufacturing company decided to buy a GPU computer and associated computer hardware for $12,000. There will be no salvage value for this equipment. Please create the following depreciation schedules. a) Straight line b) Double Declining Balance c) Sum of Year's digit's d) MACRS (because this is a computure use the 5 year property schedule
A company bought a new machine fot $300,000. The new machine generated revenue for $90,000 per year. Operating cost of that machine is $10,000 per year. The machine is depreciated according to 7-years MACRS method. The machine is sold for $80,000 in the middle of 6th year of service. Determine the after tax net present worth. Assume, the after-tax MARR is 10% and income tax rate is 25% (federal and state combined). dont use excel
A new industrial vacuum for electronic factory activities has a purchased value of $50, 000 and $20,000 for transportation cost within a 7-years depreciable life. The estimated salvage value of the equipment is zero at the end of 7 years. Calculate the annual depreciation amounts using the 200% DB method.
EXERCISE-3 DEPRECIATION AND DEPLETION 10. A generator costs P500,000 and whose salvage value is P10,000. after 20 years. Find the book value after 12 years by sum of the year's digit method.
An equipment costs ¥ 10,000 with a salvage value of ¥ 500 at the end of 10 years. Calculate the total depreciation charge and book value at the end of 7 years using: *Answer should be rounded off to 2 decimal places. Do show solution, thank you.
2. Determine the depreciation charge
A front-end loader costs $70,000 and has a depreciable salvage value of $10,000 at the end of its 5-year useful life. Use MACRS depreciation to compute the depreciation schedule and book value of the equipment.
A new drilling mud pump was purchased and placed in service by a petroleum drilling company. Its initial cost is $250,000, and it has an estimated market value of $15,000 at the end of useful life of 15 years. Calculate the depreciation amount and the BV in the fifth year and at the end of the tenth year using the (1) straight line (SL) method, por workovcr at 8 year (2) 150% declining balance (DB) method.
John bought a machine set for P90,000. Other expenses including installation amounted to P10,000. The machine set is to have a life of 17 years with a salvage value of P5,000. Determine the depreciation charge during the 13th year and the book value at the end of 13 years bya.) Declining balance methodb.) Double declining balance methodc.) Sinking fund method at 12%d.) Sum-of-the-years-digit method
9.
Labor costs, materials, all direct and indirect costs, and facilities and productive equipment with a useful life of one year or less are usually depreciated. O True O False