Excel Online Structured Activity: Black-Scholes Model Assume the following inputs for a call option: (1)...
70.2K
Verified Solution
Link Copied!
Question
Finance
Excel Online Structured Activity: Black-Scholes Model Assume the following inputs for a call option: (1) current stock price is $26, (2) strike price is $30, (3) time to expiration is 6 months, (4) annualized risk-free rate is 5%, and (5) variance of stock return is 0.26. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the question below. Open spreadsheet Use the Black-Scholes model to find the price for the call option. Do not round intermediate calculations. Round your answer to the nearest cent. Check My Work Reset Problem Excel template - Saved - Search (Option + File Home Insert Draw Page Layout Formulas Data Review View Help Editing s Arial 10 B B AY = ag Number 60 .00 .90 . +0 11 27 Oy B6 B D D E F F G H I 3 K L M N N 0 Black-Scholes Model 1 2 3 $26.00 $30.00 6 Current price of underlying stock, P Strike price of the option, X Number of months unitl expiration Time until the option expires, Risk-free rate, Variance, o Formulas #N/A 5.00% 0.26 5 6 7 8 9 10 10 11 11 12 #N/A d. = Nid,) = ( 0.5000 #N/A dy = N(dz) - 0.5000 Vc = #N/A 13 10 14 17 15 16 10 17 18 19 20 21 22 23 24 > = Sheet1 +
Answer & Explanation
Solved by verified expert
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Zin AI - Your personal assistant for all your inquiries!
