Docstoc

Option calculator Black & Scholes spreadsheet

Document Sample
Option calculator Black & Scholes spreadsheet Powered By Docstoc
					Black-Scholes Directly in a Excel Sheet

Stock price                     61.0
Strike price                    65.0
Years to maturity               0.25
Risk-free rate                8.00%
Volatility                    30.0%

European call value             2.53
European put value              5.24

				
DOCUMENT INFO
Shared By:
Stats:
views:63
posted:10/8/2012
language:English
pages:1
Description: Easy to use spreadsheet with Black and Scholes, calculate option prices and see if they are overpriced or cheap.