Investment Decision Helper

説明

You can create custom investments adding: Starting Expenditures, regular income in percentage (coupon), amortization at the end (useful for Bonds), payments frequency and price of the instruments in the secondary market .

Investment Decision Helper will calculate and compare the return rates, and help you make the right choice.

Note: Version 1.0.2 will still be available for those who are unwilling to add the additional Payments Frequency option. In any case, the Annual Payments scheme will show the same behaviour for the instruments.

Usage

1. Enter the cost of the investment.
2. Enter the coupon or periodic income rate (interest rate).
3. Enter the number of times the interest will be received.
4. (Optional) Enter de last amortization in case you need it (You can assume 100% for Bonds, otherwise omit it).
5. (Optional) Enter de Price of the instrument in percentage in case it is negotiated in secondary markets.
6. (Optional) Select the income frequency. Base returns for instruments will be considered “Annual” unless you select a different option.
7. (Optional) For pre-calculated return, place the corresponding Return rate. It will override every information added in previous cells (except “Frecuency”). This option won’t be placed in the chart since there’re no “Starting Expenditure” or “Coupon” to obtain the corresponding “NPV”.
8. Click on “submit” button and look at the new box showing the return rates of both instruments. The preferred option will be featured in green, and a chart will show you the NPV behavior as IRR changes.