AMORLINC
An asset's depreciation for a period by the French straight-line method, the first period prorated.
Group: Financial. Compatible with DAX.
Syntax
AMORLINC ( <cost>, <date_purchased>, <first_period>, <salvage>, <period>, <rate> [, <basis>] )| Parameter | Type | Description |
|---|---|---|
cost | Number | What the asset cost. |
date_purchased | Date | The day the asset was bought. |
first_period | Date | The day the first period ends, usually the end of that financial year. |
salvage | Number | What it is worth at the end of its life. |
period | Number | The period asked about: 0 is the first, part-year one, then 1, 2 and on. |
rate | Number | The yearly depreciation rate; 1 divided by it is the asset's life in years. |
basis | Whole number optional | How the first, part-year period is counted: US 30/360 (0, when left out), actual/actual (1), actual/365 (3) or European 30/360 (4). |
Returns
Number. The depreciation for the period.
Remarks
- France's straight-line method: every full period takes cost × rate; period 0 is prorated by the part of the year from the purchase to the end of the first period.
- The period that would take the value below salvage gets only what is left above it, and the ones after it 0.
- A negative cost or salvage, a rate of 0 or less, or a purchase after the end of the first period is an error.
Examples
The same kettle, straight line
2,000 a year (20 % of 10,000), 1,590.16 for the first 291 days, and the rest down to the 500 of salvage in period 4.
EVALUATE
ADDCOLUMNS (
SELECTCOLUMNS ( GENERATESERIES ( 0, 5 ), "Period", [Value] ),
"Depreciation", AMORLINC ( 10000, DATE ( 2024, 3, 15 ), DATE ( 2024, 12, 31 ), 500, [Period], 0.2, 1 )
)
ORDER BY [Period]| Period | Depreciation |
|---|---|
| 0 | 1590.16393442623 |
| 1 | 2000 |
| 2 | 2000 |
| 3 | 2000 |
| 4 | 1909.83606557377 |
| 5 | 0 |