Receive your group's fixed-asset scenario and understand the project goal
Your Group's Fixed-Asset Project Begins Now
In Lesson 07, everyone practiced with the same shared dataset. Today, each group receives its own fixed-asset scenario. Your workbook structure stays exactly the same — only the data and business context change.
Stays the Same
- Workbook sheet structure (4 sheets)
- Column fields and formula logic
- Book Value = Cost − Accumulated Depreciation
- Definition of Done criteria
- Recommendation format (claim, evidence, risk)
Changes for Your Group
- Your assigned fixed-asset dataset
- Business scenario and constraints
- Asset types, costs, and useful lives
- Your team's depreciation recommendation
- The numbers you cite as evidence
- Track long-term assets with accurate cost, life, and salvage data
- Choose depreciation methods that fit each asset class
- Build a trustworthy asset register that management can audit
- Defend your method choice with workbook evidence
- Open and rename the correct group workbook
- Verify all 4 sheets match the Lesson 07 structure
- Enter all assets on the Asset Register sheet
- Begin the Depreciation Schedule with linked formulas
Your teacher has assigned your group a number below. Download only your group's starter workbook. Do not use another group's data.
TechStart Café is opening two new locations. Each location needs commercial kitchen equipment, refrigeration, and modern POS systems.
Assets to Track:
- Espresso machines (3)
- Refrigerated display cases (2)
- Commercial oven (1)
- POS system upgrade
TechStart Logistics is building a regional delivery network. The fleet requires vehicles, warehouse equipment, and tracking technology.
Assets to Track:
- Delivery vans (4)
- Warehouse forklift (1)
- GPS tracking hardware
- Loading dock equipment
TechStart Labs is creating a prototyping facility. The lab needs precision manufacturing equipment, computing infrastructure, and testing instruments.
Assets to Track:
- 3D printers (2)
- Server rack and networking gear
- Testing equipment and oscilloscopes
- Workstation computers (6)
TechStart Health is equipping a new clinic. The facility requires diagnostic equipment, patient monitoring systems, and data infrastructure.
Assets to Track:
- Diagnostic imaging system (1)
- Patient monitoring stations (3)
- Sterilization autoclave (1)
- Electronic health record servers
TechStart Manufacturing is adding a production line. The facility needs precision machining, material handling, and quality assurance equipment.
Assets to Track:
- CNC machine (1)
- Conveyor belt system
- Quality control inspection station
- Industrial compressor and tools
Your workbook must have these four sheets in this exact order. The architecture is identical to the Lesson 07 rehearsal workbook.
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Sheet Name | Purpose | Key Columns / Fields | |||||||
| 2 | 1. Asset Register | List every asset with cost, life, salvage, and method | Asset ID, Description, Cost, Useful Life, Salvage Value, Method, Depreciable Base | |||||||
| 3 | 2. Depreciation Schedule | Annual depreciation, accumulated depreciation, and book value | Year, Beginning BV, Depreciation Expense, Accum. Depr., Ending BV, Check | |||||||
| 4 | 3. Method Comparison | Side-by-side comparison of two methods | Year, SL Total Expense, DDB Total Expense, SL Total BV, DDB Total BV, Difference | |||||||
| 5 | 4. Recommendation | Written claim, evidence, and risk statement | Claim, Evidence (cite 3+ numbers), Risk/Limitation, Final Recommendation | |||||||
| 6 | ||||||||||
| 7 | ||||||||||
| 8 | ||||||||||
| 9 | ||||||||||
| 10 |
- Receive and open your group workbook (5 min)
Download only your assigned file. Rename it:
Unit08-[GroupName]-Team[Letter]-M1.xlsx - Verify sheet structure (5 min)
Confirm all 4 sheets exist with correct names. Check that column headers match the Lesson 07 rehearsal model.
- Build the Asset Register (20 min)
Enter every asset from your group dataset. Fill in cost, useful life, salvage value, and assign a depreciation method (SL or DDB). Calculate the depreciable base for each row.
- Start the Depreciation Schedule (10 min)
Begin formulas for your first asset class. Link Beginning BV to Cost for Year 1. Set up the depreciation formula and the Book Value check column.
- Write one draft claim (5 min)
Based on your asset types, write one sentence: "We recommend [method] for [asset class] because [reason]."
- Teacher check-in (5 min)
Your teacher will verify your workbook against the Milestone 1 acceptance criteria below.
Your team must meet all of these before leaving class today:
- ☐Correct workbook opened and named — Your file matches your group assignment and follows the naming convention.
- ☐All 4 sheets present with correct structure — Asset Register, Depreciation Schedule, Method Comparison, Recommendation.
- ☐Asset Register has all assets entered — Every asset from your group dataset has cost, useful life, salvage value, and method assigned.
- ☐Depreciable base calculated for each asset — Depreciable Base = Cost − Salvage Value is correct on every row.
- ☐Depreciation Schedule started for at least one asset class — Year 1 formulas are linked and the Book Value check column is set up.
- ☐One draft claim written — A preliminary recommendation statement on the Recommendation sheet.
- Workbook saved with correct group name and version number
- File uploaded or submitted to your teacher's collection point
- Every team member can explain which assets they entered and why
- Team knows what must be complete by Lesson 09 (full depreciation schedule, method comparison, final recommendation)
This rubric will be used for the final project evaluation. Milestone 1 focuses on getting started correctly.
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Criteria | Weight | What We Look For | |||||||
| 2 | Asset Register Accuracy | 30% | All assets complete; formulas correct; book value verifies; no errors | |||||||
| 3 | Depreciation Method Application | 25% | Methods calculated correctly; comparison clear; statement impact explained | |||||||
| 4 | Recommendation Quality | 25% | Clear claim; strong evidence from workbook; thorough risk analysis | |||||||
| 5 | Professional Communication | 20% | Clear writing; professional formatting; confident presentation | |||||||
| 6 | ||||||||||
| 7 | ||||||||||
| 8 | ||||||||||
| 9 | ||||||||||
| 10 |
If your group's starter workbook is missing, corrupted, or won't open:
- Re-download your assigned file from the list above
- Check with your teacher if the file still won't open
- Rebuild from your notes using the Lesson 07 rehearsal workbook as a structural guide
- Do not use another group's dataset — your numbers will not match your scenario