Excel Function : DDB
Category
Financial
Description
Returns the depreciation of an asset for a specified period by using the double-declining balance method or some other method that you specify
Microsoft Excel Reference Page
https://support.office.com/en-us/article/DDB-function-519a7a37-8772-4c96-85c0-ed2c209717a5
Syntax and Description of the DDB Excel Function
syntax The syntax for the DDB function in Microsoft Excel is: DDB( rate, nper, pmt, fv, type, method ) rate The interest rate per period. nper The number of compounding periods. pmt The payment for each compounding period. fv The future value of the investment. type The number 0 or 1 and indicates when payments are due. method The number 1, 2, or 3 and indicates how the principal is paid. Example Lets look at some Excel DDB function examples and explore how to use the DDB function in Excel VBA code: DDB(0.2/12,60,-100000,0,
About DDB Excel Function
The DDB function in Excel calculates the depreciation of an asset using the straight-line method. The function takes five arguments: 1. Cost: The initial cost of the asset. 2. Salvage: The value of the asset at the end of its depreciation. 3. Life: The number of periods over which the asset will be depreciated. 4. Period: The period for which depreciation is being calculated. 5. Factor: The rate at which the asset will be depreciated. The function returns the depreciation amount for the specified period.
