


tadIRR in tadXL v3.0
tadIRR in tadXL v2.5
Abraham's Transform
Excel IRR function in tadXL v2.5
 tadIRR ( guess rate, cash flows, compounding, period, concentration )
 tadIRRSchedule ( guess rate, discount rates, cash flows, compounding, period, concentration )
 tadXIRR ( guess rate, cash flows, compounding )
 tadXIRRSchedule ( guess rate, discount rates, cash flows, dates, compounding )
tadIRR ( guess rate, cash flows, compounding, period, concentration )
%
Data output
tadIRRSchedule ( guess rate, discount rates, cash flows, compounding, period, concentration )
%
Data output
tadXIRR ( guess rate, cash flows, dates, compounding )
%
Data output
tadXIRRSchedule ( guess rate, discount rates, cash flows, dates, compounding )
%
Data output
Excel IRR function in tadXL v3.0
Let me take a few seconds to introduce tadXL v3.0 addin that is the latest version of this popular Excel addin. The previous versions of this addin 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 addin for Excel 2007, 2010 and 2013. tadXL v3.0 is the latest version of this popular addin 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.
Rates  3%  5%  4%  2%  5%  6%  7%  8% 
Growth  0%  0%  0%  0%  0%  0%  0%  0% 
Tax_Rates  35%  36%  37%  38%  39%  40%  45%  50% 
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     
Compoundings  1  0.019231  0.5  0.002740    0.083333  0.250000  1 
Periods  1  0.019231  0.5  0.002740    0.083333  0.250000  1 
Concentrations  1  0.5  2  10  1  0.5  1  0.75 
Hair_Cuts  0%  25%  25%  0%  25%  25%  25%  25% 
Rate_Rigged_By  0%  20%  20%  0%  20%  20%  20%  20% 
Using tadXL function such as tadIRR 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: