Lesson Objective: To build the detailed operational phase model, including the revenue and operating expense projections, the construction of the senior debt repayment schedule (including sculpting and amortizing debt), and the design of the comprehensive “Cash Flow Waterfall” that allocates available cash to operating costs, debt service, reserve accounts, and equity distributions.

In-Depth Notes:

1. The Revenue and Operating Expense Model:
The operational phase revenue and expenses are driven by the project’s specific operating characteristics.

• Revenue Modeling: Revenue is typically derived from an offtake agreement (e.g., a PPA for a power plant, a concession agreement for a toll road).

  • Capacity Payments (Take-or-Pay): Under a take-or-pay agreement, the off-taker pays a fixed fee for the capacity (availability) of the project, regardless of whether it actually uses the output. This provides a guaranteed, “tolling” revenue stream that covers the project’s fixed costs and debt service.

  • Energy Payments (Variable Output): In addition to capacity payments, the project may receive payments based on actual output (e.g., kilowatt-hours produced, cars using the toll road). This is a variable revenue stream that depends on demand and market prices.

  • Renewable Energy Credits (RECs) / Guarantees of Origin (GOs): For renewable projects, revenue may also come from the sale of RECs (US) or GOs (Europe), which are tradable certificates representing the environmental benefits of the project. The model must incorporate a separate schedule for REC/GO revenue, based on government-issued credits (e.g., one REC per MWh of renewable energy produced).

• Operating Expenses (OPEX): Operating expenses are divided into two categories:

  • Fixed OPEX: Costs that do not vary with output (e.g., insurance, administrative costs, fixed O&M fees). These are typically escalated annually with inflation.

  • Variable OPEX: Costs that vary directly with output (e.g., fuel costs for a gas-fired power plant, or toll collection costs that vary with traffic volume). Variable OPEX is usually modeled as a cost per unit of output (e.g., $/MWh,$/toll transaction).

2. Debt Sizing and the Debt Repayment Schedule:
The debt sizing process (determining how much debt the project can support) is the most critical financial calculation in project finance.

• The “Debt Sizing” Constraint: The maximum debt capacity is the amount of debt that can be serviced by the project’s projected cash flows. The lenders will not lend more than the project can repay.

  • The “Annuitized” Debt: The debt is often structured as an annuity, meaning the total debt service (principal + interest) is constant over the life of the loan.

  • The “Sculpted” Debt: In “sculpted” debt, the principal repayment is designed to match the project’s expected cash flow profile, often with a “mini-perm” (a short-term loan that is refinanced after 5-7 years) that converts to a longer-term amortizing loan.

• The Debt Service Coverage Ratio (DSCR): The DSCR is the primary metric for determining debt capacity.

  • Formula: DSCR = (Cash Flow Available for Debt Service - CFADS) / Total Debt Service (Principal + Interest).

  • CFADS: Cash Flow Available for Debt Service = EBITDA – Cash Taxes – Maintenance CAPEX – Changes in Working Capital.

  • The Minimum DSCR: Lenders require a minimum DSCR of 1.20x to 1.30x under the base case. If the base case DSCR falls below this threshold, the debt must be reduced (equity must be increased). If the downside case DSCR is below 1.0x, the project is not “bankable.”

• The “Sculpting” Process (Goal Seek): The model uses Goal Seek to determine the maximum debt size that satisfies the minimum DSCR constraint. The target cell is the project’s DSCR, the changing cell is the debt amount, and the target value is the minimum DSCR (e.g., 1.30x). This is the standard global practice for project finance debt sizing.

3. The Cash Flow Waterfall (The Seniority of Payments):
The Cash Flow Waterfall is the defining feature of a project finance model. It dictates the strict order in which cash is distributed, ensuring that senior obligations are met before junior obligations receive any cash.

• The “Tier 1” – Operating Costs: The project must first pay its operating costs (O&M, fuel, insurance, etc.). Failure to pay operating costs would result in the project shutting down (a catastrophic event for lenders).

• The “Tier 2” – Senior Debt Service: The next priority is the repayment of the senior debt (interest and principal). Any cash remaining after debt service is available for distributions to equity.

• The “Tier 3” – Reserve Account Funding: The project must maintain several reserve accounts to provide liquidity buffers.

  • The Debt Service Reserve Account (DSRA): A cash reserve equal to 3 to 6 months of debt service. If the project has a cash flow shortfall, it can draw on the DSRA to make its debt payments. This is a non-negotiable requirement for most international lenders.

  • The Maintenance Reserve Account (MRA): A reserve for future planned maintenance CAPEX (e.g., major overhauls every 5 years). The project funds this account monthly, ensuring it has the cash to pay for scheduled maintenance.

  • The Revenue Account: The collection account where all revenue is deposited. The model allocates cash from the Revenue Account to the various sub-accounts.

• The “Cash Sweep” (Excess Cash Flow): After funding all reserve accounts and making debt service payments, any remaining cash can be distributed to the sponsors as dividends.

  • The “Minimum Cash Balance” Rule: The model ensures that a minimum cash balance is maintained in the Revenue Account at all times. Excess cash above this minimum is swept into the DSRA (up to the target DSRA balance) and then distributed to equity.

4. The “Lock-Up” and “Cure” Periods:
If the project’s DSCR falls below a certain trigger level (e.g., 1.10x), the project enters a “lock-up” period. During a lock-up period, all excess cash is “trapped” in the project accounts and cannot be distributed to equity. The cash is used to repay debt faster (deleveraging) to restore the DSCR to acceptable levels. This is a standard protective covenant for project finance lenders. The model must include a “Cure Period” mechanism: if the project enters a lock-up, management has a defined period (e.g., 12 months) to “cure” the default. If the DSCR is not restored by the end of the cure period, the lenders can exercise their right to take control of the project (step-in rights).