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


average inventory turnover formulahow do we complete a horizontal and vertical analysisvendor statement reconciliationreorder point and safety stockconsignee accountingfactoring without recoursefob point meaningtemplate for balance sheet and income statementdirect materials inventory formulabond discount journal entryfuture value calculator exceldefine cashbookhow to maintain petty cash bookfuture value formula annuityaccounts receivable exceljournal entry for warrantyadjusting entries worksheet exampleshow to record payroll journal entriessubsidiary ledger templatehow to calculate profit markupdouble entry for debtorscash book entry exampledebits and credits made easypayback period calculator onlinedepreciation reducing balance methodwhen is a trial balance preparedt accounts journal entriesimprest fundreimbursement of petty cashaccounting ratios calculatoraccounting journalizing exampleshow to calculate current liabilitiesonline amortization schedule generatorbank notes payableconsignment journal entrieshow to calculate days in accounts receivablebank reconciliation journal entry examplesvaluing zero coupon bondshow to find future value of an annuityjournalize the petty cash transactionsprepaid rent expense journal entryordinary annuity formula calculatorbad debts allowance methodhow to calculate vertical analysis percentagesloan balance calculator exceljv accounting termjournal entry for cash withdrawal from bankvariable costing formulasimple bookkeeping excelgaap capital leaseprofitability index excelpurchase ledger definitionbills payable in balance sheetjournal entry for machinery purchaseannuity table pdfpayback analysis examplefinance lease accounting example lesseepresent value annuity factor formulapractice bookkeeping testapplied overhead ratedeferred tax double entryfifo perpetual inventorystock valuation in excelexample of a ledger booktime sheet formatwhat is the normal balance for accounts payablefuture value annuity due calculatorlabor variance formulapv annuity due tableledger reconciliation formatspreadsheets for small business bookkeepingbookkeeping journal entries examples