Difference between revisions of "Manuals/calci/AMORLINC"
Jump to navigation
Jump to search
(2 intermediate revisions by the same user not shown) | |||
Line 8: | Line 8: | ||
*<math>Rate</math> is the rate of depreciation | *<math>Rate</math> is the rate of depreciation | ||
*<math>Basis</math> is the year basis to be used | *<math>Basis</math> is the year basis to be used | ||
− | + | **AMORLINC(), returns the depreciation for each accounting period. | |
− | AMORLINC(), returns the depreciation for each accounting period. | ||
== Description == | == Description == | ||
Line 83: | Line 82: | ||
==Related Videos== | ==Related Videos== | ||
− | {{#ev:youtube| | + | {{#ev:youtube|v=DQfl_5hkeYo|280|center|AMORLINC}} |
== See Also == | == See Also == |
Latest revision as of 15:22, 15 November 2018
AMORLINC (Cost,DatePurchased,FirstPeriod,Salvage,Period,Rate,Basis)
- where, is the cost of the asset
- is the date of purchase of asset
- is the end of first period
- is the salvage value at the end of life of asset
- is the accounting period
- is the rate of depreciation
- is the year basis to be used
- AMORLINC(), returns the depreciation for each accounting period.
Description
- The function calculates the decrease in value of asset for the mentioned period.
- If > , Calci displays #N/A error message.
- also called as 'residual value' is the remaining value of an asset after it has been fully depreciated.
- If is <=0, Calci displays #N/A error message.
- If is omitted, Calci assumes it as 0.5 years(6 months).
- value is optional. If omitted, Calci assumes it to be 0.
Below table shows the use of values:
Basis | Description |
---|---|
0 | 360 days (NASD) |
1 | Actual |
3 | 365 days in a year |
4 | 360 days in a year (European) |
- If value is other than 0, 1, 3 or 4, Calci displays #N/A error message.
Examples
Consider the following example that shows the use of AMORLINC function:
3200 | ||
8/19/2010 | ||
12/31/2010 | ||
250 | ||
1 | ||
18% | ||
1 |
=AMORLINC(A1,A2,A3,A4,A5,A6,A7) displays 576 as a result.
Related Videos
See Also
References