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 $$31,(3)$ time to expiration is $5$ months, $(4)$ annualized riskfree rate is $6\%,$ and $(5)$ variance of stock return is $0\mathrm{.}15.$ 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. $

x template $-$ Saved $v$

Search for tools, help, and more $($Option

File

Home Insert Share

Page Layout

Formulas

Data

Review

View

Help

Draw

$v$

Arial

B

$a{c}^{ab}$

General

A

B

C

D

E

F

Black$-$Scholes Model

Current price of underlying stock, $P,$$$26\mathrm{.}00$

Strike price of the option, $x$

$$31\mathrm{.}00$

Number of months unitl expiration

$5$

$6$ Time until the option expires, $t$

$7$ Risk$-$free rate, $r_{RF}$

$6\mathrm{.}00\%$

Variance, ${}^2$

$0\mathrm{.}15$

$d_1=$

$\backslash$table$[[5],[6\mathrm{.}00\%$