Skip to main content

Limited time: save up to 25% on spreadsheet models and templates.

Explore templates
10XSheets

Free calculator

Options profit calculator

Estimate profit or loss at expiration for a long call or long put: type the underlying price you want to scenario-test, strike, premium per share you paid, and number of contracts. We show intrinsic value per share, total premium, net P&L (per contract and total), breakeven, and whether the option is in, at, or out of the money. This is not live market data, not Greeks or fair-value pricing, and not multi-leg strategies in v1—see methodology for scope.

Educational illustration only. Not investment, tax, or brokerage advice; not an order ticket. We do not fetch live quotes, model time value before expiration, assignment, short options, spreads, or commissions beyond the premium you type—use your broker for execution math.

When to use this calculator

Quick expiration what-if for one long option before you mirror the payoff in Sheets or Excel.

  • See max loss to the premium you type and how net P&L moves when you change the spot scenario.
  • Grab breakeven and intrinsic lines to align a workbook row with the same 100× contract multiplier.
  • Compare call vs put tabs with the same strike/premium story to avoid mixing payoff directions.
  • Jump to the stock calculator when you only need shares bought and sold without an option leg.
How do you calculate long option P&L at expiration here?

We only model European-style payoff at a single date: you supply a spot S, strike K, premium per share you paid to open the long position, and contracts with the usual 100 multiplier per contract.

Intrinsic value per share

Long call: max(S − K, 0). Long put: max(K − S, 0). This is time-value zero view at expiration.

Net P&L and premium

Total premium = contracts × 100 × premium per share. Net P&L = contracts × 100 × (intrinsic per share − premium per share). Per contract line is 100 × that per-share parenthesis.

Breakeven and moneyness

Long call breakeven = K + premium per share. Long put breakeven = K − premium per share. ITM / ATM / OTM compares S and K (calls ITM when S > K; puts ITM when S < K); ATM uses a tiny numerical band around K.

What we do not model

Before-expiration mark-to-market, Greeks, American early exercise paths, short options, multi-leg spreads, dividends on underlyings, commissions beyond the typed premium, live quotes, or tax—use a full chain sheet or your broker when you need those layers.

For underlying-only round-trip stock P&amp;L, open the stock calculator; for return on two totals, use ROI. For shares bought and sold without options, open the Stock calculator. For gain ÷ invested from two lump sums, open the ROI calculator.

Google Sheets & Excel

English US/UK function names below. Let S be spot, K strike, P premium per share, N contracts, and M = 100.

Intrinsic per share (long call, expiry)
=MAX(S-K,0)

Replace S and K with cells. 0 when the call is out of the money.

Intrinsic per share (long put, expiry)
=MAX(K-S,0)

Replace S and K with cells.

Net P&amp;L (currency, long, expiry)
=N*M*(MAX(S-K,0)-P)

For a put, swap the MAX body to MAX(K-S,0). M is 100 for standard U.S. equity options.

More tools in Unit economics

Browse all tools

Frequently asked questions

What does this options profit calculator do?

It estimates expiration profit or loss for a long call or long put from spot, strike, premium per share, and contracts (with 100 shares per contract). It does not pull live prices or model Greeks.

Is this only for expiration?

Yes for v1. We use intrinsic value at the spot you type, which matches expiration (or any moment you choose to treat as zero time value). Before expiration, market value includes time value—use your broker or a fuller model.

Why multiply by 100?

A listed equity option contract in the U.S. typically represents 100 shares of the underlying. Total premium = premium per share × 100 × contracts; net P&amp;L scales the same way.

Is premium per share or per contract?

Enter premium per share (the option price shown per share on many chains). We multiply by 100 and contracts for total premium.

How do you define breakeven?

Long call: K + premium per share. Long put: K − premium per share—the spot where intrinsic per share equals the premium per share you paid, ignoring fees beyond that premium.

How is this different from the stock calculator?

The stock tool is shares round-trip with buy/sell prices and optional flat commissions. This page is one long option leg with strike and premium—different payoff shape.

Can I model short calls or short puts?

Not in v1. Short options have different risk profiles (including unlimited loss on naked calls). We keep the UI to long positions only.

Do you show delta, gamma, or implied volatility?

No. Those need a pricing model and often live inputs. This page stays a transparent intrinsic calculator with a Sheets/Excel bridge.

Is this tax or legal advice?

No. It is a free educational illustration—not a recommendation to trade options, not a fiduciary opinion, and not a substitute for qualified professionals.

How do I match this in Google Sheets or Excel?

Use =MAX(S-K,0) for call intrinsic per share or =MAX(K-S,0) for puts, then =N*100*(intrinsicCell-P) for net P&amp;L with N contracts and P premium per share.

What do in the money, at the money, and out of the money mean?

At a given spot, calls are in the money when S > K, puts when S < K. Out of the money is the opposite strict inequality. At the money is a narrow band around K for display stability.

Is this investment advice?

No. Options involve risk of loss, including losing the entire premium for long options. This tool helps you rehearse arithmetic—not tell you whether to trade.