userX
  Log In  |  Create a FREE Account  |  Everyone's Spreadsheets  |  Tags  |  Help  
 Saving... 
  login to save   undo redo  |  bold italic font text underline more font formatting  |  align left align center align right  |  text color background text color  |  sum hide/show tools
  fx
DateDec. 1, 2005Dec. 1, 2005Dec. 1, 2005Dec. 1, 2005ENTER
TickerGOOGGOOGMOLUDATA
Stock Price413.31413.2173.232.82HERE
ExpirationDec. 2005Dec. 2005Jan. 2006Jan. 2006
Strike400420852.50
Price198.40.10.40
Contracts10101010
Proceeds190008400100400
Commission17.4517.4517.4517.459.95
Days to Expiration
Net charge to the cash available
MAX of 3 things103327.596512.49999999999732350005e-324
1. 25% of underlying value + any out of the money + premium103327.596512.499999999996537.5000000000041024.9999999999998
2. 10% of underlying value + premium41331413217323282
3. $500 / contract MINUS premium collected5000500050005000
 
Average Rating:  Not rated (Not yet rated)
 
Name:  Financing Short Option Position by  userX userX 
Description:  Calculates net cash requirement of short call position at Schwab. -- Enter price of underlying stock, # of contracts and strike price, and you get net cash requirement. This is a MAX of 3 calculations. Four examples are shown, in which each of these calculations prevails (2 for the most common calculation: one in-the-money, one out-of-the-money.)
Tags:  finance short option stock market stockmarket equity howto Schwab calculation  
[ default color ]
 
 recent: