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 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 4,00,000 3,00,000 1,00,000 Other Equipment 10,000 50,000 1,00,000 1,00,000 Machinery Vehicules 80,000 40,000 Furniture/Fixtures IT Hardware 2,00,000 1,00,000 2,00,000 2,50,000 IT Software Telco Equipment Total Capital Expenditures 1,00,000 3,50,000 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 Total Depreciation - 0 - - 2018 2019 2020 2021 2022 Property & Equipment Gross Asset Value Accumulated Depreciation Net Property & Equipment 2019 12 Months Depreciation Schedule 2020 2021 12 Months 12 Months 2022 12 Months Capital Expenditure 2018 Building Main Equipment Other Equipment Machinery Vehicules Furniture/Fixtures IT Hardware IT Software Telco Equipment TOTAL Years to 2018 Depreciate 12 Months 7 3 10 5 5 3 4 5 5 0 Residual Value 0 4,00,000 10,000 0 80,000 0 2,00,000 0 0 6,90,000 0 0 0 0 2020 12 Months 2021 12 Months 2022 12 Months 2023 12 Months Capital Expenditure 2019 Building Main Equipment Other Equipment Machinery Vehicules Furniture/Fixtures IT Hardware IT Software Telco Equipment TOTAL Years to 2019 Depreciate 12 Months 7 3 10 5 5 3 4 5 5 Residual Value 3,00,000 50,000 1,00,000 4,50,000 2020 12 Months 2021 12 Months 2022 12 Months 2023 12 Months 2024 12 Months Residual Value 1,00,000 Capital Expenditure 2020 Building Main Equipment Other Equipment Machinery Vehicules Furniture/Fixtures IT Hardware IT Software Telco Equipment TOTAL Dure / ans 7 3 10 5 5 3 4 5 5 40,000 2,00,000 3,40,000 2022 12 Months 2023 12 Months 2024 12 Months 2025 12 Months Residual Value 1,00,000 1,00,000 Capital Expenditure 2021 Building Main Equipment Other Equipment Machinery Vehicules Furniture/Fixtures IT Hardware IT Software Telco Equipment TOTAL 2021 Dure / ans 12 Months 7 3 10 5 5 3 4 5 5 2,50,000 4,50,000 2023 12 Months 2024 12 Months 2025 12 Months 2026 12 Months Residual Value 1,00,000 Capital Expenditure 2022 Building Main Equipment Other Equipment Machinery Vehicules Furniture/Fixtures IT Hardware IT Software Telco Equipment TOTAL 2022 Dure / ans 12 Months 7 3 10 5 5 3 4 5 5 3,50,000 4,50,000 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 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 4,00,000 3,00,000 1,00,000 Other Equipment 10,000 50,000 1,00,000 1,00,000 Machinery Vehicules 80,000 40,000 Furniture/Fixtures IT Hardware 2,00,000 1,00,000 2,00,000 2,50,000 IT Software Telco Equipment Total Capital Expenditures 1,00,000 3,50,000 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 Total Depreciation - 0 - - 2018 2019 2020 2021 2022 Property & Equipment Gross Asset Value Accumulated Depreciation Net Property & Equipment 2019 12 Months Depreciation Schedule 2020 2021 12 Months 12 Months 2022 12 Months Capital Expenditure 2018 Building Main Equipment Other Equipment Machinery Vehicules Furniture/Fixtures IT Hardware IT Software Telco Equipment TOTAL Years to 2018 Depreciate 12 Months 7 3 10 5 5 3 4 5 5 0 Residual Value 0 4,00,000 10,000 0 80,000 0 2,00,000 0 0 6,90,000 0 0 0 0 2020 12 Months 2021 12 Months 2022 12 Months 2023 12 Months Capital Expenditure 2019 Building Main Equipment Other Equipment Machinery Vehicules Furniture/Fixtures IT Hardware IT Software Telco Equipment TOTAL Years to 2019 Depreciate 12 Months 7 3 10 5 5 3 4 5 5 Residual Value 3,00,000 50,000 1,00,000 4,50,000 2020 12 Months 2021 12 Months 2022 12 Months 2023 12 Months 2024 12 Months Residual Value 1,00,000 Capital Expenditure 2020 Building Main Equipment Other Equipment Machinery Vehicules Furniture/Fixtures IT Hardware IT Software Telco Equipment TOTAL Dure / ans 7 3 10 5 5 3 4 5 5 40,000 2,00,000 3,40,000 2022 12 Months 2023 12 Months 2024 12 Months 2025 12 Months Residual Value 1,00,000 1,00,000 Capital Expenditure 2021 Building Main Equipment Other Equipment Machinery Vehicules Furniture/Fixtures IT Hardware IT Software Telco Equipment TOTAL 2021 Dure / ans 12 Months 7 3 10 5 5 3 4 5 5 2,50,000 4,50,000 2023 12 Months 2024 12 Months 2025 12 Months 2026 12 Months Residual Value 1,00,000 Capital Expenditure 2022 Building Main Equipment Other Equipment Machinery Vehicules Furniture/Fixtures IT Hardware IT Software Telco Equipment TOTAL 2022 Dure / ans 12 Months 7 3 10 5 5 3 4 5 5 3,50,000 4,50,000