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

Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
icon
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.

hcs385_v6_wk4_fina...
Index
9:36
Financial Calculations Financial Performance Summary
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 th
Table 1: Hillside, Inc. Balance
Sheet ($ in Millions)
ASSETS
Cash & Marketable Securities
Accounts Receivable
Inventories
Other Current Assets
Total Current Assets
Total Assets
Machinery & Equipment
Land
Buildings
Depreciation
Property, Plant & Equip. - Net
Other Long Term Assets
Total Long-Term 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
Other Liabilities
0
-13.1
1,637.3
618.1
1,019.2
1,032,271
Answers
DOID
Input the current ratio.
Input the quick ratio.
Input the average payment period.
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
Done
9,878.8
Transcribed Image Text:hcs385_v6_wk4_fina... Index 9:36 Financial Calculations Financial Performance Summary 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 th Table 1: Hillside, Inc. Balance Sheet ($ in Millions) ASSETS Cash & Marketable Securities Accounts Receivable Inventories Other Current Assets Total Current Assets Total Assets Machinery & Equipment Land Buildings Depreciation Property, Plant & Equip. - Net Other Long Term Assets Total Long-Term 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 Other Liabilities 0 -13.1 1,637.3 618.1 1,019.2 1,032,271 Answers DOID Input the current ratio. Input the quick ratio. Input the average payment period. 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 Done 9,878.8
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 7 images

Blurred answer
Recommended textbooks for you
Essentials Of Investments
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
FUNDAMENTALS OF CORPORATE FINANCE
FUNDAMENTALS OF CORPORATE FINANCE
Finance
ISBN:
9781260013962
Author:
BREALEY
Publisher:
RENT MCG
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Foundations Of Finance
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education