Question: i need to make 2 three-step binomial tree's in excel for American futures options for crude oil and price the options. i need hedge portfolio

i need to make 2 three-step binomial tree's in excel for American futures options for crude oil and price the options. i need hedge portfolio approach to price American call futures optionand i need risk neutral approach to price equivalent American put futures option.

current price/spot price $69.06

strike price $75.966

risk free rate 5%

volatility of one yr crude oil futures price is 45%

time to expiration 1 year

after, i need to use Black Scholes model in excel to compute prices of European call and put futures options based on the same data and thus essentially compare the results (binomial american call/put verse Black Scholes EU call/put)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

I need someone help me do this exam. I have the answer, but I need the solution for the answer. TestId: 1001 For each problem, choose the answer choice that best answers the question. Name...

I have attached the corresponding lessons for assignment 8, it usually includes practice problems at the bottom that look similar to the assignment. ASSIGNMENT 7 JOB ORDER COSTING Directions: After...

Question 1 (15 marks) Question 1 comprises three parts. Students are to answer ALL parts of this question: a) After successfully completing your degree at ANU, you have decided not to follow Steve's...

Assignment 1: Forwards and Futures, Interest Rate Derivatives and Swaps Due: Monday, February 15, 2015 All assignments are due on Monday 15th February 2015 by 6:00 p.m. at the latest. Late...

help to do the first problem of the assignment, just the first problem ! McGill University - Desautels Faculty of Management Instructor: P. Augustin FINE 448 Financial Derivatives...

Please give me solutions for 2 documents. I have a test soon!!! LANCASTER UNIVERSITY 2012 EXAMINATIONS PART II (SECOND AND FINAL YEAR) ACCOUNTING AND FINANCE AcF 305 INTERNATIONAL FINANCIAL...

1 Payoff Diagrams Draw the gross payoff (not net-payoff/profit) diagram as a function of MLM stock for the following portfolios consisting of: (Strike values are given in parentheses) one long...

please help with how I can get the numbers painted in red and also I cannot get the number painted in green, please also write down the formula thanks a lot QUESTION 4 [4 +2+2 = 8 MARKS] Gloria...

Can you please answer these questions? Using excel and please show the formulas with the answers as well. Thank You! Complete a three step binomial tree to price the options outlined below. Use the...

Let R be the relation on the set of people with doctorates such that (a, b) R if and only if a was the thesis advisor of b. When is an ordered pair (a, b) in R2? When is an ordered pair (a, b) in...

Assuming that the Treasury bills are yielding 10 percent for one year and the market portfolio (TSX) is expected to yield 18 percent over the next year. The stock you have invested in has a Beta of...

Given a BTIRR on total investment of 1 6 % , a BTIRR on debt of 1 1 % , and a debt - to - equity ratio of 2 . 3 3 , what is the BTIRR on equity?

A thin-walled, hollow spherical shell of mass m and radius r starts from rest and rolls without slipping down the track shown in Fig. 10.57. Points A and B are on a circular part of the track having...

Ethane is chlorinated in a continuous reactor: C 2 H 6 C1 2 C 2 H 5 Cl + HCI some of the product monochloroethane is further chlorinated in an undesired side reaction: C 2 H 5 Cl + Cl 2 C 2 H 4 C1 2...

In the Deacon process for the manufacture of chlorine, HC 1 and O 2 react to form Cl 2 and H 2 0. Sufficient air (21 mole% 0 2 , 79% N 2 ) is fed to provide 35% excess oxygen and the fractional...

Chlorobenzene (C 6 H 5 C1), an important solvent and intermediate in the production of many other chemicals, is produced by bubbling chlorine gas through liquid benzene in the presence of ferric...

The vapor pressure of an organic solvent is 50 mm Hg at 25C and 200 mm Hg at 45 C. The solvent is the only species in a closed flask at 35C and is present in both liquid and vapor states. The volume...

Determine if the overhead allocated to the product relates to a single plantwide overhead rate method, multiple production department factory overhead rate method, or activity-based costing...

3-4. Explain with examples each of the eight steps in the strategic management process.

3-6. Outline how you would implement an employee engagement program.

3-5. A high-performance work system is a set of human resource management policies and practices that together produce superior employee performance.