Financial functions(I)
 DB (cost;residual_value;life;period;month) function Returns the depreciation of an asset for a specified period, using the fixed salary declining balance method. Cost = is the initial value of the asset. Salvage = is the final value after the depreciation of the asset. Life = is the number of periods during which the depreciation of the asset takes place (also known as usefull life) Period = is the period over which you want the depreciation to be be calculated. Month = is the number of months in the first year, if these are not specified, they are assumed to be 12. example: We have bought a car for 20.000€, and we will suppose that in 5 years time the value of the car will be 9.000€. We want to know what the depreciation will be 6 months after buying it. If we introduce the data DB(20000;9000;5;1;6) it should give us the result 1.480€, that is, 6 months after buying it, the car will be worth 18.520€..   DDB (cost;salvage;life;period;factor) Function Returns the depreciation of an asset over a specific period, by way of the depreciation method for double balance reduction or another specified method. The double reduction depreciation method calculates the depreciation at a accelerated value. The depreciation is higher during the first period, and reduces over succesive periods. Cost = is the inicial asset value Salvage = is the value at the end of the depreciation (sometimes called the salvage value of the asset) Life = is the number of periods over which the asset is being depreciated (sometimes called the useful life of the asset). Period = is the period over which the depreciation is calculated. Factor = is the value at which the balance diminishes. If factor is omitted, it is assumed to be 2 (the method of depreciation by double balance reduction.   Example: We will continue with the example of the car. Therefore if we introduce the data DDB(20000;9000;5;1) it should give us the result of 8.000€, in the first year of the cars sale it will be worth 12.000€   VBD (cost;salvage;life;start_period;end_period;factor;no_switch) function Returns the depreciation of an asset for any period you specify, including partial periods, using the double-declining balance method or some other method you specify. VDB stands for variable declining balance. Cost = is the inicial asset value Salvage = is the final value of the asset after depreciation. Life = is the number of periods over which the asset is depreciated (sometimes called the useful life of the asset). Initial_period = is the starting period for which you want to calculate the depreciation Final_period = is the ending period for which you want to calculate the depreciation. Factor = If factor is omitted, it is assumed to be 2 (the double-declining balance method). Change factor if you do not want to use the double-declining balance method. For a description of the double-declining balance method, see DDB. No_Switch = is a logical value specifying whether to switch to straight-line depreciation when depreciation is greater than the declining balance calculation. If no_switch is TRUE, Microsoft Excel does not switch to straight-line depreciation even when the depreciation is greater than the declining balance calculation. If no_switch is FALSE or omitted, Excel switches to straight-line depreciation when depreciation is greater than the declining balance calculation.   Example: If we introduce the data VBD(5000;500;5*12;0;1) it should give us a result of 166.67€, that is, in the first month of the assets sale it is worth 4833.33€(166,67€ less than when it was bought).
 Continue to the next page...
 Legal warning: Authorised on-line use only. It is not allowed the use of these courses in companies or private teaching centres.