The Excel IRR function calculates the Internal Rate of Return for a given set of periodic cash flows (i.e., an initial investment value and a series of net income values).
Syntax :
=IRR( values, [guess] )
Parameters :
The following parameters are:
Example :
Cell B1 in the spreadsheet below shows a $100 initial investment, and cells B2-B6 indicate the net income over the next five years. The IRR function in cell C2 calculates the Internal Rate of Return after three years, and the function in cell C4 calculates the Internal Rate of Return after five years.
Ask Your Query