$-=$ Graded Worksheet

Workbook StatisticsPenguin 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

Using the below MACRS depreciation table, leverage VLOOKUP formulas to calculate regular depreciation for each asset.

Sum the total depreciation for each year.

$($Hint: Use an IF formula with "Yes" and $"$No$"$ to respond to the Fully Depreciated question.$)$

Navigation:

Hint: Use an IF formula with $"\text{'}$Yes$"$ and $"$Mo$"$ to respond to the Fully Depreciated que:

$\backslash$table$[[$Depreciation Rate for Recovery Period$],[$Year$,3,5,7],[1,33\mathrm{.}33\%,20\mathrm{.}00\%,14\mathrm{.}29\%$