A Statistical Analysis and Model of the Residual Value of Different Types of Heavy Construction Equipment

Residual value is defined as the price for which a used piece of equipment can be sold in the market at a particular time. It is an important element of the owning costs of equipment and needs to be estimated by equipment managers for making investment decisions.The purpose of this study is to gain insights into the residual value of selected groups of heavy construction equipment and to develop a mathematical model for its prediction. Auction sales data were collected from two online databases. Manufacturer publications and an online source provided size parameters and manufacturers suggested retail prices matching the auction records. Macroeconomic indicator values were collected from a variety of sources, including government agencies. The data were brought into the same electronic format and were matched by model name and calendar date, respectively.Data from auctions in the U.S. and in Canada were considered for this study. Equipment from four principal manufacturers of up to 15 years of age at the time of sale was included. A total of 35,542 entries were grouped into 11 different equipment types and 28 categories by size as measured by horse power, standard operating weight, or bucket volume. Equipment types considered were track and wheel excavators, wheel and track loaders, backhoe loaders, integrated toolcarriers, rigid frame and articulated trucks, track dozers, motor graders, and wheel tractor scrapers.Multiple linear regression analyses of the 28 datasets were carried out after outliers had been deleted. Explanatory variables for the regression model were age in years, the indicator variables manufacturer, condition rating, and geographic region, and selected macroeconomic indicators. The response variable was residual value percent, defined as auction price divided by manufacturers suggested retail price. Different first, second, and third-order polynomial models and exponential and logarithmic models of age were examined. A second-order polynomial was selected from these functional forms based on the adjusted coefficient of determination. Coefficients for the 28 models and related statistics were tabulated. A spreadsheet tool incorporating the final regression model and its coefficients was developed. It allows performing the residual value prediction in an interactive and intuitive manner.