Sum of the Years Digits (SOYD) Depreciation Calculator
Robert Miller
Published Aug 13, 2026
Enter what you know below
An asset (A) has a value of 10000
with a salvage value (S) of 1000 at time (n) = 5
Calculate the depreciation charge (Dt)
and Book Value (BVt) at time = 2
using the SOYD Method:
Calculate Sum of the First 5 Integers
| Σ 1st 5 integers = | n(n + 1) | |
| 2 |
| Σ 1st 5 integers = | 5(5 + 1) | |
| 2 |
| Σ 1st 5 integers = | 5 * 6 | |
| 2 |
| Σ 1st 5 integers = | 30 | |
| 2 |
Σ 1st 5 integers =
Depreciation Formula
| Dt = | (A - S) * (N - t + 1) | |
| Σ 1st n integers |
Calculate Depreciation
| D2 = | (10000 - 1000) * (5 - 2 + 1) | |
| Σ 1st 5 integers |
| D2 = | (9000) * (4) | |
| 15 |
| D2 = | 36000 | |
| 15 |
D2 = 2400
Excel or Google Sheets formula:
Excel or Google Sheets formula:=SYD(10000,1000,5,2)Book Value Formula
Sum of the first (n - t) = 5 - 2 = 3 integers:
| Σ 1st 3 integers = | (n - t)(n - t + 1) | |
| 2 |
| Σ 1st 3 integers = | (5 - 2)(5 - 2 + 1) | |
| 2 |
| Σ 1st 3 integers = | (3)(4) | |
| 2 |
| Σ 1st 3 integers = | 12 | |
| 2 |
Σ 1st 3 integers = 6
Calculate Book Value
| = S + |
| Σ first (n - t) integers * (Asset - Salvage) |
| Σ first n integers |
| = 1000 + |
| 6 * (10000 - 1000) |
| 15 |
| = 1000 + |
| 6 * 9000 |
| 15 |
B2 = 1000 + 3600
Book Value History
| Time | Dt | Bt |
|---|---|---|
| 0 | 0 | 10000 |
| 1 | 3000 | 7000 |
| 2 | 2400 | 4600 |
| 3 | 1800 | 2800 |
| 4 | 1200 | 1600 |
| 5 | 600 | 1000 |
Final Answer
B2 = 4600
You have 1 free calculations remaining
What is the Answer?
How does the Sum of the Years Digits (SOYD) Depreciation Calculator work?
Free Sum of the Years Digits (SOYD) Depreciation Calculator - Solves for Depreciation Charge, Asset Value, and Book Value using the Sum of the Years Digits Method
This calculator has 5 inputs.
What 1 formula is used for the Sum of the Years Digits (SOYD) Depreciation Calculator?
Dt = ((A - S) * (N - t + 1))/Σ 1st n integersFor more math formulas, check out our Formula Dossier
What 6 concepts are covered in the Sum of the Years Digits (SOYD) Depreciation Calculator?
- asset
- Resources of value in accounting. Land, Equipment, Cash are examples
- book value
- the value of an asset according to its balance sheet account balance
- depreciation
- The reduction in value of an asset over time
- salvage value
- the estimated book value of an asset after depreciation is complete, based on what a company expects to receive in exchange for the asset at the end of its useful life.
- sinking fund
- a fund formed by periodically setting aside money for the gradual repayment of a debt or replacement of a wasting asset.
- sum of the years digits depreciation method
- Accelerated deprecation method A higher expense is incurred in the early years and a lower expense in the latter years of the asset&is apos;s useful life