Difference between revisions of "Manuals/calci/AMORLINC"
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> <font color="#000000">'''<font face="Arial, sans-serif"><font size="2">AMORLINC(C, DP, FP, salvage, P, R, basis)</font>...") |
|||
| (9 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
| − | <div | + | <div style="font-size:25px">'''AMORLINC (Cost,DatePurchased,FirstPeriod,Salvage,Period,Rate,Basis)'''</div><br/> |
| − | < | + | *where, <math>Cost</math> is the cost of the asset |
| + | *<math>DatePurchased</math> is the date of purchase of asset | ||
| + | *<math>FirstPeriod</math> is the end of first period | ||
| + | *<math>Salvage</math> is the salvage value at the end of life of asset | ||
| + | *<math>Period</math> is the accounting period | ||
| + | *<math>Rate</math> is the rate of depreciation | ||
| + | *<math>Basis</math> 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 <math>DatePurchased</math> > <math>FirstPeriod</math>, Calci displays #N/A error message. | ||
| + | *<math>Salvage</math> also called as 'residual value' is the remaining value of an asset after it has been fully depreciated. | ||
| + | *If <math>Rate</math> is <=0, Calci displays #N/A error message. | ||
| + | *If <math>Period</math> is omitted, Calci assumes it as 0.5 years(6 months). | ||
| + | *<math>Basis</math> value is optional. If omitted, Calci assumes it to be 0. | ||
| + | Below table shows the use of <math>Basis</math> values: | ||
| − | + | {| class="wikitable" | |
| − | + | |- | |
| − | + | ! Basis !! Description | |
| − | -- | + | |- |
| − | + | | 0 || 360 days (NASD) | |
| − | + | |- | |
| − | + | | 1 || Actual | |
| − | - | + | |- |
| − | + | | 3 || 365 days in a year | |
| + | |- | ||
| + | | 4 || 360 days in a year (European) | ||
| + | |} | ||
| − | {| id=" | + | *If <math>Basis</math> 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: | ||
| + | |||
| + | <div id="2SpaceContent" class="zcontent" align="left"> | ||
| + | |||
| + | {| id="TABLE3" class="SpreadSheet blue" | ||
|- class="even" | |- class="even" | ||
| + | | class="sshl_f" | 3200 | ||
| + | | class=" " | | ||
| class=" " | | | class=" " | | ||
| − | + | ||
| − | |||
| − | |||
| − | |||
|- class="odd" | |- class="odd" | ||
| − | + | | class="sshl_f" | 8/19/2010 | |
| − | | class="sshl_f" | | + | | class=" " | |
| − | | class=" | + | | class=" " | |
| − | | class=" | + | |
| − | |||
|- class="even" | |- class="even" | ||
| − | | class=" | + | | class="sshl_f" | 12/31/2010 |
| − | | class=" | + | | class=" " | |
| − | | class=" | + | | class=" " | |
| − | + | ||
| − | |||
|- class="odd" | |- class="odd" | ||
| − | + | | class="sshl_f" | 250 | |
| − | | class="sshl_f | + | | class=" " | |
| − | | class=" | + | | class=" " | |
| − | | | + | |
| − | |||
|- class="even" | |- class="even" | ||
| − | + | | class="sshl_f" | 1 | |
| − | | class="sshl_f" | | + | | class=" " | |
| − | | class=" | + | | class=" " | |
| − | | | + | |
| − | |||
|- class="odd" | |- class="odd" | ||
| − | | class=" " | | + | | class="sshl_f" | 18% |
| + | | class=" " | | ||
| + | | class=" " | | ||
| + | |||
| + | |- class="even" | ||
| class="sshl_f" | 1 | | class="sshl_f" | 1 | ||
| − | | class=" | + | | class=" " | |
| − | + | | class=" " | | |
| − | |||
| − | |||
| − | |||
| − | | class=" | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | | | ||
|} | |} | ||
| − | + | =AMORLINC(A1,A2,A3,A4,A5,A6,A7) ''displays 576'' as a result. | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | + | ==Related Videos== | |
| − | + | {{#ev:youtube|v=DQfl_5hkeYo|280|center|AMORLINC}} | |
| − | + | == See Also == | |
| − | + | *[[Manuals/calci/DURATION | DURATION]] | |
| + | *[[Manuals/calci/ACCRINT | ACCRINT]] | ||
| − | + | == References == | |
| − | + | *[http://en.wikipedia.org/wiki/Depreciation Depreciation] | |
| + | *[http://en.wikipedia.org/wiki/Day_count_convention Day Count Basis] | ||
| − | |||
| − | |||
| − | + | *[[Z_API_Functions | List of Main Z Functions]] | |
| − | + | *[[ Z3 | Z3 home ]] | |
| − | |||
Latest revision as of 14: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.
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
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