You have been hired to create a 3-way financial projection model and a valuation for Healthy Foods Inc. (HF), a food processing company in the fictional country of Neverlandia, which operates in both the domestic and foreign markets. The objective of this exercise is to test your ability to create a 5-year annual financial model based on historical P&L data and starting balance sheet data, using the provided assumptions.
This is an actual case from the Financial Modeling World Cup 2021, Stage 3 (Mar 26-29) competition. The downloadable file consists of the following:
–Task: Excel file with given case assumptions; PDF file with Case Materials; PDF file with Questions
–Solution: 2 Excel files with full Solution Models for different scenarios; PDF file with correct Answers in Bold
This model awarded 600 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 firstname.lastname@example.org