| A | B | C | D | E | F | G | H | I | J | K | L | M | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | |||||||||||||
2 | |||||||||||||
3 | Asset Depreciation Tracking Template | ||||||||||||
4 | Asset ID | Asset Name | Category | Purchase Date | Purchase Price | Useful Life (Years) | Depreciation Method | Annual Depreciation | Years Used | Current Value | Condition | Location | Notes |
5 | FA001 | Office Desk | Furniture | 2020-05-12 | $400 | 5 | Straight Line | $80 | 3 | $160 | Good | NY Office | 3 years used |
6 | FA002 | Projector | Equipment | 2021-03-01 | $800 | 4 | Straight Line | $200 | 2 | $400 | Excellent | Meeting Room | Client presentations |
7 | FA003 | Company Car | Vehicle | 2019-09-15 | $25,000 | 6 | Straight Line | $4,166.67 | 4 | $8,333.33 | Good | Parking Garage | Shared by executives |
8 | FA004 | Server Rack | Equipment | 2022-02-10 | $1,500 | 5 | Straight Line | $300 | 1 | $1,200 | Excellent | Server Room | Central networking rack |
9 | FA005 | Coffee Machine | Appliance | 2022-10-05 | $700 | 5 | Straight Line | $140 | 1 | $560 | Good | Break Room | Staff refreshment area |
10 | FA006 | Whiteboard Wall | Infrastructure | 2020-09-01 | $900 | 6 | Straight Line | $150 | 3 | $450 | Excellent | Collaboration Zone | Used for planning sessions |
11 | FA007 | Desktop Scanner | Equipment | 2023-01-15 | $250 | 3 | Straight Line | $83.33 | 1 | $166.67 | Excellent | Admin Office | Document scanning |
12 | FA008 | Warehouse Shelving | Infrastructure | 2018-04-25 | $2,000 | 10 | Straight Line | $200 | 5 | $1,000 | Good | Warehouse | For inventory storage |
13 | FA009 | HVAC Unit | Equipment | 2021-05-30 | $4,000 | 10 | Straight Line | $400 | 2 | $3,200 | Good | Main Office | Central air system |
14 | FA010 | Lobby Furniture Set | Furniture | 2020-02-10 | $3,000 | 6 | Straight Line | $500 | 3 | $1,500 | Fair | Reception Area | Includes sofa, chairs, and table |
15 | |||||||||||||
16 | |||||||||||||