\begin{tabular}{|c|c|c|c|} \hline 63 & Asset: & Office Furniture & \\ \hline 64 & Class Life: & 7 & \\ \hline 65 & Basis: & 094,033 & \\ \hline \multicolumn{4}{|l|}{66} \\ \hline 67 & \multicolumn{3}{|c|}{ Depreciaiton } \\ \hline 68 & Year & Rate & Amount \\ \hline 69 & 17 & 14.29% & $156,337.32 \\ \hline 70 & 27 & 24.49% & $267,928.68 \\ \hline 71 & 3 & 17.49% & $191,346.37 \\ \hline 72 & 4 & 12.49% & $136,644.72 \\ \hline 73 & 5r & 8.93%r & $97,697.15 \\ \hline 74 & 6 & 8.92% & $97,587.74 \\ \hline 75 & 7 & 8.93% & $97,697.15 \\ \hline 76 & 8 & 4.46% & $48,793.87 \\ \hline 77 & & Total & $1,094,033.00 \\ \hline 78 & & & \\ \hline 79 & \multicolumn{2}{|c|}{ Fully Depreciated? } & No \\ \hline 80 & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|} \hline 24 & & & \\ \hline 25 & Asset: & \\ \hline 26 & Class Life: & \multicolumn{2}{|c|}{ Industrial Refrigeration Equipment } \\ \hline 27 & Basis: & $1,442,679 & \\ \hline 28 & & & \\ \hline 29 & \multicolumn{3}{|c|}{ Depreciaiton } \\ \hline 30 & Year & Rate & Amount \\ \hline 31 & 1 & 14.29% & $206,158.83 \\ \hline 32 & 2 & 24.49% & $353,312.09 \\ \hline 33 & 3 & 17.49% & $252,324.56 \\ \hline 34 & 4 & 12.49% & $180,190.61 \\ \hline 35 & 5 & 8.93% & $128,831.23 \\ \hline 36 & 6 & 8.92% & $128,686.97 \\ \hline 37 & 7 & 8.93% & $128,831.23 \\ \hline 38 & 8 & 4.46% & $64,343.48 \\ \hline 39 & & Total & $1,442,679.00 \\ \hline 40 & & & \\ \hline 41 & \multicolumn{2}{|c|}{ Fully Depreciated? } & No \\ \hline 42 & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|} \hline 82 & \multicolumn{2}{|c|}{ Total Depreciation } \\ \hline 83 & Year & Amount \\ \hline 84 & 1 & \#\#\#\#\#\#\#\#\#\#: \\ \hline 85 & 2 & \#\#\#\#\#\#\#\#\#\#\# \\ \hline 86 & 3 & \#\#\#\#\#\#\#\#\#\#\# X \\ \hline 87 & 4 & \#\#\#\#\#\#\#\#\#\#: \\ \hline 88 & 5 & \#\#\#\#\#\#\#\#\#\#\#: \\ \hline 89 & 6 & \#\#\#\#\#\#\#\#\#\#\# X \\ \hline 90 & 7 & \#\#\#\#\#\#\#\#\#\#\# \\ \hline 91 & 8 & \#\#\#\#\#\#\#\#\#\#\#:x \\ \hline \end{tabular} 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. \begin{tabular}{|c|c|c|c|} \hline 63 & Asset: & Office Furniture & \\ \hline 64 & Class Life: & 7 & \\ \hline 65 & Basis: & 094,033 & \\ \hline \multicolumn{4}{|l|}{66} \\ \hline 67 & \multicolumn{3}{|c|}{ Depreciaiton } \\ \hline 68 & Year & Rate & Amount \\ \hline 69 & 17 & 14.29% & $156,337.32 \\ \hline 70 & 27 & 24.49% & $267,928.68 \\ \hline 71 & 3 & 17.49% & $191,346.37 \\ \hline 72 & 4 & 12.49% & $136,644.72 \\ \hline 73 & 5r & 8.93%r & $97,697.15 \\ \hline 74 & 6 & 8.92% & $97,587.74 \\ \hline 75 & 7 & 8.93% & $97,697.15 \\ \hline 76 & 8 & 4.46% & $48,793.87 \\ \hline 77 & & Total & $1,094,033.00 \\ \hline 78 & & & \\ \hline 79 & \multicolumn{2}{|c|}{ Fully Depreciated? } & No \\ \hline 80 & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|} \hline 24 & & & \\ \hline 25 & Asset: & \\ \hline 26 & Class Life: & \multicolumn{2}{|c|}{ Industrial Refrigeration Equipment } \\ \hline 27 & Basis: & $1,442,679 & \\ \hline 28 & & & \\ \hline 29 & \multicolumn{3}{|c|}{ Depreciaiton } \\ \hline 30 & Year & Rate & Amount \\ \hline 31 & 1 & 14.29% & $206,158.83 \\ \hline 32 & 2 & 24.49% & $353,312.09 \\ \hline 33 & 3 & 17.49% & $252,324.56 \\ \hline 34 & 4 & 12.49% & $180,190.61 \\ \hline 35 & 5 & 8.93% & $128,831.23 \\ \hline 36 & 6 & 8.92% & $128,686.97 \\ \hline 37 & 7 & 8.93% & $128,831.23 \\ \hline 38 & 8 & 4.46% & $64,343.48 \\ \hline 39 & & Total & $1,442,679.00 \\ \hline 40 & & & \\ \hline 41 & \multicolumn{2}{|c|}{ Fully Depreciated? } & No \\ \hline 42 & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|} \hline 82 & \multicolumn{2}{|c|}{ Total Depreciation } \\ \hline 83 & Year & Amount \\ \hline 84 & 1 & \#\#\#\#\#\#\#\#\#\#: \\ \hline 85 & 2 & \#\#\#\#\#\#\#\#\#\#\# \\ \hline 86 & 3 & \#\#\#\#\#\#\#\#\#\#\# X \\ \hline 87 & 4 & \#\#\#\#\#\#\#\#\#\#: \\ \hline 88 & 5 & \#\#\#\#\#\#\#\#\#\#\#: \\ \hline 89 & 6 & \#\#\#\#\#\#\#\#\#\#\# X \\ \hline 90 & 7 & \#\#\#\#\#\#\#\#\#\#\# \\ \hline 91 & 8 & \#\#\#\#\#\#\#\#\#\#\#:x \\ \hline \end{tabular} 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