Show your work (use of formula, etc.) in solving the problems. Provide your answers/solutions in the answer space provided below. Answer all questions. 1. Data for Cary Company and its industry average follow. Balance Sheet as of Dec. 31 (Millions of Dollars) Assets Liabilities and Owner's Equity 2020 2020 Current Liabilities 75,500 Accts payable Current Assets Cash 127,000 A/R 330,000 Notes payable 84,000 Inventories 255,500 Other current liabilities 115,000 Total CA 661,000 Total CL 326,000 Long-term debt 282,500 Total Liabilities Common Equity 943,500 |Total Liabilities and Equity Net fixed assets 260,500 586,500 Net plant and equipment 357,000 Total Assets 943,500 Income statement for the year ending December 31 2020 Sales 1,800,500 COGS (1,458,000) Gross profit Fixed operating expenses except depreciation 342,500 (210,000) Earnings before interest, taxes, depre and amort (EBITDA) 132,500 Depreciation (40,000) EBIT (Opering income) 92,500 Interest expense (44,000) EBT (Taxable income) 48,500 Taxes (40%) (19,400) Net income 29,100

Financial Accounting Intro Concepts Meth/Uses
14th Edition
ISBN:9781285595047
Author:Weil
Publisher:Weil
Chapter3: The Basics Of Record Keeping And Financial Statement Preparation: Income Statement
Section: Chapter Questions
Problem 20P
icon
Related questions
Question

Please Solve 

Show your work (use of formula, etc.) in solving the problems.
Provide your answers/solutions in the answer space provided below.
Answer all questions.
1. Data for Cary Company and its industry average follow.
Balance Sheet as of Dec. 31 (Millions of Dollars)
Assets
Liabilities and Owner's Equity
2020
2020
Current Assets
Current Liabilities
Accts payable
Notes payable
Cash
75,500
127,000
A/R
330,000
84,000
Inventories
255,500
Other current liabilities
115,000
Total CA
661,000 Total CL
326,000
Long-term debt
282,500 Total Liabilities
Common Equity
943,500 Total Liabilities and Equity
Net fixed assets
260,500
Net plant and equipment
586,500
357,000
Total Assets
943,500
Income statement for the year ending December 31
2020
Sales
1,800,500
COGS
(1,458,000)
Gross profit
342,500
(210,000)
Fixed operating expenses except depreciation
Earnings before interest, taxes, depre and amort (EBITDA)
Depreciation
EBIT (Opering income)
132,500
(40,000)
92,500
Interest expense
(44,000)
EBT (Taxable income)
48,500
Taxes (40%)
(19,400)
Net income
29,100
Transcribed Image Text:Show your work (use of formula, etc.) in solving the problems. Provide your answers/solutions in the answer space provided below. Answer all questions. 1. Data for Cary Company and its industry average follow. Balance Sheet as of Dec. 31 (Millions of Dollars) Assets Liabilities and Owner's Equity 2020 2020 Current Assets Current Liabilities Accts payable Notes payable Cash 75,500 127,000 A/R 330,000 84,000 Inventories 255,500 Other current liabilities 115,000 Total CA 661,000 Total CL 326,000 Long-term debt 282,500 Total Liabilities Common Equity 943,500 Total Liabilities and Equity Net fixed assets 260,500 Net plant and equipment 586,500 357,000 Total Assets 943,500 Income statement for the year ending December 31 2020 Sales 1,800,500 COGS (1,458,000) Gross profit 342,500 (210,000) Fixed operating expenses except depreciation Earnings before interest, taxes, depre and amort (EBITDA) Depreciation EBIT (Opering income) 132,500 (40,000) 92,500 Interest expense (44,000) EBT (Taxable income) 48,500 Taxes (40%) (19,400) Net income 29,100
a. Calculate the indicated ratios for Cary.
Industry
Ratio
Cary
Average
Current ratio
2.0 X
Days sales outstanding
35 days
Inventory turnover
5.6 X
Total assets turnover
3.0 X
Net profit margin
1.2%
Return on assets (ROA)
3.60%
Return on equity (ROE)
9.00%
Debt ratio
60%
b. Construct the DuPont ROA equations for both Cary and the industry.
DuPont ROA (Cary) =
DuPont ROA (Industry) =
c. Outline Cary's strengths and weaknesses as revealed by your analysis.
Transcribed Image Text:a. Calculate the indicated ratios for Cary. Industry Ratio Cary Average Current ratio 2.0 X Days sales outstanding 35 days Inventory turnover 5.6 X Total assets turnover 3.0 X Net profit margin 1.2% Return on assets (ROA) 3.60% Return on equity (ROE) 9.00% Debt ratio 60% b. Construct the DuPont ROA equations for both Cary and the industry. DuPont ROA (Cary) = DuPont ROA (Industry) = c. Outline Cary's strengths and weaknesses as revealed by your analysis.
Expert Solution
steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Market Efficiency
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Financial Accounting Intro Concepts Meth/Uses
Financial Accounting Intro Concepts Meth/Uses
Finance
ISBN:
9781285595047
Author:
Weil
Publisher:
Cengage
Financial Accounting
Financial Accounting
Accounting
ISBN:
9781305088436
Author:
Carl Warren, Jim Reeve, Jonathan Duchac
Publisher:
Cengage Learning
Financial And Managerial Accounting
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,
Financial Accounting: The Impact on Decision Make…
Financial Accounting: The Impact on Decision Make…
Accounting
ISBN:
9781305654174
Author:
Gary A. Porter, Curtis L. Norton
Publisher:
Cengage Learning
Century 21 Accounting General Journal
Century 21 Accounting General Journal
Accounting
ISBN:
9781337680059
Author:
Gilbertson
Publisher:
Cengage
Principles of Accounting Volume 1
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College