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)
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
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;