Manuals/calci/DB

Revision as of 05:50, 15 March 2017 by Swapna (talk | contribs) (Created page with "=DB(C, Salvage, L, P, NoMonths)= Where *<math>C</math> is the initial cost of an asset, *<math>Salvage</math> is the value at the end of depreciation, *<math>L</math> is lif...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

DB(C, Salvage, L, P, NoMonths)

Where

  •   is the initial cost of an asset,
  •   is the value at the end of depreciation,
  •   is life of an asset that indicates the number of periods over which the asset is being depreciated,
  •   is the period for which depreciation is to be calculated, and
  •   specifies how many months of the year are used in the calculation of the first period of depreciation.

DB() calculates the depreciation of an asset for a specified period using the fixed-declining method.

Description

DDB(C, Salvage, L, P, NoMonths)

  • Depreciation is the decrease in value of assets. Depreciation of an asset is highest in the first period and decreases in successive periods.
  • DB() calculates the depreciation using the fixed-declining balance method.
  • If   <0, Calci displays #N/A error message.
  • If   , ,  ,   <=0, Calci displays #N/A error message.
  • If   is not an integer, Calci rounds up the value (e.g. 4.2 is rounded up to 5).

Examples

1. =DB(20000,2000,5,4.5,2) : Displays 1338.5030444492834 as a result.


2. =DB(10000,1000,5,1,6) : Displays 1338.5030444492834 as a result.

Related Videos

Double Declining Balance Method

See Also

References