Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Management Theory and Practice

Authors: Eugene F. Brigham, Michael C. Ehrhardt

16th edition

1337902608, 978-1337902601

More Books

Students also viewed these Finance questions