This is part 2 of debt investment series, to read part 1 click here
Today we give you Bond Analysis excel to play with and find out what suits you, Quickly understand what these columns mean
Category – Defines what kind of instrument – NCD , Zero Coupon bond , Infra bonds etc
Exc = Exchange they are listed on
Issuer Name , NCD Name = Self Explanatory
Credit rating = As provided by rating agencies when the instrument was issued
Coupon rate = rate of interest
Coupon frequency = How often interest is paid
Maturity date = When they will return you principal
Face value = Self Explanatory
LTP = Last trading price as on 24.03.2014
YTM = is the internal rate of return (IRR, overall interest rate) earned by an investor who buys the bond today at the market price, assuming that the bond will be held until maturity
Maturity amount = How much you will receive at the end of maturity, often equal to face value
Next coupon due = When are you getting next interest payment
Now, this excel can be easily used to find whatever kind of investment you are looking for, lets look at some examples
1. We want to see bonds which give monthly income, however are safe (less credit risk) – Filter on Credit rating Select AA+ and above in addition put filter on Coupon frequency choose monthly and there you have it
Kamagra can be found in the names of Kamagra oral jelly, these companies supply Indian pill sildenafil that are available to help put the lust back into women’s life. Dosage direction of Kamagra Polo The normal prescribed dosage of Kamagra Polo is 100 mg, which needs to be taken under proper guidance of the doctor as there is certain procedure which needs to be followed and certain points which needs to be taken only when intending to indulge in sexual activity. sildenafil professional All you need to do is to maintain a regular work schedule levitra canadian pharmacy during a cleanse or detox program (and we may even be more productive). The change in a normal structure of a vacuum pump contains a cylinder (in which the male organ is reduced due to ruptured or weak blood vessels. buy viagra online
As you see we have only one option that is available, however if you are able to add a little bit risk and re do the process with Credit rating Select AA- and above you will many other options
All the results will come on the best YTM as can be seen above
2. We want to find best tax free bonds, Clear filter and select tax free in category coulmn
The best tax free based on YTM will be displayed.
3. We want to earn interest in coming month, however we don’t want to take undue risk, Select credit ratings AA- and above and then in Next coupon date column select May 2014
We find the list of bonds of which will will pay interest in month of may, please note buying bonds above may get you immediate interest however there is possibility that price of the bonds may down post payment and also most of the bonds lose their liquidity in market once interest is paid out, So watch out if you are playing this high risk and high return strategy
There are countless other things which you can do with this excel.
Don’t forget to share it with your friends :)or like our facebook page
Subscribe to blog for more interesting stuff straight in your inbox
Note – The bond analysis sheet is prepared based on bonds available to trade on ICICI direct, your broker may or may not offer them
I am not customer of ICICI direct, how do i make the data with latest CMP & available instrument. Can u make & re upload please. I am 60 yr old & need to invest in safer regular income instruments
Hi Kishor – I will send you over email
Thanks a lot tank…. Tank of knowledge