Bonds - LDR
Bonds - LDR
VALUATION OF BONDS
1. IDBI, in its issue of flexi-bonds – 3, offered Growing Interest Bond. The interest will be
paid to the investors every year at the rats given below and the minimum deposits is `
5000/-.
Interest (p.a)
Year 1 10.5%
Year 2 11.0%
Year 3 12.5%
Year 4 15.25%
Year 5 18.0%
Calculate the Yield to Maturity (YTM)?
................................................................... 1 ..............................................................
VALUATION OF BONDS KHETAN EDUCATION
New Price = `10 / 10.09% = ` 99.108.
3. X Ispat Ltd. has made an issue of 14 per cent non-convertible debentures on January 1,
2007. These debentures have a face value of ` 100 and is currently traded in the market
at a price of ` 90.
Interest on these NCDs will be paid through post-dated cheques dated June 30 and
December 31. Interest payments for the first 3 years will be paid in advance through post-
dated cheques while for the last 2 years post-dated cheques will be issued at the third year.
The bond is redeemable at par on December 31, 2011 at the end of 5 years.
a. Estimate the current yield at the YTM of the bond.
b. Calculate the duration of the NCD.
c. Assuming that intermediate coupon payments are, not available for reinvestment
calculate the realised yield on the NCD.
Sol. C = 14% FV = 100 Price = 90 n = 5
100 × 14%
Semi-annual coupon = =`7
2
C 7
i. CY = × 100 = × 100 = 7.78%
Price 90
We need to annualize this,
BEY = 7.78% × 2 = 15.56% p.a. (Bond equivalent yield)
BAY = (1.0778)2 – 1 × 100 = 16.17% (Effective annualised yield)
b. Computation of Duration
Period CF PV@ 8.42% PV WiXi
1 7 0.922 6.454 6.454
2 7 0.851 5.957 11.914
3 7 0.785 5.495 16.485
................................................................... 2 ..............................................................
Prof. Archana Khetan VALUATION OF BONDS
................................................................... 3 ..............................................................
VALUATION OF BONDS KHETAN EDUCATION
Coupon = 12%
3
r03 = 10 + = 11.5%
2
Year CF PV@11.50% PV WiXi
1 120 0.897 107.64 107.64
2 120 0.804 96.48 192.96
3 1,120 0.721 807.52 2,422.56
1,011.64 2,723.16
2, 723.16
Duration = = 2.69
1, 011.64
a. Price = ` 1,011.64
D
Price volatility (Modified duration) =
1 + YTM
2.69
=
1.115
= 2.414
This means if interest rates change by 1% or 100 bps (basic points), the price of the bond
would change by 2.414% in the opposite direction.
Þ If interest D by 100 bps ® Price D 2.414%
If interest D by 80 bps ® Price 1.9312%
Price as per price volatility method :
Current price = ` 1,011.64
New price = ` 1,011.64 + 1.9312% = ` 1,031.18
b. Price as per Re-pricing method.
Year CF PV@10.7% PV
1 120 0.903 108.36
2 120 0.816 97.92
3 1,120 0.737 825.44
1,031.72
................................................................... 4 ..............................................................
Prof. Archana Khetan VALUATION OF BONDS
7. ABC Ltd. issued 9%, 5 year bonds of ` 1,000/- each having a maturity of 3 years. The
present rate of interest is 12% for one year tenure. It is expected that Forward rate of
interest for one year tenure is going to fall by 75 basis points and further by 50 basis
points for every next year in further for the same tenure. This bond has a beta value of
1.02 and is more popular in the market due to less credit risk. Calculate:
................................................................... 5 ..............................................................
VALUATION OF BONDS KHETAN EDUCATION
l Intrinsic value of bond
l Expected price of bond in the market
Sol. CR = 9%
FV = 1,000
r01 = 12%
ƒ12 = 12-0.75
f23 = 11.25% -0.5 = 10.75%
n = 3year = 11.25%
The sum is based on the concept of upward rising curve (as the sum mentions spot &
forward rates), we need to discount cash follow of different year with different rates.
® (1 + r02)2 = (1 + r01) (1 + f12)
(1 + r02)2 = (1.12) (1.1125)
(1 + r02)2 = 1.246
1
1 + r02 = (1.246) 2
r02 = 11.62%
® (1 + r03)3 = (1 + r02)2(1 + f23)
(1 + r03)3 = (1 + r01) (1 + f12) (1 + f 23)
= (1.12) (1.1125) (1.1075)
= 1.380
90 90 1,090
a. V0 = + +
2
(1 + r01) 1
(1 + r02) (1 + r03)3
90 90 1, 090
= + +
1.12 1.246 1.380
= ` 942.44
b. Expected market price
= Intrinsic value × Beta (b)
= ` 942.44 × 1.02
= ` 961.30
................................................................... 6 ..............................................................
Prof. Archana Khetan VALUATION OF BONDS
If the interest rate increases by 50 basis points, what will be the percentage change in the
price of the bond having a maturity of 5 years? Assume bond is fairly priced at the
moment at ` 1000.
Sol.
a. Computation of 1 year fund rate in year 2 i.e. f12
(1 + r02)2 = (1 + r01) (1 + f12)
(1.1125)2 = (1.1050) (1 + f12)
1 + f12 = 1.12
f12 = 12%
Computation of 1 year fund rate in year 3 i.e. year f23
(1 + r03)3 = (1 + r02)2 (1 + f23)
(1.12)3 = (1.1125)2 (1 + f23)
(1.4049) = (1.2377) (1 + f23)
f23 = 13.51%
b. Since the bond is fairly priced at `1,000 it means bond price = FV = `1,000.
It also means coupon rate = YTM = 12%
Year CF PV@12.5% PV
1 120 0.889 106.68
2 120 0.790 94.80
3 120 0.702 84.24
4 120 0.624 74.88
5 1,120 0.555 621.16
` 981.76
P1 - P0
\D in price = × 100 = [(` 981.76 - ` 1000)/ ` 1000] × 100
P0
= -1.824%
9. From the following data for Government securities, calculate the forward rates:
Face value (`) Interest rate Maturity (year) Current price (`.)
1,00,000 0% 1 91,500
1,00,000 10% 2 98,500
1,00,000 10.5% 3 99,000
Sol. With the help of given data, we can compute r01, r02, r03.
For Bond A,
FV
VA =
(1 + r)1
1,00,000
` 91,500 = = r01 = 9.29%
(1 + r)
................................................................... 7 ..............................................................
VALUATION OF BONDS KHETAN EDUCATION
For Bond B,
C C + R.A.
VB = + ….. (R.A. → Redemption Amount)
(1 + r01)1
(1 + r02)2
C C + R.A.
= +
(1 + r01) (1 + r01) (1 + f12)
` 10,000 ` 10,000 + ` 1,00,000
` 98,500 = +
1.0929 (1.0929)(1 + f12)
` 1,00,649.65
` 89,350 =
(1 + f12)
f12 = 12.65%
For Bond C,
C C C + R.A.
VC = + 2
+
(1 + r01)1
(1 + r02) (1 + r03)3
C C C + R.A
= + +
(1 + r01) (1 + r01) (1 + f12) (1 + r02)2 (1 + f23)
` 10,500 ` 10,500 ` 10,500 + ` 1,00,000
` 99,000 = + +
1.0929 (1.0929) (1.1265) (1.0929) (1.1265) (Hf23)
[ (1.0929)(1.1265)(1+f23)]
` 99,000 – ` 9,607.47 – ` 8,528.6 = ` 89,753.35
(1 + f23)
f23 = 10.99%
10. M/s. Transindia Ltd. is contemplating calling ` 3 crores of 30 years, <1,000 bond issued
5 years ago with a coupon interest rate of 14 percent. The bonds have a call price of
<1,140 and had initially collected proceeds of<2.91 crores due to a discount of<30 per
bond. The initial floating cost was <3,60,000. The Company intends to sell <3 crores of
12 per cent coupon rate, 25 years bonds to raise funds for retiring the old bonds. it
proposes to sell the new bonds at their par value of <1,000. The estimated floatation cost
is <4,00,000. The company is paying 40% tax and its after cost of debt is 8 per cent. As
the new bonds must first be sold and their proceeds, then used to retire old bonds, the
company expects a two months period of overlapping interest during which interest must
be paid on both the old and new bonds.
What is the feasibility of refunding bonds?
` 3 Cr
Sol. No. of Bonds = = 30,000 bonds.
` 1, 000
Computation of outflows
Post tax cost of premium = ` 25,20,000
[(`140 × 30,000) × (1- 40%)]
................................................................... 8 ..............................................................
Prof. Archana Khetan VALUATION OF BONDS
= (`4,800) = (` 6,400)
iii. Tax benefit on -
= `30 × 30, 000 × 40%
discount 30 × 40%
= (`12,000)
` 25,03,200 ` 21,53,600
Saving p.a. = ` 25,03,200 – ` 21,53,600
= ` 3,49,600
Present value = ` 3,49,600 × PVA (8%, 25)
= ` 3,49,600 × 10.675
= 37,31,980.
NPV = ` 37,31,980 – ` 29,20,000
= ` 8,11,980.
Since, the NPV is positive, we advise the firm to go ahead with bond refunding.
11. ABC Ltd. has ` 300 million, 12 per cent bonds outstanding with six years remaining to
maturity. Since interest rates are falling, ABC Ltd. is contemplating of refunding these
bonds with a ` 300 million issue of 6-year bonds carrying a coupon rate of 10 per cent.
Issue cost of the new bond will be ` 6 million and the call premium is 4 per cent. ` 9
million being the unamortized portion of issue cost of old bonds can be written off no
sooner the old bonds are called off. Marginal tax rate of ABC Ltd. is 30 per cent.
You are required to analyze the bond refunding decision.
................................................................... 9 ..............................................................
VALUATION OF BONDS KHETAN EDUCATION
Sol. NPV of bond refunding
NPV of bond refunding = P.V of Savings – Outflow
Computation of outflow
Post tax cost of Premium = ` 84,00,000
[` 300 m × 4% × (1 – 30%)]
+ Floatation cost on new bonds = ` 60,00,000
- Tax shield on unamortized Cost on old bonds = (` 27,00,000)
(` 90,00,000 × 30%)
= ` 1,17,00,000
Computation of savings
Particulars Old New
Post tax Coupon ` 3,000L × 12% × (1 – 30%) ` 3,000L × 10% × (1 – 30%)
cost
= 2,52,00,000 = 2,10,00,000
12. XYZ company has current earnings of ` 3 per share with 5,00,000 shares outstanding.
The company plans to issue 40,000, 7% convertible preference shares of ` 50 each at par.
The preference shares are convertible into 2 shares for each preference shares held. The
equity share has a current market price of ` 21 per share.
i. What is preference share’s conversion value?
ii. What is conversion premium?
................................................................... 10 ..............................................................
Prof. Archana Khetan VALUATION OF BONDS
iii. Assuming that total earnings remain the same, calculate the effect of the issue on
the basic earning per share
a. before conversion
b. after conversion
iv. If profits after tax increases by ` 1 million what will be the basic EPS
a. before conversion and
b. on a fully diluted basis?
Sol.
i. Conversion value of preference share
Conversion Ratio × Market Price
2 × ` 21 = ` 42
ii. Conversion Premium
(` 50/ ` 42) - 1 = 19.05%
iii. Effect of the issue on basic EPS
Particulars `
Before Conversion
Total (after tax) earnings ` 3 × 5,00,000 15,00,000
Dividend on Preference shares 1,40,000
Earnings available to equity shares 13,60,000
No. of shares 5,00,000
EPS 2.72
On Diluted Basis
Earnings 15,00,000
No of shares (5,00,000 + 80,000) 5,80,000
EPS 2.59
................................................................... 11 ..............................................................
VALUATION OF BONDS KHETAN EDUCATION
EPS 4.31
14. Suppose Mr. A is offered a 10% Convertible Bond (par value ` 1,000) which either can
be redeemed after 4 years at a premium of 5% of get converted into 25 equity shares
currently trading at ` 33.50 and expected to grow by 5% each year. You are required to
determine the minimum price Mr. A shall be ready to pay for bond if has expected rate
of return is 11%.
................................................................... 12 ..............................................................
Prof. Archana Khetan VALUATION OF BONDS
Accordingly, CV shall be
= ` 33.50 × 1.054 × 25 = ` 33.50 × 1.2155 × 25 = ` 1017.98
Value of bond if conversion is opted = ` 100× PVAF (11%,4) + ` 1017.98
PVF (11%,4)
= ` 100 × 3.102 + ` 1017.98 × 0.659
= ` 310.20 + ` 670.85
= ` 981.05
Since above value of Bond is based on the expectation of growth in market price which
may or may not be as per expectations. In such circumstances the redemption at premium
still shall be guaranteed and bond may be purchased at its floor value computed as
follows:
Value of bond if conversion is not opted = `100 × PVAF (11%,4) + ` 1050 PVF
(11%,4)
= ` 100 × 3.102 + ` 1050 × 0.659
= ` 310.20 + ` 691.95
= ` 1002.15
15. A Ltd. has issued convertible bonds, which carries a coupon rate of 14%. Each bond is
convertible into 20 equity shares of the company A Ltd. The prevailing interest rate for
similar credit rating bond is 8%. The convertible bond has 5 years maturity. It is
redeemable at par at ` 100.
The relevant present value table is as follows.
Present T1 T2 T3 T4 T5
Values
PVIF0.14,t 0.877 0.769 0.675 0.592 0.519
PVIF0.08,t 0.926 0.857 0.794 0.735 0.681
You are required to estimate:
(Calculations be made up to 3 decimal places)
i. Current market price of the bond, assuming it being equal to its fundamental value,
................................................................... 13 ..............................................................
VALUATION OF BONDS KHETAN EDUCATION
ii. Minimum market price of equity share at which bond holder should exercise
conversion option; and
iii. Duration of the bond.
Sol.
i. Current Market price of Bond:
Time CF PVIF 8% PV (CF) PV(CF)
1 14 0.926 12.964
2 14 0.857 11.998
3 14 0.794 11.116
4 14 0.735 10.290
5 14 0.681 77.634
åPV(CF) i.e. P0 = 124.002
Say ` 124.00
ii. Minimum Market Price of Equity Shares at which Bondholder should exercise conversion
option:
124.00
= = 6.20
20.00
16. The following is the data related to 9% Fully convertible (into Equity Shares) debentures
issued by Delta Ltd. at ` 1000.
Market Price of 9% Debenture ` 1,000
Conversion Ratio (No. of shares) 25
Straight Value of 9% Debentures ` 800
Market price of equity share on the date of conversion ` 30
Expected Dividend p r share `1
Calculate:
i. Conversion value of Debenture; ii. Market Conversion Price;
................................................................... 14 ..............................................................
Prof. Archana Khetan VALUATION OF BONDS
................................................................... 15 ..............................................................
VALUATION OF BONDS KHETAN EDUCATION
90 - 25 × 1
=
25
= ` 2.6
vii. Premium pay back period
= Conversion primium per share
favourable Income Differntial per share
10
= = 3.85 years
2.6
17. A hypothetical company ABC Ltd. issued a 10% Debenture (Face Value of ` 1000) of
the duration of 10 years, currently trading at ` 850 per debenture. The bond is convertible
into 50 equity shares being currently quoted at ` 17 per share.
If yield on equivalent comparable bond is 11.80%, then calculate the spread of yield of
the above bond from this comparable bond.
The relevant present value table is as follows.
Present t1 t2 t3 t4 t5 t6 t7 t8 t9 t10
Values
PVIF0.11,t 0.901 0.812 0.731 0.659 0.593 0.535 0.482 0.434 0.391 0.352
PVIF0.13,t 0.885 0.783 0.693 0.613 0.543 0.480 0.425 0.376 0.333 0.295
Sol. Conversion Price = ` 50 × 17 = ` 850
Intrinsic Value = ` 850
Accordingly the yield (r) on the bond shall be :
` 850 = ` 100 PVAF (r, 10) + ` 1000 PVF (r, 10)
Let us discount the cash flows by 11%
850 = 100 PVAF (11%, 10) + 1000 PVF (11%, 10)
850 = 100 × 5.890 + 1000 × 0.352 = 91
Now let us discount the cash flows by 13%
850 = 100 PVAF (13%, 10) + 1000 PVF (13%, 10)
850 = 100 × 5.426 + 1000 × 0.295 = -12.40
Accordingly, IRR
11% + 90.90 (13% - 11%)
90.90 - (-12.40)
90.90
11% + × (13% - 11% = 12.76%
103.30
The spread from comparable bond = 12.76% - 11.80% = 0.96%
18. XYZ Ltd.’s bond (Face Value of ` 1,000) with 4 years maturity is currently trading at `
900 carrying a coupon rate of 15%. Assuming that the reinvestment rate is 16%, you are
required to calculate Realized Yield to Maturity of the bond.
................................................................... 16 ..............................................................
Prof. Archana Khetan VALUATION OF BONDS
BOND X BOND Y
Face value ` 1,000 ` 1,000
Coupon 7% payable annually 8%payable annually
Years to maturity 1 4
Current price ` 972.73 ` 936.52
Current yield 10% 10%
Advice Mr. A whether he should invest all his money in one type of bond or he should
buy both the bonds and, if so, in which quantity? Assume that there will not be any call
risk or default risk.
Sol. Since, the liability is one shot,
DL = 2 years.
For immunization, DA = DL
................................................................... 17 ..............................................................
VALUATION OF BONDS KHETAN EDUCATION
The bonds are coupon paying and hence, we need to compute duration.
For Bond X,
Year CF PV@10% PV Wixi
1 70 0.909 972.63 972.63
+ 1,000
` 972.63
Dx = = 1year.
` 972.63
For Bond Y,
Year CF PV@10% PV Wixi
1 80 0.909 72.72 72.72
2 80 0.826 66.08 132.16
3 80 0.751 60.08 180.24
4 1,080 0.683 737.64 2,950.56
` 936.52 ` 3335.68
` 3,335.68
Dy = = 3.56 years.
` 936.52
In order to immunize, we would invest in a combination of Bond X & Bond Y, such that
the weighted average duration = 2 years.
WxDx + WyDy = 2
Wx + (1-Wx) 3.56 = 2
Wx + 3.56 – 3.56Wx = 2
3.56 – 2 = 3.56Wx - Wx
1.56 = 2.56Wx
Wx = 61%
Wy = 39%
FV of liability at the end of 2nd year = `1,00,000
`1,00,000
PV =
(1.10)2
= ` 82,644.63
Amount to be invested in X = ` 82,644.63 × 61%
= ` 50,413.22
50, 413.22
No. of Bonds =
972.73
= 51.83 » 52
Amount to be invested in Y = ` 82,644.63 – ` 50,413.22
................................................................... 18 ..............................................................
Prof. Archana Khetan VALUATION OF BONDS
= ` 32,231.41
32, 231.41
No. of Bonds = = 34.42 » 35
936.52
20. The following data are available for three bonds A, B and C. These bonds are used by a
bond portfolio manager to fund an outflow scheduled in 6 years. Current yield is 9%. All
bonds have face value of `100 each and will be redeemed at par. Interest is payable
annually.
................................................................... 19 ..............................................................
VALUATION OF BONDS KHETAN EDUCATION
4 10 0.708 7.08 0.067 0.268
5 10 0.650 6.50 0.061 0.305
6 10 0.596 5.96 0.056 0.336
7 10 0.547 5.47 0.051 0.357
8 10 0.502 5.02 0.047 0.376
9 10 0.460 4.60 0.043 0.387
10 110 0.4224 46.46 0.437 4.370
106.40 1.000 6.862
................................................................... 20 ..............................................................
Prof. Archana Khetan VALUATION OF BONDS
iv. New percentage of B and C bonds that are needed to immunize the portfolio.
Period required to be immunized 6.0000 Year
Less: Period covered from Bond A 3.2175 Year
To be immunized from B and C 2.7825 Year
21. Consider a bond with a face value of ` 100. And coupon = 10% p.a. the bond has a
maturity of 5 years and is trading at par.
Compute:
a. YTM of the bond.
b. Duration and modified duration.
c. New price using PV method if
• interest increases by 1%
• interest decreases by 1%
d. Show that the relationship between interest rate and bond price is inverse & not
linear.
e. Compute Convexity.
f. Compute Convexity effect
g. Compute the new bond price using convexity if
• interest increases by 1%
................................................................... 21 ..............................................................
VALUATION OF BONDS KHETAN EDUCATION
• interest decreases by 1%
FV = ` 100 C = 10% n = 5 years Price = ` 100 [Since, it is trading at par]
Sol.
a. Since, Price = Face value; Coupon = YTM = 10%
b. Computation of duration.
Year CF PV@10% PV WiXi
1 10 0.909 9.09 9.09
2 10 0.826 8.26 16.52
3 10 0.751 7.51 22.53
4 10 0.683 6.83 27.32
5 110 0.621 68.31 341.55
` 100 ` 417.01
417.01
Duration = = 4.17 years
100
D 4.17
M.D = = = 3.79 years
1 + YTM 1.10
If interest changes by 100 bps or 1%, then price of the bond will change by 3.79% in the
opposite direction.
................................................................... 22 ..............................................................
Prof. Archana Khetan VALUATION OF BONDS
22. MP Ltd. issued a new series of bonds on January 1, 2000. The bonds we sold at par (`
1,000), having a coupon rate 10% p.a. and mature on 31st December, 2015. Coupon
payments are made semi-annually on June 30th and December 31st each year. Assume
that you purchased an outstanding MP Ltd. Bond on 1st March, 2008 when the going
interest rate was 12%.
Required:
i. What was the YTM of MP Ltd. Bonds as on January 1, 2000 ?
ii. What amount you should pay to complete the transaction? Of that amount how
much should be accrued interest and how much would represent bonds basic value.
Sol.
i. On the date of issue, the price of the bond = face value.
This means, coupon = YTM = 10%
ii. Price on 30th June, 2008 assuming us a ex coupon date
= ` 50 × PVA (6%, 15) + ` 1000 × PVIF (6%, 15)
= ` 50 × 9.712 + ` 1000 × 0.417
= ` 902.6
Price on 30th June with coupon= ` 902.6 + ` 50 = ` 952.6
Price of the bond on 1st March, 2008
952.6
=
4
1 + 0.12 ×
12
................................................................... 23 ..............................................................
VALUATION OF BONDS KHETAN EDUCATION
= ` 915.96
So on 1st March,
952.6 50
+
4 4
1 + 0.12 × 1 + 0.12 ×
12 12
= ` 867.8 + ` 48.08 = ` 915.96
*Alternate Solution:
Price of the bond on 31st Dec, 2007
= ` 50 × PVA (6%, 16) + ` 1,000 × PVIF (6%, 16)
= ` 50 × 10.106 + ` 1,000 × 0.3936
= ` 898.57
Price on 1st March, 2008
= ` 898.90 + ` 50 × 2/6
= ` 915.57
23. Bank A enter into a Repo for 14 days with Bank B in 10% Government of India Bonds
2028 @ 5.65% for ` 8 crore. Assuming that clean price (the price that does not have
accrued interest) be ` 99.42 and initial Margin be 2% and days of accrued interest be 262
days. You are required to determine.
i. Dirty Price
ii. Repayment at maturity. (consider 360 days in a year)
Sol. i. Dirty Price
= Clean Price + Interest Accrued
10 262
= 99.42 + 100 × × = 106.70
100 360
24. Wonderland Limited has excess cash of ` 20 lakhs, which it wants to invest in short term
marketable securities. Expenses relating to investment will be ` 50,000.
The securities invested will have an annual yield of 9%.
The company seeks your advice
................................................................... 24 ..............................................................
Prof. Archana Khetan VALUATION OF BONDS
................................................................... 25 ..............................................................