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 making informed recommendations in the treatment of complex blood cancers, is purchased for $220,000. It is estimated to have a useful life of 6 years and to be sold at the end of that time for $11,000. Part a Develop a table showing the depreciation and book value for each year using both the Excel® DDB worksheet function and the Excel® SLN worksheet function such that the depreciation switches from double declining balance to straight-line at the optimum time. Year 1 2 3 4 5 $ $ Depreciation Book Value

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 making informed recommendations in the treatment of complex blood cancers, is purchased for $220,000. It is estimated to have a useful life of 6 years and to be sold at the end of that time for $11,000. Part a Develop a table showing the depreciation and book value for each year using both the Excel® DDB worksheet function and the Excel® SLN worksheet function such that the depreciation switches from double declining balance to straight-line at the optimum time. Year 1 2 3 4 5 $ $ Depreciation Book Value

Managerial Economics: Applications, Strategies and Tactics (MindTap Course List)

14th Edition

ISBN:9781305506381

Author:James R. McGuigan, R. Charles Moyer, Frederick H.deB. Harris

Publisher:James R. McGuigan, R. Charles Moyer, Frederick H.deB. Harris

Chapter17: Long-term Investment Analysis

Section: Chapter Questions

Problem 2E

See similar textbooks

Similar questions

A car industry invested $20,000 in cars with a 3-year useful life. The cars will have no salvage value, as the cost to remove it will equal its scrap value. The uniform annual benefits from the cars are $12,000. For a combined 25% income tax rate, and 100% bonus depreciation, compute the after-tax net present worth (NPW) using MARR if 10%.
The first costs of an equipment is P 65,000 and a salvage value of P 3,000 at the end of its 6 – year life. Find the total depreciation of the equipment after 4 years using the Straight Line Method. a. P 41,333b. P 40,668c. P 23,667d. P 22,456
A trucking company computes depreciation on its vehicles by a mileage basis.Suppose a delivery truck has a cost of $20.000. a salvage value of $2.000. andan estimated useful life of 200.000 miles. Determine the depreciation rateper mile. (a) $0.08(b) $0.09(c) $0.10(d) $0.11
An specialized machine has an initial cost of P50,000 and a salvage value of P10,000 after 10 years. What is the book value after five years using straight line depreciation? A. P35,000 B. P30,000 C. P25,000 D. P15,500
A building has a salvage value of P1 M after 50 years. Annual depreciation is P2 M. Using straight line method of depreciation, how much could you afford to sell the building after 30 years? Select one: a. P 42M b. P 41M c. P 40 M d. P 45M
Show manual solutions and depreciation schedule/table. An equipment costing P250,000 has an estimated life of 15 years with a book value of P30,000 at the end of the period. Compute the depreciation charge and its book value after 10 years using declining balance method.Ans. BV = P60,832.80 d = P9,234.93
A trucking company computes depreciation on its vehicles by a mileage basis.Suppose a delivery truck has a cost of $20.000. a sa lvage value of $2.000. andan estimated useful life of 200.000 miles. Determine the depreciation rateper mile.(a) $0.08(b) $0.09(c) $0.10(d) $0.11
A corporate expects to receive $36,144 each year for 15 years if a particular project is undertaken. There will be an initial investment of $100,705. The expenses associated with the project are expected to be $7,740 per year. Assume straight-line depreciation, a 15-year useful life, and no salvage value. Use a combined state and federal 48% marginal tax rate, MARR of 8%, determine the project's after-tax net present worth.
An asset for drilling was purchased and placed in service by a petroleum production company. Its cost basis is $60,000, and it has an estimated MV of $12,000 at the end of an estimated useful life of 14 years. Compute the depreciation amount in the third year and the BV at the end of the fifth year of life by each of these methods: (7.3, 7.4) a. The SL method. b. The 200% DB method with switchover to SL. c. The GDS. d. The ADS.
The first cost of a machine is P1,800,000 with a salvage value of P300,000 at the end of its life of 5 years. Determine the total depreciation after 3 years. Constant Percentage Method ans:P1,185,769.76
A factory has decided to purchase some new equipment for P600, 000. The equipment will be kept for 10 years before being sold. The estimated salvage value for depreciation purposes is to be P45,000. Using straight line method, what is the annual depreciation on the equipment? a. P55, 500 b. P50,000 c. P51,500 d. P52, 500
Given: Before -Tax Cash Flow (BT-CF) for Kal Tech Systems in 2012 for an equipment that will be depreciated using the SL method with salvage value of $10,000. Year 0 1 2 3 4 5 BT-CF -$120,000 32,000 32,000 32,000 32,000 32,000 Market value - $36,000 What is the after-tax return if the company is in the 34% income tax bracket? The incremental tax rate is 34%. Also, it is known that the before-tax return is 16.65% Group of answer choices 9.65% 11.29% 10.16% 10.99%