Stage 1 (2022) “More Fun in Funcity”

As the newly elected mayor of Funcity, you need to plan the development of the city efficiently to increase the value of the houses and tax revenue. Your objectives are to calculate the current value of some of the houses in the city and then make a decision on what to build on the free spots to maximize the value for the residents.

This case is using the same city map as in one of the cases that were played in the quarterfinals of the FMWC Open. The same playground, but a completely different set of questions – no advantage to the players who might be familiar with the case. The last question in this case awards 200 points. It could take a while to solve, but if the structure of your model is efficient right from the start, then this should be worth the time spent. Solving this case is more based on Excel modeling rather than financial knowledge.

This is an actual case from the Financial Modeling World Cup 2022, Stage 1 (January 28-31) competition. The downloadable file consists of the following:
–Task: PDF file with Case Materials; PDF file with Questions; Excel file with Case Assumptions
–Solution: Excel file with full Solution Model; PDF file with correct Answers in Bold

This model awarded 350 regular points + 200 extra points, while the whole 2h Stage allowed to earn 1,250 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