cells within cell means what

[ramminani]

what is the meaning of this DB(DB12,DI12,DJ12,$FN$11) ??? they all are cell names

can any one help???

[sandy666]

Excel DB function:


Description

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

Syntax

DB(cost, salvage, life, period, [month])

The DB function syntax has the following arguments:

## Cost Required. The initial cost of the asset.
## Salvage Required. The value at the end of the depreciation (sometimes called the salvage value of the asset).
## Life Required. The number of periods over which the asset is being depreciated (sometimes called the useful life of the asset).
## Period Required. The period for which you want to calculate the depreciation. Period must use the same units as life.
## Month Optional. The number of months in the first year. If month is omitted, it is assumed to be 12.

Remarks

##The fixed-declining balance method computes depreciation at a fixed rate. DB uses the following formulas to calculate depreciation for a period:
(cost - total depreciation from prior periods) * rate

where:

rate = 1 - ((salvage / cost) ^ (1 / life)), rounded to three decimal places

##Depreciation for the first and last periods is a special case. For the first period, DB uses this formula:
cost * rate * month / 12

##For the last period, DB uses this formula:

((cost - total depreciation from prior periods) * rate * (12 - month)) / 12

is that what you want?

[ramminani]

can u tell me the logic within that Db function .... actually i'm a s/w eng that i have to convert this logic in asp.net...

can u help me please... it is so helpful for me

[ramminani]

can u tell me the logic within that Db function .... actually i'm a s/w eng that i have to convert this logic in asp.net...

can u help me please... it is so helpful for me

[sandy666]

DB(cost,salvage,life,period,month)

The distinguishing feature of fixed-declining balance depreciation is that it calculates depreciation at a fixed rate based on the estimated cost, salvage value, and economic life of the asset. Excel calculates this rate using the following formula:

Fixed rate=1-((salvage/cost)^(1/life))

and then rounds this value to the nearest three decimal places. To calculate the depreciation for a period, Excel multiplies the rate by the sum of the original cost less the accumulated depreciation to date. The accumulated depreciation equals the original cost minus the previous periods’ depreciation.

Excel uses variations of the standard fixed-declining balance formula for the first and last periods. For the first period, Excel calculates the depreciation by using the following formula:

First-period depreciation=cost * rate * month / 12

For the last period, Excel calculates the depreciation using the following formula (which essentially just depreciates the asset down to its salvage value):

Last-period depreciation=((cost?accumulated depreciation)*rate*(12month))/12

that's all what I can do for you, I'm excel user not researcher

[ramminani]

thanks a lot for ur help... ur information is so valuable for me..... thanks again sandy

[sandy666]

If you found this answer helpful mark thread as solved, pls