Collapse All Expand All

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)

 

 

---

Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.