Choose two public companies in the same industry. Log into Capital IQ$.$

For each firm:

a$.$ Search for firm data

i$.$ Find and download related data to demonstrate each of the following for

the past five years $($annual data$)$:

$1.$ Growth

$2.$ Profitability

$3.$ Margin

$4.$ Asset Turnover

$5.$ Short Term Liquidity

$6.$ Long Term Solvency

ii$.$ In a new workbook $($name it as $$Capital IQ Company Research Project $-$ your

name$),$ pull all of the corresponding data for each firm into one tab.

Rename each tab by the firm, e$.$g$.$Apple$,$ etc.

b$.$ Analyze firm performance in the past five years.

i$.$ Trends in revenue, EBITDA, or net income growth and explain significant

difference in the trend, if any.

ii$.$ Trends in the firm$$s profitability, efficiency and leverage and explain

significant difference in the trend, if any

iii. Use a DuPont analysis framework to explain why ROE increased or

decreased or flatted during the past five years

c$.$ Write your answers for section $($b$)$ into each company analysis tab of your $$Capital

IQ Company Research Project $-$ your name$$ workbook.

Part II: Company Comparison

For the two public companies in Part I you will compare the five$-$year average

ratios$/$margins$/$growth and indicated which company reflects the stronger

ratio$/$margin$/$growth$.$ Also, use Industry as a benchmark in judging the performance where possible.