BBampaa

Lessons › Retail & Allocation › Store performance

Retail & Allocation lesson

Like-for-like (LFL)

This year the chain opened a sixth store, Ottawa. It had no sales last year.

Try this lesson free →
About 5–10 minutes · no sign-up needed

The idea

This year the chain opened a sixth store, Ottawa. It had no sales last year:

Key points

Like-for-likeGrowth counting only the stores open in both periods. New and closed stores are left out.
Work it outAdd up this year and last year for the stores open both years, then use the growth formula.
Why it mattersNew stores always add sales. LFL shows whether the existing business really got better.

Report both: total growth shows the business got bigger, LFL shows whether it got better.

Practice

Try each one in your head first, then open the answer.

1. Tap the store left out of like-for-like.
Ottawa opened this year, so there's no last year to compare it with.
2. In F2, add up this year's sales for the five stores open last year.
=SUM(B2:B6)
3. In F3, add up last year's sales for the same five stores.
=SUM(C2:C6)
4. In F4, work out like-for-like growth, as a decimal (no × 100).
=(F2-F3)/F3
5. What is the chain's total growth, with Ottawa included?
($57,600 − $48,000) ÷ $48,000 × 100 = 20%

Learn it by doing. This lesson is a short hands-on level on Bampaa: see it work, then build and write it yourself, with instant feedback.

Try this lesson free →
About 5–10 minutes · no sign-up needed