What does it do?
This sum of years depreciation calculator can be used to provide the sum of the years digits depreciation expense for any period in the useful life of an asset up to a maximum of 600 periods.
The calculator will also produce a depreciation schedule setting out for each period, the beginning asset book value, the depreciation expense for the period, and the ending asset book value.
The Excel sum of years depreciation calculator, available for download below, is used to produce an asset depreciation schedule by entering details relating to the cost of the asset, the asset salvage value at the end of its useful life, and the number of periods in the useful lifetime.
The sum of years depreciation calculator is used as follows:
Enter the cost of the asset.
Enter the salvage value. This is the estimated salvage value of the asset at the end of its useful life.
Enter the useful life. This is the estimated number of periods in the useful life of the asset. A period can be any term (month, year etc). The depreciation expense will be calculated for this period. For example is an asset has a 4 year life and the useful life is entered as 4 then the depreciation will be for each year, if the useful life is entered as 48 months, then the depreciation expense will be calculated for each month.
Enter the period for which the sum of the years digits depreciation expense is required. For example, if the depreciation expense for period 11 is required enter 11.
The sum of years depreciation calculator works out the depreciation expense for the period entered in step 4.
In addition, the calculator provides a sum of the years digits depreciation schedule setting out for each period, the beginning asset book value, the depreciation expense for the period, and the ending asset book value.
Sum of Years Depreciation Calculator Download
The Excel sum of years depreciation calculator, available for download below, will calculate the depreciation expense for any asset with a maximum useful life of up to 600 periods, and is used by simply entering values for the asset cost, salvage value, and useful life.
Users use this sum of years depreciation calculator template 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 sum of year digits depreciation calculator with asset depreciation schedule that you might use. It is a purely illustrative sum of years digits depreciation calculator. This is not intended to reflect general standards or targets for any particular company or sector. If you do spot a mistake in the 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 Plan Projections. 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 BSc from Loughborough University.