Excel Function : DDB

Download now!

Excel Function : DDB




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


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.