Write the spreadsheet which calculates value of put option

Assignment Help Finance Basics
Reference no: EM13477256

(a) Suppose that a share of Shell costs $21 now and that the continuously compounded risk-free rate is 1%. Compute the value of a put option to sell Shell for $22 half a year from now, under the assumption that in half a year, the share costs either $20 or $23. (This is the same situation as in the lecture, but with a put option instead of a call option.)

(b) Generalize the computation above: Suppose that a share costs S0 now and the continuously compounded risk-free rate is r. Assume that at time t (measured in years),the share costs either Sut or Sdt. Write a spreadsheet which computes the value of a put option with strike price K expiring at t. You may assume that K is between Sdt and Sut .

Hand in a print-out of the spreadsheet with the values as above (S0 = 21, r = 0:01, t = 1/2 , Sut = 23 and Sdt = 20), a print-out of the spreadsheet displaying the formulas, and an explanation of the formulas that appear in the spreadsheet.

 

Reference no: EM13477256

Questions Cloud

Determine the irr of the project determine the npv of the : conch republic electronicsconch republic electronics is a mid sized electronics manufacturer located in key west
Retailers are paying closer attention than ever before to : retailers are paying closer attention than ever before to making their environments eco-friendly. sustainable design
Determine the forward price assuming no arbitrage give the : on monday 18 november 2013 an investor takes a short position in a forward contract on royal dutch shell shares with
Determine the forecasting error why is it significant to : according to the text the npv rule states that an investment should be accepted if the npv is positive and rejected if
Write the spreadsheet which calculates value of put option : a suppose that a share of shell costs 21 now and that the continuously compounded risk-free rate is 1. compute the
The end result of this course is developing the strategic : the end result of this course is developing a strategic audit. in this module you will outline and draft a preliminary
The current spot price of platinum is 1500 in us dollars : the current spot price of platinum is 1500 in us dollars per troy ounce. assume a continuously compounded risk-free
Determine the arbitrage opportunity in market in which : consider a market with two financial assets both with a term of one year. the assets yield a single pay-out at maturity
Understanding supply chain and how the consumer can play a : understanding supply chain and how the consumer can play a critical role in the supply chain is an important part of

Reviews

Write a Review

Finance Basics Questions & Answers

  Find net income and investment base

Harbor Company had sales of $1,500,000 for the year ended Dec 31, 2004, an asset turnover ratio is 2 for the same period, and return on investment is six percent.

  Determine degree of financial leverage

Illinois Tool Corporation fixed operating expenses are $1,260,000 and its variable cost ratio variable costs are as a fraction of sales is 0.70.

  Determine the dol and dfl

Venture Corporation manufactures and sells headphones to airline and other passenger transportation companies. Each headphone sells for $5.50, and year sales are expected to be 1,750,000 units.

  Should morris-meyer lease or borrow and buy the equipment

Consider the $250,000 estimated salvage value. Is it appropriate to discount it at the same rate as the other cash flows? What about the other cash flows-are they all equally risky? Explain.

  Firm''s operating as well as cash conversion cycles

Firm's operating as well as cash conversion cycles and decision on speeding up collections

  What is the cost of the loan

What is the cost of the loan, and how much would you ask for as the loan amount if you had to have $1,000,000?

  Evaluate the industry and competitive environment

Research and evaluate the industry and competitive environment for each industry segment using Porters Five Forces and PEST approaches.

  Calculate the yield to maturity of these bonds today

Five years ago your firm issued a $1,000 par, 20-year bonds with a 6% coupon rate and an 8% call premium. The price of these bonds now is $1103.80. Assume annual compounding.

  Compute the annual net cash flows assuming equipment

Compute the annual net cash flows assuming equipment and fixtures are depreciated using the 7-year asset class under MACRS.

  What is the probability that you will run out of stock

Daily demand is distributed normally with mean = 250 and standard deviation =.50. At the end of each morning, any leftover copies are worthless and they go to a recycle bin.

  In regards to individual personality characteristics how do

1.there are a variety of theories of motivation many of which are complementary. of the main motivational theories

  Computation of npv and irr

Computation of NPV and IRR and computation the IRR and use it to determine the maximum deviation allowable in the cost of capital estimate to leave the decision unchanged

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