AMORLINC(cost, date_purchased, first_period, salvage, period, rate [,basis])
Returns the depreciation of an asset in a single period (straight-line).
|cost||The cost of the asset.|
|date_purchased||The date the asset was purchased.|
|first_period||The date of the end of the first period.|
|salvage||The salvage value at the end of the life of the asset.|
|period||The period to calculate the depreciation.|
|rate||The rate of depreciation.|
|basis||(Optional) The type of day counting to use:|
0 = US 30/360 (default)
1 = Actual/Actual
2 = Actual/360
3 = Actual/365
4 = European 30/365
|* This function is used with the French accounting system.|
* The value of an asset at the end of the depreciation is also known as the salvage value.
* Dates must be entered as text strings within quotation marks or as serial numbers.
* If "cost" < "salvage", then #NUM! is returned.
* If "basis" is left blank, then 0 is used.
* If "basis" is not an integer, it is truncated.
* If "basis" < 0, then #NUM! is returned.
* If "basis" > 4, then #NUM! is returned.
* If an asset is purchased in the middle of an accounting period then the pro-rated depreciation is taken into account.
* For a working example refer to the Quant > Accounting > Depreciation page.
* Example 1 - What is the depreciation of an asset worth £300.
* For the Microsoft documentation refer to support.office.com
* In Excel 2003 this function was only available when you had the Analysis ToolPak add-in loaded.
© 2018 Better Solutions Limited. All Rights Reserved. © 2018 Better Solutions Limited Top