16 Mar The key to understanding an organizations financi
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.
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
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. |
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Wridemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.