Question
Last weeks homework asked what happened to these 3 calls and 3 puts. Using last weeks HW and the template I sent, recreate what the
Last weeks homework asked what happened to these 3 calls and 3 puts. Using last weeks HW and the template I sent, recreate what the payoff graph would look like if we bought 3 calls and 3 puts. You must edit it because currently it only has info for calls, so the puts are wrong. The final sheet marked total is where the payoff graph will be. Email the excel to me and CC your TA AND include a screenshot of the payoff graph in the email. Hint: The maximum loss that can be made is the total of all the premiums. use apple inc stock. templates stated below.first one is total rest is option 1 2 etc.
| Stock: | Apple | Payoff | |||||||||
| Ticker: | AAPL | ||||||||||
| Current Price: | $198 | ||||||||||
| 1st option | Option Type: | Call | Premium | Stock Price | Profit/Loss from execution of option | Net Profit/Loss | |||||
| Strike price: | $120 | ($5,00) | $139 | 18,6 | ($3,55) | ||||||
| Expiration Date: | $149 | 28,5 | ($3,20) | ||||||||
| Premium: | $5,00 | $158 | 38,4 | ($3,20) | |||||||
| $168 | 48,3 | ($3,20) | |||||||||
| $178 | 58,2 | ($3,20) | |||||||||
| $188 | 68,1 | ($3,20) | |||||||||
| $198 | 78 | ($3,20) | |||||||||
| $208 | 87,9 | $4,70 | |||||||||
| $218 | 97,8 | $22,40 | |||||||||
| $228 | 107,7 | $49,90 | |||||||||
| $238 | 117,6 | $79,60 | |||||||||
| $248 | 127,5 | $109,30 | |||||||||
| $257 | 137,4 | $139,00 | |||||||||
| $267 | 147,3 | $168,70 | |||||||||
| $277 | 157,2 | $198,40 | |||||||||
| $287 | 167,1 | $228,10 | |||||||||
| $297 | 177 | $257,80 | |||||||||
| $307 | 186,9 | $287,50 | |||||||||
| $317 | 196,8 | $317,20 | |||||||||
| $327 | 206,7 | $346,90 | |||||||||
| $337 | 216,6 | $376,60 | |||||||||
| Stock: | Apple | Payoff | |||||||||
| Ticker: | AAPL | ||||||||||
| Current Price: | $198 | ||||||||||
| 1st option | Option Type: | Call | Premium | Stock Price | Profit/Loss from execution of option | Net Profit/Loss | |||||
| Strike price: | $210 | ($2,00) | $139 | 0 | ($2,00) | ||||||
| Expiration Date: | $149 | 0 | ($2,00) | ||||||||
| Premium: | $2,00 | $158 | 0 | ($2,00) | |||||||
| $168 | 0 | ($2,00) | |||||||||
| $178 | 0 | ($2,00) | |||||||||
| $188 | 0 | ($2,00) | |||||||||
| $198 | 0 | ($2,00) | |||||||||
| $208 | 0 | ($2,00) | |||||||||
| $218 | 7,8 | $5,80 | |||||||||
| $228 | 17,7 | $15,70 | |||||||||
| $238 | 27,6 | $25,60 | |||||||||
| $248 | 37,5 | $35,50 | |||||||||
| $257 | 47,4 | $45,40 | |||||||||
| $267 | 57,3 | $55,30 | |||||||||
| $277 | 67,2 | $65,20 | |||||||||
| $287 | 77,1 | $75,10 | |||||||||
| $297 | 87 | $85,00 | |||||||||
| $307 | 96,9 | $94,90 | |||||||||
| $317 | 106,8 | $104,80 | |||||||||
| $327 | 116,7 | $114,70 | |||||||||
| $337 | 126,6 | $124,60 | |||||||||
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
The Bank Credit Analysis Handbook
Authors: Jonathan Golin, Philippe Delhaise
2nd Edition
0470821574, 978-0470821572
