HP Financial Calculators » HP 30b » HP 30b Black-Scholes Equation » Black-Scholes Equation Implementation on Microsoft Excel

Microsoft Excel Black-Scholes Equation

Stock Price (S) = 60
Strike Price (X) = 65
Time to Maturity (T) = 0.25 years
Risk Free % rate (r) = 8.00 %
Rate of Return % Volatility (v) = 30.0 %

Results:
Call Value (Price) = 2.13337
Put Value (Price) = 5.84628

Download EXCEL Worksheet.

Updated On: 15.02.19

Leave your message, comment or feedback:
Your Name (shown) & Your E-mail (hidden) is used only to alert you when someone reply your message. 

 

Retailers
Malaysia Philippines Singapore Thailand

HP Calc Heritage

Note: All prices quoted on this site does not include taxes and tariffs. Actual prices may vary. Check with your nearest resellers for local pricing.