Stage 1 (2022) “Tiered Waterfall”

This case is dealing with a real estate model, forecasting cashflows for an office building. The case is split into 2 parts – part 1 deals with modeling operational cashflows and part 2 deals with the cashflow waterfall.

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 500 regular points + 50 Extra Points for the bonus questions, 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