How to Calculate Asset Depreciation in Microsoft Excel Using the SLN, DB, and DDB Functions

Tracking the diminishing value of tangible capital assets—such as computer hardware, machinery, office furnishings, and company vehicles—is a cornerstone of corporate accounting and corporate tax planning. Microsoft Excel provides three dedicated financial functions to calculate depreciation schedules accurately: SLN (Straight-Line), DB (Fixed-Declining Balance), and DDB (Double-Declining Balance). Selecting the appropriate formula depends on whether an asset depreciates evenly across its lifetime or experiences heavy early-stage wear.

Overview of Excel Depreciation Functions

Each depreciation function corresponds to a recognized financial accounting methodology:

• SLN (Straight-Line Depreciation): Allocates an equal amount of depreciation expense to each period over the asset’s useful lifetime. This is the simplest and most widespread accounting method.
• DB (Fixed-Declining Balance): Calculates depreciation at a fixed percentage rate for each period using the asset’s remaining book value, factoring in tax-compliant partial periods.
• DDB (Double-Declining Balance): An accelerated depreciation method that doubles the straight-line rate, front-loading the heaviest deductions into the asset’s earliest operational years.

Syntax and Parameter Comparison

Understanding each function’s argument structure is crucial for constructing reusable accounting models:

Function	Formula Syntax	Key Arguments
SLN	=SLN(cost, salvage, life)	cost: Initial purchase price. salvage: Residual scrap value at end of life. life: Total periods of useful life.
DB	=DB(cost, salvage, life, period, [month])	period: Specific year/period to calculate. month: Number of months in the initial year (optional, default 12).
DDB	=DDB(cost, salvage, life, period, [factor])	period: The period to calculate. factor: Acceleration rate (optional, default 2 for double-declining).

Example 1: Straight-Line Depreciation with SLN

Suppose a company buys a server rack for £10,000, expects a salvage value of £1,000 after 5 years of service:

1. Set up your input cells:
   • Cell B1: 10000 (Initial Cost)
   • Cell B2: 1000 (Salvage Value)
   • Cell B3: 5 (Useful Life in years)
2. In cell B4, enter the formula:

   =SLN(B1, B2, B3)

3. Press Enter. The annual depreciation expense returns £1,800.00 ((10,000 - 1,000) / 5) for each of the five operational years.

Example 2: Accelerated Depreciation with DDB

High-tech electronics and heavy machinery often lose value far faster during their first two years. To calculate annual depreciation across each individual year using Double-Declining Balance:

1. List years 1 through 5 in cells A6:A10.
2. In cell B6 (Year 1), enter:

   =DDB($B$1, $B$2, $B$3, A6)

3. Drag the formula down through cell B10 (Year 5).
4. Observe the resulting accelerated schedule:
   • Year 1: £4,000.00 (40% of £10,000)
   • Year 2: £2,400.00 (40% of remaining £6,000 book value)
   • Year 3: £1,440.00 (40% of remaining £3,600)
   • Year 4: £864.00
   • Year 5: £296.00 (capped so ending book value equals the £1,000 salvage floor)

Example 3: Fixed-Declining Balance with DB

If your asset was placed into service mid-year (for example, in October, meaning only 3 months occurred in the initial tax year), supply the month argument to the DB function:

=DB($B$1, $B$2, $B$3, 1, 3)

Excel calculates the exact proportional rate for the initial 3 months, prorates the intervening full years, and concludes in a final 6th period to capture the remaining fractional months accurately.

Choosing the Right Depreciation Method for Your Worksheets

Straight-Line (SLN) provides steady, predictable deductions on financial statements, whereas accelerated methods (DB and DDB) reflect faster real-world asset deterioration and offer front-loaded tax shields. Leveraging Excel’s built-in formulas ensures that your balance sheets dynamically adjust whenever equipment purchase costs or lifespans change.