Math for Business Operations

Applied Accounting with Excel

UNIT08 - Lesson 4

Double-Declining Balance and Method Comparison

45 minutes
Lesson Overview

Lesson Focus

Calculate DDB depreciation by hand and compare with straight-line

Key Unit Objectives

Enduring Understandings:

  • Long-term assets are tracked differently from everyday expenses because they provide value over multiple periods
  • Depreciation method choice affects reported profits, tax obligations, and asset book values over time
  • Professional asset tracking requires organized registers with cost, useful life, salvage value, and method documentation
  • The depreciation decision has real consequences for financial statement presentation and business decision-making

Lesson Activities

Activity 1: DDB Formula Introduction
12 minutes

Learn the double-declining balance method and its logic

Details:

  • DDB rate = 2 × (1 ÷ Useful Life)
  • Annual Depreciation = DDB rate × Beginning Book Value (not depreciable base)
  • Salvage value is a floor — depreciation stops when book value reaches salvage
  • Example: $10,000 asset, 4-year life → DDB rate = 50% → Year 1: $5,000 depreciation
Double-Declining Balance

An accelerated depreciation method that records more expense in early years

  • Higher depreciation expense in early years, lower in later years
  • Appropriate when assets lose value quickly (technology, vehicles)
  • Reduces taxable income more in early years (tax advantage)
  • Book value never drops below salvage value
Activity 2: DDB Schedule Build
15 minutes

Build a complete DDB depreciation schedule by hand

Details:

  • Same asset as straight-line practice for direct comparison
  • Calculate year-by-year depreciation using DDB formula
  • Watch for the salvage value floor in final years
  • Verify: Final book value = salvage value
Activity 3: Side-by-Side Method Comparison
13 minutes

Compare straight-line and DDB results for the same asset

Details:

  • Compare annual depreciation expense: SL is flat, DDB declines
  • Compare accumulated depreciation: DDB is higher in early years
  • Compare book value over time: DDB drops faster initially
  • Discuss: When would a business choose DDB over straight-line?
Activity 4: Preview Day 5
5 minutes

Set expectations for Excel asset register build

Details:

  • Tomorrow: Build asset register and depreciation schedule in Excel
  • We'll use SLN and DDB functions to automate calculations
  • Bring your hand-calculated schedules for verification
Required Materials
  • DDB formula card
  • Method comparison table
  • Business case scenarios
  • Sample asset data (same as Day 3)
Differentiation Strategies

For Struggling Students

  • • Scaffolded asset register with pre-filled asset descriptions
  • • Formula templates for depreciation calculations
  • • Step-by-step build guide with screenshots
  • • Peer mentoring partnerships with advanced students
  • • Reduced asset count while maintaining authentic business context

For Advanced Students

  • • Extension challenge: Add partial-year depreciation logic
  • • Compare three or more depreciation methods
  • • Leadership roles: Mentor teammates and facilitate peer critique
  • • Deep dive: Tax vs. book depreciation differences
  • • Research MACRS depreciation and its real-world application

For English Language Learners

  • • Depreciation terminology glossary with visual aids
  • • Key formulas explained in plain language with examples
  • • Recommendation templates with language scaffolding
  • • Visual depreciation schedule examples
  • • Partner with fluent English speakers for presentation preparation