This financial model analyzes a potential investment in the construction of a toll road and incorporates advanced project finance concepts, including:

• Structuring shareholder loans, revolver facilities, and blended equity IRR calculations

• Debt sculpting to meet a target DSCR

• Valuation through Discounted Cash Flow (DCF) and Internal Rate of Return (IRR) analysis

• Building fully integrated 3-statement financials

The model also demonstrates strong Excel and VBA capabilities, such as:

• Macros for scenario analysis and resolving circular references

• Clear and scalable formula design

• Automated model integrity checks

This file was originally built as part of my certification in Complete Financial Modeling for Project Finance in Excel.