Using your company’s Form 10-K from the Annual Report Project – Section 3 assignment, analyze the information and include the following items as supplemental schedules to the analysis. These schedules should be prepared as individual worksheets within an Excel spreadsheet.
Provide a calculation of at least three significant liquidity ratios:

Current ratio
Acid test ratio
Cash ratio
Current cash debt coverage ratio
Working capital

Provide a calculation of at least three significant long-term debt-paying (coverage) ratios:

Times interest earned
Debt ratio
Debt/Equity ratio
Fixed charge coverage

In a summary of 500-750 words, analyze the financial strengths and weaknesses of your company based on the results of the liquidity and long-term debt ratios analysis.
Your analysis should be more than just a restatement of the results of the ratios. The analysis should provide some possible reasons for why the ratios increased or decreased over the last 3 years. Consider the relationships between the types of accounts and correlations that should (or should not) occur with the ratios.
You will submit two items for this assignment:

An Excel file with separate tabs for the liquidity and coverage ratio calculations.
A Word document with your analysis.

While APA style is not required for the body of this assignment, solid academic writing is expected, any documentation of sources should be presented using APA formatting guidelines, which can be found in the APA Style Guide, located in the Student Success Center.
Refer to “Annual Report Project – Section 4 Rubric” prior to beginning the assignment to become familiar with the expectations for successful completion.
You are required to submit this assignment to LopesWrite. Refer to theLopesWrite Technical Support articlesfor assistance.