# Payoff diagram options excel

It is the same formula. The screenshot below illustrates call option payoff calculation in Excel. Besides the MAX function, which is very simple, it is all basic arithmetics.

One other thing you may want to calculate is the exact underlying price where your long call position starts to be profitable. If you don't agree with any part of this Agreement, please leave the website now. All information is for educational purposes only and may be inaccurate, incomplete, outdated or plain wrong. Macroption is not liable for any damages resulting from using the content.

No financial, investment or trading advice is given at any time. Home Calculators Tutorials About Contact. Tutorial 1 Tutorial 2 Tutorial 3 Tutorial 4.

We will look at: Call Option Payoff Diagram Buying a call option is the simplest of option trades. The key variables are: Strike price 45 in the example above Initial price at which you have bought the option 2. Call Option Scenarios and Profit or Loss Three things can generally happen when you are long a call option. Underlying price is higher than strike price Finally, this is the scenario which a call option holder is hoping for.

Call Option Payoff Formula The total profit or loss from a long call trade is always a sum of two things: Initial cash flow Cash flow at expiration Initial cash flow Initial cash flow is constant — the same under all scenarios. It is a product of three things: Cash flow at expiration The second component of a call option payoff, cash flow at expiration, varies depending on underlying price.

Call Option Break-Even Point Calculation One other thing you may want to calculate is the exact underlying price where your long call position starts to be profitable.

It is very simple. It is the sum of strike price and initial option price. The available instruments are stocks, riskfree bonds, puts, and calls. With puts and calls, the user specifies the strike price. With bonds, the face value must be given by the user.

This file is intended for use only by students enrolled in Finance courses at the Robinson College of Business at Georgia State University. However, if you would like to use this file in another setting, please contact the author of the spreadsheet Jason Greene for permission.

Download Instructions Click here to download the Microsoft Excel spreadsheet. If a box appears asking for a username and password, click "Cancel" and the file should open. You should save the spreadsheet on your local disk in order to access it in the future.

Spreadsheet Instructions The spreadsheet allows you to specify a strategy with up to four positions in stocks, bonds, puts, or calls. The first worksheet in the Excel spreadsheet file is named "Payoffs" and demonstrates payoff diagrams only. The second worksheet is named "Profits" and demonstrates both payoff and profit diagrams.

Select the Graph type First select the graph type using the pop-up menu under the word "Graph" located low to mid-left side of the spreadsheet.

Choosing Payoff A will graph only the payoff diagram for position A in blue on the graph. Choosing Payoff All will graph all positions on the graph at the same time.

Choosing Payoff Combined will only graph the payoff diagram on the combined strategy of positions A through D. Similar graph types are available on the "Profits" worksheet. There are four possible positions A through D and the position color will correspond to the color of the curve on the graph.