Item | Price | Free 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 version | FREE | Download Now |

Free 64-bit tadXL v2.5 full version | FREE | Download 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 | ||

f(i) = 1000 + -1100 * (1+i)^20 + 20 [(1+i)^20 - 1]/i f'(i) = 20 * -1100 * (1+i)^19 + 20 * (20 i (1 + i)^19 - (1 + i)^20 + 1) / (i^2)

i = 0.1

f(i) = -5254.75

f'(i) = -121541.3627

i1 = 0.1 - -5254.75/-121541.3627 = 0.05676574758247

Error Bound = 0.05676574758247 - 0.1 = 0.043234 > 0.000001

i1 = 0.05676574758247

f(i1) = -1608.0563

f'(i1) = -55210.0058

i2 = 0.05676574758247 - -1608.0563/-55210.0058 = 0.027639571995785

Error Bound = 0.027639571995785 - 0.05676574758247 = 0.029126 > 0.000001

i2 = 0.027639571995785

f(i2) = -372.9307

f'(i2) = -31620.5576

i3 = 0.027639571995785 - -372.9307/-31620.5576 = 0.015845641616611

Error Bound = 0.015845641616611 - 0.027639571995785 = 0.011794 > 0.000001

i3 = 0.015845641616611

f(i3) = -40.0796

f'(i3) = -25057.7742

i4 = 0.015845641616611 - -40.0796/-25057.7742 = 0.014246154392232

Error Bound = 0.014246154392232 - 0.015845641616611 = 0.001599 > 0.000001

i4 = 0.014246154392232

f(i4) = -0.632

f'(i4) = -24271.3312

i5 = 0.014246154392232 - -0.632/-24271.3312 = 0.014220114627777

Error Bound = 0.014220114627777 - 0.014246154392232 = 2.6E-5 > 0.000001

i5 = 0.014220114627777

f(i5) = -0.0002

f'(i5) = -24258.7174

i6 = 0.014220114627777 - -0.0002/-24258.7174 = 0.014220107857248

Error Bound = 0.014220107857248 - 0.014220114627777 = 0 < 0.000001

Periodic YTM = 1.42% Nominal YTM = 2.84% Annual effective yield = 2.86%

Using tadXL function such as tadBYTM finding yield to maturity in Excel 2007, 2010 and 2013 becomes really easy. Let us now briefly look at the financial functions in tadXL to find YTM using Excel: