Penguin Network Warehouse, LLC ("PNW, LLC") acquired the following assets last year: Industrial Refrigeration Equipment on January 23 Network server computer equipment on May 4 Office furniture on June 12 Required: 1. Using the below MACRS depreciation table, leverage VLOOKUP formulas to calculate regular depreciation for each asset. 2. Sum the total depreciation for each year. (Hint: Use an IF formula with "Yes" and "No" to respond to the Fully Depreciated question.) 3 Depreciation Rate for Recovery Period Year 3 5 7 1 33.33% 20.00% 14.29% B 2345656 44.45% 32.00% 24.49% 14.81% 19.20% 17.49% 7.41% 11.52% 12.49% 0 1 2 7 23 8 24 25 Asset: Industrial Refrigeration Equipment < Graded Worksheet + 11.52% 8.93% 5.76% 8.92% 8.93% 4.46%