Blog · Board and management reporting · Finance and FP&A teams
Compare fixed asset age, depreciation, book value, and capital spending by site. A worked register example shows the formulas, denominator choices, reconciliation, and the effect of one additional capital project.
Fixed asset management KPI examples turn an asset workbook into a comparison of recorded investment, depreciation, age, and capital spending by site. The useful measures show their denominators and distinguish assets already operating from projects still being built. They guide questions about replacement and investment; they do not prove physical condition.
The controller needs to know whether book values reconcile. Site managers need to know which assets require inspection or replacement planning. The capital committee needs to know where money is being committed and whether projects address maintenance, capacity, or another business need.
Start with the following small set. Broader financial KPIs and the general KPI examples cover company performance; these measures concentrate on the fixed asset workbook.
| KPI | Formula | Question it helps answer |
|---|---|---|
| Net book value | Recorded cost − Accumulated depreciation − Applicable impairment | How much carrying value remains? |
| Depreciated share | Accumulated depreciation / Depreciable recorded cost | How much recorded cost has been depreciated? |
| Cost-weighted age | Sum of recorded cost × Service age / Sum of recorded cost | How old is the recorded operating investment? |
| Capital spending / Depreciation | Period capital spending / Same-period book depreciation | How does investment spending compare with the accounting charge? |
The SBA's finance guidance identifies buildings, vehicles, and equipment as tangible business assets. Define your population before calculating: for the example below, depreciable equipment in service is one population, and construction in progress is a separate one. Land and lease assets are excluded.
Use an asset ID, site, asset class, in-service date, recorded cost, accumulated book depreciation, and year-to-date book depreciation. A project sheet supplies current-period capital spending by site and project status. Include disposal dates and asset transfers so the population can be reconciled.
Calculate service age as completed months in service divided by twelve. The example uses completed service months at September 30, 2026. This avoids silently substituting purchase date for the date an asset entered service.
The IRS depreciation guidance distinguishes the placed-in-service date from purchase or delivery and describes it in terms of readiness and availability for use. That source addresses tax depreciation. Keep your book depreciation and capitalization policy separately documented rather than adopting tax conventions for a financial reporting comparison.
Northline Packaging reviews its equipment at September 30, 2026. The simplified register groups identical assets into cohorts. There is no impairment in the example. Dollar amounts are USD, and accumulated depreciation is shown as a positive amount deducted from cost.
| Site and equipment cohort | Recorded cost (USD) | Accumulated depreciation (USD) | Service months | Age (years) | January–September depreciation (USD) |
|---|---|---|---|---|---|
| Ohio presses | 800,000 | 480,000 | 72 | 6.0 | 60,000 |
| Ohio conveyors | 400,000 | 120,000 | 36 | 3.0 | 30,000 |
| Texas trucks | 400,000 | 80,000 | 24 | 2.0 | 30,000 |
| Texas forklifts | 200,000 | 100,000 | 60 | 5.0 | 15,000 |
| Pennsylvania fittings | 100,000 | 100,000 | 60 | 5.0 | 15,000 |
| Pennsylvania packing equipment | 100,000 | 60,000 | 36 | 3.0 | 15,000 |
| Total | 2,000,000 | 940,000 | — | — | 165,000 |
Age is service months divided by twelve, not a total across rows. Pennsylvania fittings reached full depreciation by the reporting date but remain in service, so they stay in the population.
The project sheet contains capital spending on unfinished projects. None of this spending is in the operating equipment table yet, and none has started depreciation. Assume opening construction in progress was zero, all this spending was capitalized, and no projects were transferred into service during the period.
| Site | January–September project spending (USD) | Closing construction in progress (USD) |
|---|---|---|
| Ohio | 180,000 | 180,000 |
| Texas | 30,000 | 30,000 |
| Pennsylvania | 10,000 | 10,000 |
| Total | 220,000 | 220,000 |
Calling the spending out separately prevents unfinished projects from appearing as brand-new operating equipment in the age measure. It also makes clear that the spending ratio includes investment that has not yet produced an operating asset.
First aggregate costs, accumulated depreciation, and period depreciation by site. Calculate each ratio from those summed amounts. Ratios below are rounded to two decimal places, ages to one decimal place, and percentages to one decimal place; retain full precision until the final display.
| Site | Equipment book value (USD) | Depreciated share | Cost-weighted age (years) | Capital spending / Depreciation |
|---|---|---|---|---|
| Ohio | 600,000 | 50.0% | 5.0 | 2.00 |
| Texas | 420,000 | 30.0% | 3.0 | 0.67 |
| Pennsylvania | 40,000 | 80.0% | 4.0 | 0.33 |
| Company | 1,060,000 | 47.0% | 4.3 | 1.33 |
Ohio book value is $1,200,000 minus $600,000, or $600,000. Its depreciated share is $600,000 divided by $1,200,000, or 50.0%. Its spending ratio is $180,000 divided by $90,000, or 2.00.
The weighted age calculation needs its own visible proof:
| Site | Cost × Age calculation | Cost-years (USD-years) | Site cost (USD) | Weighted age (years) |
|---|---|---|---|---|
| Ohio | 800,000 × 6 + 400,000 × 3 | 6,000,000 | 1,200,000 | 5.0 |
| Texas | 400,000 × 2 + 200,000 × 5 | 1,800,000 | 600,000 | 3.0 |
| Pennsylvania | 100,000 × 5 + 100,000 × 3 | 800,000 | 200,000 | 4.0 |
| Company | Sum of cost-years / Sum of cost | 8,600,000 | 2,000,000 | 4.3 |
The company age is 8,600,000 USD-years divided by $2,000,000 of cost. Calculate the other company figures the same way: $940,000 divided by $2,000,000 gives 47.0%, and $220,000 divided by $165,000 gives 1.33. Do not average the displayed site ratios.
Operating equipment book value is $2,000,000 minus $940,000, or $1,060,000. Add the separately identified $220,000 construction in progress to reach total fixed asset book value of $1,280,000 for this defined scope. Tie both gross amounts and accumulated depreciation to the ledger; use the fixed asset dashboard for the complete movement layout.
Pennsylvania has the highest depreciated share but a lower weighted age than Ohio. That is possible because useful lives and asset mix differ. Ask for the applicable depreciation schedules and maintenance evidence before calling Pennsylvania the oldest or most urgent replacement site.
Ohio's higher spending ratio may reflect the unfinished expansion project rather than more replacement activity. The capital owner should label project purpose. Operations owns condition evidence; finance owns calculation consistency and the register reconciliation. Neither measure supplies the other's missing evidence.
For property operations, use the separate property asset management KPIs; the broader asset management KPIs page covers that neighboring search without changing this equipment population.
Suppose Pennsylvania adds $60,000 of capitalized project spending before the same reporting cutoff. The project remains unfinished. No operating equipment balances, service ages, or depreciation change.
| Measure | Original | Revised | Calculation |
|---|---|---|---|
| Pennsylvania spending (USD) | 10,000 | 70,000 | 10,000 + 60,000 |
| Pennsylvania spending / Depreciation | 0.33 | 2.33 | 70,000 / 30,000 |
| Company spending (USD) | 220,000 | 280,000 | 220,000 + 60,000 |
| Company spending / Depreciation | 1.33 | 1.70 | 280,000 / 165,000 |
The investment ratio rises immediately while the equipment age and depreciated share stay unchanged. That is the intended result: spending on an unfinished project does not make existing equipment younger.
Bring your asset register and capital spending workbook; Covirage maps the columns, and its tools compute and check depreciation, book values, weighted ages, and spending comparisons. The external AI model explains the results with every figure traced to its rows. Create a free Covirage account, set up your business, and bring a sample of your own asset records.
Use age from the in-service date, then summarize it with a clearly defined weighting method. Cost-weighted age gives larger recorded investments more influence. It remains an accounting population measure, so review maintenance history and physical condition before drawing replacement conclusions.
It is a comparison of investment spending with an accounting expense, not a direct replacement rate. Spending may fund expansion, construction, or higher replacement prices. Depreciation depends on recorded cost and accounting estimates. Review project purpose and asset condition alongside the ratio.
Keep fully depreciated assets that remain in service when measuring the operating asset base. Removing them would make age and accumulated depreciation measures look artificially lower. Exclude assets only under a documented scope rule, and reconcile exclusions back to the complete register.