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
 
YTM - yield to maturity

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:

=tadBYTM( years_to_maturity, coupon_rate, bond_price, par_value, compounding )