Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

HW8 (Sp.. Untitled W Hwy (Int. A put option in finance allows you to sell a share of stock at a given price in

image text in transcribed

HW8 (Sp.. Untitled W Hwy (Int. 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. A European put option 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 option. For example, suppose you purchase a six-month European put option for a share of stock with an exercise price of $27. If six months later, the stock price per share is $27 or more, the option has no value. If in six months the stock price is lower than $27 per share, then you can purchase the stock and immediately sell it at the higher exercise price of $27. If the price per share in six months is $23.50, you can purchase a share of the stock for $23.50 and then use the put option to immediately sell the share for $27. Your profit would be the difference, $27 - $23.50 = $3.50 per share, less the cost of the option. If you paid $1.00 per put option, then your profit would be $3.50 - $1.00 = $2.50 per share. The point of purchasing a European option is to limit the risk of a decrease in the per-share price of the stock. Suppose you purchased 310 shares of the stock at $33 per share and 120 six-month European put options with an exercise price of $27. Each put option costs $1. (a) Using data tables, construct a model that shows the value of the portfolio with options and without options for a share price in six months between $15 and $35 per share in increments of $1.00. (b) Discuss the value of the portfolio with and without the European put options. Step 1 (a) Using data tables, construct a model that shows the value of the portfolio with options and without options for a share price in six months between $15 and $35 per share in increments of $1.00. Constructing data tables using Excel is a quick way to calculate expressions by substituting different values for one of the terms within a formula. Before using the data table option, a spreadsheet of values and formulas must be constructed. Open an Excel spreadsheet and format it as below. First place the known values in the spreadsheet. The exercise price is given to be $27. At the end of 6 months, the price per share is $23.50. A total of 310 shares were purchased at $33 per share. In addition, 120 six-month European put options were purchased for $1 each. Place these values in the spreadsheet below. 1 A B European Put Option 2 3 Parameters 4 Cost of Put Option $ 1 5 Exercise Price $ x 6 Time (months) 6 7 8 Price per Share $ 9 Share Price - End of 6 Months $ xx C

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

Financial Accounting

Authors: Jerry J. Weygandt, Paul D. Kimmel, Donald E. Kieso

7th Edition

978-0470477151, 978-0-470-5562, 470556242, 0-470-55624-2, 9780470556245, 978-0470507018

Students also viewed these Finance questions

Question

When do I give in to my bad habit?

Answered: 1 week ago

Question

Contrast positive motivation with negative motivation.

Answered: 1 week ago