ou are given price information on 10 stocks, the FTSE All Share Index, and risk-free rate (UK T-bill rate) from 07/2015 to 05/2020. Data can be accessed in the Excel spread sheet “Data _coursework_2021.csv”. You are required to answerthe following questionsindependently.Question 1.(25 marks in total)(a)Calculate each stock’s average monthly return, its return variance and standard deviationand betaover the period 07/2015 to 05/2020, using the price information of the FTSE All Share Index as a proxy for market portfolio. Summarize your results in a table, and briefly describe how these are calculated(Please do not use Excel functions as your explanation).(9marks)(b)Construct three types of portfolios. Portfolio A consists of any 3 of the stocks, Portfolio B consists of any 6 of the stocks, and Portfolio C consists of all 10 stocks. Assuming that each stock has equal weight in the portfolio, calculate Portfolio A, B, and C’s average monthly returns, return variances and standard deviations, and betas. Summarizeyour results in a table, and briefly describe how these are calculated(Please do not use Excel functions as your explanation). (8marks)(c)If you rank portfolio A, B and C according to theirbetas and return variances respectively, will the threeportfolios have same ranking? Can you provide economic reasons as to why the two rankings should be (in)consistent with each other?(8marks)Question 2.(15 marks in total)(a)If you are asked to construct your own portfolio by using information about the individual stocks in the excel spreadsheet, are there any stocks which you should not include in your portfolio? Can you provide your justifications? (You may draw performance graphs of one stock against the market portfolio).(9marks)(b)Construct your own portfolio which consists of a different number of stocks from Portfolio A, B, and C and is “the best” for its return/risk characteristics. And can you justify why you choose such a portfolio?(6marks)
4Part 2:(60 Marks in total)Answer ALLthe questions.Details of calculations are required for Part 2.
Question 3.(20 marks in total)John Davidsonis aninvestment adviserat Leeds Asset Management plc. He is asked by a client toevaluatevarious investment opportunities currently available and hehascalculatedexpected returns and standard deviations for five different well-diversified portfoliosof risky assets:PortfolioExpected returnStandard deviationQ7.8%10.5%R10.0%14.0%S4.6%5.0%T11.7%18.5%U6.2%7.5%(a) For each portfolio, calculate the risk premium per unit of risk(Sharpe ratio)that you expect to receive. Assume that the risk-free rate is 3.0%.(5Marks)(b) Using answers from a, which of these five portfolios is most likely to be the market portfolio andexplain why.(200words maximum)(5Marks)(c) If you are only willing to make an investment with a standard deviation of7.0%, is it possible for you to earn a return of 7.0%?(5Marks)(d) What is the minimum level of risk that would be necessary for an investment to earn 7.0%? What is the composition of the portfolio along the Capital Market Line (CML)that will generate that expected return?(5Marks)
Question 4.(13Marks in total)(a)Jade Smith is a foreign exchange trader for a bank in New York. He has $1 million for a short-term money market investment and he faces the following quotes:(Assuming there are 360 days a year)Spot exchange rate (SFr/$)1.28103-month forward rate (SFr/$)1.2740
5US dollar annualinterest rate4.8%Swiss franc annualinterest rate3.2%He wonders whether he should invest in US dollars for 90 daysor make a covered interest arbitrage (CIA) investment in the swiss franc, and what is the profit/loss if he carries out this investment.(7Marks)(b)Using the same values in the table above, Jade decides to seek the full 4.8% return available in the US dollars by not covering his forward dollar receipts –an uncovered interest arbitrage (UIA) transaction.What is the maximum expected spot exchange rate (SFr/$) at the end of the 90-dayperiod at whichJadecan avoid losing money?(6Marks)
Question 5. (27Marks in total)Consider a semi-annual bond that has a par value of 100, a 15-year maturity, a 5% coupon rate. Monthly interest rate is 0.412%. (a) Calculate the annualized semi-annual compounding yield. (3 marks)(b) What is the price of the bond (without calculation)? And explain why you can determine the price of the bond without calculation? (4marks)(c) Using answers from (b), calculate the modified duration of this bond. (3 marks)(d) Using answers from (b) and (c), suppose that the bond’s yield to maturity decreases to 3.5%. How much will the bond price increase by applying the duration rule? (5marks)(e) Do you agree with the following statement, and explain why?(5marks)“If two bonds have the same duration, then the percentage change in price of the two bonds will be the same for a given change in interest rates.” (f) Discussthe problems with the traditional bond pricing approach by using the yield to maturity. (300 words Maximum)(7Marks
