Num Sum: Financing Short Option Position

Date	Dec. 1, 2005	Dec. 1, 2005	Dec. 1, 2005	Dec. 1, 2005	ENTER
Ticker	GOOG	GOOG	MO	LU	DATA
Stock Price	413.31	413.21	73.23	2.82	HERE
Expiration	Dec. 2005	Dec. 2005	Jan. 2006	Jan. 2006
Strike	400	420	85	2.50
Price	19	8.40	.10	.40
Contracts	10	10	10	10
Proceeds	19000	8400	100	400
Commission	17.45	17.45	17.45	17.45	9.95
Days to Expiration



Net charge to the cash available
MAX of 3 things	103327.5	96512.49999999999	7323	5000	5e-324
1. 25% of underlying value + any out of the money + premium	103327.5	96512.49999999999	6537.500000000004	1024.9999999999998
2. 10% of underlying value + premium	41331	41321	7323	282
3. $500 / contract MINUS premium collected	5000	5000	5000	5000

Spreadsheet Financing Short Option Position was created by userX and last modified on Thu Dec 1 14:26:58 2005.

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.)