DDB Function [VBA]

Returns the depreciation of an asset for a specified period using the arithmetic-declining method.

warning

This constant, function or object is enabled with the statement Option VBASupport 1 placed before the executable program code in a module.


Syntax:


DDB(Cost As Double, Salvage As Double, Life as Double, Period as Double, [Factor as Variant])

Return value:

Double

Parameters:

αžαž˜αŸ’αž›αŸƒβ€‹β€‹ αž€αŸ†αžŽαžαŸ‹β€‹β€‹αžαž˜αŸ’αž›αŸƒβ€‹αžŠαŸ†αž”αžΌαž„β€‹αž“αŸƒβ€‹β€‹αž‘αŸ’αžšαž–αŸ’αž™β€‹αžŸαž€αž˜αŸ’αž˜β€‹ αŸ”

αžŸαž„αŸ’αž‚αŸ’αžšαŸ„αŸ‡β€‹β€‹ αž€αŸ†αžŽαžαŸ‹β€‹αžαž˜αŸ’αž›αŸƒβ€‹αž“αŸƒβ€‹αž‘αŸ’αžšαž–αŸ’αž™β€‹αžŸαž€αž˜αŸ’αž˜β€‹αž“αŸ…αž…αž»αž„β€‹αž“αŸƒβ€‹αž’αžΆαž™αž»β€‹αž€αžΆαž›β€‹αžšαž”αžŸαŸ‹β€‹αžœαžΆβ€‹ αŸ”β€‹

Life αž‚αžΊβ€‹αž‡αžΆβ€‹β€‹αžšαž™αŸˆαž–αŸαž› (αž§αž‘αžΆαž αžšαžŽαŸ αž†αŸ’αž“αžΆαŸ† αž¬β€‹αžαŸ‚) αž€αŸ†αžŽαžαŸ‹β€‹αžœαž·αž’αžΈβ€‹αžŠαŸ‚αž›β€‹αž‘αŸ’αžšαž–αŸ’αž™αžŸαž€αž˜αŸ’αž˜β€‹β€‹αžαŸ’αžšαžΌαžœβ€‹αž”αžΆαž“αž”αŸ’αžšαžΎΒ αŸ”

Period αžŸαŸ’αžαžΆαž“αž—αžΆαž–β€‹αž“αŸƒβ€‹αžšαž™αŸˆβ€‹αžŸαž˜αŸ’αžšαžΆαž”αŸ‹β€‹αžαž˜αŸ’αž›αŸƒβ€‹αžαŸ’αžšαžΌαžœβ€‹αž”αžΆαž“αž‚αžŽαž“αžΆΒ αŸ”

αž€αžαŸ’αžαžΆβ€‹β€‹ (αž‡αžΆβ€‹αž‡αž˜αŸ’αžšαžΎαžŸβ€‹β€‹) αž‡αžΆαž€αžαŸ’αžαžΆβ€‹αžŠαŸ„αž™β€‹β€‹αž€αžΆαžšβ€‹αžšαŸ†αž›αŸ„αŸ‡αžŽαžΆαž˜αž½αž™αž…αž»αŸ‡αžαž™β€‹ αŸ”β€‹ αž”αŸ’αžšαžŸαž·αž“β€‹β€‹αž”αžΎβ€‹ αžαž˜αŸ’αž›αŸƒβ€‹αž˜αž·αž“αžαŸ’αžšαžΌαžœβ€‹αž”αžΆαž“β€‹αž”αž‰αŸ’αž…αžΌαž›β€‹ αž›αŸ†αž“αžΆαŸ†αžŠαžΎαž˜β€‹αž‡αžΆβ€‹αž€αžαŸ’αžαžΆβ€‹β€‹ ្ αŸ”

αž”αŸ’αžšαžΎβ€‹αž‘αž˜αŸ’αžšαž„αŸ‹β€‹β€‹αžšαŸ†αž›αŸ„αŸ‡β€‹αž“αŸαŸ‡ αž”αžΎβ€‹αž’αŸ’αž“αž€β€‹αžαŸ’αžšαžΌαžœβ€‹αž€αžΆαžšβ€‹αžαž˜αŸ’αž›αŸƒβ€‹αžšαŸ†αž›αŸ„αŸ‡β€‹αžŠαŸ†αž”αžΌαž„β€‹αžαŸ’αž–αžŸαŸ‹β€‹αž‡αžΆαž„ αžŠαŸ‚αž›β€‹αž•αŸ’αž‘αž»αž™β€‹αž“αžΉαž„β€‹αžšαŸ†αž›αŸ„αŸ‡β€‹αž›αžΈαž“αŸαž’αŸŠαŸ‚αžš αŸ” αžαž˜αŸ’αž›αŸƒβ€‹αžšαŸ†αž›αŸ„αŸ‡β€‹αž“αžΉαž„β€‹αž‘αž‘αž½αž›β€‹αž”αžΆαž“β€‹αžαž·αž…β€‹αž€αŸ’αž“αž»αž„β€‹αž’αŸ†αž‘αž»αž„αž–αŸαž›β€‹αž“αžΈαž˜αž½αž™β€‹αŸ— αž“αž·αž„β€‹αž‡αžΆβ€‹αž’αž˜αŸ’αž˜αžαžΆβ€‹αžαŸ’αžšαžΌαžœβ€‹αž”αžΆαž“β€‹β€‹αž”αŸ’αžšαžΎβ€‹αžŸαž˜αŸ’αžšαžΆαž”αŸ‹β€‹αž‘αŸ’αžšαž–αŸ’αž™β€‹αžŸαž€αž˜αŸ’αž˜ αžŠαŸ‚αž›β€‹αžαž˜αŸ’αž›αŸƒβ€‹αž”αžΆαžαŸ‹αž”αž„αŸ‹β€‹αžšαž”αžŸαŸ‹β€‹αžœαžΆβ€‹αž“αžΉαž„β€‹αž€αžΎαž“αž‘αžΎαž„β€‹αžαŸ’αž–αžŸαŸ‹β€‹αž—αŸ’αž›αžΆαž˜β€‹αŸ— αž”αž“αŸ’αž‘αžΆαž”αŸ‹β€‹αž–αžΈβ€‹αž‘αž·αž‰ (αž§αž‘αžΆαž αžšαžŽαŸ αž™αžΆαž“αž™αž“αŸ’αž αž€αž»αŸ†αž–αŸ’αž™αžΌαž‘αŸαžš) αŸ” αžŸαžΌαž˜β€‹αž…αŸ†αžŽαžΆαŸ†β€‹αžαžΆ αžαž˜αŸ’αž›αŸƒβ€‹αžŸαŸ€αžœαž—αŸ…β€‹αž“αžΉαž„β€‹αž˜αž·αž“β€‹αžŠαŸ‚αž›β€‹αžˆαžΆαž“β€‹αžŠαž›αŸ‹β€‹αžŸαžΌαž“αŸ’αž™β€‹β€‹αž‘αŸ αž“αŸ…β€‹αž€αŸ’αžšαŸ„αž˜β€‹αž”αŸ’αžšαž—αŸαž‘β€‹αž‚αžŽαž“αžΆβ€‹αž“αŸαŸ‡ αŸ”

Error codes:

5 αž€αžΆαžšβ€‹αž αŸ…β€‹αž”αŸ‚αž”αž”αž‘β€‹αž˜αž·αž“β€‹αžαŸ’αžšαžΉαž˜αžαŸ’αžšαžΌαžœ

Example:


Sub ExampleDDB
 Dim ddb_yr1 As Double
 ddb_yr1 = DDB(75000,1,60,12,2)
 Print ddb_yr1 ' returns 1,721.81 currency units.
End Sub

Please support us!