AMORDEGRC function

description:

Returns the depreciation for each accounting period (French accounting system only), including any partial period.

 

syntax:

AMORDEGRC( costdate_purchasedfirst_periodsalvageperiodrate[basis] )

 

required arguments:

cost The cost of the asset.
date_purchased The date of the purchase of the asset.
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.
rate The rate of depreciation.

 

optional arguments:

[basis] The type of day count basis to use. You use 0 for U.S. bonds.