ASAP PLS!!!! 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 $245,000. It is estimated to have a useful lifeof 6 years and to be sold at the end of that time for $11,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.Year1 $LA2LA$$LALA5 $LA6 $Depreciation$tA$tAtA$$tAta$LA$Book ValueCarry all interim calculations to 5 decimal places and then round your final answers to 2 decimal places. The tolerance is ±2.00.

The ordinary depreciation strategy is doubled by the double falling balance depreciation method,…

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 LA 5 $ LA $ LA 4 $ LA LA $ LA 6 $ Depreciation tA $ $ tA $ tA tA $ tA tA Book Value

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 LA 5 $ LA $ LA 4 $ LA LA $ LA 6 $ Depreciation tA $ $ tA $ tA tA $ tA tA Book Value

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

7 A fixed asset costing $80,000 and having an estimated salvage value of $6000 has a life expectancy of 10 years. Compare the results of Double declining, Sum of the year digits depreciation methods by filling in below columns: Sum of the year's Digits method: Year Depreciation Expense Accumulated Depreciation Book value End of the year 1 2 3 4 Double Declining Method: Year Depreciation Expense Accumulated Depreciation Book value End of the year 1 2 3 4
An engineer bought an equipment for 500,000. He spent an additional amount of 35,000 for installation and other expenses. The estimated useful life of the equipment is 10 years. The salvage value is x% of the first cost. Using the straight line method of depreciation, the book value at the end of 5 years will be 291,500. What is the value of x? Draw the cashflow if necessary
Equipment Depreciation A new piece of equipment cost acompany $15,000. Each year, for tax purposes, the companydepreciates the value by 15%. What value should thecompany give the equipment after 5 years?
1. GridCo Analytics needs to purchase new land surveying equipment. GridCo's after tax MARR is 9% and the corporate tax rate is 42%. Surveying equipment is a CCA Class 8 asset. The remaining data are contained in the table below. Model First Cost Economic Life Annual Net Salvage Value (Years) $20,000 $25,000 $30,000 (a) Using the annual worth method, which model should BlastCo buy? ' $110,000 $130,000 $155,000 Savings | $65,000 $85,000 $90,000 Ranger 5 Sonic_Flex 5 Laser_Metric 5 (b) What is the approximate after tax IRR of each model? ( (c) What is the exact after tax IRR of each model? tcas
In the choice of mechanical equipment you are required to submit your recommendation as to which of the two steam shovels for earth excavation is better to buy. The basis is 20 year service and interest at 7%. Taxes and insurance are the same in each case: 5% & 1% respectively. Use Annual Cost to determine 50-ton shovel. 50-ton shovel 70 ton shovel First Cost P30k P38k Life 20 years 20 years Salvage value P2k P3k Annual Operation P15k P17k Annual Upkeep P1.5k P2k Annual Output 150k yards3 200k yards3 a. P21,803.002 b. P12,083.002 c. P21,083.002 d. P21,380.002
Cellphone cost P12,000 new. It is estimated to have a life of 5 years with a salvage value at the end of life of P1,000. Determine the book value at 4th year. a. P3,200 b. P1,733 c. P5,400 d. P8,333
An engineer bought an equipment for P 500,000. He psent an additional amount of P 30,000 for installation and other expenses. The estimated useful life of the equipment is 10 years. The salvage value is x% of the first cost. Using straight line method of depreciation, the book value at end of 5 years will be P 291,500. What is the value of x?
Compute for the Annual Worth of MEA1 and explain.
2. A manufacturing company purchased an equipment for methods improvement for P 53,000. Paid P 1,500 for freight and delivery charges to the job site. What is the yearly depreciation cost using the sinking fund method at 6% interest. The machine has P 5,000 trade in cost and 10 yrs life.
truck production purchased a truck of $85000. the estimated life span is 5years with salvage vlaue of $10000. compute depreciation using 100% bonus depreciation
You are evaluating two different silicon wafer milling machines. The Techron | costs $264,000, has a 3-year life, and has pretax operating costs of $71,000 per year. The Techron Il costs $460,000, has a 5-year life, and has pretax operating costs of $44,000 per year. For both milling machines, use straight-line depreciation to zero over the project's life and assume a salvage value of $48,000. If your tax rate is 22 percent and your discount rate is 12 percent, compute the EAC for both machines. (A negative answer should be indicated by a minus sign. Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) > Answer is complete but not entirely correct. Techron I $ -134,840.83 Techron II $ -107,570.18
A projet cost $500000 and yield annually a profit of $80000 after depreciation @ 12 % p.a but before tax of 50% . calculate the payback period.