Filter
Top Products
Depreciation Worksheet 61
Entering Values for DB and DBX
If you choose either the declining balance (DB) or declining balance with
crossover to SL (DBX) depreciation method, remember to enter a value
representing the percent of declining balance for the
DB or DBX
variable.
Note: The declining balance you enter must be a positive number.
Entering Values for LIF
•If SL or SLF is selected, the LIF value must be a positive real number.
•If
SYD, DB, DBX, or DBF is selected, the LIF value must be a positive
integer.
Entering Values for M01
The value you enter for the starting month (M01) has two parts:
• The integer portion represents the month in which the asset is
placed into service.
• The decimal portion represents the fraction of the initial month in
which the asset begins to depreciate.
For example, to specify that the asset will begin to depreciate in the
middle of the first month, enter 1.5. To specify that the asset will begin
to depreciate a quarter of the way through the fourth month, enter 4.25.
Working with YR
• When computing depreciation, the value you enter for the year-to-
compute (
YR) variable must be a positive integer.
• If the remaining depreciable value (
RDV) variable is displayed, you
can press # to return to the year to compute (
YR) variable. To
represent the next depreciation year, press % to increment the
value for YR by one.
• To compute a depreciation schedule, repeatedly return to the year to
compute (YR) variable, press % to increment the value for YR, and
compute values for
DEP, RBV, and RDV. The schedule is complete
when RDV equals zero.
Entering Data and Computing Results
Because the Depreciation worksheet stores values and settings until you
either change them or clear the worksheet, you should not have to
perform every step each time you work a problem.
Note: Dates are not changed when you clear a worksheet.