Language Reference Guide > Language Reference Guide > Function Libraries > Finance Library Functions > DEPR Function
Was this helpful?
DEPR Function
The DEPR function calculates a depreciation factor for a specified depreciation method for a given period in the life of an asset. To calculate the actual depreciation amount, the depreciation factor must be multiplied by the original cost of the asset minus its salvage value.
This function has the following syntax:
DEPR(type = 'type', period = value, life = value)
Arguments
Data Type
Description
type
Varchar(30)
Depreciation method, which must be one of these:
• ST—Specifies a straight line. Computed as (1/life).
• SU—Specifies a sum of digits. Computed as ((life + 1 - period)*2) / ((life*(1 + life)).
• DO—Specifies double declining. This is twice the remaining balance divided by life except last period, which is the remaining balance.
• CR—Specifies cross-over depreciation. Use double declining until the straight line method provides greater depreciation.
period
Integer
Depreciation period
life
Integer
Life of asset (number of periods)
This function returns:
• Float—The depreciation factor of the specified type for the given period and life
• Null—On error
Example—DEPR function:
/*  Compute the sum of digits depreciation factor for
**  the seventh year of an asset whose life is ten
**  years, and calculate the depreciation amount.
*/
deprFact = depr(type = 'SU', period = 7, life = 10);
deprAmt  = deprFact * cost;
Last modified date: 06/25/2024