Diamonds Are Forever

Stage 3 (2020) “Diamonds Are Forever”


Global Open Limitless Distributors and Sellers Inc. (GOLD Sellers) wants to analyze their sales results from December 2019 and wants the data to be categorized by product groups to answer specific questions. The problem is, their ERP system reports do not have product categories defined. Instead, each product has many different parameters that need to be evaluated to categorize each item. Additionally, some of the sales were made in US dollars and the report shows prices in both US dollars and the local currency of Prescia, PGD.

Your role is to create a detailed sales analysis for Global Open Limitless Distributors and Sellers Inc. (GOLD Sellers) based on their sales data export from their ERP system.

This is an actual case from the Financial Modeling World Cup 2020, Stage 3 (Nov 20-23) competition. The downloadable file consists of the following:
Task: Excel file with data for the case; 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 400 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