Examples of system reducing balance depreciation calculations

For accounting purposes depreciation represents the extent to which the economic value of an asset to the organisation has been consumed by the organisation. Reducing balance depreciation in each year is calculated as a percentage of the un-depreciated value (net value of the asset). So for an asset with a purchase cost of £1000 depreciated at a reducing rate of 30%, the first year depreciation is £300 (30% of £1,000), the second year depreciation is £210 (30% of net value at that time which is the £1,000 cost less £300 depreciation to date i.e. 30% of £700) and so on. The reducing balance rule is commonly used where the value of an asset falls more quickly in the early years than the latter years of its useful economic life. Cars and Personal computers probably follow this pattern.

How the system calculates reducing balance depreciation

The system computes a net book value (Cost or Valuation less cumulative depreciation) at the date of a depreciation posting or report and compares to the net book value at the start of the period. The difference adjusting for any additions, revaluations etc. is the depreciation for the period.

For those interested, the annual reducing balance rate set on the asset is used to determine a daily rate using compound interest theory over 365 days per year. So that to compute the net book value (NBV) on a particular date the calculation is: -

New NBV = Previous NBV * (1 - annual rate TO THE POWER OF (number of days of depreciation/365)

Examples


Opening balance asset

Opening balance asset - an asset already owned and having been recorded in the asset ledger:
Cost Dep'n NBV
Asset start date 31 Dec 2018 - - -
Opening Balance Information as at 1 Jan 2020 6,000.00 1,800.00 4,200.00
Days from opening balance date to (say) 31 Oct 2020 306 - - -
Reducing balance rate set at 30% - - -
Depreciation calculated for period 1 Jan to 31 Oct - - 1,082.47 -
Revised asset Value (NBV) at 31 Oct 2020 - - 3,117.53

The NBV value above at 31 Oct 2020 is calculated as (4,200 x (1-0.3)^POWER(305/365)) and cumulative depreciation is (6,000 less 3,117.53) 2,882.47.

Return to the list of cases

New asset

New asset
Cost Dep'n NBV
Asset cost and start date 2 Sept 2020 10,000.00 - 10,000.00
Days start date to (say) 31 Dec 2020 120 - - -
Reducing balance rate set at 25% - - -
Depreciation calculated for period 2 Sept to 31 Dec - - 902.45 -
Revised asset Value (NBV) at 31 Dec 2020 - - 9,097.55

The NBV value above at 31 Dec 2020 is calculated as (10,000 x (1-0.25)^(120/365)) and cumulative depreciation is (10,000 less 9,097.55) 902.45

Return to the list of cases

Revaluation of an asset

Revalue an asset
Cost/Reval. Dep'n NBV
Asset cost and NBV at 30 Sept 2020 6,000.00 2,786.59 3,213.41
Asset revalued to 5,000 on 1 Oct 2020 7,786.59 2,786.59 5,000.00
Days from revaluation date to (say) 31 Dec 2020 92 - - -
Reducing balance rate set at 30% - - -
Depreciation calculated for period 1 Oct to 31 Dec - - 429.89 -
Revised asset Value (NBV) at 31 Dec 2020 - - 4,507.11

The NBV value above at 31 Dec 2020 is calculated as (5,000 x (1-0.30)^(92/365)) and cumulative depreciation is (7,786.59 less 4,507.11) 3,279.48

Return to the list of cases

Impairment of an asset

Impair an asset - Example
Cost Dep'n NBV
Asset cost and NBV at 30 Sept 2020 10,000.00 218.27 9781.73
Asset impaired to 5,000 on 1 Oct 2020 10,000.00 5,000.00 5,000.00
Days from impairment date to (say) 31 Dec 2020 91 - - -
Reducing balance rate set at 25% - - -
Depreciation calculated for period 2 Oct to 31 Dec - - 346.06 -
Revised asset Value (NBV) at 31 Dec 2020 - - 4,653.94

The NBV value above at 31 Dec 2020 is calculated as (5,000 x (1-0.25)^(91/365)) and cumulative depreciation is (10,000.00 less 4.653.94) 5,346.06

Return to the list of cases

Additions to an existing asset

An addition to an existing asset can be added by using a journal referenced to the relevant asset. Debit the appropriate tangible fixed asset cost account and the credit to asset additions account. Note the payment is also recorded to the asset additions account to balance to zero.

The system calculates a NBV, and therefore depreciation, for each addition starting in the month in which it was added.

Addition to an existing asset - Example
Cost Dep'n NBV
Original asset cost and NBV at 30 Sept 2020 10,000.00 218.27 9781.73
Asset addition on 1 Oct 2020 1,000.00 - 1,000.00
Reducing balance rate set at 25% - - -
Original asset calculated depreciation and NBV at 31 October 2020 10,000.00 241.37 9,758.63
Addition to asset calculated depreciation and NBV at 31 October 2020 1,000.00 24.14 975.86
Total asset depreciation and NBV at 31 October 2020 11,000.00 265.51 10,734.49
Return to the list of cases

Related Topics