Here is a comprehensive walkthrough guide for the Excel on Rocky Top case “Down to EBITDA” provided by one of our faculty fellows, Diarmuid Early. The case is available in your ExPrep account in folder Excel on Rocky Top. Try it yourself, and if you get stuck, look for the solution in the videos.

TASK
Sweets, Candies and More, Inc. (SCM) is a fast-growing manufacturer of sweets and candies in the fictional country of Neverlandia. You have recently joined the company’s finance department and were assigned to a team that works on a 10-year financial forecast for capital raising. You were given a task to summarize SCM’s revenues and expenses down to EBITDA for 2022 and to forecast them for the next 10 years. Then your colleagues will add the remaining parts to the financial model.
WALKTHROUGH VIDEO PROVIDED BY DIARMUID EARLY
This video was recorded when Diarmuid completed this case as part of the Financial Modeling World Cup stage.
So take into account his comment: This has the usual caveats of my live attempts:
(i) I’m rushing, so not always explaining myself very clearly (it will be easier to understand if you try the questions first), and
(ii) I sometimes (OK, often) make mistakes or don’t follow the optimal path. That said, this is the fastest I’ve ever finished a FMWC round by a wide margin, so I obviously didn’t waste too much time!
© 2022-2026 Microsoft Excel Collegiate Challenge. All rights reserved.