ACCUMDEPR function

Returns amount of accumulated depreciation for specified number of months (or a specific month) from month depreciation starts

Syntax

The ACCUMDEPR function syntax has the following arguments

  • Asset_cost     Required.    Number.    Cost of asset to be depreciated

  • Depr_term_years     Required.    Number.    Term of depreciation in years. Must be a number >=0.

  • Depr_method     Required.    Refer table.    Method of depreciation. Select one of available methods, and input corresponding number. Default is straight line method.

    Interest method# values in formula Interest method mapping
    1Straight line method
    2 Sum of Years method
    3 Declining balance method

  • Declining_bal_factor     Required.    Number.    Enter a value if you select "declining balance" method. Default value is 2 (double declining balance).

  • Number_months_display     Required.    Number.    Number of months of this value to display; for example: enter 12 if you'd like to get the value for the first 12 months. Input value must be >=1 and default=12.

  • Salvage_percentOptional.    Number.    Percentage of original cost of asset that is salvaged at end of depreciation term. Default value is 0%.

  • Month_number     Optional.    Number.    Month for which this value is required. Leave this blank (no input) if you need values displayed for a specified number of months. Input value must be integer >=1. For example, enter 6 if you'd like this value for month 6. Note: value will be returned for specified month only if you enter a value.