Identify ticker symbols of stocks to trade

Assignment Help Corporate Finance
Reference no: EM131168220

Research Project

A key component of graduate study at ADU is research. The objective of this research project is to give students the skills to critically evaluate pertinent literature and master basic research methodology. The research project consists of a focused Portfolio Performance and Financial Analysis involving samples of health care versus non-health care investor-owned enterprises. The report should be approximately 7-15 pages in length (including tables, figures and list of references; prepared following any recognized style format such as APA (American Psychological Association) or MLA (Modern Language Association).  Students are expected to search for, read, and cite a minimum of two (2) peer-reviewed articles (additional information will be provided in class).

Use the following chart as a guide for data collection and organization:

Master Portfolio, n=40

Health Care Sector Portfolio, n=20

Non-Health Care Sectors Portfolio, n=20

Hospitals

Basic Materials

Home Health Care

Conglomerates

Long-term Care

Consumer Goods

Health Care Plans

Financial

Drug Manufacturers

Industrial Goods

Biotechnology

Services

Medical Appliances

Technology

Diagnostic

Utilities

Part A

Select forty enterprises, 20 from the health care sector and 20 from the non-health sectors (see Note 1). Using SPSS or Excel, perform an independent sample t-test to examine the risk-unadjusted return performance differential between the two portfolios. Decide between equal-variances and unequal-variances test statistics. The research objective is to identify the portfolio dominance order, hence the hypotheses are:

H0: (µ1 - µ2) = 0 (there is no dominant portfolio)

H1: (µ1 - µ2) ≠ 0 (there is a dominant portfolio)

How to form the master portfolio

1. Identify ticker symbols of stocks to trade

2. You Yahoo.Finance.com to get historical market values (see Note 1)

3. Use "Research Project Part A" template as a guide to complete this part of the research project.

Part B

Perform a financial performance assessment of TWO of the companies (one from each portfolio). Please see textbook, chapter 13. Address the areas of short-term solvency (Current Ratio), long-term solvency (Debt Ratio), asset management (Total Asset Turnover), and profitability (Return on Equity and Profit Margin). Make sure you compare these metrics with a benchmark (industry or leading competitor) and assess the two-year trend of each measure. Assess MVA and volatility via a 5-year flowchart/time series for these two companies

Organize your report as follows:

1. Introduction and Methodology

2. Data and Descriptive Statistics

3. Analysis and Conclusion

4. References

See Note 2 below. An example of a financial performance analysis report is provided under Files/Research Project.

Note 1

The research project has two components (see syllabus). The first component (Part A) is an empirical statistical test. The purpose of the test is to identify whether there is a dominant portfolio. You need to collect historical market values to run the test. Follow the attached example (see Excel file attached) to organize your data. Select 40 enterprises (20 from the healthcare sector and 20 from the other sectors). Use the following link to access the sectors: https://biz.yahoo.com/p/s_conameu.html. Note that each enterprise (company) has a stock symbol. For example, the symbol of Hospital Corporation of American is HCA. If HCA is one of your selected companies (part of the healthcare portfolio) then obtain the market values of that company for May 15 and August 15. If you do not want to wait until August 15, then use an alternative period of time, for example Jan 1, 2015 to Dec 31, 2015 (a full year). Go to https://finance.yahoo.com/ and use the "Quote Lookup" function (enter the stock symbol, for example HCA and click on "Go'), then click on "Historical Prices" then set the date range (for example Jan 1, 2015 to Dec 31, 2015) daily values. Record the Jan 1 and Dec 31 "Adj Close" values in the Excel spreadsheet as illustrated in Template A (Canvas/Files). Do the same for the other selected companies. When done, run a "t-test, Two-Sample, Assuming Equal Variances" test. When done, explain your findings. Note that Template A has two spreadsheets: "Data" and "Test". If you have any questions, please let me know.

Note 2

For Part B, perform a financial performance analysis of TWO of the companies (one from each portfolio). You need access to the income statements and balance sheets for three years (for example, 2015, 2014, and 2013). Go to https://finance.yahoo.com/ and use the "Quote Lookup" function (enter the stock symbol, for example HCA and click on "Go'), then click on "Income Statement" and get the necessary revenue/expense data for these periods. Transfer these amounts to the Template. Do the same for the "Balance sheet." Address the areas of short-term solvency (Current Ratio), long-term solvency (Debt Ratio), asset management (Total Asset Turnover), and profitability (Return on Equity and Profit Margin). Make sure you compare these metrics with a benchmark (industry or leading competitor) and assess the two-year trend of each measure. Assess MVA and volatility via a 5-year flowchart/time series for these two companies. Use Template B (Canvas/Files/Research Project) as a guide.

Attachment:- Case_Project.zip

Reference no: EM131168220

Questions Cloud

Construct a histogram of these measurements : Can you guess what might have caused the unusual aspect(s) of the histogram?
The characteristics of water as a fire suppression agent : Write research paper on one of the topics: - --- The characteristics of water as a fire suppression agent.
Income inequality hypothesis : Use the production function equation to describe the ‘income inequality hypothesis', i.e. that labour income is being redistributed to capital. What might that particular model imply about what is happening and why?
Mention the importance of leadership : State two important characteristics of Directing. Mention the importance of Leadership
Identify ticker symbols of stocks to trade : Identify ticker symbols of stocks to trade. You Yahoo.Finance.com to get historical market values. Use "Research Project Part A" template as a guide to complete this part of the research project.
Four constraints at the optimal solution : If Electrocomp decides that at least 30 air conditioners should be produced but no more than 50 fans should be produced, what would be the optimal solution? How much slack is there for each of the four constraints at the optimal solution?
What you learn from this control chart : John makes 20 computers per day for Pathway computer. Production data appear in the file P20_48 .xlsx. Construct a control chart based on the number of defective computers produced during each of the last 30 days. Explain as fully as possible what..
Waht kind of new technologies can help students learn : How can new technologies be used problem solution effectively in education? - Should Students/Teachers use new technology when learning in class/when teaching in class?
How you will apply managerial decision-making methods : Provide an explanation of how you will apply managerial decision-making methods throughout your action plan.  Which business functions will be impacted by your action plan? What tactics will you use to manage implementation across business function..

Reviews

Write a Review

Corporate Finance Questions & Answers

  Find short term liabilities and long term liabilities

Balance Sheet and Market Value of Under Armour, Corporation Liabilities and Equity, determine the Short term liabilities & long term liabilities.

  What is the projected dividend for the coming year

What is the projected dividend for the coming year? (Do not round intermediate calculations and round your final answer to 2 decimal places. (e.g., 32.16))

  Jetblue airways ipo valuation questions1 what are the

jetblue airways ipo valuation questions1. what are the advantages and disadvantages of going public?2. what different

  Investment in fixed assets or borrow funds

Analysis on whether to go for investment in Fixed Assets or borrow funds - what conclusion can you draw from it

  Sole proprietorship, partnership, and corporation forms

Discuss the primary differences between partnership, sole proprietorship, and corporation forms of business ownership?

  Explain the principal benefits that firms obtain

Prepare flexible budgets for monthly output levels of 55,000 and 65,000 units for the year ended 31 December 2005. Explain the principal benefits that firms obtain from the preparation of flexible budgets.

  Compute what the weighted average cost of capital

Determine what the weighted average cost of capital (WACC) is for your chosen company. Determine the cost of debt and equity for your chosen US publicly traded company using the techniques presented.

  When the mnc develops an economic exposure strategy

When the MNC develops an economic exposure strategy, the ___ the price elasticity of demand, the ___ the incentive to hold down price and thereby expand sales.a) Lower, greaterb) Greater, lowerc) Greater, greaterd) Lower, lower

  Please wirte the difinition of each answer and use some

please wirte the difinition of each answer and use some examples pictures and math to explain each questions1. list and

  What are currently undervalued and overvalued exchange rates

What are currently the most undervalued and overvalued exchange rates? How would you use this information in forecasting exchange rates?

  Prepare the schedule of cost of goods manufactured

All raw materials are considered direct to the manufacturing process. During April, the company purchased $260,000 of raw materials. Direct labor cost for the month was $342,000; workers are paid $9.50 per hour. Overhead is applied at the rate of ..

  Determine the optimal capital structure

Determine the optimal capital structure, the various financing options available and the debt maturity profile of the project. Discuss the merits and limitations of each form of financing proposed.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd