ItemPriceFree Download
 
Please feel at home to download tadXL for FREE, currently valued at US$119
 
Whether you require analyzing a single investment to find investor's ROI or are eager to evaluate a whole portfolio of investments, tadXL will deliver the results. And how about analyzing a "portfolio of portfolios" or even a portfolio of "portfolios of portfolios"
 
tadXL v2.5 allows one dimensional financial analysis, the next many iterations of tadXL will allow for N-dimensional financial analysis starting with 2 dimensional TVM equation in v3.0 followed by 3 dimensional time value of money equation in v4.0 and moving upwards
 
Free 32-bit tadXL v2.5 full versionFREEDownload Now
Free 64-bit tadXL v2.5 full versionFREEDownload Now
 
In near future you will be get to download newer versions of tadXL v3.0, v4.0, v5.0, v6.0, v7.0, v8.0, v9.0 and v10.0
 
Don't be surprised if you find out that Microsoft has copied ideas from tadXL to offer similar financial functions in its upcoming Excel 2015. And you thought Microsoft would respect others copy protected work, yet that is not the case this time with that software Giant pirate
 
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 )