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 Table 1: Hillside, Inc. Balance Sheet ($ in Millions) ASSETS Cash & Marketable Securities Accounts Receivable Inventories Other Current Assets Total Current Assets Machinery & Equipment Land Buildings Depreciation Property, Plant & Equip. - Net Other Long Term Assets Total Long-Term Assets Total Assets Table 2: Hillside, Inc. Income Statement ($ in Millions) Revenue Cost Of Goods Sold Gross Profit Operating Expenses: Selling, General & Admin. Depreciation Operating income Interest Other Expense (Income) Income Before Taxes Income Taxes Net Income Number of Common Stock Shares Outstanding Table 3: Financial Performance Calculations 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 No data No data No data No data No data No data No data No data No data No data No data No data No data No data No data No data No data LIABILITIES 449.9 Accounts Payable 954.8 Salaries Payable 3,645.2 Other Current Liabilities 116.6 Total Current Liabilities 5,165.267 1,688.9 1,129.7 Total Liabilities 2,348.4 -575.6 SHAREHOLDER'S EQUITY 4,591.4 Common Stock 120.9 Retained Earnings 4,712.3 Total Shareholder's Equity 9,877.567 Total Liabilities & Equity 28,681.1 20,768.8 7,912.3 5,980.8 307.3 1,624.2 0 -13.1 1,637.3 618.1 1,019.2 Other Liabilities 1,032,271 Answers Input the current ratio. Input the quick ratio. Input the average payment period. III Input the total asset turnover. Input the average collection period. Input the inventory turnover. Input the debt to total assets. Input the equity multiplier. 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. 1,611.2 225.2 1,118.8 2,955.2 693.4 3,648.6 828.5 5,401.7 6,230.2 9,878.8
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 Table 1: Hillside, Inc. Balance Sheet ($ in Millions) ASSETS Cash & Marketable Securities Accounts Receivable Inventories Other Current Assets Total Current Assets Machinery & Equipment Land Buildings Depreciation Property, Plant & Equip. - Net Other Long Term Assets Total Long-Term Assets Total Assets Table 2: Hillside, Inc. Income Statement ($ in Millions) Revenue Cost Of Goods Sold Gross Profit Operating Expenses: Selling, General & Admin. Depreciation Operating income Interest Other Expense (Income) Income Before Taxes Income Taxes Net Income Number of Common Stock Shares Outstanding Table 3: Financial Performance Calculations 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 No data No data No data No data No data No data No data No data No data No data No data No data No data No data No data No data No data LIABILITIES 449.9 Accounts Payable 954.8 Salaries Payable 3,645.2 Other Current Liabilities 116.6 Total Current Liabilities 5,165.267 1,688.9 1,129.7 Total Liabilities 2,348.4 -575.6 SHAREHOLDER'S EQUITY 4,591.4 Common Stock 120.9 Retained Earnings 4,712.3 Total Shareholder's Equity 9,877.567 Total Liabilities & Equity 28,681.1 20,768.8 7,912.3 5,980.8 307.3 1,624.2 0 -13.1 1,637.3 618.1 1,019.2 Other Liabilities 1,032,271 Answers Input the current ratio. Input the quick ratio. Input the average payment period. III Input the total asset turnover. Input the average collection period. Input the inventory turnover. Input the debt to total assets. Input the equity multiplier. 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. 1,611.2 225.2 1,118.8 2,955.2 693.4 3,648.6 828.5 5,401.7 6,230.2 9,878.8
Century 21 Accounting General Journal
11th Edition
ISBN:9781337680059
Author:Gilbertson
Publisher:Gilbertson
Chapter17: Financial Statement Analysis
Section17.4: Analyzing Financial Statements Using Financial Ratios
Problem 1WT
Related questions
Question
100%
I am having trouble understanding how to answer these questions. I am not good with formulas. May I please have an expert help break this down with examples so I understand it.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 7 images
Recommended textbooks for you
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:
9781337788281
Author:
James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:
Cengage Learning
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:
9781337788281
Author:
James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:
Cengage Learning