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.
=SLN(24000, 4000, 8)→2,500An asset costing 24,000 with a salvage value of 4,000 over 8 years.
=SLN(10000, 1000, 5)/12→150Monthly depreciation: the yearly amount divided by 12.
Use DDB (double-declining) or DB for front-loaded depreciation methods.
Subtract the salvage value from the cost and divide by the useful life: =(A2-B2)/C2.
Subtract the accumulated depreciation from the cost: =A2-SLN(A2, B2, C2)*D2, where D2 is the number of years elapsed.
Enter 0 as the second argument: =SLN(10000, 0, 5) returns 2,000 a year.
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.