Open In App

SLN() and SYD() Function Function in MS Access

Last Updated : 14 Sep, 2020
Improve
Improve
Like Article
Like
Save
Share
Report

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

Like Article
Suggest improvement
Previous
Next
Share your thoughts in the comments

Similar Reads