Reflect on what the workbook added, name what you can now do faster, and preview method comparison
You built a professional asset register and depreciation schedule in Excel. Your workbook calculates annual expense, tracks accumulated depreciation, and verifies book value automatically. When cost or useful life changes, everything updates.
Key Takeaways
- One source of truth: The asset register stores each asset's details once
- Linked formulas: The schedule references the register, so changes flow through
- Book value logic: Book Value = Cost − Accumulated Depreciation, every row
- Verification checks: The check column flags errors before they reach investors
- Professional standards: No hard-coded numbers in formula cells
What Comes Next: Lesson 06
In Lesson 06, you will extend this workbook to compare depreciation methods side by side. You will add a method comparison section that shows straight-line vs. double-declining balance for the same assets, calculate the income statement and balance sheet impact of each method, and write a short defense of which method TechStart should use. Your asset register from today becomes the foundation for that comparison.