In: Finance
Rierson owns a garment factory in Spain and sells designer clothes to US and other European countries. He is trying attract some investments from US that he can use to expand further into the US market. US investors are looking for stable cash flow, which is going to be a challenge given that the fashion industry is changing constantly and he can get stuck with unsold inventory. To allay their fears, Rierson decides to investment some of the capital raised into Italian 10 year Government Bonds. He explains that the return from these bonds will be used to improve his operations. Ignoring currency exposure, consider the following: (15 PTS)
a. He decides to invest into ten year 1,000 EURO Government bond with 8% coupon rate and semi-annual coupons. If the bond is currently trading for a price of 957.35 Euros, what is the bond's yield to maturity? Assume is buys 10,000 of these bonds. (10 PTS)
b. Suppose he is told that the yield to maturity has increased to 15% (expressed as an APR with semiannual compounding). What price is the bond trading for now? (5 PTS)
a. Below is the Bond price calculation.
Period | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 |
Cashflow | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 1040 |
PV | 38.34 | 36.75 | 35.23 | 33.77 | 32.37 | 31.03 | 29.74 | 28.51 | 27.33 | 26.20 | 25.11 | 24.07 | 23.07 | 22.12 | 21.20 | 20.32 | 19.48 | 18.67 | 17.90 | 446.11 |
Bond price | 957.35 |
Since the coupon payment is semi-annual, the periodic payment is 40 and the total period is 10*2 = 20.
PV = cashflow / ((1+yield-to-maturity)^period)
Bond price = sum of all PVs
Using hit and trial or the Goal seek function in excel, we calculate the YTM as 4.32%. for annualising it, we multiply it by 2 to get 8.65%.
b. If the YTM is increased to 15% annually, we divide it by 2 to get periodic ytm as 7.5%.
Period | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 |
Cashflow | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 1040 |
PV | 37.21 | 34.61 | 32.20 | 29.95 | 27.86 | 25.92 | 24.11 | 22.43 | 20.86 | 19.41 | 18.05 | 16.79 | 15.62 | 14.53 | 13.52 | 12.58 | 11.70 | 10.88 | 10.12 | 244.83 |
Bond price | 643.19 |