AMORDEGRC (PQL - xl)

This function returns the depreciation for an accounting period, taking into consideration prorated depreciation, and applies a depreciation coefficient in the calculation based on the life of the assets

  • Library: PQL \ Spreadsheet \ Financial
  • Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module

Syntax

AMORDEGRC(cost, date purchased, first period, salvage, period, rate, OPTIONAL basis)

Function Arguments

Name

Description

Type

Optional

cost

Cost of the asset

Number

date purchased

Purchase date of the asset

StringOrNumber

first period

End date of the first period

StringOrNumber

salvage

Salvage value at the end of the life of the asset

Number

period

Accounting period

Number

rate

Rate of depreciation

Number

basis

Integer representing the basis for day count

Number

Y

Comments

This function is the same as the Microsoft Excel 'AMORDEGRC' function - using the same inputs, logic and outputs.