Calculate asset depreciation schedules
Calculate asset depreciation using straight-line, declining balance, and MACRS methods. Free depreciation calculator for tax and accounting.
The Depreciation worksheet calculates asset depreciation using various accounting methods for tax and financial reporting. It generates year-by-year depreciation schedules showing depreciation expense, remaining book value, and remaining depreciable value.
Straight-Line: Annual Depreciation = (Cost - Salvage) / Life
Scenario: A company purchases a commercial building for $1,000,000 with a 31.5-year life and no salvage value. Depreciation begins mid-March. Calculate depreciation for the first two years.
Step | Input | Display | Description |
---|---|---|---|
1 | 2ND DEPR | SL | Access Depreciation worksheet |
2 | ↓ | LIF= 0.00 | Move to life |
3 | 31.5 ENTER | LIF= 31.50 | Enter 31.5 year life |
4 | ↓ | M01= 1.00 | Move to starting month |
5 | 3.5 ENTER | M01= 3.50 | Enter mid-March (3.5) |
6 | ↓ | CST= 0.00 | Move to cost |
7 | 1000000 ENTER | CST= 1,000,000.00 | Enter building cost |
8 | ↓ ↓ | YR= 1.00 | Skip salvage (0), move to year |
9 | ↓ | DEP= 25,132.28 | Year 1 depreciation |
10 | ↓ | RBV= 974,867.72 | Remaining book value |
11 | ↓ | RDV= 974,867.72 | Remaining depreciable value |
Step | Input | Display | Description |
---|---|---|---|
1 | ↑ ↑ ↑ | YR= 1.00 | Return to year |
2 | 2 ENTER | YR= 2.00 | Enter year 2 |
3 | ↓ | DEP= 31,746.03 | Year 2 depreciation |
4 | ↓ | RBV= 943,121.69 | Remaining book value |
5 | ↓ | RDV= 943,121.69 | Remaining depreciable value |
Note: Year 1 has lower depreciation ($25,132) because the asset was placed in service mid-year. Year 2 shows full annual depreciation ($31,746).
This Financial Calculator is an independent, third-party tool provided by ryanoconnellfinance.com. It is not affiliated with, endorsed by, or connected in any way to Texas Instruments Incorporated or any of its products. All trademarks, including "BA II Plus," are the property of their respective owners. This tool is provided for educational and informational purposes only and should not be used for official examinations where specific hardware calculators are required. The accuracy of calculations is not guaranteed; verify all results.
View our Privacy Policy for information about data collection and usage.
Access our complete suite of professional financial analysis tools
View All Calculators