AMORDEGRC function

The AMORDEGRC function in Excel calculates the depreciation of an asset for a specified period using the declining balance method. It is one of the functions used for calculating depreciation based on the General Depreciation System (GDS), commonly used for tax purposes in the United States.

Syntax

AMORDEGRC(cost, date_purchased, first_period, salvage, period, factor, [no_of_periods])

Parameters

• cost: The initial cost of the asset, i.e., the purchase price or the cost of the asset when it was acquired.
• date_purchased: The purchase date of the asset (in Excel date format).
• first_period: The first period in which depreciation is calculated. This is the number of periods from the asset’s purchase date to the first depreciation period.
• salvage: The asset’s salvage value, which is the estimated residual value of the asset at the end of its useful life.
• period: The period for which depreciation is to be calculated (e.g., 1 for the first period, 2 for the second, etc.).
• factor: The rate of depreciation. The default value is 2 (which means double-declining balance), but you can use other values to change the method.
• [no_of_periods] (optional): The total number of periods over which depreciation is to be calculated. If omitted, the function assumes the total number of periods is the same as the asset’s useful life.

How It Works

The AMORDEGRC function calculates the depreciation of an asset using the declining balance method, which accelerates depreciation, meaning the asset depreciates more in the earlier periods of its life. The function follows a formula that considers:

• The purchase price of the asset.
• The number of periods (usually years or months).
• The salvage value, which is the value left after depreciation.

Depreciation is calculated using the formula:

$$\text{Depreciation for a period} = (\text{Cost} – \text{Salvage value}) \times \text{Depreciation Factor}$$

The depreciation for each period is based on the declining balance, so the depreciation amount decreases over time.

Example

Assume you purchased an asset for $10,000 on January 1, 2023. The asset has a salvage value of $1,000 and a useful life of 5 years. The depreciation factor is 2 (for the double-declining balance method), and you want to calculate the depreciation for the first year (period 1).

The formula would be:

=AMORDEGRC(10000, "1/1/2023", 1, 1000, 1, 2, 5)

Explanation of the Example:

• 10000: The initial cost of the asset.
• "1/1/2023": The date the asset was purchased.
• 1: The first period of depreciation.
• 1000: The salvage value of the asset.
• 1: The first period of depreciation calculation.
• 2: Depreciation factor for double-declining balance method.
• 5: The total number of periods (in years) over which the asset will be depreciated.

Important Notes

• AMORDEGRC follows the declining balance method, where depreciation is higher in the early years and decreases over time.
• The factor argument determines the rate of depreciation, with 2 indicating double-declining balance. If you want to use a different rate of depreciation, you can adjust this factor.
• The no_of_periods argument is optional, and if omitted, Excel will calculate depreciation based on the asset’s useful life.
• The first_period argument helps in cases where depreciation may not start immediately after purchase (e.g., if it starts from the middle of a period).

Summary

The AMORDEGRC function in Excel is used to calculate the depreciation of an asset using the declining balance method, with the option to accelerate depreciation using a factor. This function is particularly useful for tax purposes or when working with assets that lose value more quickly in the initial years of their useful life.