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 firstname.lastname@example.org