In the space provided, 150- to 350-word summary of your financial analysis from Part 2: Financial Ratio
Fantastic news! We've Found the answer you've been seeking!
Question:
In the space provided, 150- to 350-word summary of your financial analysis from Part 2: Financial Ratio Calculations. Include the following in your summary:
- 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.
- Cite and reference for any sources used and format them according to APA guidelines.
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 times | |||
Quick Ratio (times) | 0.51 times | |||
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 times | |||
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 | |||
Related Book For
Accounting Principles Part 2
ISBN: 978-1118306796
6th Canadian edition Volume 1
Authors: Jerry J. Weygandt, Donald E. Kieso, Paul D. Kimmel, Barbara Trenholm, Valerie Kinnear, Joan E. Barlow
Posted Date: