Accounting template
Depreciation Schedule Template (Straight-Line)
Spread an asset's cost over its useful life. Book value falls by the same amount each year.
Opening a template uses no credits.
What's inside
| Row | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Input | Value | Year | Book value | |
| 2 | Cost | 100,000 | 1 | =B2-$B$5*D2 | |
| 3 | Salvage value | 10,000 | 2 | =B2-$B$5*D3 | |
| 4 | Useful life (years) | 5 | 3 | =B2-$B$5*D4 | |
| 5 | Yearly depreciation | =SLN(B2,B3,B4) | 4 | =B2-$B$5*D5 |
Preview with sample numbers. Formulas are shown in green.
The formulas, explained
B5 =SLN(B2,B3,B4)
SLN gives equal depreciation each year.
E2 =B2-$B$5*D2
Cost minus depreciation so far.
Make it yours by asking
Try a request like this in Tabstra:
"Create a straight-line depreciation schedule with cost, salvage value, useful life, yearly depreciation and book value per year"