In excel, please solve the following problem... The current price of Natasha Corporation stock is $ 5.92. In each of the next two years, this stock price can either go up by $2.50 or go down by $ 2.00. The stock pays no dividends. The one-year risk - free interest rate is 3.7% and will remain constant. Using the Binomial Model, calculate the price of a two-year call option on Natasha stock with a strike price of $7.00. What is the price of the two year call option?

In excel, please solve the following problem... The current price of Natasha Corporation stock is $ 5.92. In each of the next two years, this stock price can either go up by $2.50 or go down by $ 2.00. The stock pays no dividends. The one-year risk - free interest rate is 3.7% and will remain constant. Using the Binomial Model, calculate the price of a two-year call option on Natasha stock with a strike price of $7.00. What is the price of the two year call option?

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Similar questions

Suppose you think AppX stock is going to appreciate substantially in value in the next year. Say the stock's current price, Sø. is $75, and a call option expiring in one year has an exercise price, X, of $75 and is selling at a price, C, of $21. With $21,000 to invest, you are considering three alternatives. a. Invest all $21,000 in the stock, buying 280 shares. b. Invest all $21,000 in 1,000 options (10 contracts). c. Buy 100 options (one contract) for $2,100, and invest the remaining $18,900 in a money market fund paying 6% in interest over 6 months (12% per year). What is your rate of return for each alternative for the following four stock prices in 6 months? (Leave no cells blank - be certain to enter "0" wherever required. Negative amounts should be indicated by a minus sign. Round the "Percentage return of your portfolio (Bills + 100 options)" answers to 2 decimal places.) The total value of your portfolio in six months for each of the following stock prices is: Stock Price All…
A stock is currently selling for $45. Over the next two periods, the stock will move up by a factor of 1.23 or down by a factor of .61 each period. A call option with a strike price of $54 is available. If the risk-free rate of interest is 3.2 percent per period, what is the value of the call option? (Do not round intermediate calculations. Round your answer to 2 decimal places.) Value of the call option
Assume that the current stock price is $50 per share, that call options can be purchased with an exercise price of $60 per share, that bank loans can be obtained for a 10 percent nominal rate, and that at expiration of the option in three months, the stock will either be valued at $30 or $70. Show that it is possible to replicate the stock payoff by borrowing and buying a call option.
The current stock price of Chocho inc is $125. You expect the stock price a year from now to be either $134 or $86 with equal probabilities. The interest rate at which investors can borrow is 13%. Using the binomial opm, what should be the price (premium) of a call option with an exercise price of $115.00 and an expiration date one year from now?
The current price of Natasha Corporation stock is $6.00. In each of the next two years, this stock price can either go up by $2.50 or go down by $2.00. The stock pays no dividends. The one-year risk-free interest rate is 3.0% and will remain constant. Using the Binomial Model, calculate the price of a two-year call option on Natasha stock with a strike price of $7.00. The price of the two-year call option is $ (Round to the nearest cent.)
The current price of a stock is $21. In 1 year, the price will be either $26 or $16. The annual risk-free rate is 5%. Find the price of a call option on the stock that has a strike price of $22 and that expires in 1 year. (Hint: Use daily compounding.) Assume a 365-day year. Do not round intermediate calculations. Round your answer to the nearest cent.
Use the binomial tree analysis to value a 6-month American put option with a $65 strike price on Crookshanks Corporation. The shares are currently trading for $60. The annualized continuously compounded risk-free rate is 3%. The volatility of the stock is 57%. You will use the Cox Ross Rubenstein method for computing the binomial tree, and use a time step of 2 months.
The current price of a non-dividend paying stock is $60. Use a two-step tree to value an American put option on the stock with a strike price of $66 that expires in 2 years. Each step is 12 months, the risk free rate is 5% per annum, and the volatility is 30%. Which of the following is the closest to the option price? O $8.91 O $11.41 O $9.91 O $12.41
The current stock price is $10. In each of the next two years, the stock price can either go up by $2 or go down by $2. The stock pays no dividends. The one-year risk-free interest rate is 5% and will remain constant during this two-year period. a) Using the Binomial Model of option pricing, calculate the price of a two-year call option on the stock with a strike price of $13. b) Using Risk Neutral valuation calculate the price of two-year put option on the stock with a strike price of $7.
The current price of a stock is $20. In 1 year, the price will be either $28 or $15. The annual risk-free rate is 7%. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the question below. Find the price of a call option on the stock that has a strike price is of $25 and that expires in 1 year. (Hint: Use daily compounding.) Assume 365-day year. Do not round intermediate calculations. Round your answer to the nearest cent.

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS