Question: Evaluate the financial statement data and the financial ratios for these two firms and answer the questions. Your answers should be based on the numbers
Evaluate the financial statement data and the financial ratios for these two firms and answer the questions. Your answers should be based on the numbers given. Show your work to ensure credit.
- Compute the Cash Conversion Cycle for both firms. Which firm has the shorter CCC? Provide evidence for your answer.
- Which of these two firms has the highest average annual Earnings Per Share ratio? Explain your answer (show your work)
- If you were a bank lending officer specializing in short-term loans to businesses, which of the two firms would you rather do business with? Explain your answer.
| Firm A | Firm B | ||||||
| Income Statement | 2016 | 2015 | 2014 | 2016 | 2015 | 2014 | |
| Revenues | 58,811 | 63,740 | 49,853 | 350,052 | 347,379 | 349,894 | |
| Cost of Goods Sold | 35,830 | 38,206 | 30,616 | 258,040 | 257,846 | 260,776 | |
| Gross Profit | 22,981 | 25,534 | 19,237 | 92,012 | 89,533 | 89,118 | |
| Operating Expenses | 6,611 | 6,116 | 4,923 | 72,752 | 69,315 | 66,727 | |
| Operating Income | 16,370 | 19,418 | 14,314 | 19,260 | 20,218 | 22,391 | |
| Interest & Other Non-Oper Exp | 368 | 350 | 267 | 1,090 | 1,105 | 1,251 | |
| Earnings Before Taxes | 16,002 | 19,068 | 14,047 | 18,170 | 19,113 | 21,140 | |
| Income Tax | 4,278 | 5,215 | 3,811 | 6,389 | 6,572 | 7,642 | |
| Net Income | 11,724 | 13,853 | 10,236 | 11,781 | 12,541 | 13,498 | |
| Number of shares outstanding | 18,000 | 18,000 | 18,000 | 25,000 | 25,000 | 25,000 | |
| Balance Sheet | |||||||
| Cash & Cash Equiv | 47,409 | 45,133 | 29,134 | 11,397 | 11,287 | 12,929 | |
| Accounts Receivable | 29,299 | 30,343 | 31,527 | 10,699 | 10,557 | 11,343 | |
| Inventory | 12,133 | 12,355 | 18,199 | 22,328 | 23,290 | 24,426 | |
| Total Current Assets | 88,841 | 87,831 | 78,860 | 44,424 | 45,134 | 48,698 | |
| Net Property, Plant, & Equipment | 25,119 | 22,471 | 20,624 | 71,066 | 71,970 | 74,672 | |
| Intangible Assets | 8,941 | 8,816 | 8,744 | 11,513 | 11,246 | 10,203 | |
| Total Assets | 122,901 | 119,118 | 108,228 | 127,003 | 128,350 | 133,573 | |
| Accounts Payable | 51,161 | 49,661 | 47,559 | 41,912 | 49,147 | 53,440 | |
| Short-Term Debt | 11,605 | 10,999 | 4,308 | 33,341 | 17,095 | 16,738 | |
| Long-Term Debt | 16,477 | 4,399 | 987 | 11,430 | 16,814 | 18,703 | |
| Shareholders Equity | 43,658 | 54,059 | 55,374 | 40,320 | 45,295 | 44,692 | |
| Total Liabilities & Equity | 122,901 | 119,118 | 108,228 | 127,003 | 128,351 | 133,573 | |
| Dupont Analysis: | |||||||
| Net Profit Margin | 19.9% | 21.7% | 20.5% | 3.4% | 3.6% | 3.9% | |
| Total Asset Turnover | 0.48 | 0.54 | 0.46 | 2.76 | 2.71 | 2.62 | |
| Equity Multiplier | 2.82 | 2.20 | 1.95 | 3.15 | 2.83 | 2.99 | |
| Return on Equity | 26.9% | 25.6% | 18.5% | 29.2% | 27.7% | 30.2% | |
| Current Ratio | 1.42 | 1.45 | 1.52 | 0.59 | 0.68 | 0.69 | |
| Quick Ratio | 1.22 | 1.24 | 1.17 | 0.29 | 0.33 | 0.35 | |
| Cash Ratio | 0.76 | 0.74 | 0.56 | 0.15 | 0.17 | 0.18 | |
| Inventory Turnover (Sales basis) | 4.8 | 5.2 | 2.7 | 15.7 | 14.9 | 14.3 | |
| Accounts Receivable Turnover | 2.0 | 2.1 | 1.6 | 32.7 | 32.9 | 30.8 | |
| Fixed Asset Turnover | 2.3 | 2.8 | 2.4 | 4.9 | 4.8 | 4.7 | |
| Debt Ratio | 64% | 55% | 49% | 68% | 65% | 67% |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
