A case study in the use of regression to identify demand drivers

IDENTIFICATION OF DEMAND DRIVERS

nwa

One of the stakeholders of NWA wanted to have a better understanding and identification of demand drivers and dynamics of the commercial aviation industry. They were concerned that the company would need a restructuring, and also wanted a comparison of NWA to the industry as a whole.

We constructed an industry composite income statement starting with 1979, the year the industry was deregulated. Included in our statistical analysis was the operating data for every airline that existed in that particular year, many of which were then out of business, acquired, or new startups. We started by using (i) a correlation matrix to identify possible cause-effect relationships (ii) plotting techniques, and (iii) multi-variate regression1, to demystify this industry’s performance2.

We applied multivariate regression and used the industry profitability we calculated as our defendant variable, and various economic metrics as our independent variables. We also included a binomial to account for economic shocks such as wars, etc. We obtained a surprisingly high R2 of .95, meaning that our model accounted for 95% of the earnings variability in the airline industry over the time period studied.

Capital Raising During a Crisis Mergers and Acquisitions

Identification of demand drivers for commercial aviation

– Identification of demand drivers: demand for air travel is driven by individual travel, highly correlated with Consumer Confidence. But we showed that it is last year’s GDP that matters: companies set travel budget a year in advance.

Our best regression model used GDP (lagged one year3, Consumer Confidence, and a binomial entered in for the years with wars or other Black Swan events to estimate the adverse effect on margins of shocks. This model accounted for 95% of all variance in industry operating margins. Redacting the coefficients for theindependent variables, the model was: Industry Operating Margin= (Coefficient 1)(GDP lagged) + (Coefficient 2)(Consumer Confidence) – (Coefficient 3)(Shock) – .0695)

This model exhibited extremely small error in each year, less than 0.5 margin points, with the exception of one particular year4. Due to the extremely good fit of the model (and strong statistical measures) we were comfortable in opining that this model fairly represented the dependence of the airline industry’s profitability on 1) the strength of the economy 2) the mood of consumers and 3) the impact of extraordinary events.

Our conclusions, based upon our findings, were:

1) It is possible to identify the demand drivers of the airline industry. It is volatile and unpredictable, but understandable. This has implications for leverage for the players in this space, and the importance of prudence. Our regression on the airline industry indicates quite clearly that the current operating performance is consistent with the Industry’s ever-present dependence on (and vulnerability to) changes in real GDP, Consumer Confidence, and extraordinary events.
2) The adverse effect, on the industry, as a whole of adverse events which create a “fear to fly’. Our regression coefficient suggested at the time that an average 2.4 point decrease in operating margin were result of wars and other Black Swan events.
3) The profitability of the U.S. airline industry will recover as GDP and Consumer Confidence recover, assuming the absence of any extraordinary shocks to the industry, ceteris paribus.
4) A separate regression analysis concluded that 80% of NWA’s profitability was driven by its industry, and 20% was unique, likely its dominance of the Minneapolis hub and its Pacific routes. We concluded that NWA enjoyed about a 20 basis point advantage in operating margins over its industry.

Footnotes

1 For readers who are not familiar or comfortable with multi-variate regression, we offer the following analogy. Fuel efficiency of an automobile is affected by both the horsepower of the engine and the weight of the car. However, engine horsepower and car weight are related. In many cases, horsepower and car weight carry much of the same information, and fuel efficiency can largely be predicted using one or the other. A “radar” chart would reveal such a relationship, and would better predict fuel efficiency than either variable used alone. Regression is a statistical method which calculates an algebraic equation which best explains observed relationships. It is, in essence, a radar chart taken much further.

2 After conducting this work (1992), we found a study by Robert Decker of Duff & Phelps, which also used regression analysis. We discussed our work and findings with him. Mr. Decker did not examine Consumer Confidence, nor did he attempt to look at the industry as a whole. He did study GDP and found that it is 97% correlated to Manufacturing and Trade Sales.

3 Businesses set travel budgets based upon last year’s profitability. This accounts for why GDP lagged a year correlated with this year’s business travel. Current consumer confidence drives holiday travel, and thus, current consumer confidence is the other demand driver.

4 We find this to be a very curious outcome; the year in question was the last year of the economic expansion. We posited the question, “was the consumer already pulling back on discretionary expenses in that year, in spite of all indicators?”. Robert Decker at Duff & Phelps would likely agree. His opinion was that airline profitability can sometimes predict GNP. This logic has an appeal. If consumers pull back on discretionary purchases, the economy will suffer.

5This case study was subsequently cited (2012) in a pioneering Airbus funded PhD thesis: “How the consumer confidence index could increase air travel demand forecast accuracy” (2012), p176.Teyssier, Narjesse https://dspace.lib.cranfield.ac.uk/bitstream/1826/7907/1/Narjess_Teyssier_Thesis_2012.pdf


 

 

“Middle Market Investment Bank of the Year - USA” 2016 - Acquisition International

“Investment Banking Boutique of the Year - North America” - M&A Today

“Investment Banking Firm of the Year” 2015 - Finalist” - The M&A advisor

“Investment Banking Boutique of the Year” - 2014/15 - Acquisition International

“Best Aerospace-Defense Investment Bank – USA” 2015 - Acquisition International

“Best Boutique Investment Bank – USA” 2014 - Wealth & Finance Magazine                       

“Capital Raising Investment Bank of the Year - 2014” - Acquisition International Magazine              

“Investment Banking Boutique of the Year - 2013” - Acquisition Finance Magazine                     

“2013 Investment Banking Boutique of the Year - USA” - InterContinental Finance Magazine             

“Agribusiness M&A Advisor of the Year 2014 – USA” - Corporate Intl Magazine                              

“Transactional Intellectual Property Consultant of the Year” - Acquisition International Magazine