andrew@agcapitalcfo.com

Stage 3 (2020) “Diamonds Are Forever”

Professional Excel Templates for your Business

Stage 3 (2020) "Diamonds Are Forever"

This is a case from the Financial Modeling World Cup 2020, Stage 3 (Nov 20-23) competition. It can be used to expand your knowledge of financial modeling and train for future FMWC Stages.

Case description:

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. The client wants to analyze their sales results from December 2019 and wants the data to be categorized by product groups to answer specific questions.

The sales data from December 2019 provided by GOLD Sellers need to be categorized by product groups to answer specific questions, but the client’s 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. The currency conversion should be done without rounding.

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 info@fmworldcup.com
You can also buy tickets to participate in the future FMWC Stages at https://fmworldcup.com/shop/

 

Reviews

There are no reviews yet.

Be the first to review “Stage 3 (2020) “Diamonds Are Forever””

Your email address will not be published. Required fields are marked *