Calculate Total Depreciation (D18:H18), Gross Asset Value (D21:H21) and Accumulated Depreciation (D22:H22) for different assets listed in (B7:B15) Assumptions: 1 - CAPEX are listed in 1st table per asset type and year (D7:H15) 2 - Years to depreciate are listed in table 2 Depreciation Schedule (C29:C37) 3 - Depreciation use Straight Line method for all assets, except Main Equipment which uses Double Declining Balance (DDB) method 4 - Fill up depreciation values for 2018, 2019, etc 5 - Total Depreciation in (D18:H18) will be populated automatically \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline \begin{tabular}{c} Capital Expenditure \\ 2019 \end{tabular} & \begin{tabular}{l} Years to \\ Depreciate \end{tabular} & \begin{tabular}{c} 2019 \\ 12 Months \end{tabular} & \begin{tabular}{c} 2020 \\ 12 Months \end{tabular} & \begin{tabular}{c} 2021 \\ 12 Months \end{tabular} & \begin{tabular}{c} 2022 \\ 12 Months \end{tabular} & \begin{tabular}{c} 2023 \\ 12 Months \end{tabular} & \begin{tabular}{l} Residual \\ Value \end{tabular} \\ \hline Building & 7 & & & & & & \\ \hline Main Equipment & 3 & & & & & & 400000 \\ \hline Other Equipment & 10 & & & & & & 150000 \\ \hline Machinery & 5 & & & & & & \\ \hline Vehicules & 5 & & & & & & \\ \hline Furniture/Fixtures & 3 & & & & & & \\ \hline IT Hardware & 4 & & & & & & 150000 \\ \hline IT Software & 5 & & & & & & \\ \hline Telco Equipment & 5 & & & & & & \\ \hline TOTAL & & & & & & & 700000 \\ \hline \begin{tabular}{c} Capital Expenditure \\ 2020 \end{tabular} & Dure / ans & \begin{tabular}{c} 2020 \\ 12 Months \end{tabular} & \begin{tabular}{c} 2021 \\ 12 Months \end{tabular} & \begin{tabular}{c} 2022 \\ 12 Months \end{tabular} & \begin{tabular}{c} 2023 \\ 12 Months \end{tabular} & \begin{tabular}{c} 2024 \\ 12 Months \end{tabular} & \begin{tabular}{l} Residual \\ Value \end{tabular} \\ \hline Building & 7 & & & & & & \\ \hline Main Equipment & 3 & & & & & & \\ \hline Other Equipment & 10 & & & & & & 230000 \\ \hline Machinery & 5 & & & & & & \\ \hline Vehicules & 5 & & & & & & 60000 \\ \hline Furniture/Fixtures & 3 & & & & & & \\ \hline IT Hardware & 4 & & & & & & 450000 \\ \hline IT Software & 5 & & & & & & \\ \hline Telco Equipment & 5 & & & & & & \\ \hline TOTAL & & & & & f & & 740000 \\ \hline \begin{tabular}{l} Capital Expenditure \\ 2021 \end{tabular} & Dure/ans & \begin{tabular}{c} 2021 \\ 12 Months \end{tabular} & \begin{tabular}{l} 2022 \\ 12 Months \end{tabular} & \begin{tabular}{c} 2023 \\ 12 Months \end{tabular} & \begin{tabular}{c} 2024 \\ 12 Months \end{tabular} & \begin{tabular}{c} 2025 \\ 12 Months \end{tabular} & \begin{tabular}{l} Residual \\ Value \end{tabular} \\ \hline Building & 7 & & & & & & \\ \hline Main Equipment & 3 & & & & & & 250000 \\ \hline Other Equipment & 10 & & & & & & 230000 \\ \hline Machinery & 5 & & & & & & \\ \hline Vehicules & 5 & & & & & & \\ \hline Furniture/Fixtures & 3 & & & & & & \\ \hline IT Hardware & 4 & & & & & & 300000 \\ \hline IT Software & 5 & & & & & & \\ \hline Telco Equipment & 5 & & & & & & \\ \hline TOTAL & & & & & & & 780000 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline \begin{tabular}{l} Capital Expenditure \\ 2022 \end{tabular} & Dure / ans & \begin{tabular}{c} 2022 \\ 12 Months \end{tabular} & \begin{tabular}{c} 2023 \\ 12 Months \end{tabular} & \begin{tabular}{c} 2024 \\ 12 Months \end{tabular} & \begin{tabular}{c} 2025 \\ 12 Months \end{tabular} & \begin{tabular}{c} 2026 \\ 12 Months \end{tabular} & \begin{tabular}{l} Residual \\ Value \end{tabular} \\ \hline Building & 7 & & & & & & \\ \hline Main Equipment & 3 & & & & & & \\ \hline Other Equipment & 10 & & & & & & 220000 \\ \hline Machinery & 5 & & & & & & \\ \hline Vehicules & 5 & & & & & & \\ \hline Furniture/Fixtures & 3 & & & & & & \\ \hline IT Hardware & 4 & & & & & & 500000 \\ \hline IT Software & 5 & & & & & & \\ \hline Telco Equipment & 5 & & & & & & f \\ \hline TOTAL & & & f & & & & 720000 \\ \hline \end{tabular}