| JAMES CONFECTIONERS |
| Financial Statements |
| INCOME STATEMENTS | | | | | | | | 20XX RATIO ANALYSIS |
| | | | | 20XX | | | | SUBJECT | | INDUSTRY MEDIAN |
| Sales | | | | | | | Current | | | 1.7 |
| COGS | | | | | | | Quick | | | 0.8 |
| GP | | | | | | | A/R Turn | | | 15.7 |
| SGA Exp. | | | | | | | Avg Coll | | | 23 |
| Deprec. | | | | | | | Inv Turn | | | 4.9 |
| EBIT (Oper. Income) |
| Interest | | | | | | | OI ROI |
| EBT | | | | | | | OPM |
| Income Taxes | | | | | | | FA Turn | | | 8.2 |
| Net Income |
| | | | | | | | Debt/TA | | | 0.7 |
| | | | | | | | Times Int | | | 2.3 |
| BALANCE SHEETS |
| | | | | 20XX | | | ROE | | | 16.5 |
| ASSETS | | | | | | | ROA | | | 5.6 |
| CURRENT ASSETS |
| Cash |
| Accounts Receivable |
| Inventories |
| Other Current |
| TOTAL CURRENT ASSETS |
| FIXED ASSETS |
| Gross PP&E |
| Accumulated Depreciation |
| Net PP&E |
| Other Fixed |
| TOTAL ASSETS |
| LIABILITIES & EQUITY |
| CURRENT LIABILITIES |
| Accounts Payable/Accruals |
| Short Term Debt |
| TOTAL CURRENT LIABILITIES |
| LONG TERM DEBT |
| STKHLDRS EQUITY |
| Common Stock (par+paid-in) |
| Retained Earnings |
| TOTAL LIABILITIES & EQUITY |
liam1998
LU1JamesConfectionersWorksheetExcel97-2003version.xls
