Select a different account.

DDB ( 成本、残值、生命周期、期间 [， 因素])

DDB函数语法具有以下参数：

 参数 说明 成本 必需。 Double 指定资产的初始成本。 salvage 必需。 在 资产使用寿命结束时双击指定资产的值。 life 必需。 Double 指定资产的有用生命周期长度。 period 必需。 计算 资产折旧的双倍指定周期。 factor 可选。 变量指定余额下降的速率。 如果省略，则 (双倍) 2。

DDB函数使用以下公式计算给定时段的折旧值：

## 示例

`Dim Fmt, InitCost, SalvageVal, MonthLife, LifeTime, DepYear, DeprConst YRMOS = 12 ' Number of months in a year.Fmt = "###,##0.00"InitCost = InputBox("What's the initial cost of the asset?")SalvageVal = InputBox("Enter the asset's value at end of its life.")MonthLife = InputBox("What's the asset's useful life in months?")Do While MonthLife < YRMOS ' Ensure period is >= 1 year. MsgBox "Asset life must be a year or more." MonthLife = InputBox("What's the asset's useful life in months?")LoopLifeTime = MonthLife / YRMOS ' Convert months to years.If LifeTime <> Int(MonthLife / YRMOS) Then LifeTime = Int(LifeTime + 1) ' Round up to nearest year.End If DepYear = CInt(InputBox("Enter year for depreciation calculation."))Do While DepYear < 1 Or DepYear > LifeTime MsgBox "You must enter at least 1 but not more than " & LifeTime DepYear = InputBox("Enter year for depreciation calculation.")LoopDepr = DDB(InitCost, SalvageVal, LifeTime, DepYear)MsgBox "The depreciation for year " & DepYear & " is " & _Format(Depr, Fmt) & "."`

×