IRR Project Finance Analysis

The IRR Project Finance Analysis forecasts the expected financials for a greenfield project and calculates the levered and unlevered Internal Rate of Return (IRR).

Internal Rate of Return Analysis
,
, , , , ,

The IRR Project Finance Analysis forecasts the expected financials for a greenfield project and calculates the levered and unlevered Internal Rate of Return (IRR).

The model template includes:

  • Executive Summary section with charts and key financials
  • Key assumptions sheet specific
  • Yearly financial projections (Income Statement, Balance Sheet and Cash Flow Statement)
  • Simple debt schedule
  • Fixed asset depreciation schedule
  • Forecasted financial ratios such as Debt/EBITDA, current ratio, ROE, ROIC, days sales, says inventory, days payables, etc.
  • Projected Free Cash Flows to Firm which are used to calculate the internal rate of returns (Project IRR) and the Net Present Value (NPV)
  • Paypack period based on Free Cash Flows to Firm (FCFF)
  • Calculation of the Equity IRR by using the levered cash flows from the shareholder’s point of view
  • Reader and print-friendly layout including charts and graphs

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

Filetype: .xlsx (Microsoft Excel 2008 for Mac)

Add to wish list

Reviews

  • Análisis de Financiamiento IRR

    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.

    24 of 39 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

    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)

    44 of 85 people found this review helpful.

    Help other customers find the most helpful reviews

    Did you find this review helpful? Yes No

    • 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

      46 of 96 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

    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.

    272 of 565 people found this review helpful.

    Help other customers find the most helpful reviews

    Did you find this review helpful? Yes No

  • Irr Project Finance

    easy, clear and simple to use.

    256 of 513 people found this review helpful.

    Help other customers find the most helpful reviews

    Did you find this review helpful? Yes No

  • You must log in to submit a review.