Description Question 1 The term structure is a basic device that provides a snapshot of the interest rate environment in terms of lending/borrowing costs across the various terms. (a) Describe the nature of the term structure and how it is constructed in detail. Use Excel as an aid in your working. (15 marks) (b) Do the following exercises from Chapter 8 of the textbook: 81, 82. Be sure to express your answers clearly in your own words, based on your own understanding, with Python as an aid in your calculations and reasoning. (5 marks) Question 2 The principle of no-arbitrage is a fundamental notion that is applied to relate prices or rates in the market on theoretical terms. (a) Apply the principle of no-arbitrage to find USDSGD if it is given that a broker quotes EURUSD as and EURSGD as . (10 marks) (b) Do the following exercises from Chapter 9 of the textbook: 85, 86. Be sure to express your answers clearly in your own words, based on your understanding, with Python as an aid in your calculations and reasoning. (10 marks) Question 3 The equity option market is closely linked to the stock market but at the same time it is structurally different from the latter. (b) Do the following exercises from Chapter 11 of the textbook: 98, 100. Be sure to express your answers clearly in your own words, based on your own understanding, with Python as an aid in your calculations and reasoning. (5 marks) Question 4 Jonathan’s portfolio of fixed income instruments comprises the following corporate bonds: Jonathan collected the following data from government bonds: Assume that all bonds listed pay semi-annual coupons (or none) and have $100 face value. (a) Compute all risk-free zero rates from the given information. (b) Find the value of Jonathan’s portfolio. (c) Explain what duration is and calculate the duration of bonds I, II, III and IV. (d) Explain what convexity is and estimate, using duration and convexity, the value of Jonathan’s portfolio if interest rate falls by 1.5%. (5 marks) Show your workings clearly with calculations performed with Excel