YEARLYDEPR function

Returns amount of depreciation expense for specified number of years (or a specific year) from the period depreciation starts

Syntax

The YEARLYDEPR 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_years_display     Required.    Number.    Number of years of this value to display; for example: enter 1 if you'd like to get the value for the first year. Input value must be >=1 and default=1.

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

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