Back to all functions

In this lesson we will take a look at DB, which stands for Declining Balance, and uses a fixed rate to calculate the Depreciation Values.
To find it we’ll enter the same values as in SYD.
We’ll write Equals, DB, select the Cost, Residual Value and Lifespan, making them all absolute, as well as selecting the period to the left.
DB also has an optional fifth argument which lets you decide how many months to go in the first year.
The default is 12, but you can set this argument to 6, for example, if you purchased the asset at the beginning of the third quarter in the first year.
We will ignore it for now, and copy downward.
By the tenth period, the Asset value has depreciated to Fourteen hundred, Ninety Three, which is just under the Residual value.
We’ll insert a graph to assess the curvature of the line.
In this lesson we have gone through the Depreciation function DB.

Popular courses

The Excel Functions Guide

Deepen and develop your Excel Functions skills

Learn how to efficiently manage databases, clear text in cells, and retrieve values from other tables. The course also walks...

Excel Essentials

Get a better understanding of the Excel workflow

Learn to feel more comfortable in Excel. This course will help quickly develop your knowledge in Excel. Excel Essentials is...

Contact us for assistance in finding right course

Excel for your profession

The Excel course for Procurement and Logistic professionals

Excel for professionals working within procurement and logisticians

In cooperation with organisations and professionals within the industry, Learnesy have developed an Excel course that is adapted to those...

Looking for something custom made? Contact us and we will make sure to meet your requirements.