Project Finance: Flexing scenarios through a scenario manager & data table

Here we set up the base case for a project finance model, and go through how the scenario manager is connected to the model. We create a data table to measure the outputs and enter a few different cases that equity and debt might use to help analyse a deal - including analysis of the percentage that opex would need to increase by to hit a DSCR of (e.g. lock-up), and running multiple variables at once to emulate a “disaster scenario“. ** NOTE: This video and excel model are from Wall Street Prep’s Ultimate Guide to Project Finance Modeling at and are available through enrollment into the program. HOWEVER: A simplified version of this model is available in Wall Street Prep’s FREE PROJECT FINANCE MODELING course at