Manually compute the modified duration for the following bond: Maturity Date: 04/20/2017 Settlement Date: 02/05/2016 Coupon...

Question

Question

Maturity Date: 04/20/2017

Settlement Date: 02/05/2016

Coupon Rate: 10%

Coupon Frequency: Semiannual

Yield-to-Maturity: 12%

Day Count Convention: 30/360 (European)

Answer 1

Answer #1

T	360/2	180
t	25+30+20	75

Period	Time to reciept	Cashflow	Present value	Weight	Time * Weight
n	n - t/T	CF	CF/1.12^n	CFn/Sum(CF)
1	0.583333333	5	4.464285714	0.062682904	0.036565027
2	1.583333333	5	3.985969388	0.055966878	0.088614224
3	2.583333333	5	3.558901239	0.049970427	0.12909027
4	3.583333333	5	3.177590392	0.044616453	0.159875622
5	4.583333333	5	2.837134279	0.039836118	0.182582209
6	5.583333333	105	53.19626772	0.74692722	4.170343647
			71.22014874	1	4.767070998


Mac Dur	*(TimeWeight)/No. of coupon payments per year**	2.383535499
Mod Dur	Mac Dur/(1+coupon%/No. coupon payments per year)	2.270033809

Give a thumbs up if this helped :)

Add a comment

Answer 2

Similar Homework Help Questions

Find both the Macaulay and Modified duration of a bond with a settlement date of May...

Find both the Macaulay and Modified duration of a bond with a settlement date of May 27, 2020, and maturity date November 15, 2031. The coupon rate of the bond is 5.5%, and the bond pays coupons semiannually. The bond is selling at a bond -equivalent yield to maturity of 6.5%.
Find the duration of a bond with settlement date June 14, 2018, and maturity date December...

Find the duration of a bond with settlement date June 14, 2018, and maturity date December 21, 2027. The coupon rate of the bond is 8%, and the bond pays coupons semiannually. The bond is selling at a yield to maturity of 9%. (Do not round intermediate calculations. Round your answers to 4 decimal places.) Macaulay Duration Modified Duration
Find the duration of a bond with settlement date June 10, 2012, and maturity date December...

Find the duration of a bond with settlement date June 10, 2012, and maturity date December 13, 2021. The coupon rate of the bond is 7%, and the bond pays coupons semiannually. The bond is selling at a yield to maturity of 8%. (Do not round intermediate calculations. Round your answers to 4 decimal places.) Macaulay duration Modified duration

Bond B Settlement Date Maturity Date Coupon Rate Required Return (YTM) Redemption Value Frequency...

pleas the answer using excel Bond B Settlement Date Maturity Date Coupon Rate Required Return (YTM) Redemption Value Frequency Basis 28/3/19 15/8/34 10.00% 8.00% 1,000 Modified Duration Convexity Predicted % Change Bond B Settlement Date Maturity Date Coupon Rate Required Return (YTM) Redemption Value Frequency Basis 28/3/19 15/8/34 10.00% 8.00% 1,000 Modified Duration Convexity Predicted % Change
Bond dealers most often quote the: Flat Price Full Price Full Price plus accrued interest none...

Bond dealers most often quote the: Flat Price Full Price Full Price plus accrued interest none of the above. An investor, with an investment horizon of 10 years is considering purchasing a bond with a Macaulay Duration of 12. If the investor goes through with the purchase she will be subject to ________ risk and be worse off if interest rates ________. reinvestment; go up reinvestment; go down interest rate; go down none of the above. What is the Approximate...
A fixed coupon bond has a coupon rate of 4% paid semi-annually with a maturity date...

A fixed coupon bond has a coupon rate of 4% paid semi-annually with a maturity date of 8/15/20. The bond uses a 30/360 day counting convention and is trading at a yield today (12/10/19) of 3%. Calculate the following for today: The Dirty Price of the Bond

A fixed coupon bond has a coupon rate of 4% paid semi-annually with a maturity date...

A fixed coupon bond has a coupon rate of 4% paid semi-annually with a maturity date of 8/15/20. The bond uses a 30/360 day counting convention and is trading at a yield today (12/10/19) of 3%. Calculate the following for today: The Dirty Price of the Bond Answer this: The Accrued Interest of the Bond
A bond has the following terms: January 1, 2000, settlement date January 1, 2020, maturity date...

A bond has the following terms: January 1, 2000, settlement date January 1, 2020, maturity date 10 percent semiannual coupon 12 percent yield $100 redemption value Frequency is semiannual 30/360 basis =PRICE("1/1/2000","1/1/2020",10%,12%,100,2,0)=84.954 Bond Problems 1. Calculate the price of a 20-year 10% coupon bond with a par value of $1,000. The bond should be price to provide a yield to maturity of 11%. Interest payments are paid semiannually. 2. Calculate the price of a 20-year 10% coupon bond with a...
A fixed coupon bond has a coupon rate of 4% paid semi-annually with a maturity date...

A fixed coupon bond has a coupon rate of 4% paid semi-annually with a maturity date of 8/15/20. The bond uses a 30/360 day counting convention and is trading at a yield today (12/10/19) of 3%. Calculate the following for today: The Dirty Price of the Bond The Accrued Interest of the Bond Answer this :The Clean Price of the Bond

Find the duration of a bond with settlement date June 10, 2018, and maturity date December...

Find the duration of a bond with settlement date June 10, 2018, and maturity date December 13, 2027. The coupon rate of the bond is 7%, and the bond pays coupons semiannually. The bond is selling at a yield to maturity of 8%. (Do not round intermediate calculations. Round your answers to 4 decimal places.)