Categories
Excel Macros Microsoft Office

VDB function in Excel

[ad_1]

Are you having a difficult time without calculating the depreciation of fixed assets by the reducing balance method? You know you can use Excel to process it but don’t know which function to use to calculate it? The following share will guide you to use the VDB function in Excel to calculate depreciation of fixed assets by the reducing balance method.


Jaw VDB is a function that helps you calculate the depreciation of fixed assets by the reducing balance method. Using this calculation function will return the depreciation of the assets in the period you specify, including incomplete terms, using the double descending balance method or some other method you specify. VDB stands for Variable Declining Balance (descending balance changes).

ham vdb in excel

VDB function in Excel

How to use the VDB function in Excel

1. Description and syntax used

This is a function that calculates the depreciation for an asset over multiple defined periods, the calculation function is based on the double-declining balance method.

Syntax:

VDB (cost, salvage, life, start_period, end_period, [factor], [no_switch])

Inside:

Cost: The initial cost of the property, is a fixed parameter.
Salvage: The recovery value of an asset is the value after depreciation of the asset, which is a required parameter.
Life: Number of depreciation periods of the asset, which is a required parameter.
Start_period: The first period to calculate the depreciation of the property, is a required parameter.
End_period: The last period to calculate depreciation, is a required parameter.
Factor: Balance reduction ratio, which is an optional parameter, if omitted, is 2.
No_switch: The logical value used to determine whether or not the amortization is greater than the reduction of the balance to a straight-line depreciation method.
+ Case No_switch = TRUE: Do not switch to straight-line depreciation method even if the amortization value is larger than the declining balance.
+ Case No_switch = FALSE or skip: Carrying to the depreciation method according to the acceleration path when the depreciation value is larger than the declining balance.

Attention:

– In case you do not want to use the double-declining balance method when calculating depreciation -> change the value Factor.

– All parameters (apart from No_switch) must be a positive number.

2. Examples of specific situations

To give you a better idea of ​​how to use this function, please see a specific example below:

ham vdb in excel 2

2.1. Calculate depreciation of assets after the first day

ham vdb in excel 3

You enter the formula in the cell C5 = VDB (A3, B3, C3 * 365,0,1) as shown below:

ham vdb in excel 4

As you can see, the investment assets in this example are 10 years. The unit is calculated by year but the requirement here is to calculate daily depreciation, so I multiplied 10 years by 365 days per year as the value. Life up here

Next -> you press Enter to get results:

ham vdb in excel 5

2.2. Asset depreciation for the first month

Similar to depreciation on the first day. Here I will multiply 10 years by 12 January as shown below:

ham vdb in excel 6

You press Enter To get the result of the calculation function:

ham vdb in excel 7

2.3. Calculate depreciation of assets from the 2nd month to the 9th month

Here you only need to enter the value of depreciation time and you will get the desired result:

ham vdb in excel 8

Next, click Enter To get the result of the calculation function:

ham vdb in excel 9

2.4. Asset depreciation for the first year

You enter the task in the box C8 = VDB (A3, B3, C3,0,1) as shown below:

ham vdb in excel 10

Next, click Enter to get results:

ham vdb in excel 11

The article on Taimienphi.vn has shown you how to use it VDB function in Excel. Using this function helps you calculate the depreciation of assets over multiple defined periods (the calculation function is based on the double-declining balance method).

https://thuthuat.taimienphi.vn/ham-vdb-trong-excel-43750n.aspx
In case, if you need to calculate depreciation value of assets using the straight-line method, you should use SLN function to calculate and process. Good luck!

.

[ad_2]

Leave a Reply

Your email address will not be published. Required fields are marked *