Make the register useful.
Bulldog’s CFO needs a clear view of replacement priorities, capital concentration, and asset history. Build each analysis in Excel, then choose the setup, result, and interpretation here.
- Download and save the student workbook. The Assets table contains all 150 records and prepared data fields.
- Select a cell in Assets, then Insert → PivotTable → From Table/Range. Use the Pivot Workspace or a new worksheet.
- Complete eight missions. Choose None for unused areas. Follow the requested orientation so layouts are comparable.
- Save your Excel analysis and download your answer record below.
Your data is already inside.
A formatted Excel table, real dates, numeric amounts, and ready-to-use data fields. The dataset stays the same every time you open the lab.
No copy/paste. No data import.
Use desktop Excel for the full PivotTable feature set.
What the supplied fields mean
Years Remaining is the unused portion of estimated useful life as of December 31, 2026, floored at zero. It is provided as a value. The replacement flag uses the unrounded number.
Annual SL Rate = (cost − salvage) / life. Provided as a value; it is a standard full-year rate, not current-year expense.
Cost Band is a $25,000 bracket’s lower bound. Buildings exclude land. All data is synthetic.
Explore records and report filters.
Drill through
This demonstration uses the same Heavy Equipment records as Excel. In Excel, double-click the numeric total to extract the source records.
One report for each group
Place Asset Group in Filters. In supported desktop versions, use PivotTable Analyze → Options → Show Report Filter Pages. There are six groups.
Grouping: dates and cost bands
Raw dates can be grouped into years or quarters. Q8 supplies Purchase Year to avoid date-grouping differences across versions. Q5 similarly supplies exact $25,000 bands. Original dates and costs remain in the data.
Preview the asset register
Eight decisions. One dataset.
Choose an answer, then check that mission. Hints explain the Excel steps. Choices save in this browser when local storage is available.
Save the evidence behind your answers.
Check your selections, save your Excel analyses, and download the answer record. This page does not submit files automatically. If assigned through Canvas, upload both files there.