Evaluate the current and quick ratios as a trend analysis (year-over-year) and when compared to the industry averages. What do these numbers tell us about the companys liquidity position?

Use the example in the directions as a template for how to write your analysis.

Your financial analysis should be chock full of numbers. And all of your numbers should be properly labeled (%, times, or $). When writing a financial analysis, it is important to state and analyze the account balances as well as the ratios for the current and prior period numbers in your analysis as well as the industry averages. Including the base and revised account balances and ratios is important because a standalone number is not nearly as telling or valuable as comparing a figure to prior periods or even against industry averages.

When comparing and contrasting the changes in account balances and ratios, measure if the change was significant by calculating what the % increase or decrease was and explain why the change occurred (which factor(s) in the ratio most affected the ratio). Measure if the change was significant and explain why the change occurred. Keep in mind, your financial analysis should answer lots of the reader's questions - not raise more questions.

Use my explanation (available after the first attempt) to GUIDE your answers for your second (and final) attempt but use your own words. My comments serve as a general overview only and are not provided to be "your" answer. To maximize points, proofread carefully and demonstrate to the reader that you understand the material with originality. Please use the answers and these comments to redo this assignment before the deadline and be sure to include LOTS of numbers in your analysis.

Example

In 202X, Company XYZ reported a current ratio of 1.8X which is a 12.5% improvement over last year's current ratio of 1.6X and compares favorably to the industry average of 1.2X. The strong current ratio in 202X is attributed to accounts receivable climbing from $200,000 to $600,000 while the remaining current assets and current liabilities remained relatively stable. The jump in accounts receivable was attributed to a 22% increase in revenue year over year (from $1 million to $1.22 million).

This example states the baseline ratio and revised ratio, includes the account balances, is properly labeled ($ or %), and includes the relative percent increase/decrease while addressing the "why" behind the changes.

FOLLOW THIS FORMAT

\begin{tabular}{lrr} Other Data & 2020 & 2019 \\ \hline December 31 stock price & $6.00 & $8.50 \\ Number of shares & 100,000 & 100,000 \\ Dividends per share & $0.22 & $0.22 \\ Lease payments & $40,000 & $40,000 \end{tabular} Industry average data for 2020 : \begin{tabular}{lc} Ratio & Industry Average \\ \hline Current & 2.7x \\ Quick & 1.0x \\ Inventory turnover & 6.0x \\ Days sales outstanding (DSO) & 32.0 days \\ Fixed assets turnover & 10.7x \\ Total assets turnover & 2.6x \\ Debt ratio & 50.0% \\ TIE & 2.5x \\ Fixed charge coverage & 2.1x \\ Net profit margin & 3.5% \\ ROA & 9.1% \\ ROE & 18.2% \\ Price/earnings & 14.2x \\ Market/book & 1.4x \end{tabular} Statement of Cash Flows (2020) Operating Activities Net income $44,220 Other additions (sources of cash) Depreciation 20,000 Increase in accounts payable 29,600 Increase in accruals 4,000 Subtractions (uses of cash) Increases in accounts receivable (50,800) Increase in inventories (120,800) Net cash flow from operations $(73,780) Long-Term Investing Activities Investment in fixed assets $(36,000) Financing Activities Increase in notes payable $25,000 Increase in long-term debt 101,180 Payment of cash dividends (22,000) Net cash flow from financing $104,180 Net reduction in cash account $(5,600) Cash at beginning of year 57,600 Cash at end of year $52,000 \begin{tabular}{lrr} Other Data & 2020 & 2019 \\ \hline December 31 stock price & $6.00 & $8.50 \\ Number of shares & 100,000 & 100,000 \\ Dividends per share & $0.22 & $0.22 \\ Lease payments & $40,000 & $40,000 \end{tabular} Industry average data for 2020 : \begin{tabular}{lc} Ratio & Industry Average \\ \hline Current & 2.7x \\ Quick & 1.0x \\ Inventory turnover & 6.0x \\ Days sales outstanding (DSO) & 32.0 days \\ Fixed assets turnover & 10.7x \\ Total assets turnover & 2.6x \\ Debt ratio & 50.0% \\ TIE & 2.5x \\ Fixed charge coverage & 2.1x \\ Net profit margin & 3.5% \\ ROA & 9.1% \\ ROE & 18.2% \\ Price/earnings & 14.2x \\ Market/book & 1.4x \end{tabular}