{"id":1825,"date":"2018-07-04T17:56:25","date_gmt":"2018-07-04T17:56:25","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=1825"},"modified":"2023-11-02T18:34:37","modified_gmt":"2023-11-02T18:34:37","slug":"amordegrc","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/functions\/amordegrc\/","title":{"rendered":"AMORDEGRC function"},"content":{"rendered":"\n
AMORDEGRC is an Excel function that is used to calculate the depreciation of an asset for a specific accounting period using the French accounting method. It is commonly used for financial analysis and reporting purposes.<\/p>\n\n\n\n
AMORDEGRC(cost, date_purchased, first_period, salvage, period, rate, [basis])<\/strong><\/p>\n\n\n\n To use the AMORDEGRC function, follow these steps:<\/p>\n\n\n\n Here’s an example of how to use the AMORDEGRC function:<\/p>\n\n\n\n This formula calculates the depreciation for an asset with an initial cost of $10,000, purchased on January 1, 2023, using the French accounting method. The first period is 1, the salvage value is $2,000, the depreciation rate is 20%, and the basis is 1 (indicating the French accounting method). It will return the depreciation amount for the third accounting period.<\/p>\n\n\n\n If you need more information about specific terms or concepts used in this function, you can refer to a financial accounting glossary or an Excel documentation resource for clarification.<\/p>\n","protected":false},"excerpt":{"rendered":" AMORDEGRC is an Excel function that is used to calculate the depreciation of an asset for a specific accounting period using the French…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25],"tags":[180],"yoast_head":"\nArguments<\/h2>\n\n\n\n
cost:<\/b><\/td> The initial cost of the asset.<\/td><\/tr> date_purchased:<\/b><\/td> The date when the asset was purchased.<\/td><\/tr> first_period:<\/b><\/td> The first period for which you want to calculate depreciation.<\/td><\/tr> salvage:<\/b><\/td> The estimated salvage value of the asset at the end of its useful life.<\/td><\/tr> period:<\/b><\/td> The accounting period for which you want to calculate depreciation.<\/td><\/tr> rate:<\/b><\/td> The depreciation rate for the asset.<\/td><\/tr> [basis]:<\/b><\/td> (Optional) The basis to use for calculating depreciation. If omitted, it defaults to 0.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n How to Use<\/h2>\n\n\n\n
\n
cost<\/code> argument.<\/li>\n\n\n\n
date_purchased<\/code> argument.<\/li>\n\n\n\n
first_period<\/code> argument.<\/li>\n\n\n\n
salvage<\/code> argument.<\/li>\n\n\n\n
period<\/code> argument.<\/li>\n\n\n\n
rate<\/code> argument.<\/li>\n\n\n\n
basis<\/code> argument.<\/li>\n\n\n\n
=AMORDEGRC(10000, \"1\/1\/2023\", 1, 2000, 3, 0.2, 1)<\/code><\/pre>\n\n\n\n
Additional Information<\/h2>\n\n\n\n