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


formula for double declining balance depreciationamortizing bondbasic accounting concepts principlespayback period in excelexamples of suspenceconsignor and consigneestandard overhead ratecash voucher template exceljournal entry for contingent liabilitycogs examplelifo equationquick assets divided by current liabilities is theaccounting balance sheet templatewhat is the definition of bookkeepingdebit credit voucher formatbank reconciliation format in excelwhat is a perpetual inventory system accountingvendor reconciliation processmanual bookkeeping examplesan example of deferred revenue is unearned rentpayment in perpetuityis prepaid rent an expenseannuity present value factorcalculating wipcalculate discount excelirr excel functionhow to calculate variable costingentry for sale of fixed assethigh school accounting worksheetsstandard costing variancesmaterials price variancehow to calculate interest coveragesum of years depreciation calculatornotes receivable vs accounts receivablemanual ledger formatcogs in accountingselling inventory journal entrydebt calculator excelfixed overhead budget varianceannuity formula in exceljournal entries for depreciationcash flow cycle formulaintangible assets examples balance sheethow to do closing entriesbills receivabletemplate for voucheraccounting ratios cheat sheetwhat is closing entries in accountingdegree operating leveragewageadvancecogs accounting entrytwo column cash bookis merchandise inventory a debit or creditcost of capital calculation excelproduct costing systemspayback period advantagesformula straight line depreciationhow to calculate manufacturing overhead allocatedbasic bookkeeping tutorialbusiness plan financials template excelpresent value of annuity tablefob frieghtjournal entry for stock splitdays purchases in accounts payablecreditor ledgerexamples of period costsmatching concept accounting principleinventory shrinkage rateintangible fixed assets amortisation policyretained earnings calculation examplebalance sheet reconciliation examplesmarkup margin tablecost of good sold income statement