The IRR Project Finance Analysis forecasts the financial statements for a greenfield infrastructure project and calculates the levered and unlevered Internal Rate of Return (IRR) based on Free Cash Flows.

This is a simplified general industry spreadsheet template, fully FREE and editable in MS Excel.

The financial model template includes:

Executive Summary section with Charts and Key Financial Metrics such as IRR, Payback Period
Financial projections, which include a 30-year forecast of the Income Statement, Balance Sheet, and Cash Flow Statement
Calculation of the Projected Financial Ratios, including liquidity ratios, profitability ratios, bank ratios, and efficiency ratios.
Debt Schedule together with standard Financial Ratios, typically relevant for banks and/or capital providers
Fixed Asset Schedule
Calculation of Funding Required
Uses and Sources of Funds Table
Up to 5 Sources of Revenues included
Assumption Sheet that offers a simple way to input Direct Costs and Operating Expenses, CAPEX, Net Working Capital, and Income Tax Assumptions
Financial Metrics calculation such as the Internal Rate of Return (IRR), Cash on Cash Yield, Payback Period, and Net Present Value (NPV)
Financial metrics are calculated separately for unlevered (project point of view) and levered cash flows (shareholders’ point of view after taking into account debt financing).
Reader and print-friendly layout, including charts and tables

Want to quickly obtain an idea of what kind of IRR your next infrastructure or project finance project might generate? Simply download our template, populate it with your assumptions, and review the financial forecast together with the key financial metrics.

The IRR Model provides the financial model to evaluate the IRRs and NPV of a greenfield project.

This is a FREE Template offered. The latest model version is 5.0 and the Excel file is fully editable.

Filetype: .xlsx

Reviews

project fin

By Utkarsh Unnithan on May 23, 2024 at 18:07 (Verified Purchase)

It is very easy, crystal clear and yet simple to understand while using it as simple.

274 of 587 people found this review helpful.

Help other customers find the most helpful reviews

Did you find this review helpful? Yes No

By EdisonBasson on October 31, 2025 at 16:38 (Verified Purchase)

An absolute gem! Every project promoter needs this; it helps you understand your project’s financials much better. Thank you so much for such a useful tool, and that it is for free is unbelievable!

112 of 221 people found this review helpful.

Help other customers find the most helpful reviews

Did you find this review helpful? Yes No

Análisis de Financiamiento IRR

By Rolando on September 10, 2023 at 18:35

Buen día, disculpen la demora, es que no hablo Ingles y por eso la demora en traducir su plantilla Excel, luego realice una prueba y me parece muy buena y útil…. muchas gracias por tan valioso aporte.

English Translation:
Good morning, sorry for the delay, I don't speak English and that's why it took a while to translate your Excel template, then I did a test and I find it very good and useful…. Thank you very much for such a valuable contribution.

310 of 599 people found this review helpful.

Help other customers find the most helpful reviews

Did you find this review helpful? Yes No

IRR Project Finance Analysis

By Tim on March 28, 2023 at 23:47

Thank you for this free Excel workbook. I was trying to work out from your website how to incorporate net working capital changes in the calculation of IRR and this workbook made it clear that I was to subtract the change in net working capital from the earnings to calculate the free cash flow. Layout of spreadsheet is neat and presentable. I prefer formulae with defined names rather than cell references especially when referencing another worksheet (Summary!Tax_rate better than Summary!J80)

326 of 729 people found this review helpful.

Help other customers find the most helpful reviews

Did you find this review helpful? Yes No

By eFinancialModels on March 29, 2023 at 06:28 (Verified Purchase)

Hi Tim, Thanks for your review. We intentionally do not use defined names in all our worksheets as this can create significant confusion when copying worksheets and all defined names are duplicated. Cell references also include more information value about the structure of how the worksheet is built when you can pinpoint the exact cell location instead of having to search for a defined name. For these reasons, we give preference to using Excel this way. Best Regards, eFinancialModels

376 of 662 people found this review helpful.

Help other customers find the most helpful reviews

Did you find this review helpful? Yes No

IRR Project Finance Analysis

By Joseph Casabona on June 23, 2020 at 14:21 (Verified Purchase)

Like many other Models from “efinance models”, this Model saved me many, many hours of work and enabled me to address my “objective” in a very direct manner. I wish to thank the “Management” of “efinance models” for all they do to help us with fulfilling our business objectives with such carefully constructed Models. Thank you.

574 of 1116 people found this review helpful.

Help other customers find the most helpful reviews

Did you find this review helpful? Yes No

Irr Project Finance

By Mohamad Srour on July 11, 2019 at 06:44

easy, clear and simple to use.

Thank you for your feedback.

538 of 1068 people found this review helpful.

You must log in to submit a review.