[]

SpreadJS Overview
Getting Started
JavaScript Frameworks
Best Practices
Features
SpreadJS Designer
SpreadJS Designer Component
Touch Support
Formula Reference
- Formula Overview
- Formula Functions
  - Barcode Functions
  - Compatibility Functions
  - Database Functions
  - Date and Time Functions
  - Engineering Functions
  - Financial Functions
    - ACCRINT
    - ACCRINTM
    - AMORDEGRC
    - AMORLINC
    - COUPDAYBS
    - COUPDAYS
    - COUPDAYSNC
    - COUPNCD
    - COUPNUM
    - COUPPCD
    - CUMIPMT
    - CUMPRINC
    - DB
    - DDB
    - DISC
    - DOLLARDE
    - DOLLARFR
    - DURATION
    - EFFECT
    - FV
    - FVSCHEDULE
    - INTRATE
    - IPMT
    - IRR
    - ISPMT
    - MDURATION
    - MIRR
    - NOMINAL
    - NPER
    - NPV
    - ODDFPRICE
    - ODDFYIELD
    - ODDLPRICE
    - ODDLYIELD
    - PDURATION
    - PMT
    - PPMT
    - PRICE
    - PRICEDISC
    - PRICEMAT
    - PV
    - RATE
    - RECEIVED
    - RRI
    - SLN
    - SYD
    - TBILLEQ
    - TBILLPRICE
    - TBILLYIELD
    - VDB
    - XIRR
    - XNPV
    - YIELD
    - YIELDDISC
    - YIELDMAT
  - Information Functions
  - Logical Functions
  - Lookup and Reference Functions
  - Math and Trigonometric Functions
  - Statistical Functions
  - Sparkline Functions
  - Text Functions
  - Web Functions
  - Other Functions
  - RegEx Functions
Import and Export Reference
Frequently Used Events
API Documentation
Release Notes

AMORLINC

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)