Learn How to Use Microsoft Excel AMORDEGRC Function

Microsoft Excel AMORDEGRC Function

The main purpose of the Microsoft Excel AMORDEGRC function is to get the depreciation for the accounting period coefficient. That implies, with the help of the AMORDEGRC function you can able to return the depreciation for a given accounting using a depreciation coefficient determined by asset life. So, with the help of the AMORDEGRC function, you can able to get the depreciation for the accounting period coefficient.

Return Value of AMORDEGRC Function

The return value will be the depreciation in the given period. 

Syntax of AMORDEGRC Function

=AMORDEGRC(cost, purchase, first, salvage, period, rate, [basis])

Where the arguments:

• cost: This is the asset cost.
• purchase: This is the asset purchase date.
• first: This is the first-period end date.
• salvage: This is the asset salvage value.
• period: This is the period for which you want to calculate the depreciation.
• rate: This is the rate of depreciation.
• basis: This is the day count basis, default is 0 (optional).

How to Use Microsoft Excel AMORDEGRC Function?

So we know that Microsoft Excel AMORDEGRC function you can able to get the depreciation for the accounting period coefficient. That implies, with the help of the AMORDEGRC function you can able to return the depreciation for a given accounting using a depreciation coefficient determined by asset life. So, with the help of the AMORDEGRC function, you can able to get the depreciation for the accounting period coefficient.

Check out the list of all other articles:

• Learn How to Get nth Match in Microsoft Excel
• Learn How to Find Missing Values in Microsoft Excel
• Learn How to Get nth Smallest Value With Criteria in Microsoft Excel
• Learn How to Sort by Text Length in Microsoft Excel
• Learn How to Sort by Two Columns in Microsoft Excel
• Learn How to Sort by Random in Microsoft Excel
• Learn How to Sort by One Column in Microsoft Excel
• Learn How to Sort by Custom List in Microsoft Excel