Spreadsheet: 87899d1287761089-sumif-function-depreciation-example1
Sheet: Sheet3

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In # column, insert number that corresponds to the specific expenditure
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | Computers/Office Equipment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | Furniture & Fixtures
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | Automobiles
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | Software
 |  |  |  |  |  |  |  |  |  |  |  | Enter Expected FY Capex |  |  |  |  |  |  | 5 | Leasehold Improvements
 | # | Description |  |  |  |  |  |  |  |  |  |  |  |  |  | Total |  |  | # | Description |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
1 | 2 | Chair |  |  |  |  |  |  |  |  |  | 500 | 1500 |  |  |  |  | 1
2 | 1 |  |  |  |  |  |  |  |  |  |  | 1000 |  |  |  |  |  | 2 | 1 | New Laptops | 1450 |  |  | 1450 |  |  | 1450 |  |  | 1450
3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7
8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 2
9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | 1 | Desktop | 200 | 555 |  | 5000 |  |  | 10000
10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 | 5 | Fence to separate railroad |  |  | 10000
12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12
13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13 | 1
14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14
15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15
16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16
17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17
18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18
19 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19
20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20
21 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21
22 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22
23 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23
24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24
25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25
26 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 26
27 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 27
28 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28
29 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 29
30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30
Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
*Enter any capital items to be purchased for balance of FY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Future Depreciation
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Current Depreciation
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total plan Depreciation
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Current Depreciation Table
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Computers/Office Equipment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Furniture & Fixtures | 367.76 | 367.76 | 367.76 | 367.76 | 367.76 | 367.76 | 367.76 | 367.76 | 367.76 | 367.76 | 367.76 | 367.76
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Automobiles
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Software
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Leasehold Improvements
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Current Depreciation
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Future Depreciation Table
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Computers/Office Equipment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Furniture & Fixtures
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Automobiles
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Software
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Leasehold Improvements
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Future Depreciation