Stock Market Project
In this assignment you
will select a variety of stocks to invest in for a period of two weeks. You have inherited $10,000 and will use this money to invest in the stock market. You must select at least 5 stocks to invest in and create a
spreadsheet to track its performance.
Starting today…
$
You will select 5
stocks using the Internet (www.cnnfn.com, www.yahoo.com,
etc..)
$
You will create a
spreadsheet with 6 sheets (one for each stock and one for a totals page)
$
You must keep all
documentation of today’s price (Internet printouts)
$
Name the 6
Worksheets in your spreadsheet using the company name of the stock that you are
purchasing and the last one as the Totals Page.
$
For the next two
weeks you will keep track of the stock and will record its price every class
day. (See Sample Below…) The following
is a sample page….
Company
Name Disney
Ticker Symbol DIS
Number of Shares Purchased 30
Price per Share $33.00
Total Investment $990.00
Tracking:
10/8/02 $20.00 =Today’s Price * Number of
Shares
10/10/02 $20.15 =Today’s Price * Number of
Shares
$
You are to include
appropriate clip art and graphics in order to make this spreadsheet look presentable. Be creative in the use of fonts, colors etc…
$
Save As Stock Portfolio.