Monday, June 19, 2017

Developing a Pricing Model for a Late Model Vehicle - A Nissan Altima Case Study

Developing a Pricing Model for a Late Model Vehicle 

-- 2014 Nissan Altima Case Study --

Altima has been Nissan’s bread and butter mid-size sedan for over a decade, competing with other popular mid-size brands like Toyota Camry, Honda Accord, Hyundai Sonata, Chevrolet Malibu, Ford Fusion, and a host of others. Nissan sold a record 335K in combined Altima brands in 2014, rising from a mere 203K at the bottom of the last recession in 2009. 

The 2014 Altima came in two primary engine configurations: 2.5L I4 16V and 3.5L V6 24V, with the SL Trim topping both lines. While the 3.5 SL represented the hallmark of luxury for Altima with V6 engine, moonroof, upgraded Bose audio, leather interior and a luxury power pack, the 2.5 complex (2.5, 2.5 S, 2.5 SV & 2.5 SL) collectively led the overall production and sales volume. Of course, the moonroof, Bose audio and leather were available as factory options for the 2.5 SL as well.

The modeling sample, therefore, comprises of the 2.5 and 3.5 SLs only.


Modeling Step 1 (Correlation Matrix)



As indicated before, the correlation matrix sets the table for modeling. As expected, the Dealer Price (abbreviated here as Dealer Pr) has the highest (negative) correlation with Miles, signifying that the higher miles generally dampen the dealers’ asking prices in the market.

Though Warranty is the next best predictive variable, it’s extremely high collinearity with Miles (-0.8792) makes it an insignificant variable, leaving the latter to solely represent the entire mile-related complex. As all warranties are primarily tied to the mileage (and secondarily to the number of years/months), their collinearity is observably inseparable. For instance, the original factory warranty covered the car bumper to bumper for 3-years/36,000 miles, Power-train warranty covered engine and transmission for 5-years/60,000 miles, and the factory Certified (for the pre-owned vehicles) warranty extended the Power-train to 7-years/100,000 miles.    

The Trim variable demonstrates the third highest predictive relationship with the dependent variable. Though Trim has a high collinearity with the Moonroof variable, the latter would still be tried in the model considering the limited pool of independent variables.

Unlike the older and mid-age models, Service history (Service) is usually an important consideration in purchasing late model vehicles as buyers are forced to pay up to 70% of the original MSRP for the well-maintained ones. Service is therefore a new variable which shows significant predictive promise, though somewhat correlated with Owner and Accident.

Accident is the other important predictive variable in the modeling queue, with low multi-collinearity, except for Service. Moonroof and the prior ownership (Owner) will be the other predictors in the MRA model. While prior ownership – particularly original ownership – is generally an important variable in predicting prices of the older and mid-age models, it is nonetheless much less significant for the late models as the vast majority of late model cars have single owners, thus making the variable more predictable and less disparate. The lack of distribution makes it significantly weaker.




The above scatter graph depicts the negative relationship between the Dealer Prices and Miles. Prices generally decrease commensurately with the increasing mileage. Of course, the fit would tighten with some outliers removed, thus paving the way for a higher R-square, perhaps up to a more customary level. 


Modeling Step 2 (Multiple Regression Analysis)



The model R-square – 0.976608347 – is reasonably high, with potential for even higher R-square if the model is rerun without the outliers.

The above MRA output confirms the negative contributory relationship between Miles and the dependent variable, meaning higher miles are negatively contributing to the predicted prices. Though the Miles coefficient is seemingly small, it will nonetheless have significant impact on cars with high mileage; for example, the predicted price of a 2014 with 70,000 miles will be reduced by -$3,221 (-0.04601892 * 70,000), as opposed to -$920 for a competing Altima with only 20,000 miles on it.

Accident, in sharp contrast to a lower correlation coefficient, stands out as the most important independent variable (highest t stat and lowest P-value) in the model followed by Trim and Miles. The reason Accident is so prominent in the model is that it provides the maximum price differentiation between the two groups of cars – accident-free vs. accident-encountered. Simply put, the future owners of near new cars are mostly risk-averse, negotiating significantly lower (discounted) prices for the cars that have encountered damages and accidents. Accidents, often resulting in physical damages, are not covered by the factory warranty which covers manufacturing faults only.

To interpret the other MRA model coefficients, the higher Trim model – 3.5 SL – is contributing more to the model estimate than the lower 2.5 SL Trim. Additionally, single ownership (Owner) and better serviced vehicles (Service) are preferred while Moonroof adds to the model estimate as well. Again, higher miles and accidents have recognizably negative impacts on model estimates.    


Modeling Step 3 (Analysis of Model Estimates)



The above percentile graph shows that the model estimates are significantly lower at the bottom end of the curve, zigzagging between the 25th and 50th percentile, and are confirming the dealer prices on the long end of the curve. The fact that the model has been predicting lower prices at the bottom end of the curve points to the above-the-market asking prices for the lower end units, perhaps those with accidents on record. On the other hand, this additionally proves that the model estimates could help both consumers and dealers to quickly converge on the same page as these estimates are independently derived. Likewise, the private sellers can validate their subject prices before accepting the trade-in values from the dealers.  




The model is predicting even higher (than the dealer) prices for the top-of-the-line 3.5 SL Trim, signifying that the market is ready to withstand higher prices for the more robust V6 engine with factory-installed power and cosmetic upgrades, even though the manufacturer sells a disproportionately higher volume of the lighter 2.5 SL version (assuming, of course, that the 2.5 SL’s 63% presence in this sample represents the actual rollout too). While the dealers are under-pricing the high-end low-volume 3.5 SLs, the model estimates are signaling the possible over-pricing of the 2.5 SLs.

The original average MSRPs for these two models were $27,920 and $30,820, respectively, pointing to ironic 56% and 49% decays in respective values.




Considering these are the late model cars without any significant exposure, the cars with reported damages/accidents comprise a low 13%.  While the Model is agreeing with the dealer pricing for the vehicles without any reported damages/accidents, the dealers are however way over-pricing their fleet of Altimas with the reported damages/accidents. Therefore, by having the model estimates placed alongside the dealer prices, consumers can save on average $4,549 (15,029 – 10,480), a truly wow savings and a great firewall protection from dealers’ over-pricing.




The major car rental companies usually start withdrawing their fleets as they approach 2 years and/or 30-40K miles, to avoid having to deal with questionable rentals. As of this writing (6/2017), only one major rental company had the 2014 inventory on sale (while others have been selling 2015 and 16) which is reflected in the sample. The above graphic shows the rental car sales are more aggressively priced than the competing dealer inventories. Even the model is showing an average savings of $1,500. Knowledgeable consumers are generally aware of this potential savings and use them as direct comps while negotiating with the dealers. Again, having the model estimates available side-by-side the dealer prices would protect average consumers and ease deal-making by eliminating all unnecessary price haggling back and forth.




The presage by the correlation matrix that a better serviced car is more likely to fetch a higher price is now emphatically confirmed by the model. The lesser maintained cars fetch bottom of the barrel prices. Of course, those cars tend to have higher miles (as shown above), disproportionately more accidents, lower order trims and sometimes multiple owners even during this short stint.




The above Miles table shows the price comparison by having miles broken down into two (equal) halves. Ceteris paribus, the lower mileage group is slightly over-priced, while the higher mileage group is appropriately priced. The lure of very low mileage vehicles (not shown here) is forcing consumers to pay an unwarranted premium which could be avoided if the model estimates were also published alongside the dealer prices.




The above table proves that the location arbitrage is virtually non-existent nationally, other than the fact that the West Coast market, though inadequately represented, is seriously overpriced. Of course, considering that West Coast is not the typical Altima country, this price imbalance could be temporary, resulting from (temporary) shortage of supplies.




The above graphic is suggesting why the Moonroof is such a highly sought after option. While it is standard in 3.5 SL sedans, it is an option for 2.5 SLs – needless to say, a worthwhile option indeed. The Model is predicting $3,000 lower value for the vehicles that are unequipped with Moonroofs.   




When the Model identifies the over-priced vehicles, it’s pointing to a silver-lining, uncovering “potential” savings. If the model estimates were to be reported alongside the dealer prices, buyers would immediately know the extent of those potential savings. The above data sample demonstrates that the dealers are way over-pricing the accident-free 2.5 SLs that are still under Full (3-year/36K miles bumper-to-bumper) factory warranty (e.g., SL # 1, 3, 7 and 9), followed by the factory Certified (7-year/100K Powertrain) units (e.g., SL # 8 and 10).




Alternatively, when the modeling process identifies the under-priced cars, it’s pointing to some “upfront” savings for the consumers. This is an area where dealers would be most benefitted if they were to subscribe to the model estimates. The above sample shows that the dealers are generally under-pricing the good (accident-free and under warranty) 3.5 SLs. Again, the above under-priced sample proves the accuracy of the model. As indicated in the previous chapter, now and then, the dealer prices could consciously be lower to factor in some minor negatives (not captured in the modeling database) or to address some imminent psychological breakpoints. SL # 8 could be one such psychological case where the dealer might have consciously lowered the price as the vehicle is on the verge of running out of the 60K Powertrain warranty.

Considering the ever-escalating popularity of the Nissan Altima brand, the 2014 model has been one of the most sought after mid-size late models on the market today.

COPYRIGHTED MATERIAL

Click on the Link below for the Book on Amazon (Kindle or Paperback)


No comments:

Post a Comment

A "Quick Look" Auto Valuation Site must be Mobile-friendly, Working as an App as well

How Mobile-friendly JustAutoValue.com   Looks and Works as an App on iPhone http://www.justautovalue.com/ Most Websites are ...