IRR - internal rate of return

See also

  1. NIV - net intermediate value
  2. NPV - net present value
  3. MIRR - modified IRR

Let me take a few seconds to introduce tadXL v3.0 add-in that is the latest version of this popular Excel add-in. The previous versions of this add-in extended the functionality of Excel financial functions but this latest version is a ground breaking financial analysis software that redefines the way investments are analyzed. "Matrix" is the code name for the programming code that makes possible the processing of a m x n rows of data to perform financial calculations. The tadIRR function in tadXL v3.0 returns a single result by taking the cash flows and many of its attributes that define the properties of such data. Have a look at some of the options that are available in this one of kind financial function.

Excel IRR function

What if I told you about an Excel IRR function such as tadIRR that is part of tadXL v3.0 add-in for Excel 2007, 2010 and 2013. tadXL v3.0 is the latest version of this popular add-in that will be available to our users as early as February 2014.

Look at what is possible using this unique unmatched financial function that accepts 12 rows of data to return a single IRR value. The values that it accepts include a schedule of discount rates, the inflation rates, the tax rates. the cash flows, adjustments for inflations, the frequencies of cash flows, the types of annuity payments (start of period or end of period), the compounding frequencies of interest, the lengths of payment periods, the discounting conventions, the expected hair cuts (loss) on income, the rigged rates.

Cash_Flows $(100) $200 $300 $(150) $400 $500 $600 $700
Adjust_for_inflation - - - - - - - -
Frequencies 4 365 24 365 INF 260 INF 5,200
Types 1 - 1 - - 1 - -
Compoundings10.0192310.50.002740 - 0.0833330.2500001
Periods10.0192310.50.002740 - 0.0833330.2500001

Using tadXL function such as tadIRR, and tadXIRR finding internal rate of return in Excel 2007, 2010 and 2013 becomes really easy. Let us now briefly look at each of these three financial functions in tadXL to find IRR using Excel:

=tadIRR( guess, use_rates, rates, inflation, tax_rates, cashflows, adjust_for_inflation, frequencies, types, compoundings, periods, concentrations, hair_cuts, rate_rigged_by )

=tadXIRR( cashflows, dates, guess, compounding, iterations, precision )