A

B

C

D

E

F

G

H

$1$

$2$ 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:

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.$)$

$13$

$14$

Deverintion Pitefor Resomey Reied

$15$

Year

$5$

$7$

$16$

$1$

$33\mathrm{.}33\%$

$20\mathrm{.}00\%$

$14\mathrm{.}29\%$

$17$

$2$

$44\mathrm{.}45\%$

$32\mathrm{.}00\%$

$24\mathrm{.}49\%$

$18$

$3$

$14\mathrm{.}81\%$

$19\mathrm{.}20\%$

$17\mathrm{.}49\%$

$19$

$4$

$7\mathrm{.}41\%$

$11\mathrm{.}52\%$

$12\mathrm{.}49\%$

$20$

$5$

$11\mathrm{.}52\%$

$8\mathrm{.}93\%$

$21$

$6$

$5\mathrm{.}76\%$

$8\mathrm{.}92\%$

$22$

$7$

$8\mathrm{.}93\%$

$23$

$8$

$4\mathrm{.}46\%$

$\backslash$table$[[24,],[25,$Asset:,Industrial Refrigeration Equipment$],[26,$Class Life:,$r,7,],[27,$Basis:,$$1,434,214],[28,],[29,$Depreciaiton$],[30,$Year,,Rate,Amount$],[31,,1^7,14\mathrm{.}29\%(8)r,$$$204,949\mathrm{.}18],[32,,2^7,24\mathrm{.}49\%(8)$ r$,$$$351,239\mathrm{.}01],[33,,3^r,17\mathrm{.}49968,$$$250,844\mathrm{.}03],[34,,4^r,12\mathrm{.}4996$ e$,5179,133\mathrm{.}33],[35,,5^{\text{'}\text{'}},8\mathrm{.}93\%(8),$$$128,075\mathrm{.}31],[36,,6,8\mathrm{.}92968,$$$127,931\mathrm{.}89],[37,,7^{\text{'}\text{'}},8\mathrm{.}9396,$$$128,075\mathrm{.}31],[38,,8^7,4\mathrm{.}4696,$$$63,965\mathrm{.}94],[39,,,$Total,F $$1,434,214,00$