08 Oct The key to understanding an organizations financial health is analyzing its financial performance using financial ratios. This week youll demonstrate your financial analysis skills by evalu
The key to understanding an organization’s financial health is analyzing its financial performance using financial ratios. This week you’ll demonstrate your financial analysis skills by evaluating Hillside, Inc. using its balance sheet and income statement to calculate financial ratios.
Assignment Directions
Access and complete the Financial Performance Calculations Worksheet by:
- Calculating each required ratio
- Writing a brief summary of your financial analysis in the provided space next to the calculations
Submit your assignment.
Resources
- “6 Basic Financial Ratios and What They Reveal” by Glenn Wilkins from Investopedia
- “Four Basic Types of Financial Ratios Used to Measure a Company’s Performance” by Chirantan Basu from Chron
- Financial Functions (reference) page from Microsoft
Index
| Workbook Index |
| Financial Calculations |
| Financial Performance Summary |
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. |
