DB Formula
|
What Does It Do ?
|
|
|
|
|
|
|
|
This
function calculates deprecation based upon a fixed percentage.
|
|
|||||
|
The first
year is depreciated by the fixed percentage.
|
|
|
||||
|
The
second year uses the same percentage, but uses the original value of the item
less
|
||||||
|
the first
years depreciation.
|
|
|
|
|
||
|
Any
subsequent years use the same percentage, using the original value of the
item less
|
||||||
|
the depreciation
of the previous years.
|
|
|
|
|||
|
The
percentage used in the depreciation is not set by the user, the function
calculates
|
||||||
|
the
necessary percentage, which will be vary based upon the values inputted by
the user.
|
||||||
|
|
|
|
|
|
|
|
|
An
additional feature of this function is the ability to take into account when
the item was
|
||||||
|
originally
purchased.
|
|
|
|
|
|
|
|
If the
item was purchased part way through the financial year, the first years
depreciation
|
||||||
|
will be based
on the remaining part of the year.
|
|
|
|
|||
|
|
|
|
|
|
|
|
|
Syntax
|
|
|
|
|
|
|
|
=DB(PurchasePrice,SalvageValue,Life,PeriodToCalculate,FirstYearMonth)
|
|
|||||
|
The
FirstYearMonth is the month in which the item was purchased during the
|
|
|||||
|
first
financial year. This is an optional value, if it not used the function will
assume 12 as
|
||||||
|
the
value.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Formatting
|
|
|
|
|
|
|
|
No
special formatting is needed.
|
|
|
|
|
||
