\begin{tabular}{|c|c|c|c|c|c|c|c|} \hline & A & B & C & D & E & F & G \\ \hline 41 & Required: & & & & & & \\ \hline 42 & \multicolumn{5}{|c|}{ Complete the depreciation schedules in the spreadsheet for each of these assets. } & & \\ \hline 43 & & & & & & & \\ \hline 44 & \multicolumn{5}{|c|}{ Milling Machine } & & \\ \hline 45 & \multicolumn{5}{|c|}{ Straight Line } & & \\ \hline 46 & Year & Cost & \begin{tabular}{c} Depreciation \\ Expense \end{tabular} & \begin{tabular}{l} Accumulated \\ Depreciation \end{tabular} & Book Value & & \\ \hline 47 & 04/01/2021 & r & & 0 & & & \\ \hline 48 & 12/31/2021 & r & r & r & r & & \\ \hline 49 & 12/31/2022 & r & r & r & r & & \\ \hline 50 & 12/31/2023 & r & r & r & r & & \\ \hline 51 & 12/31/2024 & r & r & r & r & & \\ \hline 52 & 12/31/2025 & r & r & r & r & & \\ \hline 53 & 12/31/2026 & r & r & r & r & & \\ \hline 54 & 12/31/2027 & r & r & r & r & & \\ \hline 55 & 12/31/2028 & r & r & r & r & & \\ \hline 56 & 12/31/2029 & r & r & r & r & & \\ \hline 57 & 12/31/2030 & r & r & r & r & & \\ \hline 58 & 03/31/2031 & r & r & r & r & & \\ \hline \multicolumn{8}{|l|}{59} \\ \hline 60 & \multicolumn{5}{|c|}{ Forklift } & & \\ \hline 61 & \multicolumn{5}{|c|}{ Units of Production } & & \\ \hline 62 & Year & Cost & \begin{tabular}{l} Depreciation \\ Expense \end{tabular} & \begin{tabular}{l} Accumulated \\ Depreciation \end{tabular} & Book Value & & \\ \hline 63 & 10/1/2021 & & & 0 & & & \\ \hline 64 & 12/31/2021 & r & r & r & r & & \\ \hline 65 & 12/31/2022 & r & r & r & r & & \\ \hline 66 & 12/31/2023 & r & r & r & r & & \\ \hline 67 & 12/31/2024 & r & r & r & r & & \\ \hline 68 & 12/31/2025 & r & r & r & r & & \\ \hline 69 & 12/31/2026 & r & r & r & r & & \\ \hline 70 & 12/31/2027 & r & r & r & r & & \\ \hline 71 & 12/31/2028 & r & r & r & r & & \\ \hline 72 & 12/31/2029 & r & r & r & r & & \\ \hline 73 & 12/31/2030 & r & r & r & r & & \\ \hline 74 & 9/30/2031 & r & r & r & r & & \\ \hline 75 & & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline 2 & A & B & c & D & E & F & G \\ \hline 75 & & & & & & & \\ \hline 76 & \multicolumn{5}{|c|}{ Milling Machine } & & \\ \hline 77 & \multicolumn{5}{|c|}{ Double-Declining Balance } & & \\ \hline 78 & Year & Cost & \begin{tabular}{c} Depreciation \\ Expense \end{tabular} & \begin{tabular}{l} Accumulated \\ Depreciation \end{tabular} & Book Value & & \\ \hline 79 & 7/1/2020 & r & & \multicolumn{2}{|c|}{0l} & & \\ \hline 80 & 12/31/2021 & r & r & r & r & & \\ \hline 81 & 12/31/2022 & r & r & r & r & & \\ \hline 82 & 12/31/2023 & r & r & r & r & & \\ \hline 83 & 12/31/2024 & r & r & r & & & \\ \hline 84 & 12/31/2025 & r & r & r & r & & \\ \hline 85 & 12/31/2026 & r & r & r & \multirow{2}{*}{$27,000} & & \\ \hline 86 & 12/31/2027 & r & $ & r & & & \\ \hline 87 & 6/30/2028 & r & $ & r & r & & \\ \hline \multicolumn{8}{|l|}{88} \\ \hline 89 & & & & & & & \\ \hline 90 & & & & & & & \\ \hline \end{tabular}