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.
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.
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:
Enter the asset cost (PV). This is the original cost of the asset at the start of period 1.
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%.
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)
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.
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.
About the Author
Chartered accountant Michael Brown is the founder and CEO of Double Entry Bookkeeping. He has worked as an accountant and consultant for more than 25 years and has built financial models for all types of industries. He has been the CFO or controller of both small and medium sized companies and has run small businesses of his own. He has been a manager and an auditor with Deloitte, a big 4 accountancy firm, and holds a degree from Loughborough University.