Final project - fire 650

Assignment Help Finance Basics
Reference no: EM131313921

Final Project - FIRE 650

Refer to the template spreadsheet provided.  Stock A has an annualized volatility equal to 18% for which you have just written an out-of-the-money 26 week call option.  The risk free rate is 2% per annum and the strike price is $100.  There is another asset called the "index" which has an annualized volatility equal to 15% and whose returns have covariance 0.0216 with Stock A. 

Express Stock A, the Index, the call option and the Forward price in column P in dollars and cents).  Account for the running cost of the hedge in column N and the beta neutral hedge in column S in thousands of dollars.  Express the Hedge, Exercise $, Option Sale and Profit (cells N31-N34) as well as the Forward Profit/Loss in thousands of dollars.

1.       Complete column G which denotes the remaining time to expiration. 

2.      Model the price dynamic for Stock A in column H as Brownian motion.

3.      Model the price dynamic for the Index in column R as Brownian motion.

4.      Calculate Stock A's beta to the Index in cell U2.

5.      After completing columns I-J, compute the call price in K2 and then fill in the dynamic call prices to expiration (K3-K28).

6.      Estimate the option's delta in column L and construct the dynamic delta hedge in columns M-O assuming the interest rate is 2% per annum.

7.      In cells N31-N33 link in the cost of the Hedge, the revenue received should the option be exercised and the cash flow from the sale of the call option.  In cell N35, compute the Net Profit from this hedged short position.  (Hint: in cell N32 include a logical operator that can tell whether the option finishes in the money or not:  "=IF(H28>A2,1,0)*100*100".  Note in cell O32, I have code that "prints" whether the option is OTM or ITM).

8.      Short a forward contract on Stock A and show how the price of the forward changes through time in column P.  Construct and label a graph of the spot and forward prices and identify the "basis" on the graph with an arrow and a text box.

9.      In cell Q28, calculate the profit from the short forward contract in week 26.

10.  Finally, suppose that you are long 100,000 shares of Stock A and want to hedge downside risk using the Index.  Construct the value of the beta neutral hedge in column S.

Your spreadsheet should have highlighted the net Profit from the dynamic covered call strategy, the profit from the short forward and the beta neutral hedge using the Index (all in $000). 

Reference no: EM131313921

Questions Cloud

Law5206 assignment 1 s2 : Sophia and Ben were furious on learning of this transaction and contacted Lemon International Ltd to pick these goods from their partnership premises, arguing that Mark had no authority to purchase them on behalf of the firm. Discuss the rights and l..
Meqa assignment : Determine the profit-maximizing average daily production capacity for DermaPlus for each of the possible reference-based prices identified by the consultant. Estimate the expected daily profit in each case.
What is the lowest bid that sfi : What is the lowest bid that SFI can make without violating the capital budgeting criterion for accepting new projects, if there are notax-loss-carry provisions?
Calculate the market values : You have just purchased $5 million par amount of the 5yr and 30yr US Treasury bonds shown below, at the prices shown. (Assume all bonds are semi-annual compounding.) Calculate the market values of the 5yr and 30yr bonds you purchased.
Final project - fire 650 : Refer to the template spreadsheet provided.  Stock A has an annualized volatility equal to 18% for which you have just written an out-of-the-money 26 week call option.  The risk free rate is 2% per annum and the strike price is $100.  There is anothe..
Critical for effective system analysis and design : What skills and competencies are most critical for effective system analysis and design?
What will be the mass flow rate : Assuming frictionless flow, what will be the mass flow rate?-  If a nozzle with a 1-cm diameter is placed at the pipe exit, what will be the mass flow rate?
Explore a stakeholder and contingency strategies : Identify potential risks and mitigation plans. Analyze a stakeholder and include mitigation and contingency strategies.
Stakeholders express their positions : In one section, List the various outside stakeholders Except( maceay's separation of business with Trump and the latinos who claim that Macey's take s stand against discrimination) then give your own insights and arguments persuasively what you be..

Reviews

Write a Review

 

Finance Basics Questions & Answers

  The company expects earnings and dividends to grow at a

company has recently paid annual dividend of rs.1.50 per common share this year. the company expects earnings and

  What are some examples of nonconventional expenditures

What are some examples of nonconventional expenditures that must be considered in the modern public financial management and budgeting environment? Which are most difficult to address? Why? What strategies do agencies employ to deal with them?

  What is the correlation between the returns on the portfolio

The annual expected return and standard deviation of returns for 2 assets are as follow.

  The risk per unit of return is measured by the

The risk per unit of return is measured by the

  Graphing the security market line

A regression was run in Stock B and market proxy portfolio, S&P 500. The regression line is defined as: Y =8.3+1.2X. If risk-free rate is 4%, the market risk premium is 6%, and market return on Stock B is 10.5%,

  Describe expectations theor liquidity preference theory

Briefly describe the following theories of the general shape of the yield curve: (a) Expectations theory; (b) Liquidity preference theory; and (c) Market segmentation theory.

  Determine company projected net income

Corporation x recently reported the following 2008 income statement in millions of dollars, this year the company is forecasting a 25 percent increase in sales.

  What are the average volumes for the two sampleswould you

look up the daily trading volume for the following stocks during a recent five-day periodbull merckbull caterpillarbull

  It is quite possible that when you solve a linear

it is quite possible that when you solve a linear programming application you may get fractional values for the

  What is the pretax required return on gordons stock

If the aftertax expected returns on two stocks are equal (because they are in the same risk class), what is the pretax required return on Gordons stock?

  Describe the amount of long term and short term financing

Describe the amount of long-term and short-term financing used to meet the total funds requirement under (1) an aggressive funding strategy and (2) a conservative funding strategy. Assume that, under the aggressive strategy, long term funds finance p..

  Domestic versus eurobond borrowing costs

A firm can issue an 8 year public debt issue at par with an 11 percent coupon in the domestic market. It can also issue 11.25 percent Eurobonds. If all other expenses are equal, which issue offers the firm the lower borrowing cost?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd