Question

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 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 dividends continuously at a rate of 1 .5% per year Ans: A) Calculate the theoretical price of the forward today? (1 points) B) Suppose you took the short position at the forward price computed in (A) above. On May 15th, 2015, the spot price of the asset is $95. What is the market value of your short position in the forward contract at this point? (1 points) C) Ans: C) 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). Do not forget to include FV of dividends.

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

Please refer to below spreadsheets for calculations and answers.

A.E46 92.60 S9.00Theoretical Price of Forward contract is Future value of Spot Price of assets 1/15/2019minus Future value of any dividends during, on expiry date at risk free 10/15/2019interest rate Stock Spot Price(S) Current date expiry date Risk free Interest (r Dividends (each 1st Dividend date 2nd Dividend date 3rd Dividend date Time(t1l), 1st dividend - expiry date Time(t2), 2nd Dividend - expiry date Time(t3), 3rd dividend - expiry datee Time(t), Current date - Expir Future value of 1st dividend on expir Future value of 2nd dividend on expi Future value of 3rd dividend on expir Theoretical Price of Forward 4 $1.50 2/15/2019where 4/15/2019 9/15/2019 0.6630137 10 F Forward Price S = Assets Spot Price D Dividends r risk free interest t time n number of dividends 12 13 0.50 16 I 17 18 19 0.082192 0.74794521 $ 1.5301 $ 1.5227 $ 1.5037 $ 92.60

Formula reference-


E46 -С 19 Stock Spot Price(S Current date expiry date Risk free Interest (r Dividends (each 1st Dividend date 2nd Dividend date 3rd Dividend date Time(t1l), 1st dividend - expiry date Time(t2), 2nd Dividend - expiry date Time(t3), 3rd dividend - expiry datee Time(t), Current date - Expir Future value of 1st dividend on expir Future value of 2nd dividend on expi Future value of 3rd dividend on expir Theoretical Price of Forward 4 95 43480 43753 0.03 1.5 43511 43570 43723 12 YEARFRAC(C9,C6,1 YEARFRAC(C10,С6,1 YEARFRAC(C11,C6,1 YEARFRAC(C5,C6,I 16 17 18 19 -C8 EXP(C7 C13 -C8 EXP(C7 C14 C4 PC7 C15)-SUM(C16:C18)U28 21 22 B) 23 (3.56) Spot Price of on May 15th, 2019 Spot date expiry date Theoretical Price of Forward in (A Time (t), Expiry date - Spot date Risk free interest rate (r) Market Value of Forward contract on Spot date$ 95.00 25 5/15/2019 10/15/2019 Market value of Forward contract at any date during contract period is 27 28 29 92.60difference between Price of underlying assets in cash market on that 0.419178particular date and present value of forward price on that date 0.03 (3.56)U28 21 22 B 23 -C30 Spot Price of on May 15th,2019 Spot date expiry date Theoretical Price of Forward in (A Time (t), Expiry date - Spot date Risk free interest rate (r) Market Value of Forward contract on Spot date 95 43600 43753 -C19 25 27 28 YEARFRAC(C25,C26,1 0.03 C27/EXP(C28 C29)-C24 30E46 DI 31 32 C) 0.60 34 35 36 $ $ Market Value of Forward contract on Spot date |$ 92.00 92.60 0.60 Theoretical Price of Forward in (A)C36 Vf-C35-C34 31 32 C) -C36 Spot Price of on expiry date Theoretical Price of Forward in (A) Market Value of Forward contract on Spot date 92 -C27 -C35-C34 34 35 36

Add a comment
Know the answer?
Add Answer to:
Please use EXCEL to do it, Thanks! Consider XYZ stock currently worth $95. On Jan 15th,...
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. Consider XYZ stock currently worth $95. On Jan 15, 2019,...

    Please use excel to do it. 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...

  • 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...

  • 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...

  • 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...

  • The common stock of the C.A.L.L. Corporation has been trading in a narrow range around $95...

    The common stock of the C.A.L.L. Corporation has been trading in a narrow range around $95 per share for months, and you believe it is going to stay in that range for the next 6 months. The price of a 6-month put option with an exercise price of $95 is $10.90. a. If the risk-free interest rate is 8% per year, what must be the price of a 6-month call option on C.A.L.L. stock at an exercise price of $95...

  • please just do question 7. thank you Silicon MicroSystems, Inc. (SMSI) stock is currently selling for...

    please just do question 7. thank you Silicon MicroSystems, Inc. (SMSI) stock is currently selling for $100 and the firm pays no dividends. The stock's volatility is 0.30 and the risk-free rate is 8%. Consider the following 6-month call and put options on SMSI stock (assume that contract size is 1 share): 6. Call 1 Call 2 Call 3 Strike $90 Price $12.817 $6.999 $3.380 Delta Gamma $100$110 0.7690.548 0.333 ma 0.0180.024 0.022 Put 1 90 Put 2 Put 3...

  • The question is complete, and please answer ALL of the boxes by the info provided. thanks...

    The question is complete, and please answer ALL of the boxes by the info provided. thanks Short Straddle Short Straddle Composition: Short a call and a put with the same strike and expiration $35.00 $30.00 Max Profit: the premium collected (credit) $25.00 Max Loss: T Unlimited to the upside, limited by the price of the stock to the downside $20.00 $15.00 - -- Short Call | BEP: There are 2 --strike minus credit & strike plus credit • Short Put...

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