Green IRR Calculator — Sustainability Projects

The internal rate of return is the discount rate that sets the net present value of a cash flow stream to zero: zero equals minus the investment plus the sum of each year's flow divided by one plus IRR raised to that year. Because the equation is a polynomial in the discount factor it has no closed-form solution beyond low orders, so it is solved numerically. This implementation uses Newton-Raphson iteration, stepping from an initial guess of 10 percent and refining with the analytic derivative of NPV until successive estimates differ by less than one part in a hundred million. Two features specific to green assets are built in. A cash flow growth rate compounds year one revenue forward, representing energy price escalation or rising carbon credit values, and a salvage value is added in the final year for residual equipment, land, or scrap steel. Utility-scale solar and onshore wind projects with contracted offtake commonly show unlevered IRRs of 5 to 9 percent, with merchant or emerging-market exposure pushing toward 10 to 15 percent. Two limitations are structural: IRR implicitly assumes intermediate cash flows are reinvested at the IRR itself, and if the sign of the cash flow sequence changes more than once, for example when a major mid-life replacement is booked, several mathematically valid IRRs can exist for the same project.

Discounting future receipts to a present equivalent was standard in actuarial and bond mathematics long before it reached corporate investment appraisal. Irving Fisher gave the modern formulation in The Rate of Interest of 1907 and The Theory of Interest of 1930, where he defined the rate of return over cost as the rate equating the present values of two competing income streams. John Maynard Keynes described essentially the same quantity as the marginal efficiency of capital in The General Theory of Employment, Interest and Money in 1936, defining it as the discount rate that makes the present value of an asset's expected yields equal to its supply price. Practical adoption came after the Second World War. Joel Dean's Capital Budgeting, published by Columbia University Press in 1951, argued that firms should rank projects by discounted rate of return rather than by payback period or accounting profit, and the method spread through oil, chemical, and utility companies during the 1950s and 1960s. The iterative root finding it requires descends from methods published by Isaac Newton and refined by Joseph Raphson in 1690. Spreadsheet IRR functions in the 1980s made the calculation routine, and it is now the headline metric in renewable project finance term sheets.