| Holyard Industries Assignment |
| 2012 Financial Reports |
| Holyard Industries gathered the following financial information from its 2012 financial reports: | | | | | | | | | Selected Ratios |
| | | | | | | | | | Competitors | Industry |
| Current Ratio | | 1.6 | | Shares Outstanding | | 290,000 | | Current Ratio | 1.6 | 1.4 |
| Quick Ratio | | 0.75 | | Average Issue Price | | $ 5 | | Quick | 0.8 | 0.125 |
| Inventory | | $ 300,000 | | Stock Price | | $ 18.37 | | Inventory T/O | 11.5 | 13 |
| Inventory Turnover | | 12 | | TIE Ratio | | 8 | | Stock Price | 19.25 | 18.25 |
| Expenses (ExcludingCOGS) | | $ 1,120,000 | | Interest Rate | | 8% | | TIE Ratio | 7.5 | 8.25 |
| Gross Margin | | 40% | | Fixed Asset Turnover | | 1.5 | | Fixed Asset T/O | 1.65 | 1.45 |
| Tax Rate | | 34% | | Avg. Collection Period | | 12 | | Avg. Collection | 12.25 | 11.75 |
| | | | | | | | | Book Value/Sh. | 7.75 | 7.32 |
| | | | | | | | | Market to Book | 3.12 | 2.54 |
| Complete the following financial statement templates by filling in the shaded areas and calculate the per share ratios: |
| Balance Sheet |
| Current Assets: | | | Current Liabilities: |
| Cash | | | Current Liabilities |
| Accounts Receivable | | | Long-Term Liabilities (LT Debt) |
| Inventory | | | Total Liabilities |
| Total Current Assets | | | Equity: |
| Fixed Assets | | | Paid-In Capital |
| | | | Retained Earnings |
| | | | Total Equity |
| Total Assets | | | Liabilities and Equity |
| Income Statement |
| Revenue | | | | Book Value/Share |
| Cost of Goods Sold (COGS) | | | | Market to Book Ratio |
| Gross Margin (GM) |
| Expenses |
| Earnings Before Income and Tax (EBIT) |
| Interest |
| Earnings Before Tax |
| Taxes |
| Earnings After Tax (EAT) |
FaTaHLizE
Holyard.xlsx
