Question

In: Finance

In excel, create a table with a portfolio’s profit for different prices of a stock- used...

In excel, create a table with a portfolio’s profit for different prices of a stock- used to create a protective put strategy. In this case, one put contract is used- of 50 stocks sold at $5/stock. Strike price = $50.

Solutions

Expert Solution

A protective put strategy consist of purchasing a Stock and going long on a Put option so as to cover up in case of any fall in share price. It serves as an insurance by protecting the downside along with enjoying the upside.
The maximum loss in a protective put is initial premium paid for put option because fall in share price is compensated by payoff from put option.

We assume purchase of a share price at $50 and purchase of a put contract consisting of 50 stocks at $5/stock i,e put premium paid is $250 for one contract (50 shares). Payoff and profit diagram on various maturity is as follows :

where Profit is calculated by :
Profit = Total Payoff - (Initial Investment in Shares + Put Premium paid)


Related Solutions

The share prices of two different stocks are given in the following table: Stock A 234...
The share prices of two different stocks are given in the following table: Stock A 234 245 278 345 378 230 210 423 Stock B 1090 1200 1345 1256 1640 1456 1347 1120 1. Find the correlation coefficient between stock A and stock B 2. Also find coefficient of variation for each stock and from that , conclude which one is more stable.
1. List the different kind of capacitors used in commercial products, create excel sheet with following...
1. List the different kind of capacitors used in commercial products, create excel sheet with following columns; Type, Material, Package, Tolerance, temperature, and ESR (Equivalent Series Resistance). 2. What is the difference between bi-polar and non bi-polar capacitor? 3. What is the difference between precision capacitors and regular one? 4. What is a Super Capacitor and name three usages of this kind of capacitor?
The following table contains prices and dividends for a stock. All prices are after the dividend...
The following table contains prices and dividends for a stock. All prices are after the dividend has been paid. If you bought the stock on January 1 and sold it on December​ 31, what is your realized​ return?  ​Hint: Make sure to round all intermediate calculations to at least five decimal places. Price Dividend Jan 1 9.94 Mar 31 10.94 0.23 Jun 30 10.44 0.23 Sep 30 11.04 0.23 Dec 31 10.94 0.23
The Central Limit Theorem Stock Prices The following table lists initial public offering (IPO) stock prices...
The Central Limit Theorem Stock Prices The following table lists initial public offering (IPO) stock prices for all 1999 stocks that at least doubled in value during the first day of trading. This is historical data. $17.00 $23.00 $14.00 $16.00 $12.00 $26.00 $20.00 $22.00 $14.00 $15.00 $22.00 $18.00 $18.00 $21.00 $21.00 $19.00 $15.00 $21.00 $18.00 $17.00 $15.00 $25.00 $14.00 $30.00 $16.00 $10.00 $20.00 $12.00 $16.00 $17.44 $16.00 $14.00 $15.00 $20.00 $20.00 $16.00 $17.00 $16.00 $15.00 $15.00 $19.00 $48.00 $16.00 $18.00...
Create a line chart for the closing prices for all years, and a stock chart for...
Create a line chart for the closing prices for all years, and a stock chart for the high/low/close prices for August 2013 in the Excel file S&P 500. (Show all steps in excel)
Use the advertised prices for a used car of a particular model to create a linear...
Use the advertised prices for a used car of a particular model to create a linear model for the relationship between a​ car's Year and its Price. Complete parts a through e. Year   Price ($) 1994   18,194 1994   17,945 1994   16,887 1994   14,447 1995   19,282 1995   19,017 1995   20,849 1995   18,621 1996   22,665 1996   23,081 1997   24,899 1997   25,492 1997   23,703 1997   24,413 1997   23,934 1) Find the equation of the regression line. ​2) Explain the meaning of the slope...
Use the advertised prices for a used car of a particular model to create a linear...
Use the advertised prices for a used car of a particular model to create a linear model for the relationship between a​ car's Year and its Price. Complete parts a through e. Year   Price ($) 1994   11,538 1994   12,333 1994   10,436 1994   11,995 1995   14,567 1995   14,658 1995   13,656 1995   15,199 1996   16,192 1996   17,039 1996   19,074 1997   19,823 1997   19,249 1997   19,242 1997   20,577 ​a) Find the equation of the regression line. Price=___ + _____ year b) Explain the...
Use StatCrunch and/or Excel (or another software of your choosing) to create a table of summary...
Use StatCrunch and/or Excel (or another software of your choosing) to create a table of summary statistics for all Quantitative variables in the Cleaned Student Data Survey Results that you submitted for Course Project 3. The table should include the following summary statistics: n (count) Mean Standard Deviation 5-Number-Summary (Min, First Quartile, Median, Third Quartile, Maximum) Range (= Max - Min) Inter-Quartile Range (IQR = Q3 - Q1) The table should include these summary statistics for the following variables: Age,...
In Excel, create a 2x30 data table with the left column representing a population of prey...
In Excel, create a 2x30 data table with the left column representing a population of prey and the right column representing a population of predators. Use the population model presented below. Let the starting values of the model parameters be: r = 1.3, k = 1, s = .5, v = 1.6, and u = .7 Let the starting population of P = 1.1 and Q = .4 Difference equations: P[t + 1] = P[t](1 + r(1 – P[t]/K)) -...
create a table of data for two different linear functions. The table should use the same...
create a table of data for two different linear functions. The table should use the same values of X for both functions. Based on your table will the graph of these two functions intersect explain your answer
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT