Title: Aim: Version: Date: Author:
Company Analysis Form To serve as a checklist tool for investors when screening companies listed in various stock exchange 1.0 4/29/2007 Zhigui, Dave Goh
Version 1.0 feature 1)
Setting up of spreadsheet to allow user to key in stock's important information in green cells
Future versions features 1) 2) 3)
Perform financial calculations for various ratios such as current and debt ratio etc. Setting up of historical prices table Performance of technical analysis based on historical prices supplied
References 1)
Get Organized With An Investment Analysis Form October 20, 2006; By Jonas Elmerraji www.investopedia.com
es listed in various stock exchanges
nformation in green cells
d debt ratio etc.
Investment Analysis Form Company Name
Symbol Address
State of Incorporation
Phone Number
Common Shares Outstanding Par Value / Share ($)
Common Shares Authorized Total Par Value ($)
Market Capitalization ($) Total Debt ($)
Loan Securities Issued (Y/N)
Debt Standing
EPS ($)
Executive Compensation ($)
Percentage of Profits (%)
Gross Revenues ($)
Profits ($)
Profit Margin (%)
IR Contact
Gross Profit/Share ($)
Other Stock C Net Quick Assets ($)
Loan Securities Net Liabil P/E
Subsidiaries D
Dividends ($)
Profitability
Ris Addressed
Industry / Nature of Company's Operations
Legal Is Product
Compe Competitive Advantage
Future Ch Employee Relations
Future Goal Other Comments / Footnotes of Interest
ysis Form Symbol
Exchange Recent Price ($) / Date CEO Other Stock Classes / Held
Quick Assets ($)
Assets Per Share ($)
Loan Securities Net Liability ($) P/E
Bond Rating
52 week High / Low High ($) Low ($) Subsidiaries Descriptions
Risks Addressed
otes of Interest
Unaddressed
Legal Issues
Competitors
Future Challenges Future Goals / Visions
SIT Index Components ALLGREEN PROPERTIES LTD ASCENDAS REAL ESTATE INV TRUST CAPITACOMMERCIAL TRUST CAPITALAND LIMITED CAPITAMALL TRUST CHARTERED SEMICONDUCTOR MFGLTD CITY DEVELOPMENTS LIMITED COMFORTDELGRO CORPORATION LTD COSCO CORPORATION (S) LTD CREATIVE TECHNOLOGY LTD DATACRAFT ASIA LTD DBS GROUP HOLDINGS LTD FRASER AND NEAVE, LIMITED GENTING INT'L PUBLIC LTD CO HONGKONG LAND HOLDINGS LIMITED HYFLUX LTD JARDINE CYCLE & CARRIAGE LTD JARDINE MATHESON HLDGS LTD JARDINE STRATEGIC HLDGS LTD JURONG TECH IND CORP LTD KEPPEL CORPORATION LIMITED KEPPEL LAND LIMITED LABROY MARINE LIMITED MOBILEONE LTD NEPTUNE ORIENT LINES LIMITED NOBLE GROUP LIMITED OLAM INTERNATIONAL LIMITED OVERSEA-CHINESE BANKING CORP PARKWAY HLDGS LTD PEOPLE'S FOOD HOLDINGS LIMITED PEOPLE'S FOOD HOLDINGS LIMITED SEMBCORP INDUSTRIES LTD SEMBCORP MARINE LTD SINGAPORE AIRLINES LTD SINGAPORE EXCHANGE LIMITED SINGAPORE PETROLEUM CO LTD SINGAPORE POST LIMITED SINGAPORE PRESS HLDGS LTD SINGAPORE TECH ENGINEERING LTD SINGTEL STARHUB LTD STATS CHIPPAC LTD SUNTEC REAL ESTATE INV TRUST THAI BEVERAGE PUBLIC CO LTD TOTAL ACCESS COMM PUB CO LTD
UNITED OVERSEAS BANK LTD UNITED TEST & ASSEMBLY CTR LTD UOL GROUP LIMITED VENTURE CORPORATION LIMITED WANT WANT HOLDINGS LTD WING TAI HLDGS LTD WING TAI HLDGS LTD