Formulas > =IRR()
How to Use IRR() in Google Sheets
Description
How To Actually Use IRR() in Sheets
IRR(cashflow_amounts, [rate_guess])
Try IRR yourself
Use the IRR formula to calculate the internal rate of return for the cash flows in the range A1:A5. The correct answer must return a percentage value representing the IRR.
Hints (2)
-
Make sure to include all cash flows in the specified range.
-
The result will be a decimal that you can format as a percentage.
Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas
More related tutorials
Transcript-matched member videos for IRR(). Click through to watch.
Calculate ROAS in Google Sheets
Learn more about the IRR() formula:
Generate a IRR() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses IRR(). 2 free AI generations, no signup. Members get unlimited use.
Generate a IRR() formula