Retailers -- YTD/TTM same store sales calculations?

Retail coverage folks --

I'm curious about how you would calculate the trailing 12 month same store sales figure for a company if you have the quarterly data (let's assume that the 4Q 12 through 3Q 13 same store sales numbers are +0.5%, -0.4%, +1.0%, and +0.2%, respectively -- I picked random numbers for illustration purposes). In the same way, how would you back in to a company's YTD reported same store sales figures (again using the same illustrative values)? Thanks.

7 Comments
 

The number of retailers reporting monthly SSS has dropped precipitously in the last year or two. It's down to around 9 now, at least for the companies I cover. (Costco, Fred's, Stein Mart, American Apparel, Buckle, Cato, Gap, L Brands and Zumiez).

My name is Nicky, but you can call me Dre.
 

You'd weight the results by SSS sales but those numbers are tricky because the SSS base is constanting changing from new openings, closings, and most importantly remodels.

Most companies will give you their YTD SSS number in their PRs. Also curious why you'd want to focus on YTD SSS number, most people care about looking at QoQ or YoY compares for SSS results. On top of that it is also interesting to look at SSS "stacks" as in -10% on year, +10% next year, =0% stack. Yes I know, compounding says that doesn't add up to zero but given the limited ammount of numeric SSS results this is a common way of looking at results on a comparative multi-year basis, especially amoung peers.

 

To answer your question, it is pretty difficult to back into the SSS figures due to the reasons mentioned by tiger.

Furthermore, many companies are now including 'Direct to Consumer' (aka online) sales in their SSS figures which will inflate the figure while other companies choose to not include this number. There's not really an industry standard at this point and when companies have many different brands like Gap it would make it pretty difficult to back your way in.

My name is Nicky, but you can call me Dre.
 

Est est laudantium veritatis. Enim et blanditiis ad. Accusamus ratione veniam dolorum asperiores eos cumque odio. Occaecati eum molestiae tenetur autem labore aperiam inventore provident. Omnis alias qui ipsam quos eos ut.

Dolor quis et et nam quaerat accusamus veritatis minima. In officiis et incidunt. Occaecati corrupti quia voluptatem et nostrum optio inventore. Eum eaque suscipit molestias ducimus quis. Dolor accusamus qui quia tenetur aut expedita. Molestiae et dolorum non ducimus porro.

Non deserunt veniam dolorem voluptatibus velit. Voluptatem voluptate hic autem sit accusamus.

Omnis temporibus dignissimos quo tempora. Error odio at ratione est et omnis cumque. Quia sed facere rerum quasi. Fugit quas modi aut autem sapiente.

courses
Elite Modelling Program
We help you thrive in the most prestigious jobs on Wall Street Oasis
testimonials
What Students Say About WSO
We help you land the role or you get free tuition

Career Advancement Opportunities

June 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.8%
  • JPMorgan 01 98.2%
  • Guggenheim Partners 01 97.7%
  • Morgan Stanley 07 97.1%

Overall Employee Satisfaction

June 2026 Investment Banking

  • Moelis & Company No 99.4%
  • Morgan Stanley 01 98.8%
  • Evercore 01 98.2%
  • BMO Capital Markets 12 97.6%
  • Banco Santander 01 97.1%

Professional Growth Opportunities

June 2026 Investment Banking

  • Moelis & Company No 99.4%
  • Evercore No 98.8%
  • Morgan Stanley 05 98.2%
  • JPMorgan No 97.7%
  • BMO Capital Markets 12 97.1%

Total Avg Compensation

June 2026 Investment Banking

  • Vice President (14) $434
  • Associates (43) $259
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (22) $179
  • Intern/Summer Associate (13) $156
  • 1st Year Analyst (75) $151
  • Intern/Summer Analyst (66) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
Secyh62's picture
Secyh62
99.0
3
BankonBanking's picture
BankonBanking
99.0
4
kanon's picture
kanon
99.0
5
DrApeman's picture
DrApeman
98.9
6
dosk17's picture
dosk17
98.9
7
CompBanker's picture
CompBanker
98.9
8
GameTheory's picture
GameTheory
98.9
9
Betsy Massar's picture
Betsy Massar
98.9
10
numi's picture
numi
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”