1. SLN() Function :
SLN() Function in MS Access is used to calculate the straight-line depreciation of an asset for a single period.
Syntax :
SLN(cost, salvage, life)
Parameter : This method accepts three parameters as mentioned above and described below :
- cost : It specify the initial cost of the asset.
- salvage : It specify the value of the asset at the end of its useful life.
- life : It specify the length of the useful life of the asset.
Returns : It returns depreciation of an asset.
Note : The depreciation period must be expressed in the same unit as the life argument. All arguments must be positive numbers.
Example-1 :
Depreciation for an asset with a salvage value of 15% considering the useful life of the asset to be 10 years.
SELECT SLN(1500.0, 1500.0*0.15, 10) AS Amount;
Output :
| Amount |
|---|
| 127.5 |
Example-2 :
Depreciation for a table of an asset with a salvage value of 10% considering the useful life to be 15 years.
Table – Accounts
| AccountId | LoanAmount |
|---|---|
| 11001 | 15000.0 |
| 11002 | 12000.0 |
| 11003 | 10000.0 |
SELECT SLN([LoanAmount], [LoanAmount]*.1, 15) AS Amt FROM Accounts;
Output :
| Amt |
|---|
| 900 |
| 700 |
| 600 |
2. SYD () Function :
SYD () Function in MS Access is used to calculate the sum-of-years’ digits depreciation of an asset for a specified period.
Syntax :
SYD(cost, salvage, life, period)
Parameter : This method accepts four parameters as mentioned above and described below :
- cost : It specify the initial cost of the asset.
- salvage : It specify the value of the asset at the end of its useful life.
- life : It specify the length of the useful life of the asset.
- period : It specify the period for which asset depreciation is calculated.
Returns : It returns depreciation of an asset for a specified period.
Note : The life and period arguments must be expressed in the same units. For example, if life is given in months, period must also be given in months. All arguments must be positive numbers.
Example-1 :
Depreciation for an asset with a salvage value of 15% considering the useful life of the asset to be 10 years. The depreciation is calculated for the third year.
SELECT SYD(1500.0, 1500.0*0.15, 10, 3) AS Amount;
Output :
| Amount |
|---|
| 185.454545454545 |
Example-2 :
Depreciation for a table of an asset with a salvage value of 10% considering the useful life to be 15 years. The depreciation is calculated for the second year.
Table – Accounts
| AccountId | LoanAmount |
|---|---|
| 101 | 15000.0 |
| 102 | 12000.0 |
| 103 | 10000.0 |
SELECT SYD([LoanAmount], [LoanAmount]*.10, 15, 2) AS Amt FROM Accounts;
Output :
| Amt |
|---|
| 1575 |
| 1260 |
| 1050 |