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 calculation

IRR - internal rate of return is the discount rate that brings down the net present value of an investment to zero. This turns out to be the break-even point at which the investment yield neither gains nor losses. To find this investment rate you would have to enter a series of cash flows and the guess rate ( a default guess rate of 10% is employed when finding the IRR). The reason you would require this guess is due to the lack of a IRR formula to find internal rate of return. This leads to hiring some complicated numerical methods that perform iterative calculations starting with a guess rate of 10%. When such repeated calculation converge then we have found one of the IRR values but it is not for certain that such as a value will be found. In such cases you would have to enter a different value for the guess rate so to enable the IRR calculator to redo such iterative calcualtions. The online IRR calculator will accept a series of cash flows and the guess rate of 10% and process such information using the IRR formula and return a detailed workout that was performed internally to calculate the IRR.

Data input


Data ouput

f(r) = -100(1+r)^0 +50(1+r)^-1 +40(1+r)^-2 +30(1+r)^-3 +10(1+r)^-4
f'(r) = -50(1+r)^-2 -80(1+r)^-3 -90(1+r)^-4 -40(1+r)^-5

r0 = 0.1
f(r0) = 7.882
f'(r0) = -187.7356
r1 = 0.1 - 7.882/-187.7356 = 0.1419844551017
Error Bound = 0.1419844551017 - 0.1 = 0.041984 > 0.000001

r1 = 0.1419844551017
f(r1) = 0.4788
f'(r1) = -165.5692
r2 = 0.1419844551017 - 0.4788/-165.5692 = 0.14487617020274
Error Bound = 0.14487617020274 - 0.1419844551017 = 0.002892 > 0.000001

r2 = 0.14487617020274
f(r2) = 0.002
f'(r2) = -164.1783
r3 = 0.14487617020274 - 0.002/-164.1783 = 0.14488844256652
Error Bound = 0.14488844256652 - 0.14487617020274 = 1.2E-5 > 0.000001

r3 = 0.14488844256652
f(r3) = 0
f'(r3) = -164.1725
r4 = 0.14488844256652 - 0/-164.1725 = 0.14488844278586
Error Bound = 0.14488844278586 - 0.14488844256652 = 0 < 0.000001
IRR = r4 = 0.14488844278586 or 14.49%