VDB |
VDB(cost, salvage, life, start_period, end_period [,factor] [,no_switch]) |
Returns the depreciation of an asset in a single period (variable declining balance method). |
cost | The original cost of the asset. |
salvage | The value of the asset at the end of its life. |
life | The number of periods over which the asset is being depreciated. |
start_period | The first period in the calculation. |
end_period | The last period in the calculation. |
factor | (Optional) The rate at which the balance declines (2). |
no_switch | (Optional) A logical value indicating the type of declining balance to use: False (or 0) = straight-line is used when the depreciation is greater than the declining balance calculation (default) True (<> 0) = variable is always used |
REMARKS |
* For an illustrated example refer to the [[Depreciation]] page. * VDB stands for variable declining balance. * The "start_period", "end_period" and "life" must all use the same units and be positive. * If "factor" is left blank, then 2 is used. * If "factor" = 2, then the double declining balance method is used. * If "no_switch" is left blank, then False is used. * You can use the DB function to return the depreciation of an asset in a single period (declining balance method). * You can use the DDB function to return the depreciation of an asset in a single period (double or triple declining balance method). * You can use the SLN function to return the straight line depreciation of an asset for one period. * You can use the SYD function to return the depreciation of an asset using the sum of years method. * For the Microsoft documentation refer to support.microsoft.com * For the Google documentation refer to support.google.com |
|
1 - How much has my car depreciated in the first year if I bought it for £45,000 and its resale value after 4 years is £15,000 with a factor = 3. 2 - How much has my car depreciated in the first year if I bought it for £45,000 and its resale value after 4 years is £15,000 with a factor = 2. 3 - How much has my car depreciated in the first year if I bought it for £45,000 and its resale value after 4 years is £15,000. 4 - How much has my car depreciated in the first year if I bought it for £45,000 and its resale value after 4 years is £15,000 with a factor = 1.5. 5 - How much has my car depreciated in the first year if I bought it for £45,000 and its resale value after 4 years is £15,000 with a factor = 1. 6 - How much has my car depreciated in the first year if I bought it for £45,000 and its resale value after 4 years is £15,000 with a factor = 0.5. |
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top