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.

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Please find below spreadsheet for calculations and answer

97.16 Stock Spot Price(S Current date expiry date Theoretical Price of Forward Risk free Interest (r Time(t) Theoretical Price of Forward $ 95.00 1/15/2019 10/15/2019 SeArt 4 3% 0.74794521 $ 97.16 12 B) 13 5.63% $ 95.00 1/15/2019 10/15/2019 0.74794521 Stock Spot Price(S) Current date expiry date Time(t Short Position of forward at Return on expiration date Return (%) Annualized rate of return(%) 17 19 20 21 $4.00 4.21% 5.63% 23 C 1.71 Spot Price of on April 15th,2019 Spot date expiry date Theoretical Price of Forward Time (t), Expiry date - Spot date Risk free interest rate (r) Market Value of Forward contract on Spot date $ 94.00 Market value of Forward contract 4/15/2019 at any date during contract 10/15/2019period is difference between S 97.16 Price of underlying assets in cash 25 27 0.50 market on that particular date 0.03 and present value of forward 30 31 32 | S1.71 price on that date

Formula reference -

Formula reference

Add a comment
Know the answer?
Add Answer to:
Please use excel to do it. Consider XYZ stock currently worth $95. On Jan 15, 2019,...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Please use excel to do it! Consider XYZ stock currently worth S95. On Jan 15h, 2019,...

    Please use excel to do it! Consider XYZ stock currently worth S95. On Jan 15h, 2019, you plan to sell it9 months later on Oct 15th, 201 may have fallen significantly by then. To hedge this risk, you enter into a forward contract to the stock which will mature on Oct 15th, 2019. Assume that the risk- free interest rate will remain at 3.0% pa. in 2019. Use continuous compounding method and YEARFRAC function with ACT/ACT basis Show your answers...

  • Please use EXCEL to do it, Thanks! Consider XYZ stock currently worth $95. On Jan 15th,...

    Please use EXCEL to do it, Thanks! Consider XYZ stock currently worth $95. On Jan 15th, 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 151h, 2019. Assume that the risk free interest rate will remain at 3.0% pa. in 2019. Use continuous...

  • Please use EXCEL to do it, Thanks! Show your answers along with the formula and steps...

    Please use EXCEL to do it, Thanks! Show your answers along with the formula and steps you used for each question Problem 2: A US-based firm expects to pay 1,000,000 for importing goods 90 days later. Thc firm's manager want to hedgc against possible currency risk in the future. The risk-free rate in US is 2% pa and the Euro risk-free rate is 3% pa Both interest rates will remain the same in 90 days. The current spot exchange rate...

  • - On 8/15/2019, a 3-year forward contract, expiring 8/15/2022, on a non-dividend-paying stock was entered into...

    - On 8/15/2019, a 3-year forward contract, expiring 8/15/2022, on a non-dividend-paying stock was entered into when the stock price was $55 and the risk-free interest rate was 10.8% per annum with continuous compounding. 1 year later, on 8/15/2020, the stock price becomes $58. What is the "delivery" price of the forward contract entered into on 8/15/2019? Round your answer to the nearest 2 decimal points. For example, if your answer is $12.345, then enter "12.35" in the answer box....

  • Assume that you own a dividend-paying stock currently worth $150. You plan to sell the stock in 2...

    Assume that you own a dividend-paying stock currently worth $150. You plan to sell the stock in 250 days. In order to hedge against a possible price decline, you wish to take a short position in a forward contract that expires in 250 days. The risk-free rate is 5.25% per annum (discretely compounding). Over the next 250 days, the stock will pay dividends according to the following schedule: Days to Next Dividend Dividends per Share ($) 30 1.25 120 1.25...

  • Please use EXCEL to do it Show your answers along with the formula and steps you...

    Please use EXCEL to do it Show your answers along with the formula and steps you used for each question Table 1.en January 1,2019 LIBOR so Im days) Problem 3: On January 1, 2019,a US-based lender wishes to hedge against decrease n future interest rates. The lender proposes to hedge against this risk by entering into an FRA with the notional amount of S10 million Use 30/360 day ceent coav ention ลnd simple interest rate 540% 530% s 20% 510%...

  • 4. Forward and Futures Prices A. (6 points) Suppose the stock price is $35 and the...

    4. Forward and Futures Prices A. (6 points) Suppose the stock price is $35 and the continuously compounded interest rate is 5%. What is the 6-month forward price, assuming dividends are zero? B. (6 points) If the forward price is $35.50, what is the annualized continuous dividend yield? 5. Forward and Futures Prices Suppose you are a market-maker in S&R index forward contracts. The S&R index spot price is 1100, the risk-free rate is 5%, and the dividend yield on...

  • Assume the following premia: Strike $950 Call $120.405 93.809 84.470 71.802 51.873 Put $51.777 74.201 1000...

    Assume the following premia: Strike $950 Call $120.405 93.809 84.470 71.802 51.873 Put $51.777 74.201 1000 1020 84.470 101.214 1050 1107 137.167 I 1) Suppose you invest in the S&P stock index for $1000, buy a 950-strike put, and sell a 1050- strike call. Draw a profit diagram for this position. What is the net option premium? 2) Here is a quote from an investment website about an investment strategy using options: One strategy investors apply is a "synthetic stock."...

  • 1. Consider the futures contract to buy/sell December gold for $500 per ounce on the New...

    1. Consider the futures contract to buy/sell December gold for $500 per ounce on the New York Commodity Exchange (CMX). The contract size is 100 ounces. The initial margin is S3,000, and the maintenance margin is $1,500. 1.a. Suppose that you enter into a long futures contract to buy December for $500 per ounce on the CMX What change in the futures price will lead to a margin call? If you enter a short futures contract, what futures price will...

  • I screenshot everything and put them in order, please complete every little boxes. the others are...

    I screenshot everything and put them in order, please complete every little boxes. the others are the info provided for it. Problems: Nondirection Dependent Strategies -- Straddles and Strangles Straddles and Strangles can be profitable regardless of which way the underlying moves -- profitability is not dependent on the direction of the underlying. Depending on whether you are long or short the position, profitability may not depend upon a move at all. This does not by any means make them...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT