Calculates the internal rate of return on an investment based on a series of periodic cash flows.
81% OFF online library of tutorials for mastering Google Sheets
IRR()
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 featuring this formula, yet. Stay tuned! In the mean time check out blogs below, and more formulas here at Better Sheets.