Formulas > =DB()

How To Use DB() Function in Google Sheets


Calculates the depreciation of an asset for a specified period using the arithmetic declining balance method.

Common Questions about the DB Formula:
1. What is the DB formula?
2. How does the DB formula work?
3. What parameters does the DB formula take?

How can the DB Formula be used appropriately:
The DB Formula is designed to calculate the future value of an investment. When used appropriately, it allows for accurate projections of the future value of an investment, as well as its internal rate of return.

How can the DB Formula be commonly mistyped:
The DB Formula is commonly mistyped when the user inadvertently uses the wrong symbol for the “dealing rate” (p) parameter. The dealing rate should be represented with a lowercase “p”, not an uppercase “P”.

What are some common ways the DB Formula is used inappropriately:
Common misuse of the DB Formula includes providing the incorrect parameters. For example, if a user were to provide a negative “discount rate”, the result would be incorrect. Additionally, the DB Formula should not be used if the investment has an irregular cash flow.

What are some common pitfalls when using the DB formula:
The DB formula is sensitive to small mathematical differences, so it is important to ensure that the parameters are correct. Furthermore, the DB Formula is subject to rounding errors, so it is important to ensure that the decimal points are adjusted accordingly.

What are common mistakes when using the DB Formula?
Common mistakes include passing incorrect parameters to the DB Formula. Additionally, users should avoid supplying negative values for any of the input parameters, as this will produce strange results.

What are common misconceptions people might have with the DB Formula?
A common misconception is that the DB Formula is best used for investments with fixed cash flows, when in fact this is not the case. Additionally, people often mistakenly assume that the DB Formula is a one-size-fits-all solution for Investment Analysis, when in fact it can only provide accurate forecasting when supplied with the proper inputs.

How To Actually Use DB() in Sheets

DB(cost, salvage, life, period, [month])

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at

Learn more about the DB() formula:

Google Sheets | Depreciation Functions - SLN, SYD, DB and DDB

Use Google Sheets to calculate straight-line or accelerated depreciation using the four depreciation functions. SLN - Straight Line, SYD - Sum of the Year's Digits, DB - Declining Balance, and DDB - Double Declining Balance.

Generate a DB() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members.


Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.