Month-End Stock Comparison
		3/31/00		4/30/00
Ticker	Shares	Close	Value	Close	Value	Gain/Loss	Gain/Loss %
AOL	50	152.375		142.625			#DIV/0!
AAPL	300	42		48.5			#DIV/0!
CPQ	200	72.5		80			#DIV/0!
INTC	300	101.75		99.625			#DIV/0!
MSFT	100	125.875		151			#DIV/0!
Download Excel Template
Instructions
Copy and paste above information into Excel
Save the file as CLOSE
Select cell A1-Change the font to 16-point Impact, Center across selection
Select cell A4-H4-Change the font to 12-point Impact, Center
Format Close price to display three decimal places
Format Value as currency
Format Gain/Loss as currency
Format Gain/Loss % to show a percent
Change date format to dd-mmm-yy
Compute the value using the formula =Close*Shares
Compute Gain/Loss using the formula =Value 2-Value1
Computer Gain/Loss % using the formula =Gain-Loss/Value1
Email completed spreadsheet to:
pstephan@nuhsd.k12.ca.us