Function Type: Financial


Returns the depreciation of an asset for a specified period by using the double-declining balance method or some other method that you specify.

Function Structure:

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

Argument Breakdown:

cost – Initial cost of asset.

salvage – Asset value at the end of depreciation.

life – Periods over which asset is depreciated.

period – Period to calculation depreciation for.

factor – Rate at which the balance declines. If omitted, defults to 2.


If you need instant expert help with Excel or Google Sheets, please visit my fiverr gig.

Back to Learn Excel->

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: