Requirements:

Work through the instructions below. As you work, you$$ll be asked to:

$$ Follow the steps to perform the required analysis.

$$ Answer questions, many of which require PivotTables.

The first thing you need to do is calculate the four ratios:

$$ In column I calculate Return on Equity. Format the cells as a percentage with $2$ decimals.

$$ In column J calculate Profit Margin. Format the cells as a percentage with $2$ decimals.

$$ In column K calculate Asset Turnover. Format the cells as a number with $2$ decimals.

$$ In column L calculate Financial Leverage. Format the cells as a number with $2$ decimals.

What is the calculation for Return on Equity?

What is the calculation for Return on Investment?

Ignoring other ratios, would a company rather have a High or Low Return on Equity?

Ignoring other ratios, would a company rather have a High or Low Asset Turnover?

Which of the four DuPont ratios is the best measure of risk?

If a company experiences a net operating loss, which ratios are likely to be negative? $($list $2)$

How many rows of company data $($don$$t count headings$)$ are in the file?

How many different years are included in the file?

What is the heading of the column that includes the code NASDAQ uses to uniquely identify each company?