Spread Formula Reference
AMORLINC
Formula Functions > Functions A to C > AMORLINC

This function calculates the depreciation for an accounting period, taking into account prorated depreciation.

Syntax

AMORLINC(cost,datepurchased,firstperiod,salvage,period,drate,basis)

Arguments

This function has these arguments:

Argument Description
cost Cost of the asset
datepurchased Purchase date of the asset
firstperiod End date of the first period
salvage Salvage value at the end of the life of the asset
period Accounting period
drate Rate of depreciation
basis [Optional] Integer representing the basis for day count (Refer to Day Count Basis)

Remarks

This function differs from AMORDEGRC, which applies a depreciation coefficient in the calculation depending on the life of the assets.

Data Types

Accepts numeric and DateTime object data. Returns numeric data.

Examples

AMORLINC(B1,B2,B3,B4,B5,B6,B7)

Version Available

This function is available in product version 2.0 or later.

See Also

AMORDEGRC | Financial Functions