Calculates the internal rate of return on an investment based on a series of periodic cash flows.
Description
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!