DDB Function in Excel

What this does

DDB applies double-declining-balance depreciation: each period charges a fixed percentage of the remaining book value, so the amount falls every year. That matches how vehicles, laptops and machinery actually lose value, unlike the even spread of SLN. The optional factor argument controls the aggressiveness — 2 is the default double rate, 1.5 gives a gentler decline. DB is a related but distinct function using a fixed-rate method with a slightly different formula and an extra month argument for a part-year first period. Neither depreciates below the salvage value. Keep the inputs visible and clearly labelled and the whole thing stays auditable — anyone who opens the file later, including you, can see at a glance exactly what feeds the result and change one assumption without hunting through the formula. Treat “ddb function in excel” as a small repeatable workflow rather than a one-off click you hope to remember next time. Use a small test block before the live file, so any surprise in the affected formula shows up while it is still harmless. When a formula is involved, keep the inputs labelled beside it, reference cells instead of typing values, and apply number formatting only after the result checks out. That turns a calculation you can defend to a CFO or an auditor into a method you can reuse, explain, and defend when the workbook leaves your screen.

A worked example

A 60,000 vehicle with a 6,000 residual over 8 years: =DDB(60000, 6000, 8, 1) charges 15,000 in year one, against SLN's flat 6,750. By year four the DDB charge has fallen to about 6,328, and the cumulative charge stops once book value reaches the 6,000 salvage figure. Declining-balance depreciation matches the real value curve of vehicles and equipment, which is what makes an asset schedule believable. If there is any chance you will reuse this, drop it into a small template tab right now: a labelled input area on the left and the formula beside it, checked once against the tool above. Next time the same question comes up, the answer is a single paste away instead of a rebuild from memory.

In Google Sheets

If you are in Google Sheets rather than Excel, the good news is that the formula shown here is identical and the workflow barely changes — menus sit across the top instead of in a ribbon, and a few function names differ slightly, but anything you build here moves across with little or no rework. The aim was to get you unstuck fast and leave you a little more capable than a copy-paste would. The answer is at the top, the tool proves it, and the detail above shows why it holds — so the next time a colleague asks, you can answer without reaching for search. The short version of “ddb function in excel”: the answer is at the top of this page, the tool proves it on your own numbers, and the sections above explain why it holds so the next variation does not stump you. Excel rewards people who reference cells instead of typing values and who keep inputs separate from formulas, because that is what makes a result you can audit months later. Build it once, deliberately, with the live tool as a check, and you convert a one-off lookup into a reusable skill — which is the whole point of learning the why and not just the what.

Common mistakes

• Expecting the charges to sum exactly to cost minus salvage; declining balance often needs a final-period adjustment, which VDB handles.
• Confusing DB and DDB — DB uses a fixed-rate method and takes an extra month argument.
• Applying DDB to assets that lose value steadily, which overstates early expense.

Frequently asked questions