excel template is 1 page depreciation worksheet that allows to calculate yearly depreciation cost for up to 12 assets for five years.
The model has build in depreciation percentages for the following methods:
- SL - Straight Line Depreciation
- SOYD - Sum-of-the-Year's- Digits
- DDB 150% - Double Declining Balance
- DDB 200% - Double Declining Balance
You will need to input Life-of-project cost; year when depreciation started for this asset, select depreciation key from the drop-down list (depreciation key is depreciation method for a specific asset class).
The worksheet will automatically calculate prior years accumulated depreciation, current year depreciation, and project depreciation cost for the next four year.