Printable tool

Equipment ownership cost calculator worksheet

Use this worksheet to compare equipment ownership, rental, and financing costs based on purchase price, resale value, utilization, maintenance, fuel, transport, and downtime risk.

Equipment snapshot

ItemNotes
Equipment typeExcavator / skid steer / loader / dozer / telehandler / other
New or used
Make, model, and year
Purchase price
Expected resale value
Planned ownership period
Expected annual hours
Rental alternative costDaily / weekly / monthly / hourly

Fixed ownership costs

Cost itemAnnual amountNotes
Depreciation or value lossPurchase price minus expected resale, spread over ownership period
Financing interest
Insurance
Taxes, registration, or fees
Storage or yard cost
Telematics or subscriptions
Annual inspections

Operating costs

Cost itemCost per hourNotes
Fuel or charging
DEF or fluids
Routine maintenanceFilters, grease, oil, service kits
Wear partsTires, tracks, teeth, cutting edges
RepairsUse a conservative reserve
AttachmentsPurchase, rental, or wear allocation
Operator laborIf comparing self-perform vs subcontract
Transport and mobilizationLowboy, trailer, permits, fuel

Hourly ownership estimate

StepFormulaYour number
Annual fixed costsAdd fixed ownership costs
Annual operating costsHourly operating cost x annual hours
Total annual costFixed + operating
Ownership cost per hourTotal annual cost / annual hours
Rental comparisonRental cost + delivery + fuel + attachments
Break-even annual hoursAnnual fixed costs / hourly savings versus rental

Utilization reality check

QuestionNotes
How many billable hours can this machine realistically work each year?
Are there seasonal gaps?
Can the machine serve multiple job types?
Will a dedicated attachment sit unused?
What happens during breakdowns?
Is transport capacity already available?
Who performs maintenance and keeps records?

Buy, rent, or finance decision notes

  • Buy when utilization is predictable, maintenance support is available, and the machine gives scheduling or margin advantages.
  • Rent when project needs vary, transport is difficult, or a specialized machine is needed for a short duration.
  • Finance only after modeling cash flow, insurance, repairs, and resale risk.
  • Compare used equipment savings against downtime, inspection findings, warranty gaps, and parts availability.
  • Keep tax depreciation separate from cash reality. Tax treatment can help, but it does not remove repair, fuel, transport, and downtime costs.

Red flags to slow down

  • The purchase only works if the machine has unrealistically high billable hours.
  • No repair reserve is included for used equipment.
  • Transport costs are ignored.
  • Financing terms are compared only by monthly payment.
  • Safety inspections, maintenance records, and operator training are treated as optional.
  • The machine is too large, too small, or too specialized for the actual job pipeline.

Related guides

Reference sources