excel week 8
biscuit2016
week_eight_excel.xlsxSheet1
20 3(a-c)
| Expiration Date Sophia Stock Price (S) | Expiration Date Derivative Payoff | Initial Derivative Premium | Combined Terminal Position Value | Expiration Date Sophia Stock Price (S) | Expiration Date Derivative Payoff | Initial Derivative Premium | Combined Terminal Position Value | Expiration Date Sophia Stock Price (S) | Expiration Date Derivative Payoff | Initial Derivative Premium | Combined Terminal Position Value | ||
| $25 | $25 | 0 | $50 | $25 | $25 | ($3.23) | $46.77 | $25 | $5.20 | $30.20 | |||
| $30 | $20 | 0 | $50 | $30 | $20 | ($3.23) | $46.77 | $30 | $5.20 | $35.20 | |||
| $35 | $15 | 0 | $50 | $35 | $15 | ($3.23) | $46.77 | $35 | $5.20 | $40.20 | |||
| $40 | $10 | 0 | $50 | $40 | $10 | ($3.23) | $46.77 | $40 | $5.20 | $45.20 | |||
| $45 | $5 | 0 | $50 | $45 | $5 | ($3.23) | $46.77 | $45 | $5.20 | $50.20 | |||
| $50 | $0 | 0 | $50 | $50 | ($3.23) | $46.77 | $50 | $5.20 | $55.20 | ||||
| $55 | ($5) | 0 | $50 | $55 | ($3.23) | $51.77 | $55 | ($5) | $5.20 | $55.20 | |||
| $60 | ($10) | 0 | $50 | $60 | ($3.23) | $56.77 | $60 | ($10) | $5.20 | $55.20 | |||
| $65 | ($15) | 0 | $50 | $65 | ($3.23) | $61.77 | $65 | ($15) | $5.20 | $55.20 | |||
| $70 | ($20) | 0 | $50 | $70 | ($3.23) | $66.77 | $70 | ($20) | $5.20 | $55.20 | |||
| $75 | ($25) | 0 | $50 | $75 | ($3.23) | $71.77 | $75 | ($25) | $5.20 | $55.20 | |||
| Expiration Date Sophia Stock Price (S) | Expiration Date Derivative Payoff | Initial Derivative Premium | Combined Terminal Position Value | ||||||||||
| $25 | $5.20 | $30.20 | |||||||||||
| $30 | $5.20 | $35.20 | |||||||||||
| $35 | $5.20 | $40.20 | |||||||||||
| $40 | $5.20 | $45.20 | |||||||||||
| $45 | $5.20 | $50.20 | |||||||||||
| $50 | $5.20 | $55.20 | |||||||||||
| $55 | ($5) | $5.20 | $55.20 | ||||||||||
| $60 | ($10) | $5.20 | $55.20 | ||||||||||
| $65 | ($15) | $5.20 | $55.20 | ||||||||||
| $70 | ($20) | $5.20 | $55.20 | ||||||||||
| $75 | ($25) | $5.20 | $55.20 |
