Reducing Balance Depreciation Calculation

Depreciation is the reduction in value of a long term asset due to wear and tear. There are various methods used to calculate depreciation one of which is the
reducing balance depreciation method often referred to as the declining balance depreciation method.

The reducing balance depreciation method involves applying a constant depreciation rate to the value of the asset at the start of each period.

The time value of money calculations can be used to calculate depreciation using the reducing balance depreciation method. To carry out the calculations we use the future value of a lump sum formula.

FV = PV x (1 + i)n
Variables used in the formula
PV = Present Value
FV = Future Value
i = Discount rate
n = Number of periods

If we treat the present value (PV) as the original cost of the asset at the start of period 1, and the discount rate (i) as the reducing balance depreciation rate, then the future value of a lump sum formula can be used to give the value of the asset after depreciation (net book value) at the end of period n.

The variables in the formula above can be restated as follows:

FV = PV x (1 + i)n
Variables used in the formula
PV = Original cost of the asset
FV = Net book value of the asset
i = Reducing balance depreciation rate per period
n = Number of periods

Reducing Balance Depreciation Example

Suppose for example, a business purchases an asset for 100,000 (PV) and depreciates it using the declining balance method at the rate of 25% a year, then at the end of year 4, the net book value (FV) is given as follows:

PV = 100,000
n = 4 years
i = -25% (rate is negative as the asset value is declining)
FV = Net book value = PV x (1 + i)n
FV = Net book value = 100,000 x (1 - 25%)4
FV = 31,640.63 

The time value of money calculations show that the net book value of the asset at the end of period 4 is 31,640.63 and the accumulated depreciation for the 4 years must be 100,000 – 31,640.63 = 68,359.37.

Depreciation Calculation for a Specific Period

The reducing balance depreciation for any particular period can be found by calculating the future value at the start of the period, the future value at the end of the period, and taking the difference between the two.

Using the example above, if we want the reducing balance depreciation for period 8, we calculate the future value at the end of period 7 and deduct this from the future value at the end of period 8, the difference must be the reducing balance depreciation for period 8.

Net book value at the end of period 7

PV = 100,000
n = 7 years
i = -25% (rate is negative as the asset value is declining)
FV = Net book value = PV x (1 + i)n
FV = Net book value = 100,000 x (1 - 25%)7
FV = 13,348.39

Net book value at the end of period 8

PV = 100,000
n = 8 years
i = -25% (rate is negative as the asset value is declining)
FV = Net book value = PV x (1 + i)n
FV = Net book value = 100,000 x (1 - 25%)8
FV = 10,011.29

The reducing balance depreciation for period 8 is then 13,348.39 – 10,011.29 = 3,337.10

Reducing Balance Depreciation Calculation November 6th, 2016Team

You May Also Like


Related pages


accrued interest receivablegross profit computationperpetuity formula excelsample of requisition formadjusting entry for depreciation on equipmentcalculating margins in excelfob destination freight prepaidprice and quantity variancereconciling accounts payableaccounts receivable flowchartifrs deferred revenueytm in excelpercentage of completion method of accountingbookkeeping debit creditending retained earningsaccounts spreadsheet excelcash disbursement bookdebtors and creditors on balance sheetcalculate npv excelnpv of an annuitytrade discount examplewhat is a suspense paymentinventory sale journal entryequation for gross profitsales ledger control account formatsample chart of accounts for non profitdupont roe formulainventory shrinkage rateebit interest coveragedeferred rent journal entryexample general ledgertimesheet formathow to calculate retained earnings on balance sheetsales taxes collected by a retailer are recorded bydiscounted cash flow formula in excelpetty cash worksheetzero coupon bond price calculatorjournal entry for interest expensesafety stock calculation excelstockholders equity exampleformula annuitypayroll accrual examplecost of direct materials used formulafluctuating fund systemfactoring accounting treatmentoperating leaverageaccounts receivable and accounts payable are examples of controlling accountsreduced balance depreciationfour accounting conceptslabour costing in cost accountingmargin markup calculatorgross sales equationsteps involved in adjusting entriescontra in accounting examplehow to reconcile petty cashtreatment of suspense accountinterest in suspense definitionexpanded accounting equation calculatorstock split journal entrywhat does fob on an invoice meanwhat is intangible assets examplesincome account normal balancehow to make adjusting journal entriesretained earnings journal entryeffective interest method amortizationbasic p&l statementhow to compute for net salesaccounting cycle steps examplejournal entry for petty cashexcel balance sheet formatbookkeeping test questionsis allowance for doubtful accounts a liabilitymanufacturing over headformula to calculate current ratioperiodic vs perpetualaccounts spreadsheet templateyear end accounting entries