close solutoin list

DUPONT ANALYSIS A firm has been experiencing low profitability in recent years. Perform an analysis of the firm’s financial position using the DuPont equation. The firm has no lease payments but has a $2 million sinking fund payment on its debt. The most recent industry average ratios and the firm’s financial statements are as follows: Industry Average Ratios Current ratio 3× Fixed assets turnover 6× Debt-to-capital ratio 20% Total assets turnover 3× Times interest earned 7× Profit margin 3% EBITDA coverage 9× Return on total assets 9% Inventory turnover 10× Return on common equity 12.86% Days sales outstandinga 24 days Return on invested capital 11.50% a Calculation is based on a 365-day year. Balance Sheet as of December 31, 2015 (Millions of Dollars) Cash and equivalents $78 Accounts payable $45 Accounts receivable 6600% Other current liabilities 11 Inventories 159 Notes payable 2900% Total current assets $303 Total current liabilities $85 Long-term debt 5000.00% Total liabilities $135 Gross fixed assets 225 Common stock 114 Less depreciation 78 Retained earnings 201 Net fixed assets 147 Total stockholders’ equity $315 Total assets 450 Total liabilities and equity $450 Income Statement for Year Ended December 31, 2015 (Millions of Dollars) Net sales $795.0 Cost of goods sold 660.0 Gross profit $135.0 Selling expenses 73.5 EBITDA $ 61.5 Depreciation expense 12.0 Earnings before interest and taxes (EBIT) $ 49.5 Interest expense 4.5 Earnings before taxes (EBT) $ 45.0 Taxes (40%) 18.0 Net income $ 27.0 a. Calculate the ratios you think would be useful in this analysis. b. Construct a DuPont equation, and compare the company’s ratios to the industry average ratios. c. Do the balance sheet accounts or the income statement figures seem to be primarily responsible for the low profits? d. Which specific accounts seem to be most out of line relative to other firms in the industry? e. If the firm had a pronounced seasonal sales pattern or if it grew rapidly during the year, how might that affect the validity of your ratio analysis? How might you correct for such potential problems?

BuyFind

Fundamentals of Financial Manageme...

14th Edition
Eugene F. Brigham + 1 other
Publisher: Cengage Learning
ISBN: 9781285867977
BuyFind

Fundamentals of Financial Manageme...

14th Edition
Eugene F. Brigham + 1 other
Publisher: Cengage Learning
ISBN: 9781285867977

Solutions

Chapter
Section
Chapter 4, Problem 24P
Textbook Problem

DUPONT ANALYSIS A firm has been experiencing low profitability in recent years. Perform an analysis of the firm’s financial position using the DuPont equation. The firm has no lease payments but has a $2 million sinking fund payment on its debt. The most recent industry average ratios and the firm’s financial statements are as follows:

Industry Average Ratios

Current ratio Fixed assets turnover
Debt-to-capital ratio 20% Total assets turnover
Times interest earned Profit margin 3%
EBITDA coverage Return on total assets 9%
Inventory turnover 10× Return on common equity 12.86%
Days sales outstandinga 24 days Return on invested capital 11.50%

aCalculation is based on a 365-day year.

Balance Sheet as of December 31, 2015 (Millions of Dollars)

Cash and equivalents $78 Accounts payable $45
Accounts receivable 6600% Other current liabilities 11
Inventories 159 Notes payable 2900%
Total current assets $303 Total current liabilities $85
Long-term debt 5000.00%
Total liabilities $135
Gross fixed assets 225 Common stock 114
Less depreciation 78 Retained earnings 201
Net fixed assets 147 Total stockholders’ equity $315
Total assets 450 Total liabilities and equity $450

Income Statement for Year Ended December 31, 2015 (Millions of Dollars)

Net sales $795.0
Cost of goods sold 660.0
Gross profit $135.0
Selling expenses 73.5
EBITDA $ 61.5
Depreciation expense 12.0
Earnings before interest and taxes (EBIT) $ 49.5
Interest expense 4.5
Earnings before taxes (EBT) $ 45.0
Taxes (40%) 18.0
Net income $ 27.0

a. Calculate the ratios you think would be useful in this analysis.

b. Construct a DuPont equation, and compare the company’s ratios to the industry average ratios.

c. Do the balance sheet accounts or the income statement figures seem to be primarily responsible for the low profits?

d. Which specific accounts seem to be most out of line relative to other firms in the industry?

e. If the firm had a pronounced seasonal sales pattern or if it grew rapidly during the year, how might that affect the validity of your ratio analysis? How might you correct for such potential problems?

Expert Solution

Want to see this answer and more?

Experts are waiting 24/7 to provide step-by-step solutions in as fast as 30 minutes!*

See Solution

*Response times vary by subject and question complexity. Median response time is 34 minutes and may be longer for new subjects.

Chapter 4 Solutions

Fundamentals of Financial Management (MindTap Course List)
Show all chapter solutions
Ch. 4 - Differentiate between ROE and ROIC.Ch. 4 - Indicate the effects of the transactions listed in...Ch. 4 - DAYS SALES OUTSTANDING Baker Brothers has a DSO of...Ch. 4 - DEBT TO CAPITAL RATIO Bartley Barstools has a...Ch. 4 - DuPONT ANALYSIS Doublewide Dealers has an ROA of...Ch. 4 - MARKET/BOOK RATIO Jaster Jets has 10 billion in...Ch. 4 - PRICE/EARNINGS RATIO A company has an EPS of 2.00,...Ch. 4 - DuPONT AND ROE A firm has a profit margin of 2%...Ch. 4 - ROE AND ROIC Hilyard Industries net income is...Ch. 4 - DuPONT AND NET INCOME Ebersoll Mining has 6...Ch. 4 - BEP, ROE, AND ROIC Duval Manufacturing recently...Ch. 4 - M/B AND SHARE PRICE You are given the following...Ch. 4 - RATIO CALCULATIONS Assume the following...Ch. 4 - RATIO CALCULATIONS Graser Trucking has 12 billion...Ch. 4 - TIE AND ROIC RATIOS The H.R. Pickett Corp. has...Ch. 4 - RETURN ON EQUITY Midwest Packagings ROH last year...Ch. 4 - RETURN ON EQUITY AND QUICK RATIO Lloyd Inc. has...Ch. 4 - RETURN ON EQUITY Central City Construction (CCC)...Ch. 4 - CONCEPTUAL: RETURN ON EQUITY Which of the...Ch. 4 - TIE RATIO AEI Incorporated has 5 billion in...Ch. 4 - CURRENT RATIO The Petry Company has 1312,500 in...Ch. 4 - DSO AND ACCOUNTS RECEIVABLE Harrelson Inc....Ch. 4 - P/E AND STOCK PRICE Fontaine Inc. recently...Ch. 4 - BALANCE SHEET ANALYSIS Complete the balance sheet...Ch. 4 - RATIO ANALYSIS Data for Barry Computer Co. and its...Ch. 4 - DUPONT ANALYSIS A firm has been experiencing low...Ch. 4 - RATIO ANALYSIS The Corrigan Corporations 2014 and...Ch. 4 - FINANCIAL STATEMENTS AND TAXES Part I of this...Ch. 4 - Conducting a Financial Ratio Analysis on HP INC....Ch. 4 - Conducting a Financial Ratio Analysis on HP INC....Ch. 4 - Conducting a Financial Ratio Analysis on HP INC....Ch. 4 - Conducting a Financial Ratio Analysis on HP INC....Ch. 4 - Conducting a Financial Ratio Analysis on HP INC....Ch. 4 - Conducting a Financial Ratio Analysis on HP INC....Ch. 4 - Conducting a Financial Ratio Analysis on HP INC....Ch. 4 - Conducting a Financial Ratio Analysis on HP INC....

Additional Business Textbook Solutions

Find more solutions based on key concepts
Show solutions
CAPITAL BUDGETING CRITERIA A firm with a 14% VVACC is evaluating two projects for this years capital budget. Af...

Fundamentals of Financial Management, Concise Edition (with Thomson ONE - Business School Edition, 1 term (6 months) Printed Access Card) (MindTap Course List)

Which of the following is classified as an accrued payroll liability?

Intermediate Accounting: Reporting And Analysis

Use a production possibilities frontier to describe the idea of efficiency.

Brief Principles of Macroeconomics (MindTap Course List)

What is the purpose of adjusting entries?

College Accounting (Book Only): A Career Approach

What are the five components of internal control?

College Accounting, Chapters 1-27 (New in Accounting from Heintz and Parry)

Explain why a detailed task description is needed for ABM but not for ABC

Cornerstones of Cost Management (Cornerstones Series)