6. Functions : Finance Library Functions : DEPR Function
 
Share this page                  
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
period
Integer
Depreciation period
life
Integer
Life of asset (number of periods)
The depreciation method (type) must be one of the following:
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 remaining balance.
CR
Specifies cross-over depreciation. Use double declining until the straight line method provides greater depreciation.
This function returns:
Float—The depreciation factor of the specified type for the given period and life
Null—On error