Syntax
=IRR(values, [guess])Arguments
| Argument | Required | Description |
|---|---|---|
values | Required | The cash flows, with at least one payment (negative) and one receipt (positive) |
guess | Optional | A first guess for the rate (10% when left out) |
How to use IRR
IRR takes 1 required argument and 1 optional argument. Type =IRR( in a cell and SheetsBat shows the arguments as you go. Optional arguments are shown in square brackets; leave them out to use their default.
Examples
Each result below was calculated by the SheetsBat formula engine.
=IRR({-70000, 12000, 15000, 18000, 21000, 26000})Result =IRR({-70000, 12000, 15000, 18000, 21000})Result Related financial functions
- FVReturns the future value of an investment with constant payments and a constant rate.
- FVSCHEDULEReturns the future value of a principal after applying a series of interest rates.
- INTRATEReturns the interest rate of a fully invested security.
- IPMTReturns the interest part of one payment of a loan or investment.
- ISPMTReturns the interest paid in one period of a loan with equal principal repayments.
- MDURATIONReturns the modified duration in years of a security that pays periodic interest, for 100 face value.
- MIRRReturns the modified internal rate of return, with separate rates for financing and reinvestment.
- NOMINALReturns the nominal annual interest rate from an effective rate and the compounding periods per year.
- NPERReturns the number of payment periods needed for a loan or investment.