Financial Calculations
Financial Calculations
| 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 | 28,681.10 | ||
| Cost Of Goods Sold | 20,768.80 | ||
| Gross Profit | 7,912.30 | ||
| Operating Expenses: | |||
| 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 Performance Calculations | |||
| Liquidity Ratios | No data | Answers | |
| Current Ratio (times) | No data | Input the current ratio. | |
| Quick Ratio (times) | No data | Input the quick ratio. | |
| Average Payment Period (days) | No data | Input the average payment period. | |
| Asset Management Ratios | No data | ||
| Total Asset Turnover (times) | No data | Input the total asset turnover. | |
| Average Collection Period (days) | No data | Input the average collection period. | |
| Inventory Turnover (times) | No data | Input the inventory turnover. | |
| Financial Leverage Ratios | No data | ||
| Total Debt to Total Assets | No data | Input the debt to total assets. | |
| Equity Multiplier (times) | No data | Input the equity multiplier. | |
| Profitability Ratios | No data | ||
| Operating Profit Margin | No data | Input the operating profit margin. | |
| Net Profit Margin | No data | Input the net profit margin. | |
| Return on Total Assets | No data | Input the return on total assets. | |
| Return on Equity | No data | Input the return on equity. | |
| Earnings per Share | No data | Input the earnings per share. |
&”Arial,Regular”&10 Wk 4 Financial Performance Worksheet HCS/385 v4 Page &P of &N
&”Arial,Regular”&10HCS/385 v4
&”Arial,Regular”&8Copyright© 2020 by University of Phoenix. All rights reserved.
&”Arial,Regular”&8Copyright© 2020 by University of Phoenix. All rights reserved.
Financial Performance Summary
| Financial Performance Summary: Provide a brief summary of your financial analysis from the Financial Calculations. |
| Insert your summary. |
