Is the organization profitable? Why or why not? Use the Hillside, Inc. Balance Sheet information in cells A2 through D18 and cells A21 through B38 to complete the Financial Performance Calculations in...


Is the organization profitable? Why or why not?




























































































































































































































































































































































































































































































































































Use the Hillside, Inc. Balance Sheet information in cells A2 through D18 and cells A21 through B38 to complete the Financial Performance Calculations in cells A40 through C60.
Table 1: Hillside, Inc. Balance Sheet ($ in Millions)
ASSETSLIABILITIES
Cash & Marketable Securities                449.90Accounts Payable 1,611.20
Accounts Receivable                954.80Salaries Payable    225.20
Inventories             3,645.20Other Current Liabilities 1,118.80
Other Current Assets                116.60Total 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
Property, Plant & Equip. - Net             4,591.40Common Stock    828.50
Other Long Term Assets                120.90Retained Earnings 5,401.70
  Total Long-Term Assets             4,712.30  Total Shareholder's Equity 6,230.20
Total Assets             9,877.57Total 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:
Selling, General & Admin.             5,980.80
Depreciation                307.30
  Operating income             1,624.20
Interest                        -
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 Performance Calculations
Liquidity RatiosNo dataAnswers
Current Ratio (times)No data1.75
Quick Ratio (times)No data0.48
Average Payment Period (days)No data190.12
Asset Management RatiosNo data
Total Asset Turnover (times)No data2.90
Average Collection Period (days)No data12.15
Inventory Turnover (times)No data5.70
Financial Leverage RatiosNo data
Total Debt to Total AssetsNo data70.64%
Equity Multiplier (times)No data1.59
Profitability RatiosNo data
Operating Profit MarginNo data                                               0.06
Net Profit MarginNo data3.55%
Return on Total AssetsNo data10.32%
Return on EquityNo data16.36%
Earnings per ShareNo data0.99
Jun 08, 2022
SOLUTION.PDF
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
Have files?