Manuals/calci/AMORLINC
Jump to navigation
Jump to search
AMORLINC(C, DP, FP, salvage, P, R, basis)
Where 'C' is the cost of the asset, 'DP' is the date of the purchase of the asset, 'FP' is the date of the end of the first period, 'salvage' is the salvage value at the end of the life of the asset, 'P' is the period, 'R' is the rate of depreciation and 'basis' is the year basis to be used.
This function calculates the depreciation for each accounting period.
AMORLINC
Syntax
Examples
Description
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 3200 | |||
| Row2 | 8/19/2010 | |||
| Row3 | 12/31/2010 | 576 | ||
| Row4 | 250 | |||
| Row5 | 1 | |||
| Row6 | 18% | |||
| Row7 | 1 |
AMORLINC(C, DP, FP, salvage, P, R, basis)
B
3200
8/19/2010
12/31/2010
250
1
18%
1
=AMORLINC(B2,B3,B4,B5,B6,B7,B8) is 576