Calculate YTM and Bond Valuation Methods
Calculate YTM and Bond Valuation Methods
7% Debenture 100 FV
life 8 N
CMP 77 Coupon Rate
Compute YTM Coupon Amount
Value of Bond
Trial and Error Method (Find
Discount Rate
PV Of CI (Annual CI*PVIFAr,n)+(Terminal value*PVIFr,n) PV Of CI
Interpolation Calculation
LDR
HDR
PV of bond at LDR
PV of bond at HDR
CMP
YTM= LDR+(PV@LDR-CMP)/(PV@LDR-PV@HDR)*(HDR-LDR) YTM
INTERPRETATION:-
If investor invest Rs 77 in 7% Rs 100 debt and hold it till the
end of maturity (end of 8th year) then investor might earn a
yield of 11.584% p.a.
100
8
7%
7
Interpolation Calculation
10%
12%
₹ 84.00
₹ 75.16
77
11.584%
Value of Bond
Trial and Error Method (Finding Bracketing Rates)
r1 r2
Discount Rate 6% 11%
PV Of CI ₹ 50.00 ₹ 39.42
Interpolation Calculation
LDR 6%
HDR 11%
INTERPRETATION:- PV of bond at LDR ₹ 50.00
If investor invest Rs 41 in 6% Rs 50 PV of bond at HDR ₹ 39.42
debt and hold it till the end of CMP 41
maturity (end of 6th year) then
investor might earn a yield of YTM 10.255%
10.133% p.a.
racketing Rates)
Q3
8% Debenture of Rs. 100 FV 100
Life: 7 years Coupon rate 8%
Current market price: Rs. 87 Coupon amt 8
Compute YTM N 7
CMP 87
Value of Bond
Trial and Error Method (Finding Bracketing Rates)
r1 r2
Discount Rate 8% 11%
PV Of CI ₹ 100.00 ₹ 85.86
Interpolation Calculation
LDR 8%
HDR 11%
PV of bond at LDR ₹ 100.00
PV of bond at HDR ₹ 85.86
CMP 87
YTM 10.76%
Q.4
9% Debenture of Rs. 500 FV 500
Life: 10 years Coupon rate 9%
Current market price: Rs. 467 Coupon amt 45
Compute YTM N 10
CMP 467
Value of Bond
Trial and Error Method (Finding Bracketing Rates)
r1 r2
Discount Rate 9% 11%
PV Of CI ₹ 500.00 ₹ 441.11
Interpolation Calculation
LDR 9%
HDR 11%
PV of bond at LDR ₹ 500.00
PV of bond at HDR ₹ 441.11
CMP 467
YTM 10.12%
(Finding Bracketing Rates)
Q.5
15% Debenture of Rs. 10 FV 10
Life: 8 years Coupon rate 15%
Current market price: Rs. 7.75 Coupon amt 1.5
Compute YTM N 8
CMP 7.75
Value of Bond
Trial and Error Method (Finding Bracketing Rates)
r1 r2
Discount Rate 15% 23%
PV Of CI ₹ 10.00 ₹ 7.19
Interpolation Calculation
LDR 15%
HDR 23%
PV of bond at LDR ₹ 10.00
PV of bond at HDR ₹ 7.19
CMP 7.75
YTM 21.40%
racketing Rates)
Q.6
6 % Debenture of Rs. 100 FV 100
Life: 6 years Coupon rate 6%
Discount rate: 8% Coupon amt 6
YTM: 9% N 6
Compute Duration and convexity Discount rate 8%
Change in Interset rate 0.5 % and in YTM is 0.8 % YTM (Modified/ Convexity) 9%
What will be the impact on Debenture price? Change in int 0.50%
Change in YTM 0.80%
0.034796
3.15784
93.912
87.596
Q.7
7% Debenture of Rs. 300 FV
Life: 8 years Coupon rate
Discount rate: 12% Coupon amt
YTM: 10% N
Compute Duration and convexity Discount rate
Change in Interset rate 1.5 % and in YTM is 1 % YTM (Modified/ Convexity)
What will be the impact on Debenture price? Change in int
Change in YTM
0.0916
20.6631
246.149
204.822
0.055538
12.5231
238.01
212.96
0.050489
11.38463
236.87
214.10
300
7%
21
8
12%
10%
1.50%
1.00%
Q.8
8% Debenture of Rs. 400 FV
Life: 7 years Coupon rate
Discount rate: 14% Coupon amt
YTM: 11% N
Compute Duration and convexity Discount rate
Change in Interset rate 2 % and in YTM is 1.5 % YTM (Modified/ Convexity)
What will be the impact on Debenture price? Change in int
Change in YTM
0.1075
31.9395
329.020
265.141
0.072643
21.58074
318.66
275.50
0.065444
19.44211
316.52
277.64
400
8%
32
7
14%
11%
2.00%
1.50%
Q9
9% Debenture of Rs. 800 FV
Life: 8 years Coupon rate
Discount rate: 8% Coupon amt
YTM: 12% N
Compute Duration and convexity Discount rate
Change in Interset rate 0.7 % and in YTM is 0.6 % YTM (Modified/ Convexity)
What will be the impact on Debenture price? Change in int
Change in YTM
0.0426
36.0746
882.048
809.898
0.032635
27.60813
873.58
818.36
0.029138
24.65012
870.62
821.32
800
9%
72
8
8%
12%
0.70%
0.60%
Q10
10% Debenture of Rs. 200 FV 200
Life: 5 years Coupon rate 10%
Discount rate: 6% Coupon amt 20
YTM: 8% N 5
Compute Duration and convexity Discount rate 6%
Change in Interset rate 0.6 % and in YTM is 0.9 % YTM (Modified/ Convexity) 8%
What will be the impact on Debenture price? Change in int 0.60%
Change in YTM 0.90%
0.0254
5.9412
239.640
227.758
0.035309
8.251637
241.95
225.45
0.032693
7.640404
241.34
226.06
Q11
Shares A B C D
Avg Return 17% 15% 16% 14%
Risk 1.8 1.7 1.9 1.3
Beta 0.8 1.3 -1.1 1.1
Rm 15.50%
Rf 6%
Are the shares fairly priced?
Rm 20.00%
Rf 7%
Are the shares fairly priced?
Rm 13.00%
Rf 4%
Are the shares fairly priced?
Rm 18.70%
Rf 5%
Are the shares fairly priced?
Rm 22.00%
Rf 5%
Are the shares fairly priced?
Rm 24%
Rf 9%
Comment on the performance of the Mutual Funds using Sharpe ratio, Treynor ratio and Jensen measure?
Mutual funds Actual Return Beta Rm-Rf CAPM Based Return Jenson Ratio Ranking
A 22.80% 1.62 15.00% 33.3% -10.50% 4
B 27.60% 1.86 15.00% 36.9% -9.30% 3
C 21.60% 1.104 15.00% 25.6% -3.96% 1
D 31.20% 1.98 15.00% 38.7% -7.50% 2
INTERPRETATION:-
sen measure?
Q17
Mutual Funds A B C D
Avg Return 27.36% 33.12% 25.92% 37.44%
Risk 2.664 2.736 2.088 2.7936
Beta 1.944 2.232 1.3248 2.376
Rm 23%
Rf 8%
Comment on the performance of the Mutual Funds using Sharpe ratio, Treynor ratio and Jensen measure?
Mutual funds Actual RetBeta Rm-Rf CAPM Based Return Jenson Ratio Ranking
A 27.36% 1.944 15.00% 37.16% -9.80% 4
B 33.12% 2.232 15.00% 41.48% -8.36% 3
C 25.92% 1.3248 15.00% 27.87% -1.95% 1
D 37.44% 2.376 15.00% 43.64% -6.20% 2
n measure?
Q18
Mutual Funds A B C D
Avg Return 32.83% 39.74% 31.10% 44.93%
Risk 3.1968 3.2832 2.5056 3.35232
Beta 2.3328 2.6784 1.58976 2.8512
Rm 34%
Rf 9%
Comment on the performance of the Mutual Funds using Sharpe ratio, Treynor ratio and Jensen measure?
Rm 43%
Rf 12%
Comment on the performance of the Mutual Funds using Sharpe ratio, Treynor ratio and Jensen measure?
Mutual funds Actual RetBeta Rm-Rf CAPM Based Return Jenson Ratio Ranking
A 39.40% 2.79936 31.00% 98.78% -59.38% 2
B 47.69% 3.21408 31.00% 111.64% -63.94% 3
C 37.32% 1.907712 31.00% 71.14% -33.81% 1
D 53.91% 3.42144 31.00% 118.06% -64.15% 4
Q20
Mutual Funds A B C D
Avg Return 47.28% 67.23% 44.79% 64.69%
Risk 4.603392 4.727808 3.60806 4.82734
Beta 3.35923 3.856896 1.289254 4.105728
Rm 51%
Rf 16%
Comment on the performance of the Mutual Funds using Sharpe ratio, Treynor ratio and Jensen measure?
Mutual funds Actual RetBeta Rm-Rf CAPM Based Return Jenson Ratio Ranking
A 47.28% 3.359232 35.00% 133.57% -86.30% 3
B 67.23% 3.856896 35.00% 150.99% -83.76% 2
C 44.79% 1.289254 35.00% 61.12% -16.33% 1
D 64.69% 4.105728 35.00% 159.70% -95.01% 4