What would be the Excel formula in Spreadsheet for the Black-Scholes value of a straddleposition? 1INPUTS 2Standard
Question:
1INPUTS 2Standard deviation (annual 0.2783 OUTPUTS d1 d2 FORMULA FOR OUTPUT IN COLUMNE 0.0029 (LN(B5/B6) (B4-B7+.5 B22) B3 (B2 SORT (B3)) 3 Maturity (in years) 4 Risk-free rate (annual) 5 Stock 0.5 0.06 N(d1) 100 105 0.5012NORMSDIST(E2) 0.4231 7.0000 N(d2) B/S call value NORMSDIST(E3) 6 Exercise price 7 Dividend yield (annual) BIS put value 8.8968 B6 EXP(-B4 B3)(1-E5-B5 EXP B7 B3)(1 E4)
Step by Step Answer:
A straddle is a call and a put The BlackScholes valu...View the full answer
Related Video
Stocks (also known as equities) are securities that represent ownership in a company. They are issued by companies to raise capital, and when an individual buys stocks, they become a shareholder in that company. Investing in stocks can be a way for individuals to potentially earn a return on their investment through dividends and capital appreciation. However, investing in stocks also carries a level of risk, as the value of the stock can fluctuate based on various factors such as the financial performance of the company and general market conditions. For companies, issuing stocks can be a way to raise funds for growth and expansion. When a company goes public by issuing an initial public offering (IPO), it can raise significant capital by selling ownership stakes to the public. Companies can also issue additional stock offerings to raise additional capital as needed.
Students also viewed these Accounting questions
-
What would be the Excel formula in Spreadsheet 19.1 for the Black- Scholes value of a straddle position?
-
What would be the result if all project managers decided to withhold a management reserve? What criteria should be used for determining when a management reserve is necessary?
-
What would be the important location factors that Mc- Donalds might consider before opening a new restaurant?
-
A closed tank contains oil with a specific gravity 0.85. If the gauge pressure at a point 10 feet below the oil surface is 23. 7 psi (lb/in.2), determine the absolute pressure and gauge pressure (in...
-
Sketch the graphs of the conic sections in 11a-d. a. y = x2 b. x2 + y2 = 9 c. x2/9 + y2/16 = 1 d. x2/9 - y2/16 = 1 e. If each of the curves in 11a-d is rotated about the y-axis, describe the shape...
-
Use (a) The Midpoint Rule and (b) Simpsons Rule to approximate the given integral with the specified value of n. (Round your answers to six decimal places.) Compare your results to the actual value...
-
A partial condenser operates as shown in Figure 10.36. Assuming that \(T_{0}=70^{\circ} \mathrm{F}\), calculate the following: (a) Condenser duty (b) Change in availability function (c) Lost work (d)...
-
See Table 2.5 showing financial statement data and stock price data for Mydeco Corp. Was Mydeco able to improve its ROIC in 2013 relative to what it was in 2009? Table continue TABLE 2.5 2009-2013...
-
1. $3,800+ ($8,000) =$ (-4,200) Netting of long term capital gains and losses ($2,400) + 2,000 + ($500) = $ (-900) Netting of short term capital gains and losses (-4,200) + (-900) = $(-5,100) Netting...
-
Frank is looking at a new sausage system with an installed cost of $560,000. This cost will be depreciated straight line to zero over the projects five-year life, at the end of which the sausages...
-
A call option with X = $50 on a stock currently priced at S = $55 is selling for $10. Using a volatility estimate of s = .30, you find that N (d1) = .6 and N (d2) = .5. The risk-free interest rate is...
-
Which of the following best explains a delta-neutral portfolio? A delta-neutral portfolio is perfectly hedged against: a. Small price changes in the underlying asset. b. Small price decreases in the...
-
When a heat pump is used to heat a building, where does the heat come from? Explain.
-
Describe the basic procedure for obtaining a protective order, including who can commonly seek one and the kinds of relief that can be sought.
-
Describe battered womans syndrome and indicate how it is sometimes used in criminal cases.
-
Identify and distinguish among the five forms of child abuse most commonly identified and defined by the states.
-
What is the relationship between density and specific volume?
-
a. Draw the budget constraint of an individual facing a negative income tax with a constant marginal tax rate of, say, 30 percent, assuming the individual receives $1000 if he or she does not work...
-
Quality principles are only now being adopted by universities. Develop a plan for the administration in your college for implementing Jurans approach.
-
Imagine a sound wave with a frequency of 1.10 kHz propagating with a speed of 330 m/s. Determine the phase difference in radians between any two points on the wave separated by 10.0 cm.
-
Use the standard normal values you computed in question 30, and find the probability that Z is less than those values. Question 30 Suppose that X is distributed as normal with a mean of 5 and a...
-
What are the coupon rate and current yield on a bond? What happens to these if a bond's price rises?
-
What is interest rate risk? What are the roles of a bond's coupon and maturity in determining its level of interest rate risk?
-
For a premium bond, which is greater the coupon rate or the yield to maturity? Why? For a discount bond? Why?
-
During October 2 0 2 3 , Fern Field Farms, Inc. received $ 1 0 , 0 0 0 from customers in exchange for fruit and vegetables. During the same month, the company paid $ 2 , 0 0 0 to employees, $ 5 0 0...
-
Given data below answer the question. Cash Accounts receivable $ 10,200 Cash dividends 15,200 Consulting revenue Office supplies 3,550 Rent expense $ 2,340 15,200 3,910 Office equipment 18,310 Land...
-
Last year, a city had three school districts: North with a population of 5200 children, South with a population of 10600 children, West, with a population of 15100 children. Use Hamilton, Adams,...
Study smarter with the SolutionInn App