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


reserve for bad and doubtful debtsretained earnings debit balanceexcel npv calculationhow to post journal entries to t accountsgaap acronymhow to work out retained profitretained profit meaningbank reconciliation exercisesprofit vs markupcalculation for markupcost volume profit graph excel templateallowance for bad debt income statementsales return ratioformula for total asset turnoverhow to calculate total asset turnover ratio200 declining balance depreciationsimple bookkeeping template for excelpresent value annuity formulahow to calculate profit ratioallowance for doubtful debts definitionpresent value of annuity table excelreducing balance interest calculatoraccounts payable report sampleproject payback periodpv factor chartimprest account entryage of accounts receivablenet present value calculator annuityexamples of journal entries in tallyfactoring procedureexamples of deferred tax liabilities and assetsdebt equity ratio significanceaverage trade debtorsfixed overhead costsale of fixed assets journal entryequation for gross marginaccounts receivables turnovermirr calculation examplehow to calculate accrued interest on a note payablecar loan accounting entrymarketable securities on a balance sheetaccelerated depreciation method examplegearing ratio analysisdefinition payback periodsingle entry ledger examplemanagerial accounting calculatortotal labor variance formulawhat is beginning inventoryaccounting for accrued expensesytm in exceljournal entry for prepaid rentformula of future value of annuityaccounting and bookkeeping pdfvertical analysis of income statement interpretationhow to figure out markup percentagejournal entry for credit sales with discountfactoring receivables accountingtable present value of annuitywhen are annuity due payments madesubsidiary general ledgercalculation for inventory turnsfuture value of a growing annuityaccrued salaries definitiondepreciation reducing balance formulaageing of accounts receivablehow do i calculate npv in exceldebts and creditsirr in accountingdebit prepaid expensedifference between carriage and freightjournal entries in accounting for interviewreserve for bad debts journal entryhow to calculate weighted average inventory