Project 2: Tracking Stock Prices Using Excel
Jason Turner CGS 2100 Lab: 0013 Lecture: 0002
1/17/2009 1
JDA Software Group Inc.
The stock symbol for JDA Software Inc. is “JDAS”. The company has over 4800 customers including over 1200 retail customers in more than 60 countries. Some of the companies customers include Anheuser-Busch, Office Depot, and even Wal-mart.
2
1/17/2009
JDA Software’s Product’s
JDA offers Software for a variety of needs including:
– E-commerce – Decision Support – Server-to-Server data Synchronization
1/17/2009
3
Brief JDA Timeline
1986- Signed first three clients and had four associates. 1990- Opened first international office in UK and had 55 associates.
1995- Moved corporate headquarters to AZ and had 209 associates. 2001- JDA acquired its 1,400th associate.
4
1/17/2009
Mentor Graphics Corp.
The stock symbol for Mentor Graphics Corp. is “MENT”. MENT provides software and hardware tools that help other companies deliver better and more cost efficient electronic products to the market.
1/17/2009
5
Mentor Graphic’s Product Uses
MENT’s products are used in the design of:
– – – – – Game Consoles PC’s Cell Phones Hubs Video Conferencing Equipment
6
1/17/2009
About Mentor Graphics
Revenue in the last 12 months was $650 Million. There are 3,600 current employees. Headquartered in Wilsonville, Oregon. Was Founded in 1981 www.mentor.com
7
1/17/2009
TIBCO Software Inc.
The stock symbol for TIBCO Software is TIBX TIBCO develops software that allows the owner to link their own operations, their partners operations, and their own customers together.
1/17/2009
8
Services of TIBCO
TIBCO also offers consulting services including:
– System Planning and design – Systems Integration – Custom Development
1/17/2009
9
Categories of Software
TIBCO offers three categories of software:
– Business Optimization – Business Integration – Enterprise Backbone
1/17/2009
10
Company
JDAS MENT TIBX
Number of Shares
Current Price
Price 1 Year Ago
52 Week Low
52 Week High
T.C.V
1 Year G/L
52/L Profit
52/H Loss
350 350 350
$14.35 $18.00 $9.09
$9.12 $9.00 $4.44
$8.83 $8.00 $4.07
$22.36 $5,022.50 $20.99 $6,300.00 $9.25 $3,181.50
$784.50 $1,350.00 $697.50
$828.00 $1,500.00 $753.00
$1,201.50 $448.50 $24.00
1/17/2009
11
Stock Comparison
$18.00
$16.00
$14.00
$12.00
$10.00 Price $8.00 Current Price Price 1 Year Ago
$6.00
$4.00
$2.00
$0.00 JDAS MENT Com pany TIBX
1/17/2009
12