Structure the finance

Model funding options and facilities, then adopt the one that drives the study.

The "Finance" sheet is where the deal gets its debt and equity. You can model more than one funding option, each with its own facilities, and adopt the one the study's cashflow is built on.

1. 1

   Read the funding figures

   The top of the sheet shows the "Total limit" of the facilities, the "Cost of finance" and the "Equity in". If the structure cannot fund the project, a banner says "This structure does not fund."

2. 2

   Start from a preset

   "Start from a preset structure" fills in a common arrangement of facilities, with each one's sizing, rate, establishment fee and line fee, for you to adjust.

3. 3

   Work with funding options

   Each funding option is listed with the adopted one badged "Adopted". "New option" adds another; "Adopt this option" makes one the option the study runs on.

4. 4

   Set up the facilities

5. 5

   Check what the cashflow ran