Lesson ProgressPhase 1 of 6
Phase 1Hook
Hook: Complete Workbook and Depreciation Recommendation

Recap Lesson 08 progress and understand Milestone 2 requirements

Lesson 09 — Complete Workbook & Recommendation

Finish Your Asset Register, Compare Methods, and Finalize Your Recommendation

In Lesson 08, your team set up the workbook and entered the asset register. Today, you will finish the depreciation schedule, complete the method comparison, write a final evidence‑based recommendation, and get peer feedback before Lesson 10 presentations.

What You Will Accomplish Today

Workbook Completion

  • Finish Depreciation Schedule for all assets
  • Complete Method Comparison sheet (SL vs. DDB)
  • Verify all Book Value check columns pass
  • Ensure formulas link correctly across sheets

Recommendation & Feedback

  • Write final recommendation (claim + 3+ evidence numbers)
  • Include one honest risk/limitation
  • Exchange peer critique with another team
  • Revise workbook and recommendation based on feedback
Business Objectives
  • Defend a depreciation policy that fits your group's assets
  • Show how your method choice impacts expenses and book value over time
  • Prove your workbook is trustworthy with check columns and linked formulas
  • Use peer feedback to strengthen your analysis before presentations
Workbook Objectives
  • Complete Depreciation Schedule for all asset classes
  • Build Method Comparison sheet with side-by-side totals
  • Verify Book Value = Cost − Accumulated Depreciation on every row
  • Finalize Recommendation sheet with cited workbook numbers
Workbook Structure — Same as Lesson 07 & 08

Do not rename sheets or change the column order. Your workbook must still have these four sheets in this exact order.

ABCDEFGHIJ
1Sheet NamePurposeKey Columns / Fields
21. Asset RegisterList every asset with cost, life, salvage, and methodAsset ID, Description, Cost, Useful Life, Salvage Value, Method, Depreciable Base
32. Depreciation ScheduleAnnual depreciation, accumulated depreciation, and book valueYear, Beginning BV, Depreciation Expense, Accum. Depr., Ending BV, Check
43. Method ComparisonSide-by-side comparison of two methodsYear, SL Total Expense, DDB Total Expense, SL Total BV, DDB Total BV, Difference
54. RecommendationWritten claim, evidence, and risk statementClaim, Evidence (cite 3+ numbers), Risk/Limitation, Final Recommendation
6
7
8
9
10
Workflow Today (50 min)
  1. Open and verify your Lesson 08 workbook (5 min)

    Make sure your file is saved correctly: Unit08-[GroupName]-Team[Letter]-M1.xlsx. Confirm Asset Register is complete.

  2. Finish Depreciation Schedule (15 min)

    Extend the schedule for all asset classes. Link Year 1 Beginning BV to Asset Register Cost. Verify the Book Value check column says "OK" for every row.

  3. Complete Method Comparison (10 min)

    Calculate total annual depreciation expense and total book value for both methods side by side. Highlight the year where DDB crosses over to straight-line if applicable.

  4. Write final recommendation (10 min)

    Use the structure below. Cite at least three specific workbook cells/numbers. Include one risk and explain why your choice still makes sense.

  5. Peer critique and revision (7 min)

    Exchange workbooks with one other team. Use the peer critique table below. Give one strength and one improvement suggestion for each category.

  6. Teacher check-in (3 min)

    Your teacher will verify your workbook and recommendation against the Milestone 2 acceptance criteria below.

Recommendation Structure — Use This Exact Format

Your recommendation must follow this four-part structure. Every number you cite must come directly from your workbook.

ABCDEFGHIJ
1SectionRequirementExample
2ClaimOne clear, specific depreciation policy recommendationWe recommend straight-line depreciation for all kitchen equipment and double-declining balance for POS systems.
3EvidenceAt least 3 cited numbers from your workbookBy Year 3, straight-line gives us $18,500 in accumulated depreciation for espresso machines (Cell D12), while DDB gives $24,800 (Cell H12). Our total book value for all assets in Year 5 is $42,300 with SL (Cell F28).
4Risk/LimitationOne honest downside of your recommendationThe downside is that DDB will lower our net income in the first two years, which could make initial profit reports look weaker to investors.
5Final RecommendationWhy your choice still makes sense despite the riskEven with lower early profits, we recommend this mix because it matches how our assets actually lose value: kitchen equipment holds value steadily, while POS technology becomes obsolete quickly.
6
7
8
9
10
Peer Critique Guide — Give Specific, Kind, and Helpful Feedback

When reviewing another team's work, name one clear strength and one concrete improvement suggestion for each category below. Do not just say "good job" or "fix this" — be specific!

ABCDEFGHIJ
1CategoryStrength to NameImprovement to Suggest
2Workbook AccuracyOne formula or calculation that is clearly correctOne row or sheet where the Book Value check might be wrong
3Evidence ChainOne place where numbers connect from register to scheduleOne place where a formula link is missing or unclear
4Recommendation ClarityOne sentence that is specific and easy to understandOne claim that needs more cited numbers to feel convincing
5
6
7
8
9
10

Peer Feedback Rules

  • Start with a strength before suggesting improvements
  • Point to specific cells or sentences, not vague feelings
  • Ask questions if something is confusing ("How did you calculate this number?")
  • After receiving feedback, your team must make at least one visible revision
Milestone 2 Acceptance Criteria

Your team must meet all of these before leaving class today:

  • Depreciation Schedule complete for all assets — Every asset has annual depreciation, accumulated depreciation, and ending book value calculated for all years.
  • Book Value check column passes for every row — Every "Check" cell confirms Book Value = Cost − Accumulated Depreciation (or Beginning BV − Depreciation + ...).
  • Method Comparison sheet complete — Side-by-side totals for SL and DDB depreciation expense and book value each year.
  • Final recommendation written with 3+ cited numbers — Claim, evidence (3+ numbers from specific cells), risk/limitation, and final justification.
  • Peer critique completed and at least one revision made — You have given feedback to another team and revised your own work based on the feedback you received.
End-of-Class Checklist
  • Workbook saved with updated version number: Unit08-[GroupName]-Team[Letter]-M2.xlsx
  • File uploaded or submitted to your teacher's collection point
  • Every team member can explain the recommendation and cite at least one supporting number
  • Team knows what must be ready for Lesson 10: final workbook polish and presentation notes
Project Rubric Preview

This rubric will be used for your final Lesson 10 presentation. Milestone 2 focuses on workbook completion and recommendation quality.

ABCDEFGHIJ
1CriteriaWeightWhat We Look For
2Asset Register Accuracy30%All assets complete; formulas correct; book value verifies; no errors
3Depreciation Method Application25%Methods calculated correctly; comparison clear; statement impact explained
4Recommendation Quality25%Clear claim; strong evidence from workbook; thorough risk analysis
5Professional Communication20%Clear writing; professional formatting; confident presentation
6
7
8
9
10
Reflection
Lesson 09 Completion Reflection
Reflect on your learning journey and growth in the CAP framework
0/3 Complete
UNDERSTANDING
What is the strongest part of your team's recommendation? Which three numbers are you most proud of citing, and why?
0 characters
TRANSFER
What was the most helpful feedback you received from peers? What revision did you make, and how did it improve your work?
0 characters
APPLICATION
What does your team need to polish or prepare for Lesson 10 presentations? Who is responsible for what?
0 characters
Progress: 0/3 reflections completed