Overview

This is call and put options price calculator that uses the Black-Scholes model. The model helps to calculate the price of a European option based on the current stock and strike prices, risk-free interest rate, time to maturity and the expected volatility of the underlying asset price.

The underlying assumptions of the Black-Scholes model:

  • the underlying price follows a geometric lognormal diffusion process;
  • the risk-free rate is known and constant;
  • the volatility of the underlying asset is known and constant;
  • there are no taxes or transaction costs;
  • there are no cash flows on the underlying (e.g. payments of dividends);
  • the options are European (e.g. cannot be exercised before the maturity date).
Reviews Add a review
No reviews yet

More From Andrew Grigolyunovich, CFA, CFM, FMVA

Browse our top rated business templates. See All
CFO Excel Template Bundle (10 complete templates)
2,181
2
This CFO excel template bundle is of great value to serious financial modelers and chief financial officers. It includes templates…
Financial Analyst Bundle (8 complete Excel Templates)
2,209
1
Financial Analyst Bundle will be of great help to anyone who is familiar with financial modeling, who needs to carefully…
Financial Assistant Bundle (5 core templates)
2,030
0
Financial Assistant Excel Template Bundle will greatly assist in everyday simple financial calculations. The bundle allows gaining a quick overview…
WACC Calculator
4,706
397
WACC Calculator is a weighted average cost of capital Calculator. This model will help you to calculate the fair cost…
Optimal Purchase Volume Calculator
4,212
0
Optimal Purchase Volume Calculator is an MS Excel financial model used for comparing up to five purchase options of inventory…
Loan Calculator (for Lenders)
3,851
0
This Loan calculator is a very useful tool for loan management. This template helps to calculate the interest that should…
See All