VDB

Function Type: Financial

Description:

Returns the depreciation of an asset for a specified or partial period by using a declining balance method.

Function Structure:

=VDB(cost, salvage, life, start_period, end_period, [factor], [no_switch}).

Argument Breakdown:

cost – Initial cost of the asset.

salvage – Asset value at the end of depreciation.

life – Periods over which asset is depreciated.

start_period – The starting period for which you want to calculate the depreciation. Start_period must use the same units as life.

end_period – This is the ending period for which you want to calculate the depreciation. End_period must use the same units as life.

factor – This is the rate of depreciation. If we omit the argument, the function will take the default value of 2, which denotes the double declining balance method.

no_switch – This is an optional logical argument that specifies whether the method should switch to straight-line depreciation when depreciation is greater than the declining balance calculation.

Example:

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 )

Google photo

You are commenting using your Google 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: