Navigation:  Formula Reference > Spreadsheet Formula Functions >

AMORLINC

Previous pageReturn to chapter overviewNext page

 

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)