Please use EXCEL to do it, Thanks!
Please refer to below spreadsheets for calculations and answers.
A.
Formula reference-
Please use EXCEL to do it, Thanks! Consider XYZ stock currently worth $95. On Jan 15th,...
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, 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 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 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 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 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 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 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 $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 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...