Reference no: EM132266695
Information Literacy Project
This project is designed to 1) familiarize students with much of the data available to investors for analyzing companies primarily through the use of the Bloomberg Professional terminal and Value Line; and 2) provide hands-on experience applying investment finance theory and models to real firms. In the process, students will:
a) examine the history of a firm and its industry
b) analyze the risk and return of the firm
c) conduct a relative value analysis
d) analyze insider and institutional ownership
e) analyze the firm's earning history relative to estimates and analysts' recommendations
Format for report
I. History and Industry Description
A. Provide a brief history of the firm over the past ten years, including the firm's primary industry of operation, its major competitors (at least 2), and any major acquisitions, restructurings, or other newsworthy events that have occurred recently. Briefly describe the characteristics of the industry.
For example, is the industry growing quickly? How competitive is the industry? How easily can others enter the industry? What challenges do you expect the company to face in the future?
B. Sources: Business Insights: Global (history, news, industry)
Company annual reports, 10K reports (some years available on company website; 10+ years in Mergent Online as well as competitors and industry)
Value Line (competitors, news, industry)
Bloomberg Company Description and News (DES, CN)
II. Risk Analysis and Return
A. Go to Bloomberg Beta (BETA) and find the raw Beta and adjusted Beta. Why are the two betas different? Compare your estimate to Yahoo's estimate of beta. Why are betas different? Include screen shot in the report.
B. Use Bloomberg Total Return Analysis (TRA) to determine your firm's return over the last five years. How much of the return over the period is attributable to dividends? To price appreciation? Include screen shot in the report.
C. Sources: finance yahoo
Bloomberg Beta (BETA, go to <Help> Definitions)
Bloomberg Total Return Analysis (TRA)
III. Relative Value Analysis
A. Compare the valuation multiples for your company tothose of the major competitors you identified in Part I of the assignment. Reference the list of appropriate metrics for your company in the appendix. Compare Bloomberg and Value Line and discuss reasons for any differences.
Does the company appear to be undervalued or overvalued relative to these comps?
B. Sources : Bloomberg Relative Value Analysis (RV). Include screen shot in the report.
Value Line (peers and valuation for each company separately)
IV. Ownership Analysis
A. Go to Bloomberg Ownership (OWN) and Value Line Insider Transactions. Examine insider transactions over the last 6 months. What percent of the shares do insiders own? In the past six months have insiders been buying or selling shares?
Next examine institutional ownership. What percent of the shares are owned by institutions? What type of funds own the stock?
B. Examine the short interest over the last year using Bloomberg's Short Interest (SI) function. What is the current short interest ratio?
What percent of the float has been shorted? Has short interest increased or decreased over the past year? Is there a relationship between short interest and the price of the shares?
C. Sources:Bloomberg Ownership (OWN). Include screen shot in the report.
Value Line (insider transactions, institutional ownership)
Bloomberg Short Interest (SI). Include screen shot in the report.
V. Earnings and Analyst Recommendations
A. Go to Bloomberg Earnings History (ERN) and compare reported earnings with estimated earnings over the past 10 quarters. Have earnings surprises been consistently positive, consistently negative, or mixed?
B. Go to Bloomberg Analyst Recommendation (ANR) and examine the number and percentage of buy, sell and hold recommendations. Would you consider the analyst community to be bullish or bearish on the company? Use the bar chart on the page to determine if analysts' sentiments have changed over the last year.
Based on the 12-month price target listed, what is the anticipated price appreciation over the next 12 months? Does the forecasted appreciation appear to be consistent with the ratio of buy, sell, and hold recommendations?
C. Read the most recent three Value Line Commentary sections. Discuss changes in sentiment over time and how they compare to the Bloomberg findings.
D. Sources : Bloomberg Earnings Estimates (ERN). Include screen shot in the report.
Bloomberg Analyst Recommendation (ANR). Include screen shot in the report.
Value Line (commentary)