Stage 1 (2020) “Warm-up with AFM”

This case aims to simulate the Advanced Financial Modeler (AFM) designation exam by requiring the construction of revenue, debt, depreciation schedules for Just Around the Corner Inc. (JAC), a retail grocery network in the fictional country of Jabrana.

JAC plans to expand its retail network, but increasing the number of stores means an increase in the number of goods flowing through its logistics center. The company may soon reach maximum capacity, limiting its ability to operate. The case requires building support schedules for a five-year financial model that takes these constraints and other assumptions into account.

This is an actual case from the Financial Modeling World Cup 2020, Stage 1 (Sep 18-21) competition. The downloadable file consists of the following:
–Task: Excel file with given case assumptions and company financials; PDF file with Case Materials; PDF file with Questions.
–Solution: Excel file with the full Solution Model; PDF file with correct Answers in Bold.

This model awarded 250 points, while the whole 2h Stage allowed to earn 1,000 points in total.

For your questions/suggestions/consideration please reach out to the Organizing Committee of the Financial Modeling World Cup at info@fmworldcup.com