Use the Hillside, Inc. Balance Sheet information in cells A2 through D18 and cells A21 through B38 to complete the Financial Performance Calculations in cells A40 through C60.
Table 1: Hillside, Inc. Balance Sheet ($ in Millions)
ASSETS		LIABILITIES
Cash & Marketable Securities	449.90	Accounts Payable	1,611.20
Accounts Receivable	954.80	Salaries Payable	225.20
Inventories	3,645.20	Other Current Liabilities	1,118.80
Other Current Assets	116.60	Total Current Liabilities	2,955.20
Total Current Assets	5,165.27
		Other Liabilities	693.40
Machinery & Equipment	1,688.90
Land	1,129.70	Total Liabilities	3,648.60
Buildings	2,348.40
Depreciation	(575.60)	SHAREHOLDER'S EQUITY
Property, Plant & Equip. - Net	4,591.40	Common Stock	828.50
Other Long Term Assets	120.90	Retained Earnings	5,401.70
Total Long-Term Assets	4,712.30	Total Shareholder's Equity	6,230.20
Total Assets	9,877.57	Total Liabilities & Equity	9,878.80
Table 2: Hillside, Inc. Income Statement ($ in Millions)
Revenue	28,681.10
Cost Of Goods Sold	20,768.80
Gross Profit	7,912.30
Operating Expenses:
Selling, General & Admin.	5,980.80
Depreciation	307.30
Operating income	1,624.20
Interest	-
Other Expense (Income)	(13.10)
Income Before Taxes	1,637.30
Income Taxes	618.10
Net Income	1,019.20
Number of Common Stock
Shares Outstanding	1,032,271

Liquidity Ratios	No data	Answers
Current Ratio (times)	No data	1.75
Quick Ratio (times)	No data	Input the quick ratio.
Average Payment Period (days)	No data	Input the average payment period.
Asset Management Ratios	No data
Total Asset Turnover (times)	No data	Input the total asset turnover.
Average Collection Period (days)	No data	Input the average collection period.
Inventory Turnover (times)	No data	Input the inventory turnover.
Financial Leverage Ratios	No data
Total Debt to Total Assets	No data	Input the debt to total assets.
Equity Multiplier (times)	No data	Input the equity multiplier.
Profitability Ratios	No data
Operating Profit Margin	No data	Input the operating profit margin.
Net Profit Margin	No data	Input the net profit margin.
Return on Total Assets	No data	Input the return on total assets.
Return on Equity	No data	Input the return on equity.
Earnings per Share	No data	Input the earnings per share.