Lesson ProgressPhase 3 of 6
Phase 3Guided Practice
Guided Practice: Build Asset Register and Depreciation Schedule
Rehearse depreciation schedule logic in a safe simulator before touching Excel
Safe Rehearsal: Depreciation Schedule Logic
Practice Before You BuildBefore you open Excel, practice the depreciation schedule logic here. The simulator below lets you pick an asset from TechStart's register, predict its depreciation by hand, and then see the full schedule.
This mirrors exactly what you will build in Phase 4. If you can predict the schedule correctly here, you know the logic is ready for Excel.
What You Are Practicing
- Depreciable base: Cost minus salvage value
- Annual expense (SL): Depreciable base divided by useful life
- Accumulated depreciation: Running total of annual expenses
- Book value: Cost minus accumulated depreciation
- Check: Does book value equal cost minus accumulated depreciation?
Step 1: Choose an Asset
Pick an asset from TechStart's register. You will predict its depreciation schedule before building it in Excel.
Asset Details
A-001
$30,000
5 years
$5,000
Straight-Line
Step 2: Predict Before You Build
Calculate by hand. Enter your answers below. Do not use a calculator yet — think through the logic.
Bridge to Phase 4: Build in Excel
You have practiced the logic. Now you will build it for real.
In Phase 4, open the Asset Register Starter Workbook and build both sheets: the asset register with all required fields, and the depreciation schedule with linked formulas. The layout will match the reference previews you saw in Phase 2.