![]() |
Research Assignments |
The objective of the research assignments is to ensure that each student can conduct simple business research, interpret raw data, and use basic business tools. The submitted work will normally 1-2 pages in length and should report only the information required. The narrative for each assignment is to be limited to what is necessary to complete the assignment. Assignments are due as scheduled by the syllabus. They ought take longer than an hour to complete. The 3 assignments are 15% of the course grade, each is 5% of the course grade. Be sure you reference all sources of your data.
This
page gives the assignments and provide links to assist with the assignments.
Assignment 1: Comparative
Financial Ratios
The objective of this assignment is that you demonstrate an ability to interpret financial data. Select 3 firms in an industry - you may use any industry in which you have an interest. Report and interpret 3 financial ratios for 3 years for each of the three firms. The kind of ratio used should be appropriate to surface interesting information about the industry. Your interpretation of data should be brief - 1 or 2 sentences - for each ratio. Try not to restate the definition of the ratio, but interpret what the three-year comparative data report as organizational strengths or weaknesses of the firms. For data source, see Standard & Poor's NetAdvantage or Mergent Online available at: https://libweb.hamptonu.edu/login?url=http://www.hamptonu.edu/universityservices/library/research/Database_Subject.html
An example:
One ratio is the Market-Book value, using 3 years of data for 3 pharmaceutical firms:
|
M/B Ratio |
1979 |
1980 |
1981 |
| Squibb Corp. |
1.32 |
1.38 |
1.99 |
| Smith-Kline |
5.34 |
4.61 |
3.73 |
| Drug Industry |
1.76 |
1.89 |
2.19 |
Interpretation: While the M/B for the group is greater than 1, indicating a strong performance. Smith-Kline is in free-fall suggesting troubled performance and a possible "take-over". It is apparent that patents are a valued resource for these firms.
Assignment 2: The Business Environment
The objective of this assignment is that you demonstrate an ability to:
(1) test a simple hypothesis H1 : Time predicts future value of a critical business measure (H0 = No relationship)
(2) use a simple statistical technique and interpret the results.
You are to use a simple forecasting technique and demonstrate an understanding of time series analysis. You will be assigned an environmental measure. You are to collect 7 data points, using 6 data points forecast the next interval of datum, and compare your forecast with the actual datum. Lastly, verify the proportion of the economic indicator explained by time by calculating the R². For example, if your measure were GNP using annualized data, you would collect GNP data for 1989, 1990, 1991, 1992, 1993, and 1994. Using linear regression you would forecast GNP for 1995, then compare your forecast with the 1995 actual GNP. Do not be concerned if your forecast is not correct. The R² will be low if the model does not fit. The drill is the collection of data, the use of linear regression, and the problems with linear estimation techniques. Your typed written submission will be brief: simply cite the data collected and the source; show your forecasting; show the difference between the actual and forecast data; and show the R². Use linear regression - you may calculate the intercept and slope coefficients manually or use computer software, such as Excel. The time interval is not especially important, but it must be uniform. You may use annualized data, monthly, or quarterly data that is historical or current. (Check ManagementGuru, Google, or library for data sources.) If you need help with the statistics, check out the tutorial hyperlink on the syllabus at ManagementGuru. In one sentence state your conclusion as to H1. Be prepared to discuss your findings in class.
Environmental
Measures [athe
measure assigned to you]:
|
Stock
price movement: S&P 500 index |
No.
of Company Bankruptcies |
T-Bill
Rate |
|
Stock
price movement: NASDAQ |
No.
of Initial Public Offerings |
Trade
Deficit |
|
Unemployment Rate |
Per
Capita Income |
U.S.
Population |
|
Inflation
Rate (CPI) |
Price
of Gold - any market |
GDP
(inflat. adj’d.) |
|
Any
Leading Economic Indicator |
Price
of Oil - any market |
Fed
Funds Rate |
Help with this Assignment:
1. The above data is available from several sources on the Internet, you may use a search engine or go to my page on Economics for sources. Get your data first.
2. The data: You need 7 data points. This means that if your data is in years, you need 7 years; if your data is reported monthly, you need 7 months. The time interval needs to be continuous, so you cannot use 1940, 1941, 1956, etc. or use Jan, Feb, Aug. etc.
3. You are going to use 6 time periods of data to predict the 7thn period. You already have the real 7th period and will use this to compare the real datum with what you predict.
4. I recommend that you learn to use simple spreadsheets for this exercise - we forget formulas, but usually always have access to Excel. For help on forecasting using regression with Excel CLICK HERE and follow instructions.
5. When you have predicted the 7th period, compare this number with what the real 7th period was. Is the forecast close? Why or why not? Do you accept the Hypothesis that Time and this economic measure are associated?
Assignment 3: Mergers
and Acquisitions
The objective of this assignment is that you demonstrate an ability to interpret stock price and conduct basic business research. You are to select a merger/acquisition that is currently in the press or investigate an historical case. Recent mergers are easier, because the stock data that will be needed can be difficult to find in our library for M&A more than a few years old.
A list of M&A’s is available to assist you at:
Corporate Affiliations
Answers.com (bank mergers)
FERC (utility company mergers)
DRIP Wizard (various m&a used for this software)
CNN Money.com (list of biggest m&a's)You may also check the current business news, such as at Google, MSN, CNN, etc., for ideas.
Your assignment is to:
1.
Report the names of the firms
involved. (I would avoid foreign firms, because unless you know how to look up
foreign stock exchanges and convert currencies - although these are available,
if you look - you will have trouble. I would also avoid older M&A, because
you can have trouble finding historical stock movement- although it is
available)
2.
Provide a one or two paragraph
summary of each firm’s history, including its products or services and current
CEO. Assistance for this is available at ManagementGuru (I like to use Hoover's
On-Line for this).
3.
Report the general terms of
the merger/acquisition agreement - for example, offered price and proposed
financing. You may have to do some online research to find out about this. (Use
a search engine to find the company or go to Hoover's Online for help.)
4. Track and report the stock price of each firm for six moths prior to the announcement of a merger/acquisition. If consummated, report the stock price of the consolidated firm for six months post merger/acquisition. The number of months available for the post-merger analysis depends on when the deal was consummated. If the merger is "in the works" and not consummated, report the stock prices for the two firms after the public announcement if stocks are traded. To find stock data you best source is likely to be BigCharts.com.using the historical interactive charting tab at the top of the page. These charts can be saved and copied into your paper.
5.
Interpret the stock price
movements you find. (Look at the stock trends and tell me what you see.)
This paper should be no longer than 2 pages.