50.1K

Verified Solution

Link Copied!

1. Using Excels IF function, calculate the 2018 depreciation expense (this should be in column J- label it 2018 Depr Exp)
2. Using Excels IF function, calculate the accumulated depreciation in column K.
3. Report your total 2018 depreciation expense and total accumulated depreciation.

A 1 ASSET_TAG_ID 2 U000009 3 U000010 4 U000015 5 U000016 6 U000018 7 U000020 8 U000022 9 U000023 10 U000024 11 U000026 12 U000029 13 U000031 14 U000032 15 U000036 16 U000037 17 U000038 18 U000040 19 U000041 20 U000042 21 U000043 22 U000044 23 U000045 24 U000049 25 U000050 26 U000051 27 U000052 28 U000053 29 U000054 30 U000055 31 U000056 32 U000057 33 U000058 4 Ready Accessibility: Good to go Or B ASSET_DESCRIPTION PUMP BONDER IRRIGATION SYSTEM DRILL VIDEO CAMERA ULTRASOUND SYSTEM PUMP COPYING MACHINE MIXER MICROSCOPE METER REACTOR SYSTEM READER INCUBATOR SERVER ARRAY SERVER SERVER SERVER SERVER WASHER STACKER CENTRIFUGE FREEZER SHAKER SHAKER SHAKER SHAKER SHAKER SHAKER SERVER FVAPORATOR Useful Lives Asset Register CATEGORY LABORATORY EQUIPMENT LABORATORY EQUIPMENT AGRICULTURAL AND FARM MACHINERY AGRICULTURAL AND FARM MACHINERY COMMUNICATION, AUDIO-VISUAL, ALARM, & SIGNAL EQUIPMENT LABORATORY EQUIPMENT LABORATORY EQUIPMENT OFFICE AND BUSINESS MACHINES & NON-CONSUMABLE SUPPLI AGRICULTURAL AND FARM MACHINERY LABORATORY EQUIPMENT LABORATORY EQUIPMENT LABORATORY EQUIPMENT LABORATORY EQUIPMENT LABORATORY EQUIPMENT COMPUTER EQUIPMENT COMPUTER EQUIPMENT COMPUTER EQUIPMENT COMPUTER EQUIPMENT COMPUTER EQUIPMENT COMPUTER EQUIPMENT LABORATORY EQUIPMENT LABORATORY EQUIPMENT LABORATORY EQUIPMENT REFRIGERATION EQUIPMENT LABORATORY EQUIPMENT LABORATORY EQUIPMENT LABORATORY EQUIPMENT LABORATORY EQUIPMENT LABORATORY EQUIPMENT LABORATORY EQUIPMENT COMPUTER EQUIPMENT LABORATORY FQUIPMENT Useful lives D G 8 8 F AMOUNT ACQ DATE Month 7,826.00 9/4/2015 28,628.01 9/13/2015 17,068.00 10/1/2015 28.344.00 10/29/2015 33,573.00 9/9/2015 13,720.00 9/24/2015 13,552.65 9/9/2015 41,298.05 9/25/2015 6 8 8 6 9/4/2015 10,800.00 10/1/2015 19,837.90 10/9/2015 5,856.32 14,850.00 9/17/2015 13,264.00 9/10/2015 9,760.00 11/5/2015 6,492.81 11/5/2015 15,674.76 11/15/2015 11,221.99 12/13/2015 9,501.01 12/4/2015 9,501.01 12/4/2015 9,501.01 12/4/2015 20,395.00 15,948.00 7,719.00 9,998.00 12/4/2015 12/4/2015 12/4/2015 12/4/2015 14,459.90 11/5/2015 11/5/2015 14,459.90 14,459.90 14,459.90 11/5/2015 11/5/2015 14,459.90 14,459,90 11/5/2015 11/5/2015 12,614.57 12/20/2015 6 313 32 12/20/2015 2005 10 10 10 8 8 8 8 8 5 5 5 5 5 5 8 8 8 12 8 8 8 8 8 8 5 8 U G 9 9 10 10 9 9 9 9 10 10 9 9 9 11 11 11 12 12 12 12 12 12 12 12 11 11 11 11 11 11 12 12 Day H 4 13 1 29 9 24 9 25 1 9 4 17 10 5 5 15 13 4 4 4 4 4 4 4 5 5 5 5 5 5 20 20 1 I Year 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 11:39 PM

Answer & Explanation Solved by verified expert

See Answer