2022 12 Months Calculate Total Depreciation (D18:H18), Gross Asset Value (D21:H21) and Accumulated Depreciation (D22:H22) for different assets listed in (B7:B15) Total 100 000 5-Year Capital Expenditure Plan & Depreciation Schedule 5-year Capital Expenditures Plan Purchase 2018 2019 2020 2021 Assets Date 12 Months 12 Months 12 Months 12 Months Building Main Equipment 400 000 300 000 100 000 Other Equipment 10 000 50 000 100 000 100 000 Machinery Vehicules 80 000 40 000 Fumiture/Fixtures IT Hardware 200 000 100 000 200 000 250 000 IT Software Telco Equipment Total Capital Expenditures 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 350 000 Total Depreciation - 0 - - - 2018 2019 2020 2021 2022 Property & Equipment Gross Asset Value Accumulated Depreciation Net Property & Equipment 2018 12 Months 2019 12 Months Depreciation Schedule 2020 2021 12 Months 12 Months 2022 12 Months Residual Value 0 400 000 10 000 Capital Expenditure 2018 Building Main Equipment Other Equipment Machinery Vehicules Furniture/Fixtures IT Hardware IT Software Telco Equipment TOTAL Years to Depreciate 7 3 10 5 5 3 4 5 5 80 000 200 000 0 0 690 000 0 0 0 0 0 2019 12 Months 2020 12 Months 2021 12 Months 2022 12 Months 2023 12 Months Residual Value Capital Expenditure 2019 Building Main Equipment Years to Depreciate 7 3 300 000