Financial Analysis Calculations

HCS385_v7_wk4_financial_ratio_calculations1.xlsx

Home >Business & Finance homework help >Accounting homework help >Financial Analysis Calculations

Financial Ratio Calculations

Use Table 1: Hillside, Inc. Balance Sheet ($ in Millions) information in cells A3 through D19 and Table 2: Hillside, Inc. Income Statement ($ in Millions) information in cells A21 through B38 to complete Table 3: Financial Ratio Calculations in cells A40 through B57. This is the only tab in this file, and it is Part 2 of the Wk 4 Summative Assessment: Financial Analysis Calculations.
Table 1: Hillside, Inc. Balance Sheet ($ in Millions)
ASSETS	Assets Information	LIABILITIES	Liabilities Information
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	Shareholder's Equity Information
Property, Plant, and Equipment (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:	Operating Expenses Information
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 Ratio Calculations
Calculate 3 Liquidity Ratios	Liquidity Ratios Answers
Current Ratio (times)	Input the current ratio.
Quick Ratio (times)	Input the quick ratio.
Average Payment Period (days)	Input the average payment period.
Calculate 3 Asset-Management Ratios	Asset-Management Ratios Answers
Total Asset Turnover (times)	Input the total asset turnover.
Average Collection Period (days)	Input the average collection period.
Inventory Turnover (times)	Input the inventory turnover.
Calculate 2 Financial Leverage Ratios	Financial Leverage Ratios Answers
Total Debt to Total Assets	Input the debt to total assets.
Equity Multiplier (times)	Input the equity multiplier.
Calculate 5 Profitability Ratios	Profitability Ratios Answers
Operating Profit Margin	Input the operating profit margin.
Net Profit Margin	Input the net profit margin.
Return on Total Assets	Input the return on total assets.
Return on Equity	Input the return on equity.
Earnings per Share	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