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. |
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
