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 Cost Of Goods Sold Gross Profit 28,681.10 20.768.80 7,912.30 Operating Expenses: Selling, General & Admin Depreciation Operating income 5,980.80 307.30 1,624.20 Interest Other Expense (Income) Income Before Taxes Income Taxes Net Income (13.10) 1,637.30 618.10 1,019.20 Number of Common Stock Shares Outstanding 1,032,271 Table 3: Financial Performance Calculations Liquidity Ratios Current Ratio (times) Quick Ratio (times) No data No data No data Answers Input the current ratio. Input the quick ratio. Average Payment Period (days) No data Input the average payment period. Asset Management Ratios Total Asset Turnover (times) No data No data Input the total asset turnover. Average Collection Period (days) Inventory Turnover (times) No data No data Input the average collection period. Input the inventory turnover. Financial Leverage Ratios Total Debt to Total Assets Equity Multiplier (times) No data No data No data Input the debt to total assets. Input the equity multiplier. Profitability Ratios Operating Profit Margin Net Profit Margin Return on Total Assets Return on Equity Earnings per Share No data No data No data No data No data No data Input the operating profit margin. Input the net profit margin. Input the return on total assets. Input the return on equity. Input the earnings per share