Reducing Balance Depreciation Calculator

What does it do?

This reducing balance depreciation calculator works out the accumulated depreciation of an asset using the reducing balance method.

The reducing balance method is often referred to as the declining balance method which is more fully discussed in our declining balance depreciation tutorial.

Formula

The calculator uses the future value of a lump sum formula as shown below:

FV = PV x (1 + i)n

Full details of the formula can be seen at our future value of a lump sum formula page.

Instructions

The Excel reducing balance depreciation calculator, available for download below, is used to compute the accumulated depreciation by entering details relating to the asset cost (PV), depreciation rate (i) and the number of periods (n). The calculator is used as follows:

reducing balance depreciation calculator v 2.0
Reducing Balance Depreciation Calculator Preview

Step 1

Enter the asset cost (PV). This is the original cost of the asset at the start of period 1.

Step 2

Enter the depreciation rate (i). The depreciation rate is the rate used to depreciate the asset from the beginning of period 1 (today) to end of period n. The rate should be for a period, so for example, if the period is a year, then the rate should be the yearly rate.

As the value of the asset is reducing over time, the depreciation rate is entered as a negative value. For example, if the depreciation rate is 255 this is entered as -25%.

Step 3

Enter the number of periods (n). The number of periods is entered. A period can be any term (month, year etc), but must be consistent with the depreciation rate provided (see step 2)

Step 4

The reducing balance depreciation calculator works out the net book value (FV) of the asset at the end of period n, and also calculates the accumulated depreciation on the asset for the n periods.

Reducing Balance Depreciation Calculator Download

The reducing balance depreciation calculator spreadsheet is available for download in Excel format by following the link below.

The reducing balance depreciation calculator is one type of tvm calculator used in time value of money calculations, discover another at the links below.

Notes and major health warnings
Users use this reducing balance depreciation calculator at their own risk. We make no warranty or representation as to its accuracy and we are covered by the terms of our legal disclaimer, which you are deemed to have read. This is an example of a depreciation reducing balance calculator that you might use when considering how to calculate the accumulated depreciation for an asset. It is purely illustrative of a reducing balance calculator. This is not intended to reflect general standards or targets for any particular business, company or sector. If you do spot a mistake in this accelerated depreciation calculator, please let us know and we will try to fix it.
Reducing Balance Depreciation Calculator November 6th, 2016Team

You May Also Like


Related pages


perpetuity rateaccrual accounting versus cash accountingformula to calculate variable cost per unithow to calculate predetermined manufacturing overhead ratethe profitability indexformula for calculating depreciationcompute times interest earnedjob costing excelfinancial gearing formulamarketable securities on balance sheetpayroll expense journal entrycapital gearing ratio formulapetty cash voucher formbills payable in balance sheetfifo vs lifosource document accounting definitionmerchandise inventory debit or creditstraight line amortization calculatoramortization calculation excelbad debts debit or creditjournal entry for depreciation expensedifference between periodic and perpetual inventoryinterest in suspense definitionfifo method examplewhat is the imprest systemincome gearing ratiostockholders equity formulapayback period formula exampleaccounting excel templateswhat is the formula for predetermined overhead ratewhat is implicit interest ratesample payment voucher templatemultiple step income statements showdeferred creditspresent value of annuity calculator excelstockholders equity journal entrieshow to write a ledger bookhow to calculate gearing ratiodegree of total leverage formuladebtors turnover ratio formulafuture value of annuity tablefob shipment meansstraight line depreciation in excelrearrange formula calculatorhow to prepare bank reconciliation statement with examplejournal entry for bad debt expensedays sales in receivables ratio formulaproduct costing systemmarketable securities exampleaverage accounting return calculatorretained earningunrealized loss journal entryexample of lifo methodfactory overhead varianceaccrued payrollannual straight line depreciation formuladividends on preferred and common stock examplehow to prepare multi step income statementaccounting journalizing examplesformula fixed costprepaid insurance definitionbookkeeping reconciliationcalculating the effective annual ratewhat is debtors control accountcogs and inventorydebtors turnover formulawhat is a cash floathow to calculate retail margin percentageaccrued income entrywhat are reconciling itemsfv formulaturnover ratio calculationaccounting double entry system examplecogs formula manufacturingdepreciation expense equationlifo effectrecord unearned revenuechange in nwc formulaunrealized gain loss journal entrysmall business chart of accounts spreadsheetcalculating lifo