Assignment: Finance Information Literacy Project
Here is my information literacy project. The project basically needs to do a company research based on a lot of research engine and website searching results. I needed the first two requirements (history and industry description & Risk analysis and return) down before 3/26 midnight. The first one requirement needs to use several searching websites such as Business insight, company annual report and etc. The second requirement needs using BLOOMBERG searching engine. If anyone CAN and knows how to use BLOOMBERG, can help me!
My target company is Carnival Corporation, its NYSE code is CCL!
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.com
Bloomberg Beta (BETA, go to 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)
Format your assignment according to the following formatting requirements:
1. The answer should be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides.
2. The response also includes a cover page containing the title of the assignment, the student's name, the course title, and the date. The cover page is not included in the required page length.
3. Also include a reference page. The Citations and references should follow APA format. The reference page is not included in the required page length.