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)
This function is available in product version 2.0 or later.
AMORDEGRC | Financial Functions
