O'Reilly logo

Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours by Trudi Reisner

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Financial Functions

Financial functions are used for various financial calculations involving interest rates, loan terms, present values, and future values. Financial functions are essential for performing in-depth financial analysis of purchases, investments, and cash flow.

DDB

The DDB function calculates depreciation using the double declining balance method, which accelerates the rate of depreciation early in the life of an asset. When the asset's book value depreciates to the salvage value, depreciation stops.

The basic format for the DDB function looks like this:

DDB(cost,salvage,life,period,factor)

Enter values (cell references or constant values) for the initial cost, the salvage value, the life of the asset, and the period for which ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required