andrew@agcapitalcfo.com

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

Professional Excel Templates for your Business

Stage 2 (2022) "PPE: Project Profitability Estimation"

Stage 2 (2022) "PPE: Project Profitability Estimation"

PPE: Project Profitability Estimation is an actual case from the Financial Modeling World Cup 2022, Stage 2 (March 11-14) competition. This case requires doing some data management and analysis in Excel.

Case description:

The objective of this case 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.

Cool Coders is a software development company that needs help with the proper attribution of payroll costs to each project. The company has 100 employees and is working on ten different projects for ten different customers. The typical payment structure for a project is an advance payment, an interim payment, and a final payment. However, the sales revenues are calculated based on the percentage-of-completion method, and salaries are split between projects based on the number of hours worked on each project by each employee. Administrative works are not attributed to any project and are considered as SG&A costs by the company.

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

Reviews

There are no reviews yet.

Be the first to review “Stage 2 (2022) “PPE: Project Profitability Estimation””

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