Project Profitability Estimation

Stage 2 (2022) “PPE: Project Profitability Estimation”


This case requires doing some data management and analysis in Excel. Your role is to help the CFO of Cool Coders estimate the profitability of their projects for the fiscal year 2021 by correctly attributing payroll costs to each project. Participants will need to use Excel knowledge and general logic to manage the provided data.

This is an actual case from the Financial Modeling World Cup 2022, Stage 2 (March 11-14) competition. The downloadable file consists of the following:
Task: PDF file with Case Materials; PDF file with Questions; Excel file with Case Data
Solution: Excel file with full Solution Model; PDF file with correct Answers in Bold

This model awarded 300 regular points, while the whole 2h Stage allowed to earn 1,150 points in total.

For your questions/suggestions/consideration please reach out to the Organizing Committee of the Financial Modeling World Cup at