Question

Consider XYZ stock currently worth $95. On Jan 15, 2019, you plan to sell it 9 months later on Oct 15h, 2019 to raise money, but are concerned that the price may have fallen significantly by then. To hedge this risk, you enter into a forward contract to the stock which will mature on Oct 1sth, 2019. Assume that the risk-free interest rate will remain at 3.090 p.a. in 2019. Use continuous compounding method and YEARFRAC function with ACT/ACT basis. Show your answers along with the formula and steps you used for each question A) Ans: Question 1: Assume that XYZ stock will pay NO dividend in 9 months. A) Calculate the theoretical price of the forward today? (2 points) B) Ans: B) Suppose you took the short position at the forward price of S99. What will be your annualized rate of return? (2 points) C) Suppose you took the short position at the forward price computed in (A) above. On Apr 15h, 2019, the spot price of the asset is $94. What is the market value of your short position in the forward contract at this point? (2 points) C) Ans: D)What is the value of the forward contract at expiration assuming the contract is entered into at the price computed in (A) above. The spot price of the asset is $92 at expiration.(2 points) E) Suppose you took the short position at the forward price computed in (A) above. What will be your annualized rate of return at expiration? (2 point) D) Ans: E) Ans:

Please use excel to do it.

Answer 1

Please find below spreadsheet for calculations and answer

Formula reference -

Formula reference