Which ratio did you choose? Explain what this ratio means.

What were the results of your calculation? Show your work to the class, including the formula you used and the data you input for your calculation. Use Table $1$: Hillside, Inc. Balance Sheet $($$ in Millions$)$ information in cells A$3$ through D$19$ and Table $2$: Hillside, Inc. Income Statement $($$ in Millions$)$ information in cells A$21$ through B$38$ to complete Table $3$: Financial Ratio Calculations in cells A$40$ through B$57.$ 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\mathrm{.}90$ Accounts Payable $1,611\mathrm{.}20$

Accounts Receivable $954\mathrm{.}80$ Salaries Payable $225\mathrm{.}20$

Inventories $3,645\mathrm{.}20$ Other Current Liabilities $1,118\mathrm{.}80$

Other Current Assets $116\mathrm{.}60$ Total Current Liabilities $2,955\mathrm{.}20$

Total Current Assets $5,165\mathrm{.}27$

Other Liabilities $693\mathrm{.}40$

Machinery & Equipment $1,688\mathrm{.}90$

Land $1,129\mathrm{.}70$ Total Liabilities $3,648\mathrm{.}60$

Buildings $2,348\mathrm{.}40$

Depreciation $(575\mathrm{.}60)$ SHAREHOLDER'S EQUITY Shareholder's Equity Information

Property, Plant, and Equipment $($Net$)4,591\mathrm{.}40$ Common Stock $828\mathrm{.}50$

Other Long$-$Term Assets $120\mathrm{.}90$ Retained Earnings $5,401\mathrm{.}70$

Total Long$-$Term Assets $4,712\mathrm{.}30$ Total Shareholder's Equity $6,230\mathrm{.}20$

Total Assets $9,877\mathrm{.}57$ Total Liabilities & Equity $9,878\mathrm{.}80$

Table $2$: Hillside, Inc. Income Statement $($$ in Millions$)$

Revenue $28,681\mathrm{.}10$

Cost Of Goods Sold $20,768\mathrm{.}80$

Gross Profit $7,912\mathrm{.}30$

Operating Expenses: Operating Expenses Information

Selling, General & Admin. $5,980\mathrm{.}80$

Depreciation $307\mathrm{.}30$

Operating income $1,624\mathrm{.}20$

Interest $0$

Other Expense $($Income$)(13\mathrm{.}10)$

Income Before Taxes $1,637\mathrm{.}30$

Income Taxes $618\mathrm{.}10$

Net Income $1,019\mathrm{.}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.