3 Penguin Network Warehouse, LLC ("PNW, LLC") acquired the following assets last year: 4 Industrial Refrigeration Equipment on January 23 5 Network server computer equipment on May 4 6 7 8 Office furniture on June 12 Required: 1. Using the below MACRS depreciation table, leverage VLOOKUP formulas to calculate regular depreciation for each ass 9 10 2. Sum the total depreciation for each year. 11 12 (Hint: Use an IF formula with "Yes" and "No" to respond to the Fully Depreciated question.) 13 14 Depreciation Rate for Recovery Period 15 Year 3 5 7 16 1 33.33% 20.00% 14.29% 17 2 44.45% 32.00% 24.49% 18 3 14.81% 19.20% 17.49% 19 4 7.41% 11.52% 12.49% 20 5 11.52% 8.93% 21 6 5.76% 8.92% 22 7 8.93% 23 8 4.46% 24 25 Asset: Industrial Refrigeration Equipment 26 Class Life: 27 Basis: $1,434,214 28 29 Depreciaiton 30 Year Rate Amount 31 1 ###### > Graded Worksheet + Calculation Mode: Automatic