Question: Problems 1 and 2 BALANCE SHEET 2015 INSTRUCTIONS: Analyze the firm's performance from both time-series and cross-sectional points of view using the key financial ratios
| Problems 1 and 2 | |||||||
| BALANCE SHEET | 2015 | INSTRUCTIONS: Analyze the firm's performance from both time-series and cross-sectional points of view using the key financial ratios provided. PROVIDE YOUR WRITTEN ANALYSIS IN THIS COLUMN. | |||||
| Assets | |||||||
| Cash and Equivalents | $ 237,500.00 | ||||||
| Accounts Receivable | $ 592,500.00 | ||||||
| Inventory | $ 607,500.00 | ||||||
| Total Current Assets | $ 1,437,500.00 | ||||||
| Gross Fixed Assets | $ 1,250,000.00 | ||||||
| Less Accumulated Depreciation | $ 187,500.00 | ||||||
| Net Fixed Assets | $ 1,062,000.00 | ||||||
| Total Assets | $ 2,500,000.00 | ||||||
| Liabilities and Equity | |||||||
| Current Liabilities | |||||||
| Accounts Payable | $ 222,500.00 | ||||||
| Notes Payable | $ 422,500.00 | ||||||
| Accruals | $ 217,500.00 | ||||||
| Total Current Liabilities | $ 862,500.00 | ||||||
| Long Term Debt | $ 470,000.00 | ||||||
| Total Liabilities | $ 1,332,500.00 | ||||||
| Stockholder's Equity | |||||||
| Common Stock | $ 637,500.00 | ||||||
| Retained Earnings | $ 530,000.00 | ||||||
| Total Stockholders Equity | $ 1,167,500.00 | ||||||
| Total Liabilities & Equity | $ 2,500,000.00 | ||||||
| INCOME STATEMENT | |||||||
| Sales Revenue | $ 3,360,000.00 | ||||||
| Cost of Sales | $ 2,724,960.00 | ||||||
| Gross Profits | $ 635,040.00 | ||||||
| Less: Operating Expenses | |||||||
| Selling Expense | $ 251,200.00 | ||||||
| General S&A | $ 163,200.00 | ||||||
| Depreciation | $ 48,000.00 | ||||||
| Total Operating Expenses | $ 462,400.00 | ||||||
| Total Operating Profit | $ 172,640.00 | ||||||
| Less: Interest Expense | $ 31,200.00 | ||||||
| Net Profits Before Taxes | $ 141,440.00 | ||||||
| Less Taxes (40%) | $ 56,576.00 | ||||||
| Net Profits After Taxes | $ 84,864.00 | ||||||
| LIQUIDITY RATIOS | 2013 | 2014 | 2015 | Industry Average | |||
| Current Ratio | 1.5 | 1.7 | 1.6 | ||||
| Quick Ratio | 0.9 | 1 | 0.9 | ||||
| Operating Cash Flow | n/a | n/a | |||||
| ASSET MANAGEMENT RATIOS | 2013 | 2014 | 2015 | Industry Average | |||
| Inventory Turnover | 6 | 5 | 8.4 | ||||
| Average Collection Period | 40 | 50 | 40 | ||||
| Fixed Asset Turnover | n/a | n/a | |||||
| Total Asset Turnover | 1.5 | 1.5 | 1.75 | ||||
| DEBT MANAGEMENT RATIOS | 2013 | 2014 | 2015 | Industry Average | |||
| Debt Ratio | 60% | 56% | 50% | ||||
| Times Interest Earned | 2.5 | 3.5 | 4 | ||||
| PROFITABILITY RATIOS | 2013 | 2014 | 2015 | Industry Average | |||
| Gross Profit Margin | 20% | 19.70% | 20% | ||||
| Operating Profit Margin | 4.70% | 4.80% | 6% | ||||
| Net Profit Margin | 2% | 2.30% | 3% | ||||
| Return on Investment | 3.00% | 3.50% | 5.25% | ||||
| Return on Equity | 7.50% | 7.95% | 10.50% | ||||
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
