Question

A $1,000 par value 10-year bond with annual coupons is redeemable at $1,055, and has a purchase price of $986 at a yield rate of 4% per annum. The coupons are non-level and increase by $2 per year. (a) Find the amount of the first coupon payment. Round your answer to the nearest 0.01. (b) Using a spreadsheet software, construct a bond amortization schedule for all the years. You may use your own spreadsheet template. (c) Suppose that the issue date for this bond was on June 15, 2015 with maturity date June 15, 2025. Assume that the coupon dates are June 15 of each year. On July 18, 2019, an investor purchased the bond to yield 3.8% annually. Find the purchase price, accrued interest and the quoted price of the bond at the date of purchase. Use the actual/actual method. (Note: you may use a software to check your answers. However, please show your written working for this question.)

Answer 1

(c) Let  P be  the purchase price.

P*3.8/100=41.44

Hence P= 41.44*100/3.8 = $ 1090.52

Accrued interest= 33/365*39.44 = $ 3.56

(a)4% yield rate on investment of $986/- gives the figure of $39.44.

Amount of 1st coupon payment = 39.44+2= $ 41.44

( b) Amortisation schedule is attached.

	interest	Int amount	Increment	total payments	amortisation	FV=1000	Mkt Price=986
1	3.94	39.44	2	41.44	1.4
2	3.94	39.44	4	43.44	1.4
3	3.94	39.44	6	45.44	1.4
4	3.94	39.44	8	47.44	1.4
5	3.94	39.44	10	49.44	14
6	3.94	39.44	12	51.44	1.4
8	3.94	39.44	14	53.44	1.4
9	3.94	39.44	16	55.44	1.4
10	3.94	39.44	18	57.54	1.4
total				445.06	14.00