Depreciation Reducing Balance Method

Depreciation reducing balance method 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.

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.

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 yearDepreciation rateDepreciation for yearValue of asset at y/e
Year 1£20,00040%£8,000£12,000
Year 2£12,00040%£4,800£7,200
Year 3£7,20040%£2,800£4,400
Year 4£4,40040%£1,760£2,640
Year 5£2,64040%£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.

Excel Template – Depreciation Reducing Balance Method

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.

Instructions for excel depreciation reducing balance spreadsheet

  • Download the depreciation reducing balance excel template.
  • Only enter figures in the GREEN boxes.
  • Enter the purchase price of the equipment.
  • Enter the residual balance – this is the estimated value of the asset at the end of its life.
  • Enter the number of years you wish to depreciate the asset over.
  • Enter the number of months the assets needs to be depreciated during the first year. E.g. If you purchased the asset in January and your year end is at the end of March, this figure will be 3 months. The template will automatically calculate the number of months in the last year for you.

Depreciation Reducing Balance Template

Return from depreciation reducing balance to fixed asset page.