AmorLinC

Syntax

AmorLinC(Cost, PurchaseDate, FirstPeriodEnd, Salvage[, Period[, Rate[, Basis])

Parameters

Cost. The cost of the asset.

PurchaseDate. Date of the asset acquisition.

FirstPeriodEnd. The date of the first period's end.

Salvage. The salvage value at the end of the life of the asset.

Period. Period. Parameter value must be greater than or equal to zero.

Rate. Depreciation rate. Parameter value must be greater than zero.

Basis. The day calculation method used. It is set in the range from 0 to 4:

Optional parameter.

NOTE. To determine the parameter, it is available to specify either the parameter value or the cell address where it is located.

Description

It returns the depreciation for each period.

Comments

The function is provided for the French accounting system. If an asset is purchased in the middle of an accounting period, the proportional amount of depreciation is taken into account.

Example

Formula Result Description
=AmorLinC(2000, "01.01.2008", "01.08.2008", 200, 1, 0.15, 3) 300 Depreciation value at the following conditions:

  • The cost of the asset is 2000.

  • The date of asset acquisition is 01.01.2008.

  • The date of the first period end is 01.08.2008.

  • Salvage value of the asset is 200.

  • Period 1.

  • Depreciation rate is 0.15, semi-annual payments.

  • The day calculation method is actual/365 days.
=AmorLinC(A1, A2, A3, 300, 1, 0.15, 1) 360 Depreciation value at the following conditions:

  • The cost of the asset is specified in the A1 cell, value is 2400.

  • The date of asset acquisition is specified in the A2 cell, value is 19.08.2008.

  • The date of the first period's end is specified in the A3 cell, value is 31.12.2008.

  • Salvage value of the asset is 300.

  • Period 1.

  • Depreciation rate is 0.15, semi-annual payments.

  • The day calculation method - actual.

See also:

Function Wizard │ Financial Functions