200% declining balance depreciation method—Fixed Assets Management

Fixed Assets Management supports the 200% declining balance method (200DB) for depreciating assets.

Under the 200% declining balance method, assets depreciate at two times the straight-line depreciation rate. This method results in higher depreciation amounts in the early years of an asset's useful life and gradually decreases over time as the asset's book value decreases. Any remaining depreciation is applied in the last period of the asset's life. Depreciation stops when the asset's book value equals the expected salvage value.

The 200% declining balance method accelerates the depreciation process even more than the 150% declining balance method. This method is useful for assets that are expected to be more productive or valuable in their early years and lose value rapidly.

Conventions

This method supports the following conventions:

  • Full month

  • Half year

  • Full year

Formulas

  • Depreciation for each month:

     

    (C−AD)×2×(1÷UL)

  • Depreciation for the last month:

    C−S−AD

Variables

  • C = Asset cost
  • AD = Accumulated depreciation from all previous months
  • UL = Useful life in months
  • S = Salvage value

  • Depreciation for the first year:

     

    (C−AD)×2×(1÷UL)÷2

  • Depreciation for each subsequent year:

    (C−AD)×2×(1÷UL)

  • Depreciation for the last year:

    C−S−AD

The last year is added as an extra period to apply the remaining depreciation.

Variables

  • C = Asset cost
  • AD = Accumulated depreciation from all previous years
  • UL = Useful life in years
  • S = Salvage value

  • Depreciation for each year:

     

    (C−AD)×2×(1÷UL)

  • Depreciation for the last year:

    C−S−AD

Variables

  • C = Asset cost
  • AD = Accumulated depreciation from all previous years
  • UL = Useful life in years
  • S = Salvage value

Examples

Scenario:

  • Useful life: 60 months

  • Convention: Full month

  • Asset cost: $5,000.00

  • Salvage value: $100.00

  • In-service date: April 22nd, 2020

  • Use salvage value: True

Schedule:

Depreciation schedule
Period Scheduled posting date Depreciation amount ($) Calculation
1 April 30th, 2020 166.67 (5,000.00 asset cost − 0.00 accumulated depreciation) × (2 × (1 ÷ 60 months of useful life))
2 May 31st, 2020 161.11 (5,000.00 asset cost − 166.67 accumulated depreciation) × (2 × (1 ÷ 60 months of useful life))
3 June 30th, 2020 155.74 (5,000.00 asset cost − 327.78 accumulated depreciation) × (2 × (1 ÷ 60 months of useful life))
4 July 31st, 2020 150.55 (5,000.00 asset cost − 483.52 accumulated depreciation) × (2 × (1 ÷ 60 months of useful life))
5 August 31st, 2020 145.53 (5,000.00 asset cost − 634.07 accumulated depreciation) × (2 × (1 ÷ 60 months of useful life))
6 September 30th, 2020 140.68 (5,000.00 asset cost − 779.60 accumulated depreciation) × (2 × (1 ÷ 60 months of useful life))
... ... ... ...
60 March 31st, 2025 576.55 5,000.00 asset cost − 100.00 salvage value − 4,323.45 accumulated depreciation

Scenario:

  • Useful life: 5 years

  • Convention: Half year

  • Asset cost: $5,000.00

  • Salvage value: $100.00

  • In-service date: April 22nd, 2020

  • First tax month: January

  • Use salvage value: True

Schedule:

Depreciation schedule
Period Scheduled posting date Depreciation amount ($) Calculation
1 December 31st, 2020 1,000.00

(5,000.00 asset cost − 0.00 accumulated depreciation) × (2 × (1 ÷ 5 years of useful life)) ÷ 2
2 December 31st, 2021 1,600.00 (5,000.00 asset cost − 1,000.00 accumulated depreciation) × (2 × (1 ÷ 5 years of useful life))
3 December 31st, 2022 960.00 (5,000.00 asset cost − 2,600.00 accumulated depreciation) × (2 × (1 ÷ 5 years of useful life))
4 December 31st, 2023 576.00 (5,000.00 asset cost − 3,560.00 accumulated depreciation) × (2 × (1 ÷ 5 years of useful life))
5 December 31st, 2024 345.60 (5,000.00 asset cost − 4,136.00 accumulated depreciation) × (2 × (1 ÷ 5 years of useful life))
6 December 31st, 2025 418.40

5,000.00 asset cost − 100.00 salvage value − 4,481.60 accumulated depreciation

The remaining depreciation is applied in an extra period at the end of the asset's useful life.

Scenario:

  • Useful life: 5 years

  • Convention: Full year

  • Asset cost: $5,000.00

  • Salvage value: $100.00

  • In-service date: April 22nd, 2020

  • First tax month: January

  • Use salvage value: True

Schedule:

Depreciation schedule
Period Scheduled posting date Depreciation amount ($) Calculation
1 December 31st, 2020 2,000.00 (5,000.00 asset cost − 0.00 accumulated depreciation) × (2 × (1 ÷ 5 years of useful life))
2 December 31st, 2021 1,200.00 (5,000.00 asset cost − 2,000.00 accumulated depreciation) × (2 × (1 ÷ 5 years of useful life))
3 December 31st, 2022 720.00 (5,000.00 asset cost − 3,200.00 accumulated depreciation) × (2 × (1 ÷ 5 years of useful life))
4 December 31st, 2023 432.00 (5,000.00 asset cost − 3,920.00 accumulated depreciation) × (2 × (1 ÷ 5 years of useful life))
5 December 31st, 2024 548.00 5,000.00 asset cost − 100.00 salvage value − 4,352 accumulated depreciation