ACCOUNTING & FINANCIAL MANAGEMENT
Steven01U05K
PaleyProductsInc.xlsxRatios
| Paley Products Inc | ||||
| Calculations of Ratios | ||||
| Industry | Paley Products | |||
| Average | 2016 | 2015 | 2014 | |
| Quick Ratio | 1.0 | 0.61 | 1.0 | 2.1 |
| Current Ratio | 2.7 | 1.8 | 2.6 | 4.2 |
| Inventory Turnover | 7.0 | 2.8 | 4.3 | 6.9 |
| Average Collection Period (Days) | 32 | 50 | 37 | 34 |
| Total Asset Turnover | 2.6 | 1.9 | 2.6 | 3.2 |
| Fixed Asset Turnover | 13.0 | 12.4 | 10.7 | 11.6 |
| Return on Assets | 11.7% | 3.6% | 8.4% | 15.8% |
| Debt Ratio | 50.0% | 48.0% | 33.0% | 22.0% |
| Return on Sales | 4.5% | 1.8% | 3.3% | 5.1% |
| Return on Net Worth (Equity) | 23.4% | 7.0% | 12.0% | 20.0% |
Sources and Uses of Funds
| Paley Products Inc | |||
| Souces and Uses of Funds | |||
| Sources of Funds | Uses of Funds | ||
| Total Sources | 0 | Total Uses | 0 |
| Decrease in Cash Balance 2016 | |||
Income Statement
| Paley Products Inc | ||
| Forecast Income Statement, 2017 | ||
| Actual 2016 | Forecast 2017 | |
| Revenue | 2,856,000 | 2,941,680 |
| Cost of Goods Sold | 2,284,800 | 2,353,344 |
| Gross Profit | 571,200 | 588,336 |
| General and Administrative Expenses | 244,800 | 244,800 |
| Depreciation | 122,400 | 122,400 |
| Miscellaneous Expense | 122,400 | 122,400 |
| Net Income Before Taxes | 81,600 | 98,736 |
| Income Taxes @35% | 28,560 | 34,558 |
| Net Income | 53,040 | 64,178 |
Balance Sheet
| Paley Products Inc | ||||||
| Forecast Balance Sheet, 2017 | ||||||
| Actual 2016 | Forecast 2017 | |||||
| Cash | 20,400 | 124,467 | ||||
| Accounts Receivable | 388,000 | 322,376 | 49.5868347339 | 8059.397260274 | 322375.890410959 | |
| Inventory | 826,200 | 588,336 | 588,336 | |||
| Current Assets | 1,234,600 | 1,035,178 | ||||
| Gross Book Value | 826,300 | 926,300 | ||||
| Accumulated Depreciation | (595,800) | (718,200) | ||||
| Net Book Value | 230,500 | 208,100 | ||||
| Total Assets | 1,465,100 | 1,243,278 | ||||
| Bank Notes | 286,000 | 0 | ||||
| Accounts Payable | 306,000 | 306,000 | ||||
| Accruals | 77,500 | 77,500 | ||||
| Current Liabilities | 669,500 | 383,500 | ||||
| Mortgage | 36,700 | 36,700 | ||||
| Common Stock | 365,000 | 365,000 | ||||
| Retained Earnings | 393,900 | 458,078 | ||||
| Total Liabilities and Equity | 1,465,100 | 1,243,278 | ||||
Cash Flow Forecast
| Paley Products Inc | |
| Cash Flow Forecast 2017 | |
| Sources of Funds | |
| Total Sources of Funds | 0 |
| Uses of Funds | |
| Total Uses of Funds | 0 |
| Net Increase in Cash | 0 |
| Plus Beginning Cash | |
| Ending Cash Balance | 0 |
