This is an actual case study that was presented to the participants of the Financial Modeling World Cup 2023, Stage 5 (July 21-24).
You have been made CFO of a new nature reserve SPV featuring several rare and fantastic creatures. Your compensation is based on the IRR achieved over your tenure, which includes the construction year (2050) and the following 10 years, so your goal is to build a financial model that you can use to make good decisions and provide good advice.
The downloadable file consists of the following:
–Task: PDF file with Case Materials; PDF file with Questions; Excel file with Assumptions
–Solution: Excel file with full Solution Model; PDF file with correct Answers in Bold