What is the formula for problem e?

What is the formula for problem f?

What is the journal entry to record the correction for problem g?

P2 - x fix C D E F G H M N 0 P Caerful Lite Useful Life Month Day 9 9 10 10 9 9 9 9 9 10 10 9 313495 3,134.95 1 CATEGORY 2 LABORATORY EQUIPMENT 3 LABORATORY EQUIPMENT 4 AGRICULTURAL AND FARM MACHINERY AGRICULTURAL AND FARM MACHINERY COMMUNICATION, AUDIO-VISUAL, ALARM. & SIGNAL EQUIPMENT 7 LABORATORY EQUIPMENT 8 LABORATORY EQUIPMENT 9 OFFICE AND BUSINESS MACHINES & NON-CONSUMABLE SUPPLIES 10 AGRICULTURAL AND FARM MACHINERY 11 LABORATORY EQUIPMENT 12 LABORATORY EQUIPMENT 13 LABORATORY EQUIPMENT 14 LABORATORY EQUIPMENT 15 LABORATORY EQUIPMENT 16 COMPUTER EQUIPMENT 17 COMPUTER EQUIPMENT 18 COMPUTER EQUIPMENT 19 COMPUTER EQUIPMENT 20 COMPUTER EQUIPMENT 21 COMPUTER EQUIPMENT 22 LABORATORY EQUIPMENT 23 LABORATORY EQUIPMENT 24 LABORATORY EQUIPMENT 25 REFRIGERATION EQUIPMENT 26 LABORATORY EQUIPMENT 27 LABORATORY EQUIPMENT 28 LABORATORY EQUIPMENT 29 LABORATORY EQUIPMENT 30 LABORATORY EQUIPMENT 31 LABORATORY EQUIPMENT 32 COMPUTER EQUIPMENT 33 LABORATORY EQUIPMENT 34 LABORATORY EQUIPMENT 35 COMPUTER EQUIPMENT 36 COMPUTER EQUIPMENT 37 COMPUTER EQUIPMENT 39 COMPUTER EQUIPMENT 39 COMPUTER EQUIPMENT 40 COMPUTER EQUIPMENT 11 ALBUTER GALIRLENT AMOUNT 8 7,826.00 8 28.628.01 10 17,068.00 10 28,344.00 6 33,673.00 8 13,720.00 8 13,552.65 6 41,298.05 10 10,800.00 3 19,837.90 8 5,856.32 8 14,850.00 8 13,264.00 3 9,760.00 S 8,492.81 5 15,674.76 5 11,221.99 5 9,501.01 S 9,501.01 5 9,501.01 8 20,395.00 9 15,948.00 8 7,719.00 12 9,998.00 8 14,459.90 8 14,459.90 8 14,459.90 8 14,459.90 3 14,459.90 8 14,459.90 5 12,614.57 8 6,313.32 8 8,685.00 5 7,065.78 5 13,416.36 5 10,034.67 5 7,679.65 5 15,453.15 5 15,453.15 52051775 ACO_DATE 9/4/15 9/13/15 10/1/15 10/29/15 9/9/15 9/24/15 9/9/15 9/25/15 10/1/15 10/9/15 9/4/15 9/17/15 9/10/15 11/5/15 11/5/15 11/15/15 12/13/15 12/4/15 12/4/15 12/4/15 12/4/15 12/4/15 12/4/15 12/4/15 11/5/15 11/5/15 11/5/15 11/5/15 11/5/15 11/5/15 12/20/15 12/20/15 12/20/15 12/13/15 9/5/15 9/5/15 9/5/15 6/27/16 6/27/16 BA 9 11 11 11 12 12 12 12 12 12 12 12 11 11 11 11 11 11 12 12 12 12 Accumulated Months Months Months Year 2018 Depr Exp Depreciation Useful life Since Acq. Depr 2018 2018 Depr Exp Accum Dep 4 2015 978.25 3913.00 96 40 12 978.25 13 2015 3578.50 14314.01 95 40 12 3,578.50 1 2015 1706.30 6927.20 120 39 12 1,706.80 29 2015 2834,40 11337.60 120 38 12 2,894.40 9 2015 5595.50 22382.00 72 40 12 5,595.50 24 2015 1715.00 6860.00 96 39 12 1,715.00 9 2015 1694.08 6776.33 96 40 12 1.694.08 25 2015 6883.01 27532.03 72 39 12 6,983.01 1 2015 1080.00 4320.00 120 39 12 1,080.00 9 2015 2479.74 9918.95 96 39 12 2,479.74 4 2015 732.04 2928.16 96 40 12 722.04 17 2015 1856.25 7425.00 96 39 12 1,856.25 10 2015 1658.00 6632.00 96 40 12 1,658.00 5 2015 1220.00 4880.00 96 12 1,220.00 S 2015 1298.56 5194.25 60 39 12 1,298.56 15 2015 12539.81 50 38 12 13 2015 2244.40 8977.59 60 37 12 2,244.40 4 2015 1900.20 7600.91 60 37 12 1,900.20 2015 1900.20 7600.81 60 37 12 1,900.20 4 4 2015 1900.20 7600.81 50 37 12 1,900.20 4 2015 2549.38 10197.50 96 37 12 2,549.38 4 2015 1993.50 7974.00 96 37 12 1.993.50 4 2015 964.88 3859.50 95 37 12 964.88 4 4 2015 833.17 3332.67 144 37 12 833.17 5 2015 1807.49 7229.95 96 12 1.807.49 5 2015 1807.49 7229.95 96 38 12 1,807.49 5 2015 1807.49 7229.95 95 38 12 1,807.49 5 2015 1807.49 7229.95 95 38 12 1,807.49 5 2015 1807.49 7229.95 96 3B 12 1.807.49 S 2015 1807.49 7229.95 96 38 12 1,807.49 20 2015 2522.91 10091.56 50 36 12 2,522.91 20 2015 789.17 3156.66 96 36 12 789.17 20 2015 835.63 3342.50 96 36 12 835.63 13 2015 1413.16 5652.62 50 37 12 1,413.16 5 2015 2683.27 10733.09 60 40 12 2,683.27 5 2015 2006.93 8027.74 60 40 12 2,006.93 5 2015 1515.93 G0G3.72 60 40 12 1,515.93 27 2016 3090.63 9271.89 50 30 12 3,090.63 27 2016 3090.63 9271.89 50 30 12 3,090.63 20 2016 2010 FE 12210 SE SA 17 410255 9 9 9 6 6 6 e. Create a new column (titled Accum Dep- this should be in column P) Using Excel's IF function, calculate the accumulated depreciation. HINT: Just like you did in before, you will want the LOGICAL_TEST to identify those assets that are still within their useful life. You already have what you need to calculate accumulated depreciation. Go ahead and use what you have learned already to create the IF function to calculate accumulated depreciation. f. Report your new total 2018 depreciation expense and total accumulated depreciation. g. Compare your new accumulated depreciation under nearest full month convention to your prior accumulated depreciation under the full year convention to determine the size of the prior period adjustment. Propose a journal entry to record the correction