Calculates the internal rate of return on an investment based on a series of periodic cash flows.

How To Use in Sheets

IRR(cashflow_amounts, [rate_guess])

External Links

Google Sheets IRR Function | Calculate Internal Rate of Return | Google Sheets Functions

Google Sheets IRR function returns the interest rate by which an investment would grow based on the investment, any other cash outflows, and the cash inflows at regular periods. The IRR function helps to find the investment option, from two or more investment choices, with a better profitability.

0Better Sheets Tutorials

No videos yet. Stay tuned!