Price a call option with a stock price

Assignment Help Financial Management

Reference no: EM131243367

Use your spreadsheet from Question 1 to price a call option with a stock price of $80, a strike price of $75, 3 months to maturity, a 5% risk-free rate of return, and a standard deviation of return of 20% on the underlying stock. Check it against the solution in Question 2.

Question 1
Write a computer spreadsheet that computes the Black-Scholes value on row 4 as a function of its five inputs (in the first two rows). This will teach you more about the Black-Scholes formula than all the pages in this book. Recall that the normal distribution function is normsdist.

Question 2
Price a call option with a stock price of $80, a strike price of $75, 3 months to maturity, a 5% risk-free rate of return, and a standard deviation of 20% on the underlying stock.

Reference no: EM131243367

Questions Cloud

Computes the black scholes value on row 4 : Write a computer spreadsheet that computes the Black-Scholes value on row 4 as a function of its five inputs in the first two rows.

Investment spending vary more than consumption : Why does investment spending vary more than consumption from year to year?

Explain a explanation of porters four competitive strategies : Explain A brief explanation of Porter's four competitive strategies. A brief explanation of how competitive strategy determines value chain structure.

Monopolist marginal cost : A monopolist produces and sells 400 units at a price of $40 per unit. The monopolist's marginal cost is equal to $15 and average cost is equal to $23. The monopolist's profit is?

Price a call option with a stock price : Price a call option with a stock price of $80, a strike price of $75, 3 months to maturity, a 5% risk-free rate of return, and a standard deviation of 20% on the underlying stock.

Design a human resources system : Design a human resources system that includes data such as personal information, payroll, job assignments, benefits, vacations, and termination records.

Contrast the debt crisis : Compare and contrast the Debt Crisis of the 1980's to that of today while giving examples and providing at least 3 to 4 high quality references. Work should be with 3 to 5 pages.

Price the earlier call option but with a higher strike price : Price the earlier call option but with a higher strike price. - That is, price a call with a stock price of $80, a strike price of $80, 3 months to maturity, a 5% risk-free rate of return, and a standard deviation of return of 20% on the underlying..

Are deltas of options with different strike prices different : Price the earlier call option with a higher interest rate. - That is, price a call with a stock price of $80, a strike price of $75, 3 months to maturity, a 10% risk-free rate of return, and a standard deviation of return of 20% on the underlying..

User Account

All Pages