Analyze fixed income securities to find bond price, coupon rate, duration, convexity, and yield.
From The Author
Welcome to FTWE 100
FTWE 100 is the financial treasure web index that offers you a host of financial products and services making it possible to analyze investments. The FTWE 100 index allows an analyst to determine the investor's return on investment - ROI using the financial software tools that we offer. FTWE 100 enables financial analysts like you to make informed decisions on investments thus ensuring the profitability of your company or personal gains. The FTWE 100 index is an indicator of sound invesment based upon financial analysis resulting from the use of our software tools. Keep us bookmarked in your web browser as the tools that we offer are not found elsewhere and are one of a kind in financial industry.
Download FTWE 100 free software
As stated earlier the FTWE 100 index is the result of financial calculations that are made possible using the financial software products that we offer for free. All of our software tools may be downloaded for personal and corporate use, however the complete versions of these software products cost a nominal price that allows for more complex options when finding the FTWE 100 index. For more details on downloading and using these software products, follow the read more link to find your return on investment - ROI […]
IRR - internal rate of return
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.
How old is Microsoft Excel, its quite old more than 24 years old yet all of its financial functions had stayed the same as they have been uptill Excel 2013. Not sure what Microsoft intends to do with their upcoming version of Excel 2015 or 2016 yet if they do decide to include new financial function in upcoming Excel then more than likely such functions would be based upon a popular Excel add-in called tadXL. In March of 2012, tadXL was released to the market offering its own set of financial functions that are robust and feature rich as compared to those native Excel financial functions. tadXL in the past few years has gone through many iterations and upgrades and in its current version tadXL v3.0 it has integrated related functions in a single complex function. The tadIRR function in its current form is so complex that explaining its purpose and usage would require writing a whole book on the topic of finding internal rate of return. In summary, the tadIRR function permits finding IRR for a lump sum investment and those that make series of periodic payments where such payments may be in constant amount or those that grow by a rate. Furthermore the tadIRR function allows using frequencies for each payment thus making such payments annuities in their own right. Sound complex then there is more such as using compounding frequencies of interest, payment periods of almost any length, discounting conventions such as mid-year discounting amongst others. Thus the tadIRR function is more robust and feature rich in contrast to the native Excel IRR function.
Using tadXL function such as tadIRR to find the internal rate of return is easy as 123 as shown in the example below: