Project Finance Excel Model - Feasibility & Debt Sizing Template

Description
Project Finance Model – Flexible, Industry-Agnostic Excel VBA Template
This advanced Project Finance Model is designed to support feasibility studies and financial evaluations across a wide range of industries. Built with flexibility and best practices in financial modeling and VBA, it allows users to easily incorporate diverse revenue streams, cost structures, and financing terms to assess project viability and determine the optimal pricing strategy to meet a target hurdle rate.

🔧 Key Features:

• Flexible cost structures: Supports construction, fixed, and variable operating costs with multiple cost curve options.
• Dynamic timeline: Easily adjust project duration and phasing.
• Multi-currency and indexation support: Apply inflation and FX assumptions to both revenues and costs.
• Tax and depreciation modeling: Includes capital allowances, corporate tax, and VAT refund structures adaptable to various jurisdictions.
• Funding waterfall: Calculates funding needs with three drawdown options—pari passu, debt-first, and equity-first.
• Comprehensive debt modeling: Incorporates upfront fees, commitment fees, interest, and multiple repayment methods (cash sweep, PMT, sculpting).
• Full financial statements: Automatically generates income statement, balance sheet, and cash flow statement.
• Interactive dashboard: Visualizes key outputs including cash flows, equity returns, and funding structure.
• Optimization tools: Includes macros for circularity resolution, error detection, and goal-seek-based price optimization.

This model is ideal for financial analysts, project developers, and investment professionals seeking a robust, customizable tool for evaluating complex projects. Future updates will expand its capabilities even further.


Need help getting started or customizing the model?
Feel free to reach out via private message for support or suggestions.