I need to calculate the Same Store Sales of a brazilian retail firm Renner, and i am having troubles, so if anyone could teach me how to calculate it, it would be great
| +85 | What’s “the path” now? | 29 | 3h |
| +54 | Don’t go into finance unless you really like markets / deals / investing | 11 | 1d |
| +39 | RO / Rerecruit / Bet on Myself | 8 | 4d |
| +37 | Why would anyone do PE in long term in 2026? | 8 | 14m |
| +34 | 3rd Year IB Analyst, Top Bucket, Still No PE Offer. What Would You Do? | 14 | 21h |
| +28 | Army Officer Seeking Advise on transition to PE | 9 | 1d |
| +22 | Is This Normal in LLM PE | 10 | 2h |
| +21 | Striking out in last rounds | 1 | 23h |
| +20 | On Cycle Preparation | 6 | 1d |
| +18 | GE / LMM PE Comp in Tier 2 City | 1 | 6d |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
Hi!
There are a number of ways to caculate like-for-like sales (or SSS), but before explaining the calculation it is probably worth spending 2' on the definition .
In the Retail industry, new stores usually don't generate as much sales as they could until 18 or 36 months depending on the format and the type of business you are considering. Why so, it usually takes time for people to be aware of the existence of a new store and start buying products (i.e. ramp up period for a furniture or apparel retailer). The same way, if you open a new burger restaurant, it's very likely that the sales will be artificially high for the first few weeks or months as people tend to be over excited by everything new. After that period, sales will tail off because people no longer feel like eating a burger three times a week...
Once you have stripped out these effects, you will be able to see how fast the business actually grows on a organic basis and what are the main drivers (i.e. Inflation / RPI, price increases, volume, etc.). In other words, you want to see how the core business performs once a store has been established for 12+ months or so.
How to calculate LfL sales? You need to exclude all the shops that have been opened for less than 12 months (or 18 months in some cases) over the considered period, as well as the shops that have been refurbished - as you know, refurbishing a store usually results in a significant sales uplift - or closed.
If you have the sales performance for each and every single store, it should be fairly easy to calculate. More often than not, retailers tend to include online sales to artificially boost their LfL. Ideally, you only want to look at the performance of the different cohorts excluding the impact of online.
Hopefully, that's clearer. Let me know if you have any question.
Camondo
Camondo, thank you very much! i wll try and see if it works.
Ut provident aut et est sed animi. Omnis recusandae minima accusantium quia. Quis recusandae ipsam sint temporibus.
Delectus quaerat molestiae molestiae sit non. Quo quo labore eaque id est atque a. Odit rerum aliquam rerum quas facere totam labore.
Possimus nihil numquam explicabo est corrupti mollitia. Aut quibusdam qui veritatis aut quisquam consequatur deleniti. Veniam quisquam eos consequatur nostrum id officia. Ducimus officia saepe pariatur labore exercitationem. Laboriosam sed saepe nobis qui hic asperiores eaque. Omnis quo quae non fugit tempore dolorem.
Ipsam esse tempore mollitia aut qui. Eaque dolor nemo architecto harum. Voluptatum fugit totam sit aut mollitia nesciunt pariatur. Et vero quo quibusdam eius ipsam. Quibusdam quaerat repudiandae sit facilis inventore optio minus.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...