Use Table 1: Hillside, Inc. Balance Sheet ($ in Millions) information in cells A3 through D19 and Table 2: Hillside, Inc. Income Statement ($ in Millions) information in cells A21 through B38 to complete Table 3: Financial Ratio Calculations in cells A40 through B57. This is the only tab in this file, and it is Part 2 of the Wk 4 Summative Assessment: Financial Analysis Calculations.
Table 1: Hillside, Inc. Balance Sheet ($ in Millions)
ASSETS	Assets Information	LIABILITIES	Liabilities Information
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	Shareholder's Equity Information
Property, Plant, and Equipment (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:	Operating Expenses Information
Selling, General & Admin.	5,980.80
Depreciation	307.30
Operating income	1,624.20
Interest	0
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
Table 3: Financial Ratio Calculations
Calculate 3 Liquidity Ratios	Liquidity Ratios Answers
Current Ratio (times)	1.75
Quick Ratio (times)	0.51
Average Payment Period (days)	-28.32
Calculate 3 Asset-Management Ratios	Asset-Management Ratios Answers
Total Asset Turnover (times)	-2.90
Average Collection Period (days)	12.15
Inventory Turnover (times)	5.70
Calculate 2 Financial Leverage Ratios	Financial Leverage Ratios Answers
Total Debt to Total Assets	36.94%
Equity Multiplier (times)	1.59
Calculate 5 Profitability Ratios	Profitability Ratios Answers
Operating Profit Margin	5.66%
Net Profit Margin	3.55%
Return on Total Assets	16.58%
Return on Equity	16.36%
Earnings per Share	-987.34

• Make final recommendations as to whether the hospital should move forward with the purchase of Hillside, Inc. to improve the availability of medical supplies to your hospital. 
• Address the financial outlook of Hillside, Inc. (i.e., Is it positive or negative?). Use the financial ratios to support your answer.

Answer rating: 100% (QA)

Financial Analysis Summary of Hillside Inc Recommendation Based on the financial analysis the hospit... View the full answer