How to calculate depreciation in Excel

by | Dec 27, 2021

Excel supports various methods and formulas to calculate depreciation. There 7 built-in functions dedicated to depreciation calculation. In this guide, we’re going to show you How to calculate depreciation in Excel in 7 ways. Depreciation types in this article:...
How to calculate units of production depreciation in Excel

How to calculate units of production depreciation in Excel

by | Dec 24, 2021

Units of production depreciation is a common and useful parameter for manufacturing firms to calculate the value of an asset based upon usage. In this guide, we’re going to show you How to calculate units of production depreciation in Excel. Download Workbook How to...
Excel AMORLINC Function

Excel AMORLINC Function

by | Dec 24, 2021

The AMORLINC function is a Finance function used in French accounting system that returns the depreciation for each accounting period, on a prorated basis. The prorated depreciation is considered when an asset is purchased in the middle of the accounting period. In...
Excel AMORDEGRC Function

Excel AMORDEGRC Function

by | Dec 24, 2021

The AMORDEGRC function is a Finance function used in French accounting system that returns the depreciation for each accounting period, on a prorated basis. The prorated depreciation is considered when an asset is purchased in the middle of the accounting period. In...
Excel VDB Function

Excel VDB Function

by | Dec 23, 2021

The VDB function is a Finance function that calculates the depreciation of an asset on the double-declining balance or another basis for a specified period. The VDB stands for variable declining balance and the function switches to straight-line depreciation when...
Excel DDB Function

Excel DDB Function

by | Dec 23, 2021

The DDB function is a Finance function that calculates the depreciation of an asset on the double-declining balance or another basis for a specified period. In this guide, we’re going to show you how to use the DDB function and go over some tips and error handling...
Excel DB Function

Excel DB Function

by | Dec 22, 2021

DB The DB function is a Finance function that calculates the depreciation of an asset on the fixed-declining balance basis for a specified period. In this guide, we’re going to show you how to use the DB function and go over some tips and error handling methods....
Excel SYD Function

Excel SYD Function

by | Dec 22, 2021

The SYD function is a Finance function that calculates the depreciation of an asset on the sum-of-years' digits basis for a specified period. In this guide, we’re going to show you how to use the SYD function and go over some tips and error handling methods. Supported...
Excel SLN Function

Excel SLN Function

by | Dec 21, 2021

The SLN function is a Finance function that calculates the depreciation of an asset on a straight-line basis for one period. In this guide, we’re going to show you how to use the SLN function and go over some tips and error handling methods. Supported versions All...