Act as a consultant hired by the operations director of the Barry Computer Company to do a
Fantastic news! We've Found the answer you've been seeking!
Question:
Act as a consultant hired by the operations director of the Barry Computer Company to do a financial analysis and comparison to the industry. You will conduct a financial ratio analysis to gain a good understanding of the company's financial performance and will then write up an evaluation of the organization's financial health, as well as your recommendations for how specific ratios can be improved within the next 3-5 years.
Submityour evaluation of an organization's financial health based on financial ratios, to include the following:
Part 1: Financial Information (2-3 pages, plus Excel spreadsheet)
- Calculate the following ratios for the Barry Computer Company using the Excel spreadsheet provided.
Ratio | Calculation |
Current | Current Assets/Current Liabilities |
Quick | Current Assets - Inventories/Current Liabilities |
Days Sales Outstanding | Receivables/(Annual Sales/365) |
Inventory Turnover | Sales/Inventories |
Total Assets Turnover | Sales/Total Assets |
Profit Margin | Net Income/Sales |
ROA | Net Income/Total Assets |
ROE | Net Income/Common Equity |
ROIC | EBIT(1 - T)/Total Invested Capital |
TIE | EBIT/Interest Charges |
Debt/Total Capital | Total Debt/(Total Debt + Equity) |
M/B | Market Price/Book Value |
P/E | Price per Share/Earnings per Share |
EV/EBITDA | (Market Value of Equity + Market Value of Total Debt + Market Value of Other Financial Claims - Cash and Equivalents)/EBITDA |
- Analyze computations to determine which ratios are above and below their industry averages, and for each, provide a brief explanation as to why that might be the case.
- Evaluate the financial health of the organization, including in what areas the organization could improve.
Ratio | Barry Computers | Industry Averages | ||
Current | Current Assets/Current Liabilities | #DIV/0! | 2.0X | |
Quick | Current Assets - Inventories/Current Liabilities | #DIV/0! | 1.3X | |
Days Sales Outstanding | Receivables/(Annual Sales/365) | #DIV/0! | 35 | days |
Inventory Turnover | Sales/Inventories | #DIV/0! | 6.7X | |
Total Assets Turnover | Sales/Total Assets | #DIV/0! | 3.0X | |
Profit Margin | Net Income/Sales | #DIV/0! | 1.2% | |
ROA | Net Income/Total Assets | #DIV/0! | 3.6% | |
ROE | Net Income/Common Equity | #DIV/0! | 9.0% | |
ROIC | EBIT(1-T)Total Invested Capital | #DIV/0! | 7.5% | |
TIE | EBIT/Interest Charges | #DIV/0! | 3.0X | |
Debt/Total Capital | Total Debt/(Total Debt + Equity) | #DIV/0! | 47.0% | |
M/B | Market Price/Book Value | #DIV/0! | 4X | |
P/E | Price per Share/Earnings per Share | #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 | #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 | |||
Posted Date: