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

A $150,000 asset has been depreciated with the straight-line method over an 8-year life. The estimated salvage value was $30,000. At the end of the fifth year, the asset was sold for $90,000. From a tax perspective, what is happening at the time of disposal and what is the dollar amount?
Give typing answer with explanation and conclusion Chanveida finds a home listed for $48k. Similar homes in good condition sell for $60k (market value). She buys the home and then sells it. Her adjusted cost basis is $44,000, net sell price is $55,000, and overall tax rate is 30%. Assume no financing is used and there is no depreciation taken. Determine Chanveida's Net Profit from sale.
A contractor imported a bulldozer paying P350k to the manufacturer, freight & insurance charges amounted to P18k, permits & other exp P25k. If the contractor estimates the life of the bulldozer to be 15 years with salvage value of P30k, determine the Total depreciation at the end of 11 years using Sinking fund at 10%. a. P112,718.231 b. P121,718.231 c. P111,718.231 d. P211,718.231
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 book value at the end of its depreciable life? pls show manual solution a. P 50,000 b. P 25,000 c. 35,000 d. P 45,000
A relatively small privately owned coal-mining company has the sales results summarized below. Determine the annual percentage depletion for the coal mine. Assume the company’s taxable income is $150,000 each year. Year Sales, Tons Spot Sales Price, $/Ton 1 34,300 9.82 2 50,100 10 3 71,900 11.23 Year Gross Income, $ Depletion amount 50% of the taxable amount Allowed Depletion 1 2 3
An asset is purchased for $20,000. Its estimated life is 20 years ,after which is sold for $4000. find the depreciation and book value on the 19th year using SYDM. And the depreciation on the 19th year
John constructed a commercial building amounting to $1.59 Million. Permits and taxes charges amounted to 3.23% of the construction cost. It is expected to have a life of 50 years with a salvage value of 12.9% of the construction cost. Determine the depreciation charge during the 5th year using MACRS Method and the worth of the building after 22 years using Sinking Fund Method at money worth 8%. Show cash flow diagram and complete solution.
Salvage Years N 0 Net Expenses Investment A company is consider buying a new machine for $8,550. The manufacturer tells you that the machine, with regular maintenance of around $195 per year, should be able to continue working for 11 years. Based on your calculations the salvage value at that time should be about $525. According to the current asset class table the allowable depreciation rate for this machine would be 25%. If the company's tax rate is 55% and their after-tax MARR is 12%, what is the after tax annual worth of this investment? Use four decimal place accuracy for the CTF and CSF. Answer: 878 (-1,005.28) 1
Two alternative machines will produce the same product, but one is capable of higher-quality work, which can be expected to return greater revenue. The following are relevant data. Determine which is the better alternative, assuming repeatability and using SL depreciation, an income-tax rate of 30%, and an after-tax MARR of 10%. Calculate the AW value for the Machine A. Capital investment Life Terminal BV (and MV) Annual receipts Annual expenses Click the icon to view the interest and annuity table for discrete compounding when the MARR is 10% per year. AWA (10%) = $ (Round to the nearest dollar.) Machine A $22,000 11 years $5,000 $152,000 $141,000 (...) Machine B $32,000 8 years $500 $190,000 $173,000
ENGINEERING ECONOMY
A crane rental company has acquired a new heavy-duty crane for $310,000. The company calculates depreciation on this equipment on the basis of number of rentals per year, and the salvage value of the crane at the end of its 11-year life is $40,000, if the crane is rented an average of 115 days per year, what is the depreciation rate per rental? The depreciation is S per day of rent. (Round to the nearest dollar
27 A consortium of international telecommunication companies contracted for the purchase and installment of a fiber optic cable linking two major cities at a total cost of US$990 million. The amount includes freight and installation charges estimated at 10% of the above contract price. If the cable shall be depreciated over a period of 16 years with zero salvage value. What is the book value after 4 years using straight line method?