A pharmacy is planning to purchase a second-hand scanning microscope at a cost of BD10,500, and its estimated salvage value is BD500 and a projected useful life of four years. Determine the...

A pharmacy is planning to purchase a second-hand scanning microscope at a cost of BD10,500, and its estimated salvage value is BD500 and a projected useful life of four years. Determine the depreciation for 4th year using sum of the years digit (SOYD) method and complete the depreciation schedules with depreciation values and book values. (solve fast and in m/s EXCEL for thumbs up.)