Open main menu
Home
Random
Log in
Settings
About ZCubes Wiki
Disclaimers
ZCubes Wiki
Search
Changes
← Older edit
Newer edit →
Manuals/calci/AMORDEGRC
(view source)
Revision as of 12:26, 17 January 2014
93 bytes added
,
12:26, 17 January 2014
no edit summary
Line 4:
Line 4:
*<math>DP</math> is the date of purchase of asset
*<math>DP</math> is the date of purchase of asset
*<math>FP</math> is the end of first period
*<math>FP</math> is the end of first period
−
<math>salvage</math> is the salvage value at the end of life of asset
+
*
<math>salvage</math> is the salvage value at the end of life of asset
−
<math>period</math> is the accounting period
+
*
<math>period</math> is the accounting period
*<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
Line 92:
Line 92:
=AMORDEGRC(A1,A2,A3,A4,A5,A6,A7) ''displays 564'' as a result.
=AMORDEGRC(A1,A2,A3,A4,A5,A6,A7) ''displays 564'' as a result.
+
=AMORDEGRC(3600,DATE(2010,3,4),DATE(2012,3,4),750,1,20%,1) ''displays 1441'' as a result.
== See Also ==
== See Also ==
Swapna
writer
2,661
edits