IRR Formula - Excel Formulas
To calculate Internal Rate of Return using the IRR formula in Excel, you need a series of periodic cash flows like that shown in the figure below. The IRR can then be calculated using the following formula, with 0.1 being the initial guess at the rate: =I...