Lesson ProgressPhase 2 of 6
Phase 2Introduction
Introduction: Project Rehearsal: Depreciation Workbook with Shared Data

Orient to the shared workbook, name each sheet and evidence block, define success

📋 Phase 2: Shared Artifact Orientation
Your Shared Rehearsal Workbook

Download the shared rehearsal workbook now. Every group in the class uses this exact same file and dataset today. The numbers belong to TechStart Solutions — Sarah's company as it expands and buys long-term assets.

Download:

unit08-rehearsal-workbook.xlsx

This is the teacher-controlled dataset. Save a copy with your group name so you can annotate it during today's rehearsal.

Workbook Map — What Each Sheet Proves

Each sheet has a specific job in the evidence chain. Know what each one proves.

1. Asset Register

Proves: What assets the company owns, what each cost, and how each is classified. This is the source of truth. Every depreciation calculation traces back to entries here.

Key fields: Asset name, cost, useful life, salvage value, depreciation method, purchase date.

2. Depreciation Schedule

Proves: How each asset loses value year by year. Shows annual depreciation expense, accumulated depreciation, and ending book value for every year of each asset's life.

Key check: Book Value = Cost − Accumulated Depreciation must hold every year.

3. Method Comparison

Proves: How different methods (straight-line vs. DDB) change expense timing and book value. This sheet supports the method-choice recommendation.

Key output: side-by-side totals showing which method front-loads expense.

4. Recommendation

Proves: Your team's depreciation policy decision with claim, evidence from the workbook, and risk/limitation analysis. This is the final deliverable.

Key rule: Every number in the recommendation must cite a specific workbook cell or sheet.

What Success Looks Like Today
  • Shared workbook is open and saved with your group name
  • You can name all four sheets and explain what each one proves
  • You can trace one recommendation number back to the asset register
  • You understand the Definition of Done checklist
Vocabulary and Structure Check

Confirm you know the workbook structure before moving to the audit.

Workbook Structure Check
Quick check on sheet names and their roles in the evidence chain

1. Which sheet lists each asset with cost, useful life, salvage value, and depreciation method?

2. Which sheet shows annual depreciation expense, accumulated depreciation, and book value over time?

3. What is the purpose of the Method Comparison sheet?

0 of 3 questions answered