YouTube2Text

Case Interview Fundamentals: Lesson 26 [Drill: Sports apparel retailer] — Transcript

by CraftingCases · 5,368 words · 839 segments · language en · Watch on YouTube

Full transcript

  1. 0:00Hello everyone, how's it going today?
  2. 0:02Before we start this case, I wanted to
  3. 0:03remind you that we are building a skill
  4. 0:07progression in this module. So,
  5. 0:10this case is going to be
  6. 0:13slightly tougher case than the previous
  7. 0:15one. It's going to have a few more
  8. 0:17steps. So, I want you to make sure that
  9. 0:20you follow the steps of the first step
  10. 0:22approach thoroughly and focus on the
  11. 0:25form so that the steps and the
  12. 0:26techniques that we learned in the first
  13. 0:30video of this module become second
  14. 0:32[snorts] nature to you. So, that when
  15. 0:34you get an analysis during your
  16. 0:36interview, regardless of how tough it
  17. 0:38is,
  18. 0:39these steps and these techniques will be
  19. 0:42natural to you and you will rock the
  20. 0:45interviewer's world. All right? Just a
  21. 0:48quick recap on what the first step
  22. 0:50approach is, what these steps are, and
  23. 0:53what techniques I would highly recommend
  24. 0:55you use here. The first step approach is
  25. 0:57first you structure your case,
  26. 1:00preferably with a step-by-step
  27. 1:02structure. Then, second, you ask
  28. 1:05questions that you might have and data
  29. 1:08that you might need. Third, you
  30. 1:09calculate the number and fourth, you
  31. 1:12come up with insights and next steps for
  32. 1:15your client. Okay?
  33. 1:17Now, to create the structure, I want to
  34. 1:20remind you that I gave you a technique
  35. 1:22in the first video, which is
  36. 1:24to create a step-by-step structure.
  37. 1:26First, you find some number that you
  38. 1:29know you can get to and that you
  39. 1:32are comfortable getting to and that you
  40. 1:34know it is in the way
  41. 1:36to take you towards the final answer.
  42. 1:38That's all you need to know and that is
  43. 1:40what you call step one.
  44. 1:42And then, once you have that, you will
  45. 1:44see what other number you can get to
  46. 1:47that you know is in the way, you know
  47. 1:49will get you somewhere closer to the
  48. 1:51number you need to get to, but still
  49. 1:53isn't it, and that you can get to using
  50. 1:56the numbers that you have. And then you
  51. 1:57call that step number two. And then you
  52. 2:00repeat this until you get all the steps
  53. 2:03for your structure. All right? And I'm
  54. 2:06going to go through this step-by-step
  55. 2:07process with you in this case again. And
  56. 2:10last thing before we jump into the case,
  57. 2:12you should know that the structure that
  58. 2:14I'm going to use in this case is a
  59. 2:16fairly common one
  60. 2:18for
  61. 2:20average difficulty cases, break-even
  62. 2:22cases like this one. So, I highly
  63. 2:24recommend you take notes on it cuz
  64. 2:26you're definitely going to be using it
  65. 2:28in your practice time and most likely in
  66. 2:31your interviews as well. So, let's get
  67. 2:33to the case question.
  68. 2:34Your client is a sports apparel retailer
  69. 2:37in Europe with 35 stores and around 120
  70. 2:41million euros in revenues. They have
  71. 2:43satisfactory profitability at the moment
  72. 2:46and have hired your firm to help them
  73. 2:48develop a growth strategy for the next 4
  74. 2:51years in order to reach a 40% revenue
  75. 2:55increase.
  76. 2:56So, the initial case question was
  77. 2:59>> [snorts]
  78. 2:59>> how would you help them create this
  79. 3:01growth strategy plan? But this is not
  80. 3:03the question that we're going to be
  81. 3:04working on right now. We're going to be
  82. 3:06working on the analysis question, which
  83. 3:08is considering we'll get the incremental
  84. 3:11revenues only from current stores
  85. 3:14reaching maturity and from opening new
  86. 3:16stores, how many stores will we need to
  87. 3:19open next year to reach a revenue goal
  88. 3:22in 4 years? You may use the data in this
  89. 3:25exhibit to help you. And then, well, I
  90. 3:27got this data over here, this table,
  91. 3:30which has
  92. 3:31>> [snorts]
  93. 3:31>> the data for all of the stores that we
  94. 3:33have apparently divided by age with the
  95. 3:37number of stores in that specific age,
  96. 3:39average size of store,
  97. 3:42and average revenue per square meter of
  98. 3:44the store. All right? So, let's move on
  99. 3:46to the case.
  100. 3:47Now, before we do anything,
  101. 3:50pause your video, come up with your
  102. 3:52structure, and only then listen to the
  103. 3:54structure that I have built. And then
  104. 3:56I'm going to walk you through my process
  105. 3:58of building the structure.
  106. 4:01So, here's my answer.
  107. 4:02I would solve this case in three steps
  108. 4:06to get to the number of stores that we
  109. 4:08need to open.
  110. 4:09First, I would find the
  111. 4:13total
  112. 4:14revenues that we are going to need in
  113. 4:17order to achieve our revenue goal. So,
  114. 4:20that's basically what our revenue
  115. 4:22increase goal is minus what our organic
  116. 4:27growth is already going to be given that
  117. 4:29some of the stores are going to mature,
  118. 4:31right? Then, I'm going to find
  119. 4:34what are the revenues per new store when
  120. 4:38they reach maturity cuz apparently
  121. 4:39they're already going to have reached
  122. 4:41maturity by the time we are to reach our
  123. 4:44goals since we're going to open them
  124. 4:45next year.
  125. 4:47And then, third, I am going to find how
  126. 4:50many stores need to be opened. So, to do
  127. 4:53that, I'm basically going to divide the
  128. 4:56volume of revenue that we're going to
  129. 4:57need to achieve our goal by the revenues
  130. 5:02per store at maturity that we're going
  131. 5:04to have. Now, would you be fine if I
  132. 5:06asked a few questions
  133. 5:08>> [snorts]
  134. 5:08>> about the case and about the data before
  135. 5:11I start calculating to get to the
  136. 5:13answer?
  137. 5:14And let's say the interviewer says this
  138. 5:15is okay. But before you pause the video
  139. 5:19and ask the questions yourself, I want
  140. 5:22to explain to you exactly how I got to
  141. 5:24the structure cuz I think it could be
  142. 5:26super useful to you. Here's what I did.
  143. 5:29So, I usually tell you to find
  144. 5:32a number that you know you can get to
  145. 5:34and then make it your step one and then
  146. 5:36find another one that you know you can
  147. 5:38get to and make it your step two. In
  148. 5:40this case, I did the very opposite and
  149. 5:43this is precisely why I think it's
  150. 5:45interesting to you.
  151. 5:46So, first thing I did was I looked at
  152. 5:49what I needed to find, which is the
  153. 5:50number of stores that we need to open.
  154. 5:53Right? To find that, I know that the
  155. 5:56objective with opening stores is
  156. 5:59getting increase in revenues. And what
  157. 6:02supplies this increase in revenues is
  158. 6:05opening stores. And so,
  159. 6:07I need to get the increase in revenues
  160. 6:09that I need and divide it by
  161. 6:11the supply of revenues that each store
  162. 6:14will give me, right? And so, basically,
  163. 6:17I found my last step here, which is
  164. 6:19revenue increase necessary divided by
  165. 6:22revenues that each new store is going to
  166. 6:24bring me. Okay? And so, what I did next
  167. 6:27is look into how can I get to those two?
  168. 6:30Do I have them? Or do I have data that
  169. 6:33will help me? And revenue per store was
  170. 6:35quite easy. I saw the data that I had
  171. 6:38and it told me square meters per store
  172. 6:40and it told me revenues
  173. 6:42per square meter in the stores. And so,
  174. 6:45if I only knew the size of the stores
  175. 6:47that we're going to open and the
  176. 6:48revenues per store that we would have
  177. 6:50with them,
  178. 6:51which I might be able to extrapolate
  179. 6:53from these or the interviewer might tell
  180. 6:55me, then I can definitely get to the
  181. 6:57revenues per store.
  182. 6:59And the revenue necessary
  183. 7:01to fulfill my goal, I have most of the
  184. 7:04data that I need. So, I know the
  185. 7:05revenues that we currently have, I know
  186. 7:07the goal that we have, and I know that
  187. 7:09if I extrapolate
  188. 7:11the revenues of each of those stores to
  189. 7:14maturity, assuming that it won't change
  190. 7:16or if it will change, I can ask this to
  191. 7:18the interviewer,
  192. 7:19then I know that I can get to the
  193. 7:21revenue that we will have organically.
  194. 7:24And so, basically,
  195. 7:25this is how I created my structure. But
  196. 7:27after thinking like this, I structured
  197. 7:30it in steps so that I could explain it
  198. 7:33simply to my interviewer. Now, if you
  199. 7:35want to think out loud, just like I did
  200. 7:38with you right now, with the interviewer
  201. 7:40and talk through your entire thought
  202. 7:42process. That is not a problem at all.
  203. 7:45If it makes you more comfortable, do it.
  204. 7:46The interviewer is even going to
  205. 7:47appreciate it. But, regardless of
  206. 7:49whether you choose to think out loud
  207. 7:53while talking to your interviewer or to
  208. 7:55think quietly and then get into a
  209. 7:56structure, you always have to show the
  210. 7:59interviewer your step-by-step structure
  211. 8:02in the end before you start the case.
  212. 8:04That way, you know that you are both on
  213. 8:06the same page, which is absolutely
  214. 8:08crucial for this step. Now, it's time to
  215. 8:12move on to step number two and ask our
  216. 8:14questions to the interviewer. So, pause
  217. 8:17this video and ask the questions that
  218. 8:19you have, then listen to mine and see if
  219. 8:21you missed anything. Okay? Let's go.
  220. 8:23Question number one.
  221. 8:25So, I am going to calculate the
  222. 8:29absolute value of our revenue increase
  223. 8:32goal. To do that, I'm going to multiply
  224. 8:34our current revenues by the
  225. 8:37revenue increase goal in percentage,
  226. 8:40which is 40%.
  227. 8:42And I know that you told me that our
  228. 8:44revenues are around 120 million, and I
  229. 8:46have data here that
  230. 8:49provided we only sell in
  231. 8:51brick-and-mortar stores and not in the
  232. 8:52internet, will allow me to calculate the
  233. 8:55total revenues cuz I have the
  234. 8:57number of stores, the [snorts] size of
  235. 8:59the stores, and the revenues per square
  236. 9:01meter of each store.
  237. 9:03Do you want me to calculate the
  238. 9:07the
  239. 9:08company's revenues to use the market
  240. 9:10size number or can I just use the 120
  241. 9:13million that you gave me? And let's say
  242. 9:15the interviewer tells me that I can use
  243. 9:16the 120 million. I don't need to
  244. 9:19calculate the full revenues.
  245. 9:21Next, I'm going to need to assume a
  246. 9:24revenues at maturity for each store
  247. 9:27since their revenues are still going to
  248. 9:29increase for the ones that are not
  249. 9:30mature.
  250. 9:31And from the data that you gave me, it
  251. 9:33looks like I I assume that
  252. 9:37stores that are 3 years
  253. 9:39old are already mature and that their
  254. 9:41revenues at maturity are
  255. 9:433.5 thousand euros per square meter.
  256. 9:47Is that right or should I use a
  257. 9:49different value for it?
  258. 9:51And let's say the interviewer tells me
  259. 9:52that those two statements are right.
  260. 9:55Now, my third question is regarding the
  261. 9:58size of the new stores. Since I'm going
  262. 10:00to have to calculate the revenues per
  263. 10:02new store at maturity, I don't only need
  264. 10:05to know
  265. 10:06the revenues at maturity, I also need to
  266. 10:08know their size.
  267. 10:10And let's say the interviewer tells me
  268. 10:12that it's going to be 1.3
  269. 10:14thousand square meters per store.
  270. 10:17That's the size of the new stores we're
  271. 10:18opening. And there just another thing
  272. 10:20came to my mind.
  273. 10:23Should I assume that there's going to be
  274. 10:24some kind of inflation, especially on
  275. 10:27the values of revenues per square meter
  276. 10:29at maturity? So,
  277. 10:31we're talking about 3.5 thousand euros
  278. 10:35per square meter right now for mature
  279. 10:37stores.
  280. 10:39And including for the ones that we are
  281. 10:40going to open, but in 4 years, is that
  282. 10:43going to be the same? And let's say the
  283. 10:45interviewer tells me that yes, that's
  284. 10:46going to be the same as well.
  285. 10:48Okay. So, now I have everything that I
  286. 10:50need, so I'll just start calculating.
  287. 10:53So, you who are using this as a practice
  288. 10:56drill should pause the video and run
  289. 10:59your calculations before watching mine.
  290. 11:02First, I want to calculate the
  291. 11:05revenue that we need to achieve.
  292. 11:07Specifically, I want to calculate the
  293. 11:11revenue increase goal in euros, right?
  294. 11:13So, that [snorts] is our revenue 120
  295. 11:15million times our percentage increase
  296. 11:18objective, which is 40%.
  297. 11:21So, 40% times 120 million
  298. 11:2410% of 120 million is
  299. 11:2912 million.
  300. 11:30That times four is
  301. 11:3248 million. Now, let's move on to
  302. 11:35finding the organic growth that we're
  303. 11:38already going to have from all the
  304. 11:40stores that we've opened growing to
  305. 11:42maturity. And so, this is going to be a
  306. 11:44little bit trickier. Here's what I'm
  307. 11:45going to do.
  308. 11:47I'm going to calculate for each tier of
  309. 11:49stores, which all have different sizes
  310. 11:52and different revenues per square meter,
  311. 11:54and of course a different number of
  312. 11:55stores,
  313. 11:57what is the total area, which is
  314. 11:59basically, you know, the number of
  315. 12:00stores times the area per store.
  316. 12:03And I'm also going to find the
  317. 12:07difference in revenues per square meter
  318. 12:10from where they are to maturity. So,
  319. 12:12basically, if the store has 1,000 euros
  320. 12:16per square meter in revenues, and when
  321. 12:17they're mature they're going to be at
  322. 12:193.5 thousand, then the difference is 2.5
  323. 12:22thousand, for example.
  324. 12:24And then I'm going to multiply those
  325. 12:26two, and I'm going to get to the
  326. 12:28total organic revenue increase expected
  327. 12:32by the time they reach maturity for all
  328. 12:34the stores in that tier. Okay? And so,
  329. 12:37the way I'm going to do this is with
  330. 12:38these three extra columns that I drew
  331. 12:40here. Now, let's move on and run the
  332. 12:43calculations. So, for
  333. 12:45first tier,
  334. 12:48this is 20 * 1.2 thousand square meters.
  335. 12:53So, this is 24 thousand square meters.
  336. 12:565 * 1.3 thousand. So, this gives me
  337. 13:005,000 plus
  338. 13:03.3 * 5, this is 1.5.
  339. 13:06So, 6.5 thousand square meters. For the
  340. 13:10next tier of stores that are 1 year old,
  341. 13:14four stores times 1.35
  342. 13:18thousand square meters. So, this is
  343. 13:221,000 * 4 is 4,000 plus 0.35
  344. 13:27* 4. 0.35
  345. 13:30* 2 is 7. 7 * 2 is 14.
  346. 13:35So, this 0.35
  347. 13:37* 4 is
  348. 13:391.4. So, I have 4 + 1.4. This is 5.4
  349. 13:44thousand square meters.
  350. 13:46Now, the last tier of stores that are 0
  351. 13:49years old is 6 * 1.3 thousand. Right?
  352. 13:53So, 6 * 1 is 6.
  353. 13:55.3 * 6 is 1.8. So, this gives me
  354. 14:006 + 1.8 7.8 thousand.
  355. 14:03Okay? Now, let's move on to the
  356. 14:06delta in revenues for each square meter
  357. 14:10per tier. So, for tier number one,
  358. 14:13stores that are three or more years old,
  359. 14:15that's zero, right? Cuz it's
  360. 14:17they're are already at maturity. And
  361. 14:20since maturity revenues is 3.5 thousand,
  362. 14:24for tier number two, 3.5 thousand minus
  363. 14:273 thousand is 0.5 thousand.
  364. 14:31For stores that are 1 year old, what I
  365. 14:33have is 3.5 minus 2, 1.5 thousand. And
  366. 14:38for stores that are 0 years old, 3.5
  367. 14:41minus 1, this is 2.5 thousand.
  368. 14:44Okay? Now, I just got to multiply one
  369. 14:46column by the other.
  370. 14:48And for the first tier of stores, it's
  371. 14:51of course zero cuz they're already
  372. 14:53mature, so no organic revenue increase
  373. 14:55should be expected. For
  374. 14:58stores that are 2 years old, what I have
  375. 15:00is 6.5 thousand square meters times
  376. 15:03half
  377. 15:05thousand euros per square meter. Okay?
  378. 15:07So, this is 6.5
  379. 15:11thousand times 0.5 thousand. Thousand
  380. 15:14times thousand is million, and this is
  381. 15:16going to happen in all of this table.
  382. 15:18So, 6.5 divided by 2
  383. 15:21is 3 plus
  384. 15:23half divided by two is 0.25. So, this is
  385. 15:253.25.
  386. 15:285.4
  387. 15:29* 1.5. So, it's 5.4 + 1/2 of 5.4.
  388. 15:351/2 of 5.4 is 2.7. So, 5.4 + 2.7 7 + 4
  389. 15:41is
  390. 15:4311. So, this is 8.1.
  391. 15:47Now, 7.8
  392. 15:49* 2.5.
  393. 15:51This is 7.8
  394. 15:53* 5 / 2, right? Cuz 2.5 is 1/2 of 5.
  395. 15:597.8 * 5
  396. 16:02So, I'm going to call 7.8 8 - 0.2.
  397. 16:068 * 5 is 40.
  398. 16:080
  399. 16:10.2 * 5 is 1. So, this is 39. Now, you
  400. 16:14got to divide it by two. 39 / 2 is
  401. 16:1819 and 1/2. So, this is 19 and 1/2
  402. 16:20million.
  403. 16:21So, I just got to add all of these up
  404. 16:24cuz this is the increase in
  405. 16:28revenues expected just because these
  406. 16:30stores are going to mature for each
  407. 16:32tier. And so, 0.25 + 0.1 + 0.5 is 0.85.
  408. 16:403 + 8 is 11 + 19 30. So, this is 30.85
  409. 16:47million. Now, 48 million - 30.85.
  410. 16:5248 - 30 is 18.
  411. 16:5518 - 0.85
  412. 16:58is 17.15.
  413. 17:01So, this is the revenue that we need to
  414. 17:04achieve by opening new stores. Now, I
  415. 17:06just need to figure out how much revenue
  416. 17:08each store is going to bring me, and
  417. 17:11then I can know how many stores I will
  418. 17:14need.
  419. 17:15Now, let's move on to calculating the
  420. 17:18revenue per new store that we can
  421. 17:20expect. So, I have the revenues per
  422. 17:21square meter at maturity, which is 3.5
  423. 17:25thousand euros
  424. 17:27times the size of the new stores, which
  425. 17:29is 1.3 thousand. So,
  426. 17:343.5 * 1.3
  427. 17:374.55
  428. 17:40million. Now, I just need to divide
  429. 17:43the revenue needed, 17.15
  430. 17:46million, by the revenues that each
  431. 17:49stores will bring me, which is 4.55.
  432. 17:54And it seems like this is going to be
  433. 17:57so, 17.15 is close to 18, 4.55 is close
  434. 18:01to 4.5.
  435. 18:034.5 * 2 is 9, 4.5 * 4 is 18. So, it's
  436. 18:08pretty close. This is going to be close
  437. 18:11to four.
  438. 18:13Just possibly slightly low four because
  439. 18:16it's less than 18.
  440. 18:18And actually I can't open fraction
  441. 18:22stores. [snorts]
  442. 18:22I can't open 3.8 stores. So, I actually
  443. 18:26have to open four stores. If I open
  444. 18:29three, I won't meet my goal. If I open
  445. 18:31four, I'll go slightly above, but I'll
  446. 18:33have met my goal.
  447. 18:34So, the answer is that I should open
  448. 18:37four stores.
  449. 18:38And what this tells me
  450. 18:41So,
  451. 18:42this is
  452. 18:44just
  453. 18:45slightly above 10% of the stores that we
  454. 18:48currently have, which is not that
  455. 18:50little. It's actually a lot of stores to
  456. 18:52open, but it's less stores than we
  457. 18:54opened last year. It's less stores than
  458. 18:57we opened two years ago
  459. 18:59or three years ago. And it doesn't seem
  460. 19:02like a lot given the rhythm that we've
  461. 19:05been opening stores. And if we open more
  462. 19:07stores, and not [snorts] only stores in
  463. 19:10this next year, but some stores in the
  464. 19:12other years, also.
  465. 19:14We're going to be way above this goal.
  466. 19:17So, honestly, what I would be looking at
  467. 19:19right now is
  468. 19:21why is this goal so
  469. 19:23achievable?
  470. 19:24Couldn't we have been considering
  471. 19:27a more ambitious goal?
  472. 19:29I would be looking into that.
  473. 19:32And I'd be asking this question, why is
  474. 19:34this goal so achievable? Why is it so
  475. 19:35easy to achieve?
  476. 19:37Just doing some math here, I can see
  477. 19:39that
  478. 19:40if we opened the same number of stores
  479. 19:42as the previous year, six,
  480. 19:45then we would have at maturity an
  481. 19:47increase of nine for every two stores.
  482. 19:50So, it's 36.
  483. 19:5236
  484. 19:54million
  485. 19:55while we only need 17.
  486. 19:58And so, what this means is around 20
  487. 20:00million above our goal.
  488. 20:03And so, just by opening the same number
  489. 20:05of stores we opened last year. If last
  490. 20:07year wasn't a catastrophe in terms of
  491. 20:10profitability, then I see no reason why
  492. 20:12we wouldn't do that.
  493. 20:14All right, this is it for this case,
  494. 20:15guys. Now, I want to show you a few
  495. 20:19insights that I would love if you
  496. 20:21learned from this case.
  497. 20:23Insight number one is a new tool that
  498. 20:27you have seen I use in this case and
  499. 20:29that you can use in your own cuz it's
  500. 20:33quite impressive. It's super helpful in
  501. 20:35solving the case, in communicating
  502. 20:38both your structure and uh your
  503. 20:41calculations. And it's also impressive
  504. 20:43to the interviewer cuz it shows that you
  505. 20:44already think like a consultant. And
  506. 20:46that is creating new
  507. 20:49data sets in the exhibits that you get.
  508. 20:52In this case, I created new columns in
  509. 20:54my table, but it could be a another data
  510. 20:58set in chart exhibit that you get. So,
  511. 21:01you could write numbers on the bottom
  512. 21:03with something you calculated, like
  513. 21:05under each column, for example. Or you
  514. 21:07could create other columns next to the
  515. 21:10columns that are there if you're
  516. 21:12explaining something like, "Oh, I would
  517. 21:14like to see this data." And then you
  518. 21:15place something in there. Or I would
  519. 21:17expect to see this change, and you draw
  520. 21:19a different line or something like that.
  521. 21:21Right? And the secret sauce to make this
  522. 21:24extra impressive to your interviewer and
  523. 21:26make them really see that you think like
  524. 21:29a consultant is to label your columns or
  525. 21:33data sets appropriately. So, it's one
  526. 21:35thing to just, you know, start writing
  527. 21:38on a different column, and the
  528. 21:39interviewer kind of knows what you're
  529. 21:41doing, kind of not. He's not He can't be
  530. 21:43sure. And it's another thing to actually
  531. 21:47write down the title of the column like
  532. 21:49I did, and then write everything on the
  533. 21:52bottom, or write exactly what that new
  534. 21:55data set is.
  535. 21:57That's completely different, and it
  536. 21:58makes all the difference because it's
  537. 22:00visual. It's not only intellectual, it's
  538. 22:03also visual to your interviewer that
  539. 22:05they are talking to someone who is
  540. 22:07completely ready to be a consultant. And
  541. 22:10it also signals to them that you can, at
  542. 22:12the same time, think about solving the
  543. 22:15problem with an appropriate structure,
  544. 22:17but also create it in a way that you can
  545. 22:20already communicate it
  546. 22:22to someone who is outside of your mind,
  547. 22:24possibly even outside of consulting.
  548. 22:27Now,
  549. 22:28the second insight is about the type of
  550. 22:32analysis that this is. So, you might
  551. 22:34have noticed that this is a kind of
  552. 22:36break-even case, but only conceptually.
  553. 22:38What this means,
  554. 22:40a break-even calculation is basically
  555. 22:43figuring out how many units you need to
  556. 22:46sell to compensate an investment that
  557. 22:49you made. So, on the top you will put
  558. 22:51investment and fixed costs as the
  559. 22:54numerator, and on the bottom as the
  560. 22:56denominator you will put the
  561. 22:58contribution margin of the specific
  562. 23:00product that you have. Right? That is
  563. 23:02the correct definition of a break-even
  564. 23:05analysis. But, the conceptual definition
  565. 23:08that I use is different. It's basically
  566. 23:11I think of
  567. 23:13the units sold on the denominator as
  568. 23:18a unit that supplies their contribution
  569. 23:21margin in order to offset the
  570. 23:23investment, which we can call a goal of
  571. 23:27cash flow being zero. Right? And in this
  572. 23:30case, the stores are what supply the
  573. 23:33revenue, which are created to offset a
  574. 23:36goal in revenue growth. And that's why
  575. 23:39we have the necessary revenue growth as
  576. 23:42the numerator and the uh revenues per
  577. 23:46store, because stores supply revenue in
  578. 23:49this case, on the bottom as the
  579. 23:51denominator. Okay? And
  580. 23:53since we've now agreed that this is a
  581. 23:56break-even case, what you can pay
  582. 23:58attention to is that break-even cases,
  583. 24:01including this one, are often made
  584. 24:03difficult by adding extra steps. And
  585. 24:06these steps can be added in three
  586. 24:08different parts of the structure.
  587. 24:10They can be added as extra steps to find
  588. 24:12the numerator, or in this case the
  589. 24:14revenue goal, and this is where this
  590. 24:16case was tougher, cuz you had to do a
  591. 24:18ton of calculations to find how much
  592. 24:20extra revenue you needed to find. They
  593. 24:22can be extra steps to find the
  594. 24:23denominator, in this case revenues per
  595. 24:26store. So, imagine that we didn't have
  596. 24:28the number for revenues per store, we
  597. 24:30needed to do a bunch of calculations to
  598. 24:32get it. In this case, we did have to
  599. 24:34break it down a little bit.
  600. 24:36And it can also be extra steps after
  601. 24:38finding the break-even value. Meaning,
  602. 24:41once you find the number, you still have
  603. 24:44to calculate something afterwards. For
  604. 24:46example, in this case, it would be if
  605. 24:48they had asked me
  606. 24:50what percent growth of stores
  607. 24:53we would need, rather than the number of
  608. 24:55stores that we need to open. Or if they
  609. 24:57asked us, "What will be the necessary
  610. 24:59investment?" And then after I find the
  611. 25:01number of stores, I need to calculate
  612. 25:03the investment based on the investment
  613. 25:05per store to open. Okay?
  614. 25:08Now,
  615. 25:08this is something that you should keep
  616. 25:10in mind because it's going to appear a
  617. 25:11lot. And once you see a case that is
  618. 25:13conceptually a break even, you can
  619. 25:15already know
  620. 25:17what are the general steps that you're
  621. 25:19going to need to take. There is the
  622. 25:20actual division of the break even, and
  623. 25:22then there are the steps to get to the
  624. 25:24numerator, steps to get to the
  625. 25:25denominator, and steps to do after the
  626. 25:29break even sometimes.
  627. 25:31Now,
  628. 25:32another thing that I want to point out,
  629. 25:34and this is something that I did in this
  630. 25:36case that you definitely should
  631. 25:38incorporate to your skill set, and that
  632. 25:41is in the end, when finding the so what,
  633. 25:44the insights, and then the next steps,
  634. 25:47instead of comparing the number that you
  635. 25:49got to only one number, compare it to
  636. 25:52more than one number. In this case, I
  637. 25:53compared the number of stores opened
  638. 25:56that we're going to need to open to the
  639. 25:59number of previous stores opened, so the
  640. 26:01stores that we opened in the last year,
  641. 26:03the year before, and the year before
  642. 26:04that.
  643. 26:05And I also compared it to the number of
  644. 26:07stores we already had. So, I said it's
  645. 26:10a little bit more than 10% of stores
  646. 26:12that we have, but it's also less stores
  647. 26:15than we opened last year. And if you
  648. 26:17make more than one comparison, if you
  649. 26:19compare with more than one number,
  650. 26:20you're going to get to more nuanced and
  651. 26:22stronger insights, and it's going to be
  652. 26:25noticeable to the interviewer because
  653. 26:26everyone else is going to be comparing
  654. 26:29the number to either nothing or to just
  655. 26:33one single number and giving a
  656. 26:36one-dimensional conclusion to your
  657. 26:38interviewer. Of course, you should only
  658. 26:40do this if you can find more than one
  659. 26:43relevant comparisons. You shouldn't be
  660. 26:44comparing it to something that has no
  661. 26:46relevance to the case. Okay? But while
  662. 26:49you're practicing, it pays off to take
  663. 26:51some time to find several numbers that
  664. 26:54you can compare your final answer to to
  665. 26:57get to an insight.
  666. 26:59Now, one more thing that I want to bring
  667. 27:00up is a common mistake that many people
  668. 27:05would do in this case, and I've seen
  669. 27:07many people do it. And that is making
  670. 27:10assumptions that are sort of reasonable,
  671. 27:13but not making them explicit. So, in
  672. 27:16this case, the one I want to take as an
  673. 27:17example is
  674. 27:19assuming that 3.5 thousand euros per
  675. 27:22square meter in revenues per store at
  676. 27:24maturity is the number that we can use
  677. 27:28as, you know, revenues per square meter
  678. 27:31for stores that are mature.
  679. 27:33The reason I'm saying this is
  680. 27:37it looks a lot like this is the number
  681. 27:40we can use for mature stores from the
  682. 27:42table that we got from the data that we
  683. 27:44got, and it's kind of implied in the
  684. 27:46case question, but it could very well
  685. 27:50not be. It could be that the
  686. 27:52interviewers would say no. Since these
  687. 27:54stores are larger, we might expect less
  688. 27:57revenues per square meter. Or since
  689. 27:59these stores will be opened in less
  690. 28:01premium locations, or maybe we can
  691. 28:03expect more revenues per square meter
  692. 28:05because we're going to open them in
  693. 28:07better locations or whatever.
  694. 28:09But it could be different. You don't
  695. 28:11even need to ask, but you need to make
  696. 28:13this assumption explicit. Or if you're
  697. 28:16more comfortable with this, you can ask.
  698. 28:18Asking is definitely better than keeping
  699. 28:19quiet. But when you ask this or when you
  700. 28:22make this explicit, it shows to the
  701. 28:24interviewer that you're aware of the
  702. 28:26possible nuances around it. So,
  703. 28:28it shows them that if you were doing a
  704. 28:32real-life consulting project, you're at
  705. 28:35the client, and then
  706. 28:37there is this possible assumption that
  707. 28:39you can make.
  708. 28:40Kind of like this one. Revenues per
  709. 28:42square meter at maturity will be the
  710. 28:44same for new stores.
  711. 28:46That could be a curveball, and I am
  712. 28:48certain that your interviewer has gotten
  713. 28:50several of those curveballs in their
  714. 28:53time in consulting. And when they see
  715. 28:55that you will catch that if it comes to
  716. 28:57you, they want you to be the person
  717. 29:00working on the client side in the next
  718. 29:03project for him. Because you are the
  719. 29:05person that's going to catch those
  720. 29:07problems by yourself, and they're not
  721. 29:09going to need to fact-check and recheck
  722. 29:13everything that you do when you're
  723. 29:15implied assumptions, which is much
  724. 29:17harder to check than an explicit
  725. 29:19assumption. Okay? So,
  726. 29:22when making a sort of reasonable
  727. 29:24assumption,
  728. 29:25either ask whether that assumption is
  729. 29:27reasonable or
  730. 29:29tell your interviewer that you're making
  731. 29:30an assumption over there. But, asking is
  732. 29:33a little bit better. Okay? Now, one last
  733. 29:35thing that I want to talk about because
  734. 29:37yeah, you guys always ask me about
  735. 29:40alternative structures for the analysis
  736. 29:42cases that we do. And one alternative
  737. 29:45structure that is possible and just as
  738. 29:48good as this one, I guess,
  739. 29:50is within step one,
  740. 29:52instead of finding the goal in absolute
  741. 29:55value in revenue increase and
  742. 29:57subtracting it from the
  743. 30:00organic growth that is expected
  744. 30:03from the stores that we already have,
  745. 30:05you could have gotten the revenues that
  746. 30:07we will have, which is not uh 48
  747. 30:10million, but 168 million, cuz it's 140%
  748. 30:15of our current revenues, minus the total
  749. 30:18revenues of
  750. 30:19the stores that we have once they are
  751. 30:21mature.
  752. 30:22And what we're seeing with this
  753. 30:24alternative structure is the same
  754. 30:26pattern that we saw in the
  755. 30:30last drill that we did, which is a
  756. 30:33dichotomy between finding the difference
  757. 30:35of the totals and finding the total of
  758. 30:37the differences. Right? What I did here
  759. 30:40when calculating the organic growth
  760. 30:42expected instead of calculating the
  761. 30:45total revenues at maturity of the
  762. 30:48current stores that we have is finding
  763. 30:50the
  764. 30:51total of differences. The differences
  765. 30:53being the difference for each store tier
  766. 30:56between
  767. 30:58revenues per square meter right now and
  768. 31:00revenues per square meter in the future
  769. 31:03and multiplying that by the number of
  770. 31:05square meters that we have. Finding the
  771. 31:08difference of totals would be total
  772. 31:10revenues once these stores are mature
  773. 31:14minus total revenues right now.
  774. 31:17Okay, and that would be the organic
  775. 31:19growth that we can expect. And if you
  776. 31:20were to do that, of course, you wouldn't
  777. 31:22use the exact same structure within step
  778. 31:24one. What you would do would be
  779. 31:27finding first the revenues that we need
  780. 31:30to have once we reach our goal.
  781. 31:32So, 140%
  782. 31:34of 120 million. And then subtract from
  783. 31:37that
  784. 31:38the revenues that we will have once all
  785. 31:42of our stores are mature if nothing else
  786. 31:44changes. And this structure would also
  787. 31:47work. Now, there is an alternative
  788. 31:50structure that would not work. Kind of
  789. 31:52looks like it would work conceptually,
  790. 31:54but then when you get into the weeds, it
  791. 31:56doesn't. And that is finding This is for
  792. 31:58the whole case, not only for one step,
  793. 32:00but that is
  794. 32:01finding the total revenues that we need,
  795. 32:04140% of our current revenues,
  796. 32:07and dividing that by the revenues per
  797. 32:10store at maturity, and that would give
  798. 32:12us the number of stores total that we
  799. 32:14need to have. And then we can just
  800. 32:15subtract the number of stores that we
  801. 32:17already have.
  802. 32:19This seems like it would work, but the
  803. 32:20problem is the stores we have
  804. 32:25they all have different sizes from one
  805. 32:26another. So, the
  806. 32:2820 stores that are at 20 plus year old
  807. 32:30on average have 1.2 thousand square
  808. 32:33meters per store. The ones we're opening
  809. 32:35have 1.3
  810. 32:37thousand square meters per store. So, if
  811. 32:40you divided this by the average size of
  812. 32:42stores that we have now, you wouldn't be
  813. 32:44finding the right number of stores that
  814. 32:46we need to have cuz some of them we're
  815. 32:48going to open are going to be larger and
  816. 32:50therefore have more revenues per store.
  817. 32:54So, it doesn't really work. What you
  818. 32:56could have done
  819. 32:58it seems like a stretch to me, but what
  820. 32:59you could have done
  821. 33:01is finding
  822. 33:03the total revenue needed divided by the
  823. 33:06revenues per square meter
  824. 33:08at maturity.
  825. 33:10And then, once you have that, you can
  826. 33:13subtract from that the number of square
  827. 33:15meters that we already have, and then
  828. 33:17you'd find the number of square meters
  829. 33:19that we still need to open in stores.
  830. 33:21And then you divide that by the number
  831. 33:23of square meters per store that we are
  832. 33:25going to open. That might work. That
  833. 33:28would work. And it would be it would be
  834. 33:30a clever way to structure this case, not
  835. 33:33necessarily better than this one,
  836. 33:35probably a little bit harder to explain,
  837. 33:37but no problem if you did it that way.
  838. 33:39All right, guys. This is it for today.
  839. 33:41I'll see you in the next video.

About this transcript

This page contains the full transcript of Case Interview Fundamentals: Lesson 26 [Drill: Sports apparel retailer] by CraftingCases, generated from the public captions YouTube serves with the video. The transcript has 5,368 words across 839 segments, with the original timestamps preserved so you can click any line to jump to that moment in the embedded player.

What you can do with it

Use the transcript to take notes, quote the speaker, build a study guide, generate a summary with ChatGPT or Claude via the YouTube Summary tool, or export it as a timed subtitle file with YouTube to SRT. You can also re-open it in the transcriber to choose a caption track available on the video.

Free YouTube transcript tool

YouTube2Text is a free YouTube transcript generator — no signup, no daily limit. Paste any YouTube link and get the full transcript instantly, with timestamps, click-to-jump, caption language selection, AI prompts for ChatGPT, Claude, and Gemini, and exports to TXT, SRT, VTT, or Markdown.