YouTube2Text

Case Interview Fundamentals: Lesson 27 [Drill: B2B Software as a Service] — Transcript

by CraftingCases · 5,577 words · 863 segments · language en · Watch on YouTube

Full transcript

  1. 0:01All right, everyone. Ready for another
  2. 0:02quantitative analysis case?
  3. 0:05As you know, I've been building this
  4. 0:06module with a skill progression logic.
  5. 0:10So, this case is going to be tougher
  6. 0:11than the previous ones, but I still want
  7. 0:14you to
  8. 0:16learn the concepts that I'm going to
  9. 0:18bring up, and I don't want them to be
  10. 0:19cramped. So, I'm going to break it down
  11. 0:22into three different questions. This
  12. 0:23way, if you want just stuff practice,
  13. 0:26you're going to have it, but if you want
  14. 0:29to learn the concepts one by one slowly
  15. 0:32and internalize them,
  16. 0:34uh and if you have more trouble with
  17. 0:35quantitative analysis, you're also going
  18. 0:37to get a lot of value out of this. But,
  19. 0:40the end result is that I'm going to
  20. 0:41treat this more like a lesson
  21. 0:43than like a drill, but you can still do
  22. 0:46it like a drill. I just won't be
  23. 0:48answering exactly like I would to an
  24. 0:50interviewer. Now, I'm going to break
  25. 0:53this down into three questions. If
  26. 0:54you're treating this like a drill and
  27. 0:56getting full practice out of it, what
  28. 0:58you should do is
  29. 1:00pause after each one of them, follow the
  30. 1:03four steps, and then listen to each of
  31. 1:06the steps as I answer them. Of course,
  32. 1:09as in the other cases, you might need
  33. 1:12answers from step two to be able to
  34. 1:14follow along. So,
  35. 1:16you might want to listen to steps one
  36. 1:18and two after you've drafted yours
  37. 1:20before moving on to steps number three
  38. 1:23and four. All right? Let's get right to
  39. 1:25the case.
  40. 1:27This is a long one.
  41. 1:29Your client is a software company
  42. 1:31developing software that helps
  43. 1:32restaurants, single and small chains,
  44. 1:35manage their finances and get market
  45. 1:37insights using aggregate data from all
  46. 1:40clients they have. They currently charge
  47. 1:42$2,000 for a yearly subscription to
  48. 1:45their product and sell mostly via cold
  49. 1:48calls.
  50. 1:49Here's some data they've provided from
  51. 1:50their sales process. Their sales team
  52. 1:52contacts around 4,000 people every
  53. 1:55month. 30% of those respond to their to
  54. 1:58their calls. 1/3 of those who get on the
  55. 2:01phone agree to join a 1-month trial of
  56. 2:04their software, and 10% of those who
  57. 2:06join the free trial become paying
  58. 2:08clients.
  59. 2:09Now, the engineering team has recently
  60. 2:12come up with an idea to develop a
  61. 2:14software that will dig up information
  62. 2:16and segment their leads before they even
  63. 2:19call, so they can focus only on the ones
  64. 2:21with greater likelihood of success. They
  65. 2:24want your help deciding whether they
  66. 2:26should go forward with this or not. The
  67. 2:29full development process would cost $2
  68. 2:31million,
  69. 2:32and the sales team estimates the
  70. 2:34following changes in the sales funnel
  71. 2:36numbers.
  72. 2:37The percentage of calls answered would
  73. 2:39increase to 40%. The percentage of
  74. 2:42acceptance of the free trial would
  75. 2:44increase to 50%, meaning the people who
  76. 2:48join the free trial.
  77. 2:50And the percentage of free trials that
  78. 2:52convert to a full subscription would
  79. 2:55increase to 12%. All right, so this is
  80. 2:57the full context. Now, the final
  81. 3:00question would be whether would be
  82. 3:03should they do this or not. Okay? But, I
  83. 3:06want to break this down into three
  84. 3:08questions, and the first question that I
  85. 3:10want you to answer, and then I'm going
  86. 3:12to, is
  87. 3:13assuming the average buyer remains a
  88. 3:15buyer for 3 years, can you figure out
  89. 3:18what the client's revenues are?
  90. 3:21Now, pause your video and answer the
  91. 3:24question using the four-step approach,
  92. 3:26and then listen to what I have to say to
  93. 3:28the interviewer.
  94. 3:31So, to find this client's revenues, I
  95. 3:33would go through three different steps.
  96. 3:36Number one, I would find the number of
  97. 3:38new clients that they have every month
  98. 3:40because
  99. 3:41I can do that you just but basically
  100. 3:43multiplying the
  101. 3:46number of people that they speak to, the
  102. 3:48sales team speaks to,
  103. 3:50uh by
  104. 3:51all of the funnel
  105. 3:53that leads us to the percentage of them
  106. 3:55that buy, right? And then, I would
  107. 4:00find the number of total clients that
  108. 4:01they have because assuming that their
  109. 4:04revenues are stable, I might be able to
  110. 4:06assume that the number of old clients
  111. 4:09leaving the base is equal to the number
  112. 4:11of new clients coming in.
  113. 4:14And given that I know that the average
  114. 4:16client stays for a given time in my
  115. 4:20base, I can get to the number of clients
  116. 4:24that I have at any given moment simply
  117. 4:26by multiplying the number of clients
  118. 4:28that come in every month by the number
  119. 4:31of months that the average client stays
  120. 4:35in my client base. And then, just by
  121. 4:37multiplying that by
  122. 4:40the average price, I would get to the
  123. 4:43total revenues of my client. I just need
  124. 4:45to ask a few questions to confirm if the
  125. 4:47structure actually makes sense or if I
  126. 4:49need to change it a little bit. Would it
  127. 4:51be fine if I ask these questions now?
  128. 4:54Let's say the interviewer says, "It's
  129. 4:56okay." So,
  130. 4:57I basically want to know if revenues
  131. 4:59have been stable and will remain stable.
  132. 5:01Like, number of clients coming in is
  133. 5:03equal to the number of clients going
  134. 5:05out, right? And I also need to know if
  135. 5:09price has recently changed cuz if it
  136. 5:11has, then revenue being stable doesn't
  137. 5:14mean that I can assume that number of
  138. 5:16clients is the same. And if old clients
  139. 5:18that are leaving or that have joined a
  140. 5:21long time ago pay less, for example,
  141. 5:24than current clients coming in, then I
  142. 5:26also need to adjust my model for that.
  143. 5:29Let's say that my interviewer says, "No,
  144. 5:31assume that price didn't change and that
  145. 5:33all clients pay the same $2,000 per year
  146. 5:36and that you can assume that number of
  147. 5:39clients leaving the base is equal to the
  148. 5:41number of clients coming into the client
  149. 5:43base every month."
  150. 5:45All right, so
  151. 5:46I'm going to move on to do my
  152. 5:47calculations now. What I have is
  153. 5:504,000
  154. 5:52leads for a thousand people that we call
  155. 5:55on the phone. 30% of those pick up, 1/3
  156. 5:58of those join the free trial, 10% of
  157. 6:01those actually purchase. And so
  158. 6:06this is 4K * 3 / 10 * 1 / 3 * 10%. So,
  159. 6:13I'll cut the threes here and I have 4K /
  160. 6:16100, which is 40. Okay, so this is the
  161. 6:19number of new clients coming in every
  162. 6:21month. Now,
  163. 6:23since this is also the number of old
  164. 6:25customers leaving, and I know that they
  165. 6:27stay
  166. 6:283 years or 36 months. So, basically I
  167. 6:31have to divide
  168. 6:3340 by 1 / 36, which is the same as
  169. 6:37multiplying 40 by 36.
  170. 6:39And I'm going to call 36 40 minus 10% to
  171. 6:43make this simpler, as I've done in the
  172. 6:45other drills a ton of times. So, this is
  173. 6:4840 * 40 minus 10% of that, of 40 * 40.
  174. 6:52So,
  175. 6:5340 * 40 is 1,600.
  176. 6:5610% of that is 160, and so 1,600 minus
  177. 7:00160 is
  178. 7:031,440.
  179. 7:05So, this is the number of clients that I
  180. 7:08currently have.
  181. 7:10Now, we just need to multiply that by my
  182. 7:12current price, which is 2,000. So,
  183. 7:151,440 * 2 is
  184. 7:192,880.
  185. 7:21And now I got to add on the thousand, so
  186. 7:23this is basically 2.88 million.
  187. 7:27So, around $3 million.
  188. 7:29This
  189. 7:30This is a little bit scary to me. It
  190. 7:33looks like
  191. 7:34the investment that we would need to
  192. 7:36make that we were talking about in the
  193. 7:38context of this question is almost a
  194. 7:40year worth of revenue. So, it's 2/3 of a
  195. 7:43year worth of revenues.
  196. 7:45So, the next thing I would do is
  197. 7:46definitely size the benefit of this
  198. 7:48investment to see if it's it's worth it
  199. 7:51or if it's even worth looking at cuz
  200. 7:53honestly, it's got to be a huge
  201. 7:55difference to make up for
  202. 7:598 months of revenue.
  203. 8:01All right. Now,
  204. 8:03I want to before I move on to the next
  205. 8:05question, I want to go through a quick
  206. 8:07lesson here with you cuz I think this is
  207. 8:10the biggest lesson from this one
  208. 8:12question. It's the reason I broke it
  209. 8:13down into this specific question. I
  210. 8:16broke I broke this case down into this
  211. 8:17specific question because I wanted you
  212. 8:19to learn this.
  213. 8:21And it is basically the idea that you
  214. 8:23can find the
  215. 8:25total revenues of this client just by
  216. 8:29knowing the size of a small segment and
  217. 8:32what that small segment represents of
  218. 8:34the whole. So, now in this case, I know
  219. 8:36that
  220. 8:38the number of clients coming out of the
  221. 8:40base were 40 every month. And I also
  222. 8:43knew that the number of customers
  223. 8:45leaving the base every month were
  224. 8:481/36
  225. 8:50of the base. So, what this means is that
  226. 8:52there
  227. 8:53the number of clients coming out or
  228. 8:55going in would fit 36 times into the
  229. 9:00customer into the customer base. So,
  230. 9:02basically to find the customer base, I
  231. 9:04multiplied the number of customers
  232. 9:06coming in or going out, it's the same,
  233. 9:08which is 40, by 36, which is the number
  234. 9:11of times they would fit in the full
  235. 9:13client base.
  236. 9:15And I wanted you to learn this because
  237. 9:17it's not intuitive and it might appear
  238. 9:20several different times when doing the
  239. 9:23when doing cases. And if you already
  240. 9:24know this unintuitive structure, this
  241. 9:27unintuitive math trick, then you're a
  242. 9:29lot better off. Okay? Another ideas of
  243. 9:33places where this could appear is So,
  244. 9:35basically,
  245. 9:36let's say you're doing a case on a
  246. 9:37specific market, and you know that the
  247. 9:40market growth is 2%. And you also happen
  248. 9:43to know for other reasons the number the
  249. 9:46growth of the market in units. And then
  250. 9:49you can just multiply it by 50 or divide
  251. 9:51it by 2% to find the full market size.
  252. 9:56Or let's say that you know the
  253. 9:58market leader's revenues and you know
  254. 10:01their market share. With that, using the
  255. 10:03same logic, you can find the total
  256. 10:05market size. So, let's say the leader of
  257. 10:07the market has
  258. 10:0810 billion in revenues and it represents
  259. 10:1210% of the market. So, you can tell
  260. 10:16that the total market size is 100
  261. 10:19billion. Okay?
  262. 10:20So, basically, the formula here is that
  263. 10:23we're reversing a simple equation. A
  264. 10:27simple equation which is a part divided
  265. 10:30by the whole
  266. 10:31is equal to the percentage of that part
  267. 10:33on the whole. Like, 3 / 100 is 3%. And
  268. 10:38we're reversing this equation to a part
  269. 10:41divided by the percentage that that part
  270. 10:44represents is equal to the total. So, 3
  271. 10:48/ 3% would be 100. That's the reverse.
  272. 10:52And as I said, this can appear in many
  273. 10:55different cases. So, take note of it,
  274. 10:57write it down, and once you see that in
  275. 11:00a case again, you're going to remember
  276. 11:01me.
  277. 11:02Another quick thing that I want you to
  278. 11:04learn here is that the
  279. 11:07there's a technical term for a concept
  280. 11:09that we used, which is the percentage of
  281. 11:12clients leaving the recurring revenue
  282. 11:16client base every year. So, we have, you
  283. 11:18know,
  284. 11:191,440 clients, and every year we have
  285. 11:23leaving uh a third of those clients,
  286. 11:26right? Because they stay in for 3 years
  287. 11:27on average. And we call that the churn
  288. 11:30rate.
  289. 11:31The churn rate is the percentage of
  290. 11:33clients leaving the client base every
  291. 11:35year.
  292. 11:36Net churn would be
  293. 11:39the
  294. 11:40net number of clients leaving the base
  295. 11:42every year. So, in this case, it'd be
  296. 11:43zero because the number coming in is
  297. 11:45equal to the number going out.
  298. 11:48But, here you go. If you didn't know it
  299. 11:50before, now you know the concepts of
  300. 11:52churn and net churn, what they mean, if
  301. 11:54they appear, you know what they're
  302. 11:55talking about.
  303. 11:58Now, let's move on to question number
  304. 11:59two. Basically, what we want to know is
  305. 12:03can you figure out what the revenues
  306. 12:05would be with this new software once
  307. 12:08revenues reach stability, assuming that
  308. 12:11nothing else changes, prices, capacity,
  309. 12:14anything.
  310. 12:15Okay? Now, pause the video, get to your
  311. 12:18answer, and then listen to mine.
  312. 12:21I would solve this case for the future
  313. 12:24revenues in two simple steps. First, I'd
  314. 12:27find the multiple
  315. 12:30of change of the revenues simply by
  316. 12:32finding the change in each of the
  317. 12:35drivers of revenues cuz I calculated the
  318. 12:37revenues simply by using
  319. 12:39the numbers in the sales funnel, right?
  320. 12:41And then dividing it by the average time
  321. 12:43the customer stays in the base. And
  322. 12:46since the average time didn't change as
  323. 12:48per the case question, then I can just
  324. 12:52find how each of the drivers changed,
  325. 12:54and then I'll find the multiple that I
  326. 12:56can multiply my revenues by and find the
  327. 12:58future revenues. Of course, step two
  328. 13:00will be multiplying this multiple by the
  329. 13:04current revenues that I found, and then
  330. 13:06I'll get to the final answer.
  331. 13:08So, let's move on to step number two,
  332. 13:10asking questions. And I don't really
  333. 13:13have any questions in this case. I if
  334. 13:16the interviewer hadn't stated that
  335. 13:19everything else was staying the same, I
  336. 13:21had
  337. 13:22to confirm that all the other drivers
  338. 13:24other than the sales funnel were not
  339. 13:26changing. And let since they already
  340. 13:28said they're the same, so I don't have
  341. 13:31any questions. Now, I'm moving on to
  342. 13:32step number three, calculating my
  343. 13:34answer.
  344. 13:36So, here I have the funnel numbers from
  345. 13:38before that I'd already written. And now
  346. 13:41I know that after this change, I will be
  347. 13:45still talking to 4,000 clients, but the
  348. 13:48percentage of those that answer the the
  349. 13:50get on the phone is 40% now. The
  350. 13:54percentage that is
  351. 13:55joins the free trial is 1/2 now, and the
  352. 13:58percentage that buys now 12%. So, the
  353. 14:01change here, no change to the number of
  354. 14:05people we call,
  355. 14:06but the
  356. 14:08percentage that get on the phone with us
  357. 14:10changes by 4/3, right? Which is 40% /
  358. 14:1430% 4/3.
  359. 14:17The percentage that get into the free
  360. 14:19trial changes by 3/2. It's 50% larger.
  361. 14:23Right? 1/2 over 1/3 is 3/2.
  362. 14:27And the percentage that buy
  363. 14:30increases by 20% or it's a multiplied by
  364. 14:341.2.
  365. 14:35And so,
  366. 14:374/3 * 3/2 * 1.2 is 2.4. So, this is by
  367. 14:43how much the revenues are going to
  368. 14:45increase because basically
  369. 14:47what I have is an equation, and I'm
  370. 14:49going to write it down here for you. So,
  371. 14:51calls * percentage responded *
  372. 14:54percentage free * percentage that buy
  373. 14:57equals revenue. And if I multiply each
  374. 15:01of these by a different number,
  375. 15:04then my new revenues are going to be
  376. 15:06multiplied by a number that is the
  377. 15:09product of those. So, here I have 4/3
  378. 15:12multiplied by 3/2 multiplied by 1.2, and
  379. 15:17this is 2.4.
  380. 15:19My previous revenues were 2.88 million.
  381. 15:23Would you mind if I rounded this to 2.9
  382. 15:26million or maybe 3 million? 2.9 would be
  383. 15:29just a 0.02 change. It's just a little
  384. 15:32bit, almost nothing. And even 3 million
  385. 15:35would be less than a 3% change.
  386. 15:38And let's say the interviewer says they
  387. 15:40will only allow me to
  388. 15:42to round it to 2.9 million. So, 2.9
  389. 15:46million * 2.4. I'm going to break this
  390. 15:49down. 3 million * 2.4
  391. 15:530.1 * 2.4. Okay? So,
  392. 15:583 million * 2 is 6 million. 3 million *
  393. 16:020.4 is
  394. 16:041.2 million. So, this is 7.2 million.
  395. 16:087.2 million - 0.24 million is 6.96
  396. 16:14million. So, this is
  397. 16:17my
  398. 16:18new revenues after the change. When
  399. 16:20they're stable, they will be
  400. 16:236.96 million or around 7 million.
  401. 16:27And now this is looking a lot better for
  402. 16:29this investment. Not only did the
  403. 16:31revenues increase by
  404. 16:34over 200%,
  405. 16:36but the increase is also a lot greater
  406. 16:38than the investment. The investment was
  407. 16:412 million if I recall correctly, and
  408. 16:44revenues increased from around 3 million
  409. 16:45to around 7 million. So, it's around
  410. 16:48double the investment. Next thing I
  411. 16:50would look at is the profit margin that
  412. 16:53we have, or rather the marginal profit
  413. 16:55margin of this change, to see whether it
  414. 16:59would pay off this investment or not.
  415. 17:01And before I we move on to question
  416. 17:03number three, I want to touch on just a
  417. 17:06single lesson here. Again, the reason I
  418. 17:08divided this case into these three
  419. 17:11questions and specifically into this
  420. 17:13question number two,
  421. 17:14and that is
  422. 17:16in this case finding the deltas or the
  423. 17:20multiplier for each of the drivers was
  424. 17:23so much faster than calculating the full
  425. 17:26revenue again. Right, I could have done
  426. 17:29the same thing as I did in the case
  427. 17:30before. Right, had
  428. 17:33the 4,000 multiplied by all of those
  429. 17:35percentages.
  430. 17:37So, by 40%, by 1/2, by 2% and then
  431. 17:41divide multiply that by 36 and I'd get
  432. 17:44to a number that is the same. But,
  433. 17:48since I knew that
  434. 17:50I could find simply the changes in the
  435. 17:52drivers and multiply the revenue that I
  436. 17:54had before, I could do this so much
  437. 17:57faster. And this question is not
  438. 18:00actually unfeasible even though it was
  439. 18:02very simple,
  440. 18:03the interviewer might want to see if
  441. 18:06you're able to find this quicker path
  442. 18:08because it's something that it's a skill
  443. 18:10that if you hone and if you have,
  444. 18:13once you're in consulting it might be
  445. 18:15super useful cuz if you can do an
  446. 18:17analysis that could take a week in only
  447. 18:20one day or anything any kind of savings
  448. 18:23in this order of magnitude, you're
  449. 18:25saving the client a ton of money and
  450. 18:28you're making them a lot more satisfied.
  451. 18:30And so, this means a lot to the partner
  452. 18:33and to the firm. And so, basically this
  453. 18:35is something that they are actively
  454. 18:36looking for.
  455. 18:38Now, let's finally move on to question
  456. 18:41number three which is
  457. 18:43should your client move on with this
  458. 18:46investment or not? And of course, the
  459. 18:48questions that we've answered before are
  460. 18:51going to help answer this one, but
  461. 18:52there's still a long way to go.
  462. 18:55And before you and I start solving this
  463. 18:58case, I want to make a quick comment
  464. 18:59here because this is the
  465. 19:01first and only investment analysis
  466. 19:04question that we're doing in this in
  467. 19:06this short course.
  468. 19:07Basically, there are several ways to
  469. 19:10decide
  470. 19:11if an investment is worth doing or not,
  471. 19:14right? You don't want to simply see
  472. 19:17if profits are positive or negative
  473. 19:19because you want to take into account
  474. 19:21value of money in time, which means
  475. 19:25money today is worth more than money
  476. 19:27tomorrow. And of course, you also want
  477. 19:29to take into account that there are
  478. 19:31other stuff you could do with that money
  479. 19:32as well.
  480. 19:34And among the several ways to benchmark
  481. 19:37your investment returns and see if it's
  482. 19:40worth doing, some of them are
  483. 19:42payback time. So, a client might say,
  484. 19:45"My money must be back into my account,
  485. 19:48the full money that I invested in 2 or 3
  486. 19:51or 5 years." Right? There's a discount
  487. 19:54rate method. So, you could discount the
  488. 19:57cash flows into
  489. 20:00all to the present value, compare it to
  490. 20:02the value of the investment that you're
  491. 20:03making, discount the all of the future
  492. 20:05investment as well, and get to the net
  493. 20:08present value. This is basically the
  494. 20:10discounted cash flow method. Or you
  495. 20:13could have a return rate expected. So,
  496. 20:15you'll see
  497. 20:16based on the discount rate and the cash
  498. 20:18flows, what is the return rate that you
  499. 20:21can expect? And if it's greater than
  500. 20:23your cost of capital, then you can do
  501. 20:25it. If it's not, then you won't do it.
  502. 20:27And
  503. 20:29I would definitely suggest you ask your
  504. 20:31interviewer
  505. 20:32even before structuring your all of your
  506. 20:35investment analysis if they haven't
  507. 20:37mentioned it. If they have a preferred
  508. 20:39method, if they have a benchmark. So,
  509. 20:42you might ask them if they have a
  510. 20:43preferred method or you might ask them
  511. 20:44if they have a specific payback time
  512. 20:47that they want or a specific return rate
  513. 20:50that they expect. Okay? And
  514. 20:54in this case, the reason I'd ask this as
  515. 20:56soon as possible is because it
  516. 20:58completely determines what structure
  517. 21:00you're going to use. If it's a more
  518. 21:02complex case or if it's a more complex
  519. 21:05method like the discounted cash flow,
  520. 21:08you might need a more complex structure.
  521. 21:10Usually in case interview, you're not
  522. 21:13going to get a very complex cash flow,
  523. 21:15you know, with ups and downs all the way
  524. 21:17which you have to discount entirely.
  525. 21:19You're hardly ever going to have to do a
  526. 21:21ton of compound math with pen and paper.
  527. 21:24That hardly ever makes sense.
  528. 21:26But, sometimes that might be what the
  529. 21:28interviewer wants. And of course, the
  530. 21:31interviewer appreciates you giving them
  531. 21:33the choice and you showing them that you
  532. 21:35know that these exist, you know it can
  533. 21:37be more complex, you know it can be less
  534. 21:38complex.
  535. 21:40And usually they're going to give you a
  536. 21:41simple method and you're also going to
  537. 21:43get a simple cash flow structure.
  538. 21:45And one thing that you should know is
  539. 21:47that many times the interviewer is not
  540. 21:49going to give you a an answer to this.
  541. 21:52They're not going to prefer anything.
  542. 21:53They just want you to tell them whether
  543. 21:56they should do it or not. And then,
  544. 21:58you've got to choose your own method and
  545. 21:59then you've got to create your own
  546. 22:00structure based on that. But let's say
  547. 22:02that in this specific case, I did get an
  548. 22:04answer and that answer is the client
  549. 22:07wants their money back in 2 years.
  550. 22:10All right. So, let's move on to the
  551. 22:12answer. Pause the video right now and
  552. 22:15come up with your answer.
  553. 22:18So, I would solve this case in four
  554. 22:21different steps. Step number one, I
  555. 22:23would find the difference in profits
  556. 22:26between the client with the investment
  557. 22:30when stable and without the investment
  558. 22:33when stable. And then,
  559. 22:35I'm going to chart that into a formula
  560. 22:38because those profits are going to grow
  561. 22:39steadily. Every month we're going to get
  562. 22:42a little bit more clients than than are
  563. 22:44leaving our base
  564. 22:45for 3 years until
  565. 22:48the clients that we acquired 3 years
  566. 22:49before are leaving the base and that
  567. 22:51brings us to stability again except with
  568. 22:54a lot more clients like we calculated in
  569. 22:56question number two.
  570. 22:57Right? And so, I've I would charge that
  571. 23:01into a steady increase and draw formula
  572. 23:06for it
  573. 23:07where I plug in the time and I get the
  574. 23:10difference in profits or the monthly
  575. 23:12profits.
  576. 23:14And then I would use that formula to
  577. 23:16find the profits in 2 years that our
  578. 23:20client would have.
  579. 23:21Because that's how that's when we want
  580. 23:24the investment to be paid back. And then
  581. 23:26I would add up all of the profits during
  582. 23:28those 2 years
  583. 23:30or the increase in profits of those 2
  584. 23:33years and I would see if it paid off the
  585. 23:36investment or not. All right. Now, I do
  586. 23:39have just a couple of questions that I
  587. 23:42would need to I would need to have the
  588. 23:44answer to to start doing this case. So,
  589. 23:47would you mind if I ask them now? And
  590. 23:48let's say the interviewer says that's
  591. 23:49okay. And question number one is
  592. 23:52do we know what is the profit margin
  593. 23:55that our client has and if that profit
  594. 23:58margin will change over the years?
  595. 24:00Because of course, we can only pay our
  596. 24:03investments with our profits, not with
  597. 24:05our revenues. Of course, we don't it
  598. 24:07wouldn't work to only know the
  599. 24:09difference in revenues. We need to know
  600. 24:11the difference in profits.
  601. 24:12And let's say that the interviewer tells
  602. 24:14me that the profit margin is 75%
  603. 24:17but I also want to know if
  604. 24:19that will be different because we're
  605. 24:20going to scale this company a lot. So,
  606. 24:22profit margin might increase because we
  607. 24:25now have more customers to scale. And
  608. 24:28let's say the interviewer tells me no
  609. 24:30profit margin's not going to change.
  610. 24:31It's always going to be 75%. Now, the
  611. 24:33second question I have is whether our
  612. 24:36customers pay us in advance
  613. 24:39or if they pay us in the end of the year
  614. 24:42because that totally changes how much
  615. 24:45revenues we're going to get in those 2
  616. 24:48years since it's seem like it's an
  617. 24:50yearly payment. And let's say that the
  618. 24:52interviewer tells me that we can assume
  619. 24:55that they pay monthly even though we
  620. 24:57gave me they gave me a
  621. 25:00yearly price. Assume that the
  622. 25:03new customers and old customers pay
  623. 25:05monthly.
  624. 25:06All right. So, I think I'm ready to move
  625. 25:09on to calculate.
  626. 25:11So, now is the time to pause the video
  627. 25:13and solve the case by yourself if you
  628. 25:16haven't done this yet.
  629. 25:19All right, step one.
  630. 25:21Finding the difference in profits
  631. 25:23between right now and what profits will
  632. 25:26be once we've implemented this change.
  633. 25:29So, basically what I'm going to do is
  634. 25:30find the difference in revenues and
  635. 25:33multiply it by the profit margin.
  636. 25:35Since revenues are now would you mind if
  637. 25:39I approximated or rounded the
  638. 25:43new revenues to 7 million and the old
  639. 25:46revenues to 3 million. And let's say the
  640. 25:48interviewer says that is fine. So,
  641. 25:51the difference between 7 million and
  642. 25:543 million is 4 million. That's a
  643. 25:56difference in revenues times the profit
  644. 25:57margin of 75%.
  645. 25:59That is 3 million. So,
  646. 26:02right now profits are zero. If we
  647. 26:04implement the change right now, it will
  648. 26:07take 3 years, actually 3 years and 1
  649. 26:09month because there's the
  650. 26:11free trial month.
  651. 26:14And then our profits will be
  652. 26:173 million more than our profits are
  653. 26:19today.
  654. 26:20For now, I'm going to forget about this
  655. 26:22free month and then I'm going to take it
  656. 26:25back into consideration in the end of
  657. 26:27the of the problem. So, what I'm going
  658. 26:30to do right now is step number two. I'm
  659. 26:32going to actually draw a chart
  660. 26:34with the Y axis being the difference in
  661. 26:38profits.
  662. 26:39So, it starts in zero cuz difference in
  663. 26:42profits from right now to right now is
  664. 26:43zero.
  665. 26:44And on the X axis, I'm going to have
  666. 26:47time. So, profits are going to slowly
  667. 26:49grow from the moment I implement change
  668. 26:52until the moment revenues and profits
  669. 26:55start stable again.
  670. 26:57And so what I have here is that in 3
  671. 26:58years
  672. 27:00our increase in profits will be 3
  673. 27:03million. And this is going to be a
  674. 27:05straight line, forgetting about the free
  675. 27:08trial month, okay?
  676. 27:10Which is only going to move this line a
  677. 27:12little bit to the right, anyway.
  678. 27:14So this is basically the formula here.
  679. 27:17Given that I'm assuming that they pay
  680. 27:19monthly, then this would be
  681. 27:21a a bunch of dots instead of a a
  682. 27:24straight line, but I'm going just going
  683. 27:26to assume that this is a linear function
  684. 27:29rather than a bunch of dots.
  685. 27:31And basically the accumulated profits
  686. 27:34are the area of the triangle, right?
  687. 27:36Mhm. First, I want to find what the
  688. 27:40profits are going to be in year number
  689. 27:42two. And since in
  690. 27:453 years it's going to be 3 million in
  691. 27:47revenues in difference in profits, I
  692. 27:50know that in 2 years it's going to be 2
  693. 27:53million, right? This is a simple chart.
  694. 27:55And so to get to the accumulated
  695. 27:58profits, as I said, I just need to find
  696. 27:59the area of this triangle, because
  697. 28:02it's the sum of the yearly profits from
  698. 28:06each moment, okay?
  699. 28:08And so this is basically the basis times
  700. 28:11the height of the triangle divided by
  701. 28:13two. And so 2 years times 2 million
  702. 28:17divided by two, this gives me 2 million.
  703. 28:19That's the accumulated profits over
  704. 28:22these 2 years. But I do have to consider
  705. 28:26that this 1 month of free trial.
  706. 28:29And honestly, I would go back and
  707. 28:31reconsider my approximations because now
  708. 28:34that we are right on top of the of the
  709. 28:37goal, we need to figure out if it's a
  710. 28:40little bit above or a little bit below.
  711. 28:42But to be honest, this is not the point.
  712. 28:45I think this
  713. 28:46Doing this would completely miss the
  714. 28:48point. And even considering the free
  715. 28:50trial month would completely miss the
  716. 28:52point, especially if we didn't make the
  717. 28:54investment because
  718. 28:56even if it's a little bit more than 2
  719. 28:59years that it takes to repay the
  720. 29:00investment, let's say it's 2 year and 2
  721. 29:02months or something.
  722. 29:05Right? If you look at it, the profits
  723. 29:08are still growing and they're growing a
  724. 29:09lot. And so,
  725. 29:11in 2 years we might accumulate around $2
  726. 29:14million
  727. 29:15in profits. But, in year three, look at
  728. 29:17the area of the of this triangle. It's
  729. 29:203 * 3 / 2. It would give me 4.5 million,
  730. 29:24the accumulated profits in year until
  731. 29:26year three.
  732. 29:28If I subtract the profits until then,
  733. 29:30which are $2 million, just year three
  734. 29:32would give me $2.5 million in profits.
  735. 29:36This means that only year three in year
  736. 29:39three alone would pay the investment and
  737. 29:41have an extra.
  738. 29:42And in 3 years, we would have
  739. 29:47uh
  740. 29:484.5, it's over two times the revenues of
  741. 29:51the investment back. And then, from then
  742. 29:53on, we would have $3 million more of
  743. 29:57profits every single year, which is more
  744. 29:59than the investment. So, even if the
  745. 30:01payback time is a little bit more than 2
  746. 30:03years, unless this is a hard no from our
  747. 30:06client for some reason, I would
  748. 30:07definitely recommend going forward with
  749. 30:09this investment. And if it is a hard no
  750. 30:13for some reason, like we have specific
  751. 30:16debt that we need pay by those 2 years,
  752. 30:19I would probably recommend that the
  753. 30:21client go find a way to be able to make
  754. 30:24this investment anyway, because it
  755. 30:25sounds like a really, really good
  756. 30:27investment, a really good opportunity.
  757. 30:29Okay?
  758. 30:30Now, I want to talk about three lessons
  759. 30:33from this third question. So, you got
  760. 30:35two important lessons from the previous
  761. 30:37two questions, but here there are a few
  762. 30:40more. Number one,
  763. 30:42notice that
  764. 30:43the interviewer in the case question
  765. 30:45omitted the profit margin and the
  766. 30:48existence of a profit margin in general.
  767. 30:50We're talking about revenues, revenues,
  768. 30:52revenues, never mentioned profits, but
  769. 30:54then when they started doing the
  770. 30:56investment analysis,
  771. 30:58I absolutely needed to come up with
  772. 30:59this. And of course, you can only pay
  773. 31:03for your investment using profits. You
  774. 31:05can't pay using revenues, otherwise you
  775. 31:07don't have any money to pay for your
  776. 31:09costs.
  777. 31:10And it was not a coincidence that this
  778. 31:12happened.
  779. 31:13This is something that
  780. 31:15you need to be wary of when you're in
  781. 31:18consulting. Like
  782. 31:20everyone's seeing a problem, everyone in
  783. 31:23the client firm is seeing a problem one
  784. 31:24way, right? They're talking about it in
  785. 31:27their own terms.
  786. 31:29And a consulting firm needs to come and
  787. 31:31be able to give an outsider look from
  788. 31:34first principles with a clear mind.
  789. 31:37And that means also
  790. 31:39thinking from the problem
  791. 31:41not only in the terms that they are
  792. 31:43talking about, not only in the terms and
  793. 31:45in the variables that they're using, but
  794. 31:47in all the terms and variables that are
  795. 31:49relevant. So, if you're able to come up
  796. 31:52with the idea that you should use the
  797. 31:54profit margin here
  798. 31:56and only consider profits rather than
  799. 31:58revenues in the payment of the
  800. 32:00investment, you are showing that you
  801. 32:03will be a consultant who gets to the
  802. 32:05client side and can think about the
  803. 32:07problem in your own terms and perhaps
  804. 32:09come up with a solution that they
  805. 32:10haven't thought of, which is super
  806. 32:12important to do as a consultant. Lesson
  807. 32:15number two,
  808. 32:16and this is this might be repetitive cuz
  809. 32:19I talked about in the beginning of the
  810. 32:20case, but I it needs to be
  811. 32:22re-emphasized.
  812. 32:24Every investment analysis needs a method
  813. 32:28to analyze an investment. You need to
  814. 32:30use a method. And it can be multiples,
  815. 32:33it can be the payback time, it can be
  816. 32:34the the rate, it can be discount cash
  817. 32:37flow,
  818. 32:38and asking the interviewer which one
  819. 32:41they want you to use and what their
  820. 32:42benchmark is, like what their return
  821. 32:45rate expected is or what the
  822. 32:48payback time that they want is
  823. 32:50is a good idea. You should always do
  824. 32:52this, but beware, many times they are
  825. 32:54not going to give you an answer to that.
  826. 32:57They are going to say, "Just tell me if
  827. 32:58I need to do it or not." And then, of
  828. 33:01course, you are going to have to pick
  829. 33:02one, okay? And it's going to depend on
  830. 33:05the complexity of the cash flows and on
  831. 33:07the complexity of the case. But
  832. 33:08generally, in case interviews, the
  833. 33:11cash flow structure is not going to be
  834. 33:13very complex. And of course, you need to
  835. 33:15have an idea in your mind of what is a
  836. 33:17good return rate and what is not.
  837. 33:21And lesson number three is
  838. 33:25this idea of drawing a chart and
  839. 33:30finding the function for profits in
  840. 33:33terms of time. Once we do the change and
  841. 33:36using a little graph, drawing on the
  842. 33:39paper and finding the area of a
  843. 33:41triangle, this is definitely a tool that
  844. 33:43you will benefit if you have it in your
  845. 33:45toolkit because sometimes it's just
  846. 33:47going to be so much easier to draw than
  847. 33:50to make formulas or explain things with
  848. 33:53words. This is something that you need
  849. 33:54to have.
  850. 33:56And even if you're doing Zoom interviews
  851. 33:58or video call interviews, have pen and
  852. 34:00paper with you. Have a few spare papers
  853. 34:02so that you can draw large charts on it
  854. 34:05or large tables and then show them to
  855. 34:06your interviewer on your camera.
  856. 34:09All right. Everyone, this is it for
  857. 34:11today's video. I hope this was helpful
  858. 34:13to you. I guess this is it for the
  859. 34:14quantitative analysis module as a whole.
  860. 34:17So, I hope this was fun to you. I hope
  861. 34:19it was helpful as well, most
  862. 34:20importantly. And I'll see you in the
  863. 34:22next one.

About this transcript

This page contains the full transcript of Case Interview Fundamentals: Lesson 27 [Drill: B2B Software as a Service] by CraftingCases, generated from the public captions YouTube serves with the video. The transcript has 5,577 words across 863 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.