In the previous course, you learned financial statement analysis and how to make estimate of future financial status. In this course, you are going to learn capital budgeting. That is, how to make an investment decision. You would like to select the best project among various projects you can take. Then, you need to know the criteria. In this course, you are going to learn investment decision criteria such as NPV and IRR, which are most popular decision rules. Using financial analysis and discounted cash flow method, you can make pro forma financial statement and estimate project cash flows. Then, you apply investment criteria to determine whether to invest or not. After learning how to apply NPV and IRR method to investment decision, you are going to learn how to evaluate NPV estimate and scenario, what-if analyses and break-even analysis. In addition to NPV and IRR, you are going to learn Payback period method and Profitability method to determine whether to invest or not when there is a political risk or capital rationing.
4.3 Black-Scholes Option Pricing Model
Loading...
来自 Yonsei University 的课程
Applying Investment Decision Rules for Startups
23 个评分
从本节课中
Real Options in Business Projects
We continue to study analyzing business projects, but the difference in this module is that now we consider the value of "real options" embedded in the project. You will learn how to estimate the project's value by using the decision tree approach or the Black-Scholes option pricing model.
与讲师见面
Saeyeul ParkAssistant Professor
School of Business
Hi, in the previous lecture, we calculated NPV of a project by
considering value of real options using the decision tree approach.
In that approach, optimal decisions were made in each state.
If the outcome was good, we expanded the business.
If the outcome was bad, we abandoned the project.
Also, in calculating the NPV,
we had to assign probabilities to all possible states of the outcome.
In previous examples, we had two possible states, good and bad, and
assume that they have equal probabilities of occurring, 50% each.
Alternatively, we can use a well established option pricing model
named Black-Scholes to evaluate real options.
Black-Scholes option pricing model is probably the most popular option pricing
model, which is widely used to price options on various underlying assets,
including stocks.
With the Black-Scholes option pricing model,
we can easily calculate an option's value by entering values of five determinants of
an option's price in the formula.
In this approach,
we'll calculate real options value by using the option pricing model.
Before we look at the formula, we'll first think about the five determinants of
an options price, which are inputs in the Black-Scholes option pricing formula.
In this lecture, we'll focus on the call option,
which gives the holder the right to buy the underlying asset.
First, the current price of the underlying asset should affect a call option's value.
Let's take an example of a call option on stocks.
When you hold a call option, whose exercise price is $30, and
which matures in three months, you feel much happier when
the current stock price is $40 than when the price is $20.
The reason is because as the current price of underlying asset is higher,
the chance that you can gain profits by exercising the option on
the expiration date becomes greater.
Hence, the current price of the underlying asset
should positively affect the call option price.
The exercise price of the option also determines the option's value.
The lower the exercise price, the higher the call option's value will be.
A lower exercise price not only increases the chance that the option will be
exercised, but also increases the potential payout from the option.
The third determinant is standard deviation or
variance of the underlying asset's value.
An option value is always positively affected by the volatility of
the underlying asset's value.
Since an option holder exercises her option only if it is profitable to do so,
she's always protected from the downside risk, but
it's always exposed to the upside potential.
High variance means a higher chance that the underlying asset's
price will be either very high or very low in the future.
This is an ideal situation for
an option holder because she can benefit from a very high ending stock price,
while she is not concerned about the very low ending stock price at all.
If the ending stock price is lower than the exercise price,
she will just choose not to exercise the option.
The fourth factor is time to expiration date.
The time to expiration date is also positively related to
to the option's value.
And the reason is very similar to to the one we had in number three.
We know that option holders always appreciate volatility
in underlying asset value.
As you have more time until expiration date, you can expect that
the price movement of the underlying asset will be even more volatile.
The final input in the Black-Scholes option pricing model is the interest rate
on the risk-free asset.
This rate is used to calculate the present value of the exercised
price in the formula, but we are not going to talk too much about the details here.
Just note that the risk-free rate is
positively related to the call options price.
So, to summarize, the five inputs of the option pricing model are S, K,
the standard deviation, σ, time to maturity, T, and the risk-free rate.
One amazing thing about the Black-Scholes model is that if we know those
five numbers, we can get the fair price of any option very easily.
The Black-Scholes model uses the following formula to price call options.
You'll see formula variables such as S, K, T, or σ in the formula.
I know this formula is overwhelming, but don't let this formula frighten you.
We just want to know how to use this model in Excel, and
we really don't have to understand the math behind the formula.
To understand what N(d1) and N(d2) mean, however,
we need a little bit of explanation.
And it's a value of the cumulative standard normal distribution,
or simply CDF of the standard normal distribution.
In Excel, once we calculate for values of d1 and
d2, we can get the values of N(d1) and N(d2) by using
the function named NORM.S.DIST.
Inside the function, we first enter the value, like d1 or d2, for example.
Then after hitting a comma, just type true
to indicate that we want to get the cumulative distribution function here.
Okay, so, why don't we try to find the call option price by applying
the Black-Schole's model in Excel?
The stock price is $28 now, and the exercise price of the option is $30.
That means the option is not profitable at this time.
The option holder should hope that the stock
price will be higher then $30 on the expiration date.
The expiration date is one year from now.
And we also know that the risk-free rate is 4%, and
the standard deviation of the underlined asset's value is 20%.
When we build a model in Excel,
we would like to start by making a table for the five inputs at the top.
Once you make a good template spreadsheet,
by letting sales below reference the numbers in the table,
you'll be able to price any call option, using the Black-Scholes model from now on,
by simply changing the input in the table at the top.
Calculating d1 is the hardest part.
Note that I used ln function to take the natural log of S over K,
as in the d1 formula, and also used SQRT function
to express the square root of T in the denominator.
And we'll use this number shortly when we get the value of N(d1) in row 11.
Then, we can calculate d2 as well by following the formula.
The next step is to find values of the cumulative standard normal distribution
of d1 and d2.
Inside the NORM.S.DIST function, we reference cell C8,
which has the value of d1.
Then we type true to indicate that we want the CDF value, not the PDF value.
So here is the value of N(d1).
Using the same way, we can find the value of N(d2), too.
And now, the last step is to find the call option price by applying
the Black-Scholes option pricing formula.
In the formula, the exercise price, K,
is multiplied by the continuous compounding discount factor.
And that's why the Excel formula includes the EXP function.
So finally, we got the fair price of this call option using the Black-Scholes model.
According to the model, the fair call option price is $1.87.
So what does this number tell us?
Right now, the option seems to be worthless at a glance,
because the exercise price is $30, while the current stock price is only $28.
How could we benefit from having the right to purchase the stock at
$30 when the market price is lower than 30?
Nevertheless, this option has the value of about $2.00,
because we still have one year until the expiration date.
And the stock price is volatile, as the standard deviation of 20% suggests.
We can expect that there should be a fair chance that the ending stock
price is above $30, so that the option can make money at the end.
