Please use excel if applicable
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:
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.
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?