FREE Trial

What would be the Excel formula in Spreadsheet for the Black-Scholes value of a straddleposition? 1INPUTS 2Standard

Question:

What would be the Excel formula in Spreadsheet for the Black-Scholes value of a straddleposition?
What would be the Excel formula in Spreadsheet for the
Transcribed Image Text:

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)

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Answer rating: 75% (12 reviews)

A straddle is a call and a put The BlackScholes valu...View the full answer


answer-question-section
Answered By
tutor-profile-image
Utsab mitra
I have the expertise to deliver these subjects to college and higher-level students. The services would involve only solving assignments, homework help, and others. I have experience in delivering these subjects for the last 6 years on a freelancing basis in different companies around the globe. I am CMA certified and CGMA UK. I have professional experience of 18 years in the industry involved in the manufacturing company and IT implementation experience of over 12 years. I have delivered this help to students effortlessly, which is essential to give the students a good grade in their studies.
3.50+ 2+ Reviews 10+ Question Solved
Related Book For  book-img-for-question
Investments

Investments

ISBN: 9780073530703

9th Edition

Authors: Zvi Bodie, Alex Kane, Alan J. Marcus

See More Books
Question Posted:
See More Questions

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

Eleven A Novel - ISBN: 1451606788 - Free Book