ASSETS Cash & Marketable Securities Accounts Receivable Inventories Other Current Assets Total Current Assets Machinery & Equipment Land Buildings Depreciation Property, Plant, and Equipment (Net) Other Long-Term Assets Total Long-Term Assets Total Assets Table 2: Hillside, Inc. Income Statement ($ in Millions) Revenue Cost Of Goods Sold Gross Profit Assets Information LIABILITIES 449.90 Accounts Payable 954.80 Salaries Payable 3,645.20 Other Current Liabilities 116.60 Total Current Liabilities 5,165.27 Other Liabilities 1,688.90 1,129.70 Total Liabilities 2,348.40 (575.60) SHAREHOLDER'S EQUITY 4,591.40 Common Stock 120.90 Retained Earnings 4,712.30 Total Shareholder's Equity 9,877.57 Total Liabilities & Equity 28,681.10 20,768.80 7,912.30 Liabilities Information 1,611.20 225.20 1,118.80 2,955.20 693.40 3,648.60 Shareholder's Equity Information 828.50 5,401.70 6,230.20 9,878.80

Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
icon
Related questions
Question
100%
Use Table 1: Hillside, Inc. Balance Sheet
($ in Millions) information in cells A3
through D19 and Table 2: Hillside, Inc.
Income Statement ($ in Millions)
information in cells A21 through B38 to
complete Table 3: Financial Ratio
Calculations in cells A40 through B57.
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
Cash & Marketable Securities
Accounts Receivable
Inventories
Other Current Assets
Total Current Assets
Machinery & Equipment
Land
Buildings
Depreciation
Property, Plant, and Equipment (Net)
Other Long-Term Assets
Total Long-Term Assets
Total Assets
Table 2: Hillside, Inc. Income Statement ($
in Millions)
Revenue
Cost Of Goods Sold
Gross Profit
Operating Expenses:
Selling, General & Admin.
Depreciation
Operating income
Interest
Other Expense (Income)
Income Before Taxes
Income Taxes
Net Income
Number of Common Stock
Shares Outstanding
Table 3: Financial Ratio Calculations
Calculate 3 Liquidity Ratios
Current Ratio (times)
Quick Ratio (times)
Average Payment Period (days)
Calculate 3 Asset-Management Ratios
Total Asset Turnover (times)
Average Collection Period (days)
Inventory Turnover (times)
Calculate 2 Financial Leverage Ratios
Total Debt to Total Assets
Equity Multiplier (times)
Calculate 5 Profitability Ratios
Operating Profit Margin
Net Profit Margin
Return on Total Assets
Return on Equity
Earnings per Share
Assets
Information
ILITIES
449.90 Accounts Payable
954.80 Salaries Payable
3,645.20 Other Current Liabilities
116.60 Total Current Liabilities
5,165.27
1,688.90
1,129.70 Total Liabilities
2,348.40
(575.60) SHAREHOLDER'S EQUITY
4,591.40 Common Stock
120.90 Retained Earnings
4,712.30 Total Shareholder's Equity
9,877.57 Total Liabilities & Equity
28,681.10
20,768.80
7,912.30
Operating
Expenses
Information
5,980.80
307.30
1,624.20
0
(13.10)
1,637.30
618.10
1,019.20
1,032,271
Liquidity Ratios
Answers
1.00
0.61
365.00
Asset-
Management
Ratios Answers
Other Liabilities
0.10
342 days
56973.00
Financial
Leverage Ratios
Answers
36.93%
1.59
Profitability
Ratios Answers
5.66%
3.55%
573.00%
16.30%
1019.19
Liabilities
Informa
1,611.20
225.20
1.118.80
2,955.20
693.40
3,648.60
Shareholder's
Equity Information
828.50
5,401.70
6,230.20
9,878.80
Transcribed Image Text:Use Table 1: Hillside, Inc. Balance Sheet ($ in Millions) information in cells A3 through D19 and Table 2: Hillside, Inc. Income Statement ($ in Millions) information in cells A21 through B38 to complete Table 3: Financial Ratio Calculations in cells A40 through B57. 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 Cash & Marketable Securities Accounts Receivable Inventories Other Current Assets Total Current Assets Machinery & Equipment Land Buildings Depreciation Property, Plant, and Equipment (Net) Other Long-Term Assets Total Long-Term Assets Total Assets Table 2: Hillside, Inc. Income Statement ($ in Millions) Revenue Cost Of Goods Sold Gross Profit Operating Expenses: Selling, General & Admin. Depreciation Operating income Interest Other Expense (Income) Income Before Taxes Income Taxes Net Income Number of Common Stock Shares Outstanding Table 3: Financial Ratio Calculations Calculate 3 Liquidity Ratios Current Ratio (times) Quick Ratio (times) Average Payment Period (days) Calculate 3 Asset-Management Ratios Total Asset Turnover (times) Average Collection Period (days) Inventory Turnover (times) Calculate 2 Financial Leverage Ratios Total Debt to Total Assets Equity Multiplier (times) Calculate 5 Profitability Ratios Operating Profit Margin Net Profit Margin Return on Total Assets Return on Equity Earnings per Share Assets Information ILITIES 449.90 Accounts Payable 954.80 Salaries Payable 3,645.20 Other Current Liabilities 116.60 Total Current Liabilities 5,165.27 1,688.90 1,129.70 Total Liabilities 2,348.40 (575.60) SHAREHOLDER'S EQUITY 4,591.40 Common Stock 120.90 Retained Earnings 4,712.30 Total Shareholder's Equity 9,877.57 Total Liabilities & Equity 28,681.10 20,768.80 7,912.30 Operating Expenses Information 5,980.80 307.30 1,624.20 0 (13.10) 1,637.30 618.10 1,019.20 1,032,271 Liquidity Ratios Answers 1.00 0.61 365.00 Asset- Management Ratios Answers Other Liabilities 0.10 342 days 56973.00 Financial Leverage Ratios Answers 36.93% 1.59 Profitability Ratios Answers 5.66% 3.55% 573.00% 16.30% 1019.19 Liabilities Informa 1,611.20 225.20 1.118.80 2,955.20 693.40 3,648.60 Shareholder's Equity Information 828.50 5,401.70 6,230.20 9,878.80
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question

Needing assistance with the Profability Ratio Answers

1 Particulars
2 Current assets
3 Current liabilities
Inventories
4
5 Accounts payable
6
Cost of goods sold
No. of days in a year
Revenue
Total assets
7
8
9
10 Accounts receivables
11
Total liabilities
12
Total shareholders equity
13
14
15
16
17
18
19 Total asset turnover (times)
85
A
20 Average collection period (days)
21 Inventory turnover (times)
222
23
a. Liquidity ratios:
Current ratio (times)
Quick ratio (times)
Average payment period (days)
b. Asset management ratios:
c. Financial leverage ratios:
Total debt to total asset
24 Equity multiplier (times)
B
Values
5,165.27
2,955.20
3,645.20
1,611.20
20,768.80
365.00
28,681.10
9,877.57
954.80
3,648.60
6,230.20
1.75
0.51
28.32
2.90
12.15
5.70
0.37
1.59
Transcribed Image Text:1 Particulars 2 Current assets 3 Current liabilities Inventories 4 5 Accounts payable 6 Cost of goods sold No. of days in a year Revenue Total assets 7 8 9 10 Accounts receivables 11 Total liabilities 12 Total shareholders equity 13 14 15 16 17 18 19 Total asset turnover (times) 85 A 20 Average collection period (days) 21 Inventory turnover (times) 222 23 a. Liquidity ratios: Current ratio (times) Quick ratio (times) Average payment period (days) b. Asset management ratios: c. Financial leverage ratios: Total debt to total asset 24 Equity multiplier (times) B Values 5,165.27 2,955.20 3,645.20 1,611.20 20,768.80 365.00 28,681.10 9,877.57 954.80 3,648.60 6,230.20 1.75 0.51 28.32 2.90 12.15 5.70 0.37 1.59
1 Particulars
2 Current assets
3
4 Inventories
5
6
7
لنا
Current liabilities
Accounts payable
Cost of goods sold
No. of days in a year
Revenue
9
Total assets
10 Accounts receivables
11
12
13
14
15
16
17
18
19
20
21
22
23
24
8
A
Total liabilities
Total shareholders equity
a. Liquidity ratios:
Current ratio (times)
Quick ratio (times)
Average payment period (days)
b. Asset management ratios:
Total asset turnover (times)
Average collection period (days)
Inventory turnover (times)
c. Financial leverage ratios:
Total debt to total asset
Equity multiplier
Values
B
5,165.27
2,955.20
3,645.20
1,611.20
20,768.80
365.00
28,681.10
9,877.57
954.80
3,648.60
6,230.20
=B2/B3
=(B2-B4)/B3
=B5/(B6/B7)
=B8/B9
=B10/(B8/B7)
=B6/B4
=B11/B9
=B9/B12
Transcribed Image Text:1 Particulars 2 Current assets 3 4 Inventories 5 6 7 لنا Current liabilities Accounts payable Cost of goods sold No. of days in a year Revenue 9 Total assets 10 Accounts receivables 11 12 13 14 15 16 17 18 19 20 21 22 23 24 8 A Total liabilities Total shareholders equity a. Liquidity ratios: Current ratio (times) Quick ratio (times) Average payment period (days) b. Asset management ratios: Total asset turnover (times) Average collection period (days) Inventory turnover (times) c. Financial leverage ratios: Total debt to total asset Equity multiplier Values B 5,165.27 2,955.20 3,645.20 1,611.20 20,768.80 365.00 28,681.10 9,877.57 954.80 3,648.60 6,230.20 =B2/B3 =(B2-B4)/B3 =B5/(B6/B7) =B8/B9 =B10/(B8/B7) =B6/B4 =B11/B9 =B9/B12
Solution
Bartleby Expert
SEE SOLUTION
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Essentials Of Investments
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
FUNDAMENTALS OF CORPORATE FINANCE
FUNDAMENTALS OF CORPORATE FINANCE
Finance
ISBN:
9781260013962
Author:
BREALEY
Publisher:
RENT MCG
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Foundations Of Finance
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education