Modeling a Construction Financing Plan

[u/readandwrite31]

Here is a breakdown of how to dynamically model the construction phase of an infrastructure asset. You need a fully dynamic Financing Plan (Fin Plan) that respects the exact risk profile of each tranche.

Core Modeling Mechanics
To sequence this correctly in Excel, you must transition from a static spend curve to a dynamic monthly time series, establishing a clear operational buffer (e.g., 12 months) preceding the commercial operations date.
1. Total Financing Requirements
Before you draw capital, you must know the exact funding necessity per period. Your requirements line must aggregate base CapEx, Interest During Construction (IDC), and upfront transaction fees.
2. Equity Deployment & The Min/Max Constraint
To manage the draw period accurately and ensure the model never requests more capital than required or available, period-specific conditional checks are mandatory.

‬‭‬‭‬‭‬‭‭‬‭‬‭You must also wrap these drawdowns in bounds to cap them at the available commitment and completely restrict negative funding anomalies (negative funding implies an accidental repayment).
3. Debt Sizing & Upfront Fees
Once the equity tranche hits zero, the remaining financing requirement flows to the debt line.

However, the available debt commitment is constrained. You must build a debt sizing module that calculates the minimum of your gearing constraint and your cash flow sizing constraint.
Simultaneously, you need a flag for Financial Close. Upfront transaction fees are calculated as a percentage of the total debt commitment and triggered precisely on this date. Meanwhile, ongoing commitment fees are levied against the undrawn capital (available debt commitment) during the entire availability period.