Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A put option in finance allows you to sell a share of stock at a given price in the future. There are different types of

image text in transcribed
A put option in finance allows you to sell a share of stock at a given price in the future. There are different types of put options. Let us consider the European put option which allows you to sell a share of stock at a given price called the exercise price, at a particular point in time after the purchase of the European put option. For example, suppose you purchase a six-month European put option for a share of stock with an exercise price of $26. If six months later, the stock price per share is $26 or more, the option has no value. If in six months the stock price is lower than $26 per share, then you can purchase the stock and immediately sell it at the higher exercise price of $26. If for example, the price per share in six months is $22.50, you can purchase a share of the stock for $22.50 and then use the put option to immediately sell the share for $26. Your profit would be the difference, $26- $22.50 = $3.50 per share less the cost of the option. If you paid $1.00 per put option, then you profit would be $3.50-$1.00 = $2.50 per share. Build a model in Excel to calculate the profit the European put option described above. Construct a data table in Excel that shows the profit per share for a share price in six months between $10 and $30 per share in increments of $1.00. Complete the given table below. If required, round your answers to two decimal places. For subtractive or negative numbers use a minus sign

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Recent Developments Of Mathematical Fluid Mechanics

Authors: Herbert Amann, Yoshikazu Giga, Hideo Kozono, Hisashi Okamoto, Masao Yamazaki

1st Edition

3034809395, 9783034809399

More Books

Students also viewed these Mathematics questions