This page has been archived and commenting is disabled.

Morgan Stanley Defends Retail Sales' Seasonal Adjustments From "Crazy Zero Hedge Analysis"; BAC Upgrades Netflix

Tyler Durden's picture




 

You heard our side of the story. It is only fair you hear the other side too.

From Morgan Stanley's chief economist, David Greenlaw:

There is some crazy analysis on Zero Hedge that seems to be getting some traction because a few clients have asked about it (see their chart below). 

 

 

Basically, ZH claims that a bias in the retail sales seasonal adjustment factor distorted the July results to the high side.  However, they are looking at the dollar adjustment for the level of sales in July alone.  Since the main focus in the retail sales report is on the percent change in seasonally adjusted monthly retail sales, the relevant comparison is the percent change in the seasonal adjustment factor between June and July.  Moreover, calendar effects matter.  For example, the Fourth of July holiday was midweek this year and there were only 4 shopping weekends in July 2012 -- one less than in July of the past few years.  The last time the July calendar was identical to 2012 was in 2007.  So, we show below a comparison of the monthly percent change in the seasonal adjustment factor for 2012, 2011 and 2007.  The bottom line is that seasonal adjustment factor for July 2012 added about 2 percentage points to the monthly change in retail sales -- essentially the same as in July 2007. 

 

 

Note:  a positive % ch for the SF subtracts from the NSA change and a negative % ch in the SF adds to the NSA change

* * *

And now you know the Morgan Stanley version of things.

What can we say? In X-12-ARIMA we trust:

A Basic Seasonal Adjustment Glossary

ARIMA models     These are a versatile family of models for modeling and forecasting time series data. Seasonal ARIMA models have a special form for efficiently modeling many kinds of seasonal time series and are heavily used in seasonal adjustment. ARIMA is an acronym for AutoRegressive Integrated Moving Average.

Flow series    Time series measuring consecutive changes over a unit of time, such as monthly sales or monthly cash flows, or monthly changes in any stock series.

Irregular component    This is the residual time series that results from the removal of estimated seasonal and other systematic calendar-related components of an observed time series, along with the removal of an estimated trend-cycle component.

Moving holiday effects    These are systematic changes in the values of a time series that are associated with the timing of moving holidays, i.e. holidays whose dates vary from year to year, such as Easter, Passover, Ramadan, Chinese New Year and U.S. Labor Day. Estimates of one or a combination of such effects define the moving holiday component of time series.

RegARIMA models (Also regression+ARIMA models.)    In the seasonal adjustment context, a hybrid model in which some features of the time series, such as moving holiday, trading day and outlier effects, are modeled with linear regression variables while the remaining features (those of the regression residuals, including trend, cycle and seasonal components) are modeled with a seasonal ARIMA model.

Seasonal adjustment    The estimation of the seasonal component and, when applicable, also trading day and moving holiday effects, followed by their removal from the time series. The goal is usually to produce series whose movements are easier to analyze over consecutive time intervals and to compare to the movements of other series in order to detect co-movements.

Seasonal component    A time series whose values quantify (usually in percents or in the units of data measurement, e.g. dollars) variations in the level of the observed series that recur with the same direction and a similar magnitude at time intervals of length one year. (Length is measured in the calendar units of the observed series--usually quarters or months, sometimes semesters, weeks, or other units.)

SEATS (Signal Extraction in ARIMA Time Series)    This approach is used within TRAMO-SEATS and also within the X-13A-S seasonal adjustment packages. It can simultaneously estimate the different components of a time series.

Stock series    For the unit of time of the series, months for example, these are time series like end-of-month inventories that arise as the cumulative sum of inflows and outflows (i.e. monthly net flows) starting from some initial value in the past.

Time series    A sequence of measurements of an economic (or other) variable made at approximately equally spaced times. It is important that the definition of the variable and the method used to measure it be consistent over time.

Trading day effects     As practical concerns, these are systematic effects in monthly times series related to changes in the day-of-week composition of each month and, in some cases, also to changes in the length of February. For flow series (monthly accumulations of daily activity e.g. monthly sales), the increases or decreases from average day-of-week activity associated with the days that occur five times in the month in a given year are important. (If they are days of high sales volumes, the monthly value will be inflated, etc.) For flow series, the length of February can have an impact. (More days than average should produce more sales than average for February.) For stock series, such as end-of-month inventories, the extent to which inventories tend to rise or fall on the day of measurement (e.g. the last day of the month) can have an impact that is different from year to year. Attempts to measure analogous effects in quarterly series are seldom successful. A series of estimated trading day effects defines a trading day component for the time series.

TRAMO (Time Series Regression with ARIMA noise)     This approach is used within TRAMO-SEATS seasonal adjustment sofware. It is an approach to estimate and prior correct time series before seasonal adjustment.

TRAMO-SEATS     Seasonal adjustment software developed by the Bank of Spain. It uses models to estimate the different time series components.

Trend-cycle component     This is an estimate of the local level of the time series that is expected to include the effects of moderately short- and well as long-term movements associated with the "business cycle". It is often obtained by applying a customized smoothing procedure (a data-dependent "trend filter") to the seasonally adjusted series to suppress its oscillatory movements over short time intervals, i.e. its higher frequency movements.

X-11     Seasonal adjustment software originally developed by United States Census Bureau. It is based on an iterative application of linear filters.

X-11-ARIMA     A Seasonal adjustment software developed by Statistics Canada. It incorporates ARIMA modelling to improve estimation of the different time series components.

X-12-ARIMA     A Seasonal adjustment software developed by the United States Census Bureau. It incorporates regression techniques and also ARIMA modelling to improve estimation of the different time series components.

X-13-ARIMA-SEATS (X-13A-S)     Seasonal adjustment software under development at the U. S. Census Bureau in collaboration with the Bank of Spain that integrates an enhanced version of X-12-ARIMA with an enhanced version of SEATS to provide both X-11 method seasonal adjustments and ARIMA model-based seasonal adjustments and diagnostic.

* * *

In other news, Bank of America just upgraded Netflix from Neutral to Buy with the following logic:

More potential upside than downside; maintaining $72 PO

 

We are maintaining our $72 price objective based on a sum-of-the-parts (SOP) analysis. Our SOP assigns a 20x multiple to the domestic streaming segment, a 6x multiple to the domestic DVD segment and gives no credit for the international streaming segment. As shown in Exhibit 2, we see a theoretical upside and downside case of $30 and $117 by using the lowest and highest multiples and contribution margins we believe are reasonable, respectively.

 

Bears have valid concerns…

 

Bears are primarily concerned about: 1) the likelihood that content prices will be increasing due to Netflix’s exclusive and original content emphasis, which could pressure the streaming bottom line; 2) international will likely suck up consolidated global profitability for years and this is too long to wait in a rapidly changing industry; 3) increasing competition both domestically and internationally; 4) unproven  longterm domestic streaming segment profitability; and 5) rapidly declining domestic DVD profit as the most profitable customers churn off the service.

 

…but Bull arguments more convincing to us

 

The bulls are mainly positive about: 1) continued international expansion being a drain on future profits but the right long-term strategic business decision; 2) Netflix becoming better at buying content and eliminating wasted spend as it analyzes audience viewership trends and historical data – likely increasing bottom line streaming profitability; 3) domestic earnings are becoming significant and Netflix can benefit from being the first mover in numerous international countries; and 4) at point of or beyond incremental domestic streaming segment profitability.

In other words, even the bulls admit the company will not make money, but at least it is the best thing they can hope to achieve. After all, who needs cash anyway. Just copy the AMZN model of ever lower gross profits resulting in an ever higher stock price as the former bookseller morphs into a bank-space station-precious metal miner-cloud gamer-retailers' retailer-[everything else you have never imagined].

 

- advertisements -

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.
Tue, 08/14/2012 - 16:10 | 2704910 unununium
unununium's picture

The MS "rebuttal" boils down to this:

We fucked you in June too, and you didn't notice then!

Major win for Zero Hedge.

Tue, 08/14/2012 - 16:16 | 2704917 NEOSERF
NEOSERF's picture

If Goldman is fleecing muppets, hard to imagine what MS clients should be called...sock puppets?

Tue, 08/14/2012 - 16:20 | 2704924 MachuPicchu
MachuPicchu's picture

At least also Muppets read ZH... !

Tue, 08/14/2012 - 16:39 | 2704975 canardo
canardo's picture

So, is this good or bad?

Tue, 08/14/2012 - 16:45 | 2704978 tedives
tedives's picture

I used X-11-ARIMA (X-12's predecessor) very extensively in the early 90's to analyze semiconductor market statistics (that market is notoriously volatile and closely watched).

Examining a percentage change from month to month in the seasonal adjustment factor itself, as Morgan Stanley talks about here, is IMO bizarre.  Who cares what the seasonal factor was last month, we're talking about *this* month (other than, if you take all the year's adjustment factors - 1.1, 1.2, .8, .8, and so on and add them together, they had better equal twelve - that's why it's called seasonality).

For instance, if the factor was relatively low last month (say .8), then if this month's factor is 1.0 (i.e. no boost or reduction), then looking at the change shows a difference that is hugely positive, when in reality there's essentially no adjustment for this month in that case.

The key is to take the seasonal adjustment factors for every month and subtract 1, and compare them, which I believe ZH did in the first place, and which I think is a reasonable way to look at it.

Yes, there are adjustments for holidays and all that, if someone were ambitious they could ask the issuing department "what settings did you use for X-12, what holidays did you have noted in there, and what was the exact input data", and the program is deterministic, it's freely available and anyone can run it, it should be easy to verify whether the output was fudged.

As to the inputs, maybe those were fudged, who knows - better to watch electricity, or boxcar loadings and unloadings perhaps, than these headline items, just like people have done with China for ages.

Just looking at the analysis ZH did, yes, it looks suspect to me.  Someone should ask John Williams though, he's the expert on such fudging.

Tue, 08/14/2012 - 17:06 | 2705026 onebir
onebir's picture

"The key is to take the seasonal adjustment factors for every month and subtract 1, and compare them, which I believe ZH did in the first place, and which I think is a reasonable way to look at it."

That makes sense if you're interested in monthly levels. But if people are really focussed on monthly changes, the MS way makes more sense.

The more general ZH point - that the market moved based on a statistic which is heavily adjusted using an algorithm that basically no-one really understands - still stands though.

Tue, 08/14/2012 - 21:46 | 2705627 tedives
tedives's picture

Agreed on the last bit, but I'll use a more extreme example to illustrate why this isn't a useful way to look at the data and can lead to wrong conclusions.

Let's assume month 1 had a seasonal adjustment factor of .5 (i.e. the data was halved by the adjustment).  Let's also assume that historically month 1 has had a factor of 1.1 all the time, so month 1 looks very suspect.

Then let's say month 2 gets a seasonal adjustment factor of .9 (i.e. the real data was reduced by only 10% by the adjustment).  Let's further assume that in all previous month 2's for the last 5 years, the seasonal adjustment factor was the same, .9.  Sounds like month 2 was a pretty reasonable adjustment.

By looking at the change in the seasonal adjustment factors month-to-month, the change is .4, an increase of 80%.  That makes month 2 look like it had some kind a massive increase.

But the reality was that month 2 had a very normal adjustment to it - adjusted down 10% actually.  It's month 1 that was messed up, and by comparing the two month's factors, the interpretation of the second month is polluted by the adjustment that was made to the first month.

Much more sensible to look at June's seasonal adjustment factor, and the same ones over the last 4-5 years (i.e. compare Apples to Apples etc.), and for May, compare May to all the past Mays.

Tue, 08/14/2012 - 17:02 | 2705017 SheepDog-One
SheepDog-One's picture

These clowns are still trying to ride the BS 'Christmas shopping spree' wave....what losers.

Tue, 08/14/2012 - 17:05 | 2705022 Monoki
Monoki's picture

So perhaps I'm the only counting the amount and time auto ads air.  And I thought July was gang-busters for the autos.  Hmm

Tue, 08/14/2012 - 17:24 | 2705065 Troncom
Troncom's picture

Baffle them (i.e. Muppets) with bullshit

Tue, 08/14/2012 - 17:30 | 2705074 monad
monad's picture

The strategy is to stall until the statute of limitations runs out. Thats it. Just prove real muppets are being intentionally slaughtered, there is no statute on murder.

Or treason.

Tue, 08/14/2012 - 18:05 | 2705124 falak pema
falak pema's picture

Here are two posts in french blogs that high light ZH's analysis of Eurozone crisis. ZH is getting good publicity now in France. Article from the prestigious Le Monde :

La BCE se finance auprès des banques, qu’elles le veuillent ou non. | Démystifier la financeEurope

Funding Needs.jpg 1 163 × 570 pixels

Tue, 08/14/2012 - 18:17 | 2705154 green888
green888's picture

but muppets cash is legal fare

So take it all. No scandal there

Tue, 08/14/2012 - 18:29 | 2705190 neutrinoman
neutrinoman's picture

Well, at least Tyler got noticed!

Now, is that "(Crazy Zero Hedge) Analysis," or "Crazy Analysis from Zero Hedge"? Cuz if it's the former, I want my ZH tin-foil hat now, to wear proudly in public.

Tue, 08/14/2012 - 18:45 | 2705232 BBullionaire
BBullionaire's picture

You mean there are people that read ZH and possibly comment etc that are STILL MS clients? jeez we really are fucked!!!

Tue, 08/14/2012 - 18:46 | 2705235 greenEagles
greenEagles's picture

X-12-ARIMA.... too clever by half? Do they think we're all so stupid that we can't accept an unadjusted number and come to our own conclusions?

Tue, 08/14/2012 - 22:01 | 2705662 Ted Baker
Ted Baker's picture

We need MS to concentrate in getting FB shares back on track

Wed, 08/15/2012 - 01:47 | 2705979 RunWild
RunWild's picture

California lower than expected July sales tax receipts; 33.5 percent below forecast.

http://www.bloomberg.com/news/2012-08-13/california-s-revenue-falls-10-1-below-forecast-chiang-says.html

Wed, 08/15/2012 - 08:17 | 2706261 RougeUnderwriter
RougeUnderwriter's picture

And now Money Market Funds are losing money unless there is a model out there that says they are not:

 

http://www.businessweek.com/news/2012-08-14/fed-s-dudley-backs-money-fun...

Sat, 08/18/2012 - 17:41 | 2717106 rjs
rjs's picture

to test this theory, we can add june & july unadjusted sales together, encompassing 9 weekends, which shows a total of $807,808 billion sales this year, and compare them to last years unadjusted sales (p 2, pdf) of $388,749B and $392,888B, a total of $781,637B, which means actual year over sales for the two months increased only 3.34%, much less than the seasonally adjusted annual increase which census gives, but still within the ±0.7% margin of error…

 

Do NOT follow this link or you will be banned from the site!