Depreciation Worksheet Variables

Variable

Key

Display

Variable Type**

Straight-line method

& p

SL

Setting

Sum-of-the-years’-digits method

& V

SYD

Setting

Declining-balance method

& V

DB

Setting/Enter

Declining-balance method with crossover to SL method

& V

DBX

Setting/Enter

French straight-line method*

& V

SLF

Setting/Enter

French declining balance method*

& V

DBF

Setting/Enter

Life of the asset in years

#

LIF

Enter only

Starting month

#

M01

Enter only

Starting date for French straight-line method**

#

DT1

Enter only

Cost of the asset

#

CST

Enter only

Salvage value of the asset

#

SAL

Enter only

Year to compute

#

YR

Enter only

Depreciation for the year

#

DEP

Auto-compute

Remaining book value at the end of the year

#

RBV

Auto-compute

Remaining depreciable value

#

RDV

Auto-compute

* SLF and DBF are available only if you select the European format for dates or separators in numbers. Setting Calculator Formats

** This guidebook categorizes variables by their method of entry. Types of Worksheet Variables

Resetting the Depreciation Worksheet Variables

To reset all calculator variables and formats to default values, including the Depreciation worksheet variables, press & } !.

Variable

Default

Variable

Default

Depreciation method

SL

M01

1

DB

200

YR

1

DBX

200

CST

0

LIF

1

SAL

0

To clear only the LIF, YR, CST, and SAL Depreciation worksheet variables and reset default values without affecting the depreciation method or other calculator variables and formats, press & z while in the Depreciation worksheet.

Computing Values for DEP, RBV, and RDV

The calculator computes one year at a time and rounds the results to the number of decimal places set. Setting Calculator Formats
The calculator computes values for DEP, RBV, and RDV automatically when you press # to display each variable.

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 C to increment the value for YR by one.
To compute a depreciation schedule, repeatedly return to the year to compute (YR) variable, press C to increment the value for YR, and compute values for DEP, RBV, and RDV. The schedule is complete when RDV equals zero.