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. |
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 WriteEdu. 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.
Do you need help with this question?
Get assignment help from WriteEdu.com Paper Writing Website and forget about your problems.
WriteEdu provides custom & cheap essay writing 100% original, plagiarism free essays, assignments & dissertations.
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.
Chat with us today! We are always waiting to answer all your questions.