Black-Scholes Excel Pricing Model
  • Black-Scholes Excel Pricing Model
Originally published: 22/04/2018 20:41
Last version published: 22/04/2018 20:56
Publication number: ELQ-75985-2
View all versions & Certificate
certified

Black-Scholes Excel Pricing Model

A mini Black-Scholes Excel model, just hit and go!

algorithmsblack-scholescallfinancefinancial marketsmathematicsoption pricingoption valuepricing modelsputstock

Description
2 Black-Scholes Pricing Excel Models (with & without dilution):

INPUTS:
Inputs:
Stock Price (S)
Strike Price (X)
Volatility (s)
Risk-free Rate
Time to expiration (T)
Dividend Yield
# of Options (000)
# Shares Outstanding (000)
Tax Rate

OUTPUTS:
Stock Price (S)
Strike Price (X)
Volatility (s)
Risk-free Rate
Time to expiration (T)
Dividend Yield
# of Options (000)
# Shares Outstanding (000)
Tax Rate

*Note: This spreadsheet requires iterative calculations which may result in circular references.
To correct this problem, go to "Tools" - "Options" - Calculation and check the "iteration" box.

This business tool includes
1 Excel Model

Gia Hy Le Pham offers you this business tool for free!

download for free

Add to bookmarks

Discuss

Reviews

  • No review yet!

keyboard_arrow_leftkeyboard_arrow_right

Any questions on Black-Scholes Excel Pricing Model?

The user community and author are here to help. Go ahead!

please wait...