Build Asset Register and Depreciation Schedule
Students move from manual depreciation calculations to a professional Excel asset register and depreciation schedule. This workbook becomes the evidence base for all future depreciation decisions and the group project.
- ▶Build a professional asset register with all required fields in Excel
- ▶Create a linked depreciation schedule that calculates annual expense, accumulated depreciation, and book value
- ▶Add workbook checks so accumulated depreciation and book value stay believable
- ▶Explain how the asset register connects to the income statement and balance sheet
This lesson follows a structured 6-phase learning model designed for authentic project-based learning.
Hook
Sarah needs an investor-ready asset register before the board meeting — fragile lists won't work
Introduction
Anatomy of the asset register and depreciation schedule: sheets, columns, formulas, and common traps
Guided Practice
Rehearse depreciation schedule logic in a safe simulator before touching Excel
Independent Practice
Build the real asset register and depreciation schedule workbook with verification checkpoints
Assessment
Technical check on workbook logic and a short artifact task defending the register's trustworthiness
Closing
Reflect on what the workbook added, name what you can now do faster, and preview method comparison