For the publicly$-$traded company you selected to evaluate for this course, download their most recent $10$K$.$ Include the link to the financial statements as a reference on your References page. I cannot verify your answers without a link to the financial statements.

Answer the following questions in Excel:

The Company Nike

Part $1$

$1)$ Perform a horizontal analysis of the Income Statement.

$2)$ Create a common$-$size Income Statement for the most recent year on the $10$K$.$

Part $2$

$1)$ Calculate the current ratio for the most recent year on the $10$K$.$

$2)$ Calculate the quick ratio for the most recent year on the $10$K$.$

$3)$ Calculate gross profit margin percentage for the most recent year on the $10$K$.$

$4)$ Calculate operating expense margin for the most recent year on the $10$K$.$

$5)$ Calculate net profit margin for the most recent year on the $10$K$.$

$6)$ Calculate accounts receivable turnover and days$$ sales outstanding for the most recent year on the $10$K$.$

$7)$ Calculate inventory turnover and days$$ inventory outstanding for the most recent year on the $10$K$.$

$8)$ Calculate accounts payable turnover and days payables outstanding for the most recent year on the $10$K$.$

$9)$ Calculate the cash conversion cycle for the most recent year on the $10$K$.$

$10)$ Calculate PPE turnover for the most recent year on the $10$K$.$

$11)$ Calculate Return on equity for the most recent year on the $10$K$.$

$12)$ Calculate Return on assets for the most recent year on the $10$K$.$

$13)$ Calculate the total liabilities to equity ratio for the most recent year on the $10$K$.$

$14)$ Calculate the times interest earned ratio for the most recent year on the $10$K$.$

Part III

Prepare a memo reporting on the financial health of your company. Be sure to discuss liquidity, solvency, and profitability.