Project Finance Model - Power Generation (Gas)

• Return and cash-flow analysis – Calculates levered and unlevered IRRs, MOIC and other equity and project KPIs. Provides cash-flow waterfalls and CFADS profiles.
• Advanced debt sizing – Uses macros to size debt based on target leverage ratios or DSCR; supports senior debt with sculpting, refinancing and mezzanine bullet repayment (with sinking-fund modelling).
• Flexible tariff and cost modelling – Handles capacity-charge and variable O&M tariffs (both hard-coded and formula-based) with escalators, heat-rate curves and start-up costs.
• Detailed CAPEX and construction schedule – Separates direct, indirect, pre-financial-close and owner costs with contingencies and success fees. A configurable S‑curve allocates capex across development and construction periods.
• Scenario and sensitivity analysis – Compare multiple cases side-by-side by changing dates, plant capacities, gas prices, heat rates and operating assumptions. Built-in sensitivity tables analyse IRRs under different capacity-charge and O&M charge assumptions.
• Tax and depreciation – Includes MACRS depreciation schedules (switchable between monthly, quarterly or semi-annual periods) and property/federal tax inputs.
• Dashboard and charts – A dashboard tab summarises key metrics, while charts visualise CFADS, DSRA balances and principal repayments.
• Adjustable periodicity – Model can be set to monthly, quarterly, semi-annual or annual periodicity via macros.

Inputs:

• Capacity & availability assumptions
• Fuel (gas price) and heat-rate curves
• Capacity charge & O&M tariff settings (incl. escalators)
• CAPEX breakdown and construction schedule (incl. S-Curve)
• Financing structure: leverage, tenor, DSCR target, refinancing & mezzanine options
• Tax, depreciation and working-capital assumptions

Outputs:

• Project & equity IRR, MOIC and payback metrics
• CFADS and full cash-flow waterfall
• Senior & mezzanine debt schedules, DSRA and refinancing impacts
• Financial statements & capex / depreciation schedules
• Scenario & sensitivity analysis for tariffs, fuel price and cost assumptions

‍