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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started