This function calculates the depreciation for an accounting period, taking into account prorated depreciation.
AMORLINC(cost,datepurchased,firstperiod,salvage,period,drate,basis)
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) |
This function differs from AMORDEGRC, which applies a depreciation coefficient in the calculation depending on the life of the assets.
Accepts numeric and DateTime object data. Returns numeric data.
AMORLINC(B1,B2,B3,B4,B5,B6,B7)