| Ratio |
| Barry Computers |
Industry Averages |
| Current |
Current Assets/Current Liabilities |
ERROR:#DIV/0! |
2.0X |
| Quick |
Current Assets - Inventories/Current Liabilities |
ERROR:#DIV/0! |
1.3X |
| Days Sales Outstanding |
Receivables/(Annual Sales/365) |
ERROR:#DIV/0! |
35 |
days |
| Inventory Turnover |
Sales/Inventories |
ERROR:#DIV/0! |
6.7X |
| Total Assets Turnover |
Sales/Total Assets |
ERROR:#DIV/0! |
3.0X |
| Profit Margin |
Net Income/Sales |
ERROR:#DIV/0! |
1.2% |
| ROA |
Net Income/Total Assets |
ERROR:#DIV/0! |
3.6% |
| ROE |
Net Income/Common Equity |
ERROR:#DIV/0! |
9.0% |
| ROIC |
EBIT(1-T)Total Invested Capital |
ERROR:#DIV/0! |
7.5% |
| TIE |
EBIT/Interest Charges |
ERROR:#DIV/0! |
3.0X |
| Debt/Total Capital |
Total Debt/(Total Debt + Equity) |
ERROR:#DIV/0! |
47.0% |
| M/B |
Market Price/Book Value |
ERROR:#DIV/0! |
4X |
| P/E |
Price per Share/Earnings per Share |
ERROR:#DIV/0! |
17.86X |
| EV/EBITDA |
(Market Value of Equity + Market Value of Total Debt + Market Value of Other Financial Claims - Cash and Equivalents)/EBITDA |
ERROR:#DIV/0! |
9.00X |
| Balance Sheet |
Enter figures below |
| Cash |
$0 |
| Receivables |
$0 |
| Inventories |
$0 |
| Total Current Assets |
$0 |
| Net Fixed Assets |
$0 |
| Total Assets |
$0 |
| Accounts Payable |
$0 |
| Other Current Liabilities |
$0 |
| Notes Payable to Bank |
$0 |
| Total Current Liabilities |
$0 |
| Long-Term Debt |
$0 |
Shares Outstanding |
| Common Equity (36,100 shares) |
$0 |
36,100 |
| Total Liabilities and Equity |
$0 |
| Income Statement |
| Sales |
$0 |
| Cost of Goods Sold |
0 |
| Materials |
$0 |
| Labor |
$0 |
| Heat, light, and power |
$0 |
| Indirect Labor |
$0 |
| Depreciation |
$0 |
| Gross Profit |
$0 |
| Selling Expenses |
$0 |
| Gen. Admin Expenses |
$0 |
| EBIT |
$0 |
| Interest Expense |
$0 |
| EBT |
$0 |
Tax Burden |
| Fed and State Income Taxes (25%) |
$0 |
25% |
| Net Income |
$0 |
| Earnings per Share |
$0.00000 |
| Price per Share |
$0.00 |
| Book Value (Common Equity/Shares) |
$0.00 |
CJones65
WAL_MBAX_6070_Module02_Part1_assignmentTemplate.xlsx
