ItemPriceComplete Download
Free 32-bit tadXL v2.5 full versionFREEDownload Now
Free 64-bit tadXL v2.5 full versionFREEDownload Now
32-bit tadXL v3.0PendingUnder construction
64-bit tadXL v3.0PendingUnder construction
IRR - internal rate of return

4 Dimensional TVM Equation

Excel IRR function in tadXL v5.0 (code named 4-Dim)

  1. tadIRR ( { {rates, inflation, exchange_rates, tax_rates, cashflows, frequencies, types, compoundings, periods, concentrations, hair_cuts, rate_rigged_by}...}... )
  • tadIRR ( {{rates, inflation, exchange_rates, tax_rates, cashflows, frequencies, types, compoundings, periods, concentrations, hair_cuts, rate_rigged_by}...}... )

  • %

    Data output

    Portfolio # 1

    Project #1IRR without rate scheduleIRR = 12.72%
    Project #1IRR with rate scheduleIRR = 18.29%
    Project #2IRR without rate scheduleIRR = 103.94%
    Project #2IRR with rate scheduleIRR = 3.03%
    Portfolio #1IRR without rate scheduleIRR = 331.29%
    Portfolio #1IRR with rate scheduleIRR = NAN%

    Portfolio # 2

    Project #1IRR without rate scheduleIRR = 76.53%
    Project #1IRR with rate scheduleIRR = 5%
    Project #2IRR without rate scheduleIRR = 49.44%
    Project #2IRR with rate scheduleIRR = -0%
    Portfolio #2IRR without rate scheduleIRR = 73.13%
    Portfolio #2IRR with rate scheduleIRR = 5%

    Portfolio of portfolios

    Portfolio of portfoliosIRR without rate scheduleIRR = 276.04%
    Portfolio of portfoliosIRR with rate scheduleIRR = NAN%

    3 Dimensional TVM Equation

    Excel IRR function in tadXL v4.0 (code named CUBE)

    1. tadIRR ( {rates, inflation, exchange_rates, tax_rates, cashflows, frequencies, types, compoundings, periods, concentrations, hair_cuts, rate_rigged_by}... )
  • tadIRR ( {rates, inflation, exchange_rates, tax_rates, cashflows, frequencies, types, compoundings, periods, concentrations, hair_cuts, rate_rigged_by}... )

  • %

    Data output

    Project #1IRR without rate scheduleIRR = 12.72%
    Project #1IRR with rate scheduleIRR = 18.29%
     
    Project #2IRR without rate scheduleIRR = 103.94%
    Project #2IRR with rate scheduleIRR = 3.03%
     
    PortfolioIRR without rate scheduleIRR = 331.29%
    PortfolioIRR with rate scheduleIRR = NAN%
     

    2 Dimensional TVM Equation

    Excel IRR function in tadXL v3.0 (code named MATRIX)

    1. tadIRR ( rates, inflation, exchange_rates, tax_rates, cashflows, frequencies, types, compoundings, periods, concentrations, hair_cuts, rate_rigged_by )
  • tadIRR ( rates, inflation, exchange_rates, tax_rates, cashflows, frequencies, types, compoundings, periods, concentrations, hair_cuts, rate_rigged_by )


  • %

    Data output

    IRR without rate scheduleIRR = 12.72%
    IRR with rate scheduleIRR = 18.29%

    Excel IRR function in tadXL v2.5

    1. tadIRR ( guess rate, cash flows, compounding, period, concentration )
    2. tadIRRSchedule ( guess rate, discount rates, cash flows, compounding, period, concentration )
    3. tadXIRR ( guess rate, cash flows, compounding )
    4. tadXIRRSchedule ( guess rate, discount rates, cash flows, dates, compounding )

    tadIRR ( guess rate, cash flows, compounding, period, concentration )


    %










    Data output

    IRR =

    tadIRRSchedule ( guess rate, discount rates, cash flows, compounding, period, concentration )


    %










    Data output

    IRR =

    tadXIRR ( guess rate, cash flows, dates, compounding )


    %




    Data output

    IRR =

    tadXIRRSchedule ( guess rate, discount rates, cash flows, dates, compounding )


    %




    Data output

    IRR =

    Excel IRR function in tadXL v3.0

    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.

    Rates3%5%4%2%5%6%7%8%
    Growth0%0%0%0%0%0%0%0%
    Tax_Rates35%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 - -
    Compoundings10.0192310.50.002740 - 0.0833330.2500001
    Periods10.0192310.50.002740 - 0.0833330.2500001
    Concentrations10.521010.510.75
    Hair_Cuts0%25%25%0%25%25%25%25%
    Rate_Rigged_By0%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:

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