AMORDEGRC function in Excel

-

 AMORDEGRC function in Excel

The Microsoft Excel AMORDEGRC function returns the linear depreciation of an asset for each accounting period, on a prorated basis.

The AMORDEGRC function is a built-in function in Excel that is categorized as a Financial Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the AMORDEGRC function can be entered as part of a formula in a cell of a worksheet.

Syntax

The syntax for the AMORDEGRC function in Microsoft Excel is:

AMORDEGRC( cost, purchase_date, first_period, salvage, period, rate, [basis] )

Parameters or Arguments

cost
The cost of the asset.
purchase_date
The date that the asset was purchased.
first_period
The date of the end of the first period.
salvage
The salvage value after the asset has been fully depreciated.
period
The period in which to calculate the linear depreciation.
rate
The rate of depreciation.
basis

Optional. It is the type of year basis to use when calculating the depreciation. If this parameter is omitted, it assumes that the basis is set to 0. It can be any of the following values:

ValueExplanation
0360 days (NASD)
1Actual
3365 days (in a year)
4360 days (in a year)

Returns

The AMORDEGRC function returns a numeric value.

Applies To

  • Excel for Office 365, Excel 2019, Excel 2016, Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007

Type of Function

  • Worksheet function (WS)

Example (as Worksheet Function)

Let's look at some Excel AMORDEGRC function examples and explore how to use the AMORDEGRC function as a worksheet function in Microsoft Excel:


Based on the Excel spreadsheet above, the following AMORDEGRC examples would return:

=AMORDEGRC(B1,B2,B3,B4,B5,B6,B7)
Result: 2813

=AMORDEGRC(10000,DATE(2012,3,1),DATE(2012,12,31),1500,1,0.3,1)
Result: 2813

=AMORDEGRC(10000,DATE(2012,3,1),DATE(2012,12,31),1500,1,30%,1)
Result: 2813


Comments

Post a Comment

Popular posts from this blog

Financial Accounting Important 2 Marks Theory Question and Answer

-
  1. Accounting: It's not just about recording transactions—it also involves interpreting financial information to make informed decisions. It includes financial reporting, auditing, and analyzing economic events. 2. Journal: It's the initial book of entry where transactions are recorded in chronological order. Each entry includes details like date, accounts involved, amounts, and a brief description. 3. Ledger: A ledger contains individual accounts summarizing transactions related to a specific asset, liability, equity, revenue, or expense. It's organized by account type and provides a detailed record of financial activities. 4. Legacy: It refers to outdated systems, processes, or technologies that persist because they were previously used and are still functional. However, they might not be as efficient or effective as newer alternatives. 5. Compensating Errors: These are mistakes that occur in accounting but counterbalance each other, ultimately resulting
Read more

Financial Accounting Important Theory Q&A Model Exam

-
2 Marks 1. Accounting:    Accounting is a systematic process of recording, summarizing, analyzing, and reporting financial transactions of a business or entity, enabling informed decision-making.   2. Double Entry System:    It's an accounting method requiring every transaction to have at least two entries (debit and credit), ensuring balance in financial records and maintaining the accounting equation.   3. Error of Commission:    An error made during accounting that involves an incorrect amount, account, or party, affecting the accuracy of financial records due to a wrong entry or commission.   4. Single Entry System:    A basic accounting method that records only one side of transactions, often cash or bank transactions, lacking the structured balance maintained by the double entry system.   5. Trading Account (Trading A/c):    An account summarizing direct costs (purchases, expenses, sales) related to buying and selling goods, determining the gross p
Read more

Financial Accounting Important 10 Mark theory Questions & Answer

-
Image
  1. Accounting Concepts:      Going Concern Concept: Assumes that the business will continue its operations for the foreseeable future, allowing assets to be recorded at their original cost rather than their liquidation value. This concept impacts how assets and liabilities are presented in the financial statements.      Consistency Concept: Requires a company to use the same accounting methods and principles consistently from one accounting period to another. It ensures comparability between financial statements over time, aiding analysis and decision making.      Accrual Concept: Transactions should be recorded when they occur, regardless of when the actual cash is exchanged. This means recognizing revenues when earned (even if the cash hasn't been received) and expenses when incurred (even if the cash hasn't been paid).      Matching Concept: Directly links expenses with the revenues they help generate during the same accounting period. It ensures that the financ
Read more