# Depreciation Reducing Balance Method

## What is Reducing Balance Depreciation?

Depreciation reducing balance method or Declining Balance is one of the main ways for calculating depreciation in your accounts. The other main method used is straight-line depreciation. Whichever method you choose to use for the fixed asset you need to use the same method for the whole period of the asset life.

Depreciation reducing balance method is used if an asset needs to be written off at a higher value during the early years. An example of this may be some machinery equipment, which as soon as purchased the value is reduced very quickly and then slows down over time. Another example is a new car, which will lose more value in the first few years.

Depreciation is used to reduce the value of the asset either monthly or annual and add a depreciation expense to the profit and loss account. It means that the value of the assets is written off over a period of time.

## Reducing Balance Method vs Straight Line

The image uses the data from the example on this page and shows the difference between reducing balance and straight-line depreciation. As you can see both methods start at 20,000 and finish as 1,500, but the rate they reduce is different. It is much faster to start using the declining balance method.

## Depreciation Reducing Balance Method Example

To calculate this method you need to choose a percentage rate of depreciation. For our example, we have purchased a new piece of machinery at £20,000 using a 40% rate of depreciation. The asset is depreciated of a period of 5 years and has a residual value of £1500 at the end.

 Value start of year Depreciation rate Depreciation for year Value of asset at y/e Year 1 £20,000 40% £8,000 £12,000 Year 2 £12,000 40% £4,800 £7,200 Year 3 £7,200 40% £2,800 £4,400 Year 4 £4,400 40% £1,760 £2,640 Year 5 £2,640 40% £1,056 £1,584

As you can see there is £1584 remaining at the end of the 5 year period. So to get this figure correct you will need to calculate the exact percentage that needs to be used.

There is a formula to calculate the reducing balance method, which is as follows: DB is declining balance You do not need to know the equation as our template will complete the work for you.

## Excel Template – Depreciation Reducing Balance Method Within Business Accounting Basics we have two different calculators for working out your reducing balance figure. The first reducing balance calculator requires that you know the percentage rate of depreciation that is required and is calculated over a period of 5 years.

The second calculator uses a formula embedded in Microsoft Excel. We have set up a simple spreadsheet that uses the formula to calculate the figures for you. This excel template only works if the is a residual value at the end of life up to a maximum period of 10 years.