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