Question: How can I come up with a financial performance summary? I have attached an excel document which may better explain what I am asking. Hillside,

How can I come up with a financial performance summary? I have attached an excel document which may better explain what I am asking.

Hillside, Inc.

BALANCE SHEET

INCOME STATEMENT ($ in millions)

($ in millions)

ASSETS

LIABILITIES

Revenue 28,681.10 Cash & Marketable Securities 449.90

Accounts Payable 1,611.20

Cost Of Goods Sold 20,768.80 Accounts Receivable 954.80

Salaries Payable 225.20

Gross Profit 7,912.30 Inventories 3,645.20

Other Current Liabilities 1,118.80

Other Current Assets 116.60

Total Current Liabilities 2,955.20

Operating Expenses: Total Current Assets 5,166.50

Selling, General & Admin. 5,980.80

Other Liabilities 693.40

Depreciation 307.30 Machinery & Equipment 1,688.90

Operating income 1,624.20 Land 1,129.70

Total Liabilities 3,648.60

Buildings 2,348.40

Interest - Depreciation (575.60)

SHAREHOLDER'S EQUITY

Other Expense (Income) (13.10) Property, Plant & Equip. - Net 4,591.40

Common Stock 828.50

Income Before Taxes 1,637.30 Other Long Term Assets 120.90

Retained Earnings 5,401.70

Income Taxes 618.10 Total Long-Term Assets 4,712.30

Total Shareholder's Equity 6,230.20

Net Income 1,019.20

Total Assets 9,878.80

Total Liabilities & Equity 9,878.80

Number of Common Stock

Shares Outstanding 1,032,271

Input Answers Below

Financial Performance Summary LIQUIDITY RATIOS

Current Ratio (times)

1.75 times

Quick Ratio (times)

0.5 times

Average Payment Period (days)

365.00

ASSET MANAGEMENT RATIOS

Total Asset Turnover (times)

2.9 times

Average Collection Period (days)

216.30

Inventory Turnover (times)

7.87 times

FINANCIAL LEVERAGE RATIOS

Total Debt to Total Assets

38m 24s

Equity Multiplier (times)

1.6 times

PROFITABILITY RATIOS

Operating Profit Margin

6.00%

Net Profit Margin

3.60%

Return on Total Assets

16.44%

Return on Equity

16.36%

Earnings per Share

0.01

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!