Skip to content

Excel Models

Professional Excel models for finance professionals

Showing 38 professional models

Showing 38 models in Options & Derivatives

Options & Derivatives

Variance Swap Calculator Excel Template

Educational Excel template for variance swap fair strikes using a simplified approximation. Enter ATM vol,...
Options & Derivatives

Binary Option Calculator Excel Template

Calculate cash-or-nothing and asset-or-nothing option prices using Black-Scholes. Includes invariant checks and vanilla option references.
Options & Derivatives

Chooser Option Calculator Excel Template

Price chooser options with live Black-Scholes formulas. Calculates option value, call/put components, and straddle discount...
Options & Derivatives

Swaption Pricing Calculator Excel Template

Professional swaption pricing using Black's model. Calculate premiums, Greeks, and parity checks with this free...
Options & Derivatives

Theta Decay Calculator Excel Template

Calculate option time decay with this Theta Decay Calculator Excel template. Includes theta, extrinsic value,...
Options & Derivatives

Strangle Calculator Excel Template

Analyze long strangle options positions with this Excel template. Calculate breakeven prices, max loss, and...
Options & Derivatives

Short Call Calculator Excel Template

Calculate short call option metrics using Black-Scholes pricing. Includes entry credit, breakeven price, and risk/reward...
Options & Derivatives

Short Put Calculator Excel Template

Analyze short put options with this Excel template. Calculate entry credit, breakeven, max profit, and...
Options & Derivatives

Monte Carlo Option Pricing Calculator Excel Template

Price European options with the Black-Scholes-Merton formula. Shows BSM price, d1, d2, N(d1), N(d2), and...
Options & Derivatives

Long Put Calculator Excel Template

Professional Excel template for calculating long put option P/L, breakeven, and risk metrics. Enter your...
Options & Derivatives

Intrinsic & Extrinsic Value Calculator Excel Template

Decompose option premium into intrinsic and time value using Black-Scholes pricing. Includes ITM/ATM/OTM classification.
Options & Derivatives

Long Call Calculator Excel Template

Professional Excel template for analyzing long call option positions with live formulas for entry cost,...
Search
Contact Ryan

Get in touch

Contact Me

Have a question or want to work together? Fill out the form below and we'll get back to you as soon as possible.

Contact Form Demo

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Results appear as you type. Use the arrow keys to move through them.