Calculate equal annual depreciation of an asset over its life.
Copy this formula
=SLN(cost, salvage, life)SLN spreads (cost − salvage value) evenly across the asset's useful life, returning the depreciation per period. It's the simplest, most common depreciation method.
=SLN(10000, 1000, 5)→1,800$1,800 depreciation per year.
Use DDB (double-declining) or DB for front-loaded depreciation methods.
Need a formula for your own data?
Describe what you want in plain language and let ExcelGPT write, explain, and verify the formula — free to start, no plugin.