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

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
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
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 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
Your business buys a delivery van for $28,000. You figure the van will be useful for 5 years and have a value of $5,000 at the end of the 5-year period. What is the (a) basis, (b) useful life, (c) salvage value, (d) depreciable basis, (e) accumulated depreciation at the end of year 2 if you take $4,600 depreciation each year, and (f) the book value at the end of year 2?
A certain equipment costs P 7,000 and a salvage value of P 350 at the end of its economic life. Using SYD method of depreciation, the book value at the end of 4 years is P 2,197.22. Compute the economic life of the equipment, in years.