How to Use DDB Function in Excel (Double Declining Balance)

Hello friends! Today we look at the DDB() function in Excel. It is the big, fast brother of the DB function!

What is DDB? It stand for "Double-Declining Balance". Sometimes, when you buy a new car or machine for business, it loses a LOT of value very fast in the first few years. DDB helps you calculate this fast depreciation. Very useful for taxes and accounting!

🛠️ How to write DDB Function

To use DDB, you need 4 main things: buy price, sell price when old, total years you use it, and WHICH year you want to check.

Formula Syntax:

=DDB(cost, salvage, life, period, [factor])

• cost: The price you pay to buy it today.
• salvage: The money you can sell it for when it is old.
• life: Total years you will use it.
• period: WHICH year do you want to check? (Example: 1 for Year 1).
• [factor]: (Optional) How fast you want it to drop value? If you ignore this, Excel uses 2 (Double).

📊 Short & Clear Example

Imagine your company buy a new delivery truck for $20,000 (Cost). You plan to use it for 5 years (Life). After 5 years, it is broken and old, so you can only sell it for $2,000 (Salvage).

You want to know: How much value does the truck lose in Year 1?

Formula for Fast Depreciation in Year 1:

=DDB(B1, B2, B3, B4)

• Result: $8,000.00
• What it means? It means in just Year 1, your new truck lose $8,000 in value! Boom! Very fast!
• What about Year 2? If you change B4 to 2, the result is $4,800.00. See? It loses less money as it gets older.

💡 Easy Pro Tips

1. DDB vs DB: DB is normal declining balance. DDB is DOUBLE declining balance! It means the value drops much faster at the beginning!
2. Change the Speed: If you don't want "Double" speed (which is 2), you can change the [factor]. If you put 1.5, it will be 1.5-declining balance! Example: =DDB(B1, B2, B3, B4, 1.5).
3. Cannot pass Salvage: DDB is very smart. It will never let your asset value drop below your salvage money ($2,000)!

📚 Useful Resources

• How to Use DB Function in Excel (Calculate Depreciation)
• How to Use NPV Function in Excel (Net Present Value Easy Guide)
• How to Use PMT Function in Excel (Calculate Loan Easy)