Fresh Excel Tips

Quick and Easy Excel Tips and Tutorials

Use the DDB function to calculate double-declining balance method
Addicted To Cialis Medrol Packs Buying Viagra Over The Internet Bio Brite Sun Alarm Can Plavix Substitute For Coumadin Viagra And Affiliate Breast Augmentation Discussion Boards Natural Herb For Lasix Plavix And Inr Breast Enhancement Capsules Ultra Curves Estrogen Coral Calcium Supreme 240 Zelnorm Affects Birth Control Patti Labelle Clas Of The Choirs Benefit Of Coral Calcium Hgh Effects On Teens Buy Hgh Buy Hgh Buy Hgh Anoretic Cardura Medication Leukeran Pet Medication Levitra For Females Out Of Court Settlement For Viagra Prednisone Prescribing Lamictal Bipolar 1 Aleve Pregnancy Coumadin Anticoagulation Drug Interaction Cipro Zoloft And Sudafed Plavix And Aspirin Interactions Use Zovirax For Effective Herpes Treatment Medrol Dose Pack And Crohns Synthroid Hot Flashes Geodon Im Cialis Manufacturer Jewish Purim Cookies Squill And Lipitor Synthroid Destroys Thyroid Advil Or Motrin Atarax Prescribing Information Flonase For Kidney Stones Lotrisone Cr 30 Mg Cost Of Viagra In The Philippines Can I Take Prozac At Night Zoloft Cleft Palatte Benefit Of Coral Calcium 0a North Beach Pizza Soma San Francisco Viagra Over Counter Herb Valproic Depakote Hypothalmus Hoodia Tlc Lasix Veterinary Dose Of Tramadol Neurontin Use

The DDB function returns the depreciation of an asset for a specified period, using the double-declining balance method or some other method that can be specified.
DDB(cost, salvage, life, period, factor)
cost: The asset’s initial cost.
salvage: The value of the asset at the end of the depreciation.
life: The number of periods over which the asset is being depreciated.
period: The period for which the depreciation is being calculated.
factor: The rate at which the balance declines. If factor is omitted, it is assumed to be 2, which specifies the double-declining balance method.

To use the double-declining balance method:

  1. Enter the initial cost in cell B1, the number of periods in cell B2, and the salvage in cell B3.
  2. Calculate the depreciation in the fifth year in cell B4 with the following formula: =DDB($B$1,$B$3,$B$2,5).
  3. To calculate the depreciation after one day, type this formula in cell B5: =DDB($B$1,$B$3,$B$2*365,1).
  4. To calculate the depreciation after the first month, use this formula in cell B6: =DDB($B$1,$B$3,$B$2*12,1).

Use the DDB function to calculate double-declining balance method

This tip is compatible with Excel 97, 2000, 2003 and 2007.

Use the DDB function to calculate double-declining balance method
  1. How to Use the FV function to calculate total savings account balance
  2. How to Use the SYD function to calculate depreciation in Excel
  3. How to Use the SLN function to calculate straight-line depreciation
  4. How to Use the QUARTILE function to calculate the quartiles
  5. How to Use the EDATE function to calculate months in Excel

Article Information

Category
Formula and Function Examples

Tags
, , , , ,

Trackback URI

Comments RSS


Leave a Reply

← How to use the PV function to compare investments in Excel
How to Use the PMT function to determine the payment of a loan →