Acct 5331 Financial Statement Analysis due by 11:59 PM Wednesday, May, 5.

Your team has been hired by a multi-national conglomerate to assess two US public companies within the same industry. Your analysis will be used to decide on a major investment in one of the companies. Use the financial statements provided and any other data you wish to collect. For market performance analysis purposes use the stock market data at close of day on the last day of the period for the financial statements. If the stock market was not open on the last day of the period, use the most recent day prior to financial statement date.

Required Deliverables:

Prepare Common-Size Statements and Financial Ratios:

1. The following ratios for both this year and last year:

a. The amount of working capital.

b. The current ratio.

c. The acid-test ratio.

d. The average collection period.

e. The total asset turnover.

f. The debt-to-equity ratio.

g. The times interest earned ratio.

h. The equity multiplier.

2. For both this year and last year:

a. Present the balance sheet in common-size format for both this year and last year.

b. Present the income statement in common-size format down through net income for both this year and last year.

Prepare Ratios that Assess Profitability and Market Performance:

Use the stock market data from the last day of the financial statements or if the market was closed on the last day of the accounting period, use the most recent day preceding the end of the period.

3. Assess the company's stock market performance. For both this year and last year, compute:

a. The earnings per share.

b. The dividend yield ratio.

c. The dividend payout ratio.

d. The price-earnings ratio.

e. The book value per share of common stock.

4. Assess the company's profitability. Compute the following for both this year and last year:

a. The net profit margin percentage.

b. The return on total assets.

c. The return on equity.

d. Is the company's financial leverage positive or negative?Acct 5331 Financial Statement Analysis due by 11:59 PM Wednesday, May, 5.

Your team has been hired by a multi-national conglomerate to assess two US public companies within the same industry. Your analysis will be used to decide on a major investment in one of the companies. Use the financial statements provided and any other data you wish to collect. For market performance analysis purposes use the stock market data at close of day on the last day of the period for the financial statements. If the stock market was not open on the last day of the period, use the most recent day prior to financial statement date.

Required Deliverables:

Prepare Common-Size Statements and Financial Ratios:

1. The following ratios for both this year and last year:

a. The amount of working capital.

b. The current ratio.

c. The acid-test ratio.

d. The average collection period.

e. The total asset turnover.

f. The debt-to-equity ratio.

g. The times interest earned ratio.

h. The equity multiplier.

2. For both this year and last year:

a. Present the balance sheet in common-size format for both this year and last year.

b. Present the income statement in common-size format down through net income for both this year and last year.

Prepare Ratios that Assess Profitability and Market Performance:

Use the stock market data from the last day of the financial statements or if the market was closed on the last day of the accounting period, use the most recent day preceding the end of the period.

3. Assess the company's stock market performance. For both this year and last year, compute:

a. The earnings per share.

b. The dividend yield ratio.

c. The dividend payout ratio.

d. The price-earnings ratio.

e. The book value per share of common stock.

4. Assess the company's profitability. Compute the following for both this year and last year:

a. The net profit margin percentage.

b. The return on total assets.

c. The return on equity.

d. Is the company's financial leverage positive or negative?

I have the excel documents with all the company's information but how can I really start this assignment.