In: Accounting
Hillside, Inc. | ||||||||
BALANCE SHEET | INCOME STATEMENT | |||||||
($ in millions) | ($ in millions) | |||||||
ASSETS | LIABILITIES | Revenue | 28,681.10 | |||||
Cash & Marketable Securities | 449.90 | Accounts Payable | 1,611.20 | Cost Of Goods Sold | 20,768.80 | |||
Accounts Receivable | 954.80 | Salaries Payable | 225.20 | Gross Profit | 7,912.30 | |||
Inventories | 3,645.20 | Other Current Liabilities | 1,118.80 | |||||
Other Current Assets | 116.60 | Total Current Liabilities | 2,955.20 | Operating Expenses: | ||||
Total Current Assets | 5,166.50 | Selling, General & Admin. | 5,980.80 | |||||
Other Liabilities | 693.40 | Depreciation | 307.30 | |||||
Machinery & Equipment | 1,688.90 | Operating income | 1,624.20 | |||||
Land | 1,129.70 | Total Liabilities | 3,648.60 | |||||
Buildings | 2,348.40 | Interest | - | |||||
Depreciation | (575.60) | SHAREHOLDER'S EQUITY | Other Expense (Income) | (13.10) | ||||
Property, Plant & Equip. - Net | 4,591.40 | Common Stock | 828.50 | Income Before Taxes | 1,637.30 | |||
Other Long Term Assets | 120.90 | Retained Earnings | 5,401.70 | Income Taxes | 618.10 | |||
Total Long-Term Assets | 4,712.30 | Total Shareholder's Equity | 6,230.20 | Net Income | 1,019.20 | |||
Total Assets | 9,878.80 | Total Liabilities & Equity | 9,878.80 | |||||
Number of Common Stock | ||||||||
Shares Outstanding | 1,032,271 | |||||||
Input Answers Below | Financial Performance Summary | |||||||
LIQUIDITY RATIOS | ||||||||
Current Ratio (times) | ||||||||
Quick Ratio (times) | ||||||||
Average Payment Period (days) | ||||||||
ASSET MANAGEMENT RATIOS | ||||||||
Total Asset Turnover (times) | ||||||||
Average Collection Period (days) | ||||||||
Inventory Turnover (times) | ||||||||
FINANCIAL LEVERAGE RATIOS | ||||||||
Total Debt to Total Assets | ||||||||
Equity Multiplier (times) | ||||||||
PROFITABILITY RATIOS | ||||||||
Operating Profit Margin | ||||||||
Net Profit Margin | ||||||||
Return on Total Assets | ||||||||
Return on Equity | ||||||||
Earnings per Share |
LIQUIDITY RATIOS | Formula | Answer | |
Current Ratio (times) | =Current Assets/Current Liability | 1.75 | =5166.5/2955.2 |
Quick Ratio (times) | =(Current assets-Stock)/Current Liability | 0.51 | =(5166.5-3645.2)/2955.2 |
Average Payment Period (days) | =Accounts Payable/(Total credit purchaseor COGS/days in period) | 28.32 | =1611.2/(20768.8/365) |
ASSET MANAGEMENT RATIOS | |||
Total Asset Turnover (times) | =Net Sales/Total assets | 2.90 | =28681.1/9878.8 |
Average Collection Period (days) | =Accounts Receivable/(Net Sales/days in period) | 12.15 | =954.8/(28681.1/365) |
Inventory Turnover (times) | =COGS/Inventory | 5.70 | =20768.8/3645.2 |
FINANCIAL LEVERAGE RATIOS | |||
Total Debt to Total Assets | =Total Liabilities/Total assets | 0.37 | =3648.6/9878.8 |
Equity Multiplier (times) | =Total assets/Total equity | 1.59 | =9878.80/6230.200 |
PROFITABILITY RATIOS | |||
Operating Profit Margin | =Operating profit/Net sales | 5.66% | =1624.2/28681.1 |
Net Profit Margin | =Net profit/Net sales | 3.55% | =1019.2/28681.1 |
Return on Total Assets | =Profitbefore interest and tax /total assets | 16.57% | =1637.3/9878.8 |
Return on Equity | =Net profit/Equity | 16.36% | =(1019.2/6230.2) |
Earnings per Share | =Net profit/number of shares | 987.34 | =(1019.2*10^6)/1032271 |