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 … Read the rest