Try the fastest way to create flashcards

Related questions with answers

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\$ 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\hspace{30mm}\textbf{Industry Average Ratios}

 Current ratio 3× Fixed assets tumover 6× Debt-to-capital ratio 20% Total assets tumover 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 outstanding a24 days  Return on invested capital 11.50%a Calculation is based on a 365-day year. \small{ \begin{aligned} &\begin{array}{lcll} \text { Current ratio } & 3 \times & \text { Fixed assets tumover } & 6 \times \\ \text { Debt-to-capital ratio } & 20 \% & \text { Total assets tumover } & 3 \times \\ \text { Times interest earned } & 7 \times & \text { Profit margin } & 3 \% \\ \text { EBITDA coverage } & 9 \times & \text { Return on total assets } & 9 \% \\ \text { Inventory turnover } & 10 \times & \text { Return on common equity } & 12.86 \% \\ \text { Days sales outstanding }{ }^a & 24 \text { days } & \text { Return on invested capital } & 11.50 \% \end{array}\\ &{ }^a \text { Calculation is based on a 365-day year. } \end{aligned}}

Balance Sheet as of December 31, 2015 (Millions of Dollars)\textbf{Balance Sheet as of December 31, 2015 (Millions of Dollars)}

Cash and equivalents$78Accounts payable$45Accounts receivable66Other current liabiities11Inventories159Notes payable29Total current assets$303Total current liabilties$85Long-term debt50Total libilities$135Gross fixed assets225Common stock114Less depreciation78Retained earnings201Net fixed assets$147Total stockholders’ equity$315Total assets$450Total liabilties and equity$450\small{ \begin{array}{lrlr} \text{Cash and equivalents}& \$ 78 &\text{Accounts payable} &\$ 45\\ \text{Accounts receivable}& 66 &\text{Other current liabiities} &11\\ \text{Inventories}& 159& \text{Notes payable}& 29\\ \text{Total current assets} &\$303 &\text{Total current liabilties} &\$ 85\\ &&\text{Long-term debt}& 50\\ &&\text{Total libilities} &\$135\\ \text{Gross fixed assets} &225& \text{Common stock} &114\\ \text{Less depreciation} &78& \text{Retained earnings}& 201\\ \text{Net fixed assets} &\$147& \text{Total stockholders’ equity}& \$315\\ \text{Total assets} &\$450 &\text{Total liabilties and equity}& \$450 \\ \end{array}}

Income Statement for Year Ended December 31, 2015 (Millions of Dollars)\textbf{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\small{ \begin{array}{lr} \text { Net sales } & \$ 795.0 \\ \text { Cost of goods sold } & 660.0 \\ \quad \text { Gross profit } & \$135.0 \\ \text { Selling expenses } & 73.5 \\ \text { EBITDA } & \$ 61.5 \\ \text { Depreciation expense } & 12.0 \\ \quad \text { Earnings before interest and taxes (EBIT) } & \$ 49.5 \\ \text { Interest expense } & 4.5 \\ \text { Earnings before taxes (EBT) } & \$ 45.0 \\ \text { Taxes (40\%) } &18.0 \\ \text { Net income } &\$27.0 \end{array}}

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?

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 dollars sinking fund payment on its debt. The most recent industry average ratios and the firm’s financial statements are as follows:

Current ratio 3×3 \times Fixed assets turnover 6×6 \times
Debt-to-capital ratio 20 percent Total assets turnover 3×3 \times
Times interest earned 7×7 \times Profit margin 3 percent
EBITDA coverage 9×9 \times Return on total assets 9 percent
Inventory turnover 10×10 \times Return on common equity 12.86 percent
Days sales outstanding a^a 24 days Return on invested capital 11.50 percent
a^a Calculation is based on a 365-day year.

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

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

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

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

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?

Data for Barry Computer Co. and its industry averages follow. a. Calculate the indicated ratios for Barry. b. Construct the DuPont equation for both Barry and the industry. c. Outline Barry’s strengths and weaknesses as revealed by your analysis. d. Suppose Barry had doubled its sales as well as its inventories, accounts receivable, and common equity during 2016. How would that information affect the validity of your ratio analysis?

Barry Computer Company:Balance Sheet as of December 31, 2016 (in Thousands)Cash$ 77.500Accounts payable$ 129.000Receivables336.000Other current liabilities117.000Inventories241.500Notes payable to bank84.000Total current assets$ 655.000Total current liabilities$ 330.000  Long-term debt256.500Net fixed assets292.500Common equity361.000Total assets$ 947.500Total liabilities and equity$ 947.500\begin{matrix} \text{Barry Computer Company:} & \text{Balance Sheet as of December 31, 2016 (in Thousands)}\\ \text{Cash} & \text{\$ 77.500} & \text{Accounts payable} & \text{\$ 129.000}\\ \text{Receivables} & \text{336.000} & \text{Other current liabilities} & \text{117.000}\\ \text{Inventories} & \text{241.500} & \text{Notes payable to bank} & \text{84.000}\\ \text{Total current assets} & \text{\$ 655.000} & \text{Total current liabilities} & \text{\$ 330.000}\\ \text{ } & \text{ } & \text{Long-term debt} & \text{256.500}\\ \text{Net fixed assets} & \text{292.500} & \text{Common equity} & \text{361.000}\\ \text{Total assets} & \text{\$ 947.500} & \text{Total liabilities and equity} & \text{\$ 947.500}\\ \end{matrix}

Barry Computer Company:Balance Sheet as of December 31, 2016 (in Thousands)Sales $ 1.607.500Costs of goods sold Materials$ 717.000Labor453.000Heat, light, and power68.000Indirect labor113.000Deprecation41.5001.392.500Gross profit $ 215.000Selling expenses 115.000General and administrative expenses 30.000Earnings before interest and taxes (EBIT) $ 70.000Interest expense 24.500Earnings before taxes (EBT) $45.500Federal and state income taxes (40%) 18.200Net income $ 27.300\begin{matrix} \text{Barry Computer Company:} & \text{Balance Sheet as of December 31, 2016 (in Thousands)}\\ \text{Sales} & \text{ } & \text{\$ 1.607.500}\\ \text{Costs of goods sold} & \text{ }\\ \text{Materials} & \text{\$ 717.000}\\ \text{Labor} & \text{453.000}\\ \text{Heat, light, and power} & \text{68.000}\\ \text{Indirect labor} & \text{113.000}\\ \text{Deprecation} & \text{41.500} & \text{1.392.500}\\ \text{Gross profit} & \text{ } & \text{\$ 215.000}\\ \text{Selling expenses} & \text{ } & \text{115.000}\\ \text{General and administrative expenses} & \text{ } & \text{30.000}\\ \text{Earnings before interest and taxes (EBIT)} & \text{ } & \text{\$ 70.000}\\ \text{Interest expense} & \text{ } & \text{24.500}\\ \text{Earnings before taxes (EBT)} & \text{ } & \text{\$45.500}\\ \text{Federal and state income taxes (40\\\%)} & \text{ } & \text{18.200}\\ \text{Net income} & \text{ } & \text{\$ 27.300}\\ \end{matrix}

RatioBarryIndustry AverageCurrent 2.0 ×Quick 1.3 ×Days sales outstanding 35 daysInventory turnover 6.7 ×Total assets turnover 3.0 ×Profit margin 1.2%ROA 3.6%ROE 9.0%ROIC 7.5%TIE 3.0 ×Debt/Total capital 47.0%\begin{matrix} \text{Ratio} & \text{Barry} & \text{Industry Average}\\ \text{Current} & \text{ } & \text{2.0 }{\times}\\ \text{Quick} & \text{ } & \text{1.3 }{\times}\\ \text{Days sales outstanding} & \text{ } & \text{35 days}\\ \text{Inventory turnover} & \text{ } & \text{6.7 }{\times}\\ \text{Total assets turnover} & \text{ } & \text{3.0 }{\times}\\ \text{Profit margin} & \text{ } & \text{1.2\\\%}\\ \text{ROA} & \text{ } & \text{3.6\\\%}\\ \text{ROE} & \text{ } & \text{9.0\\\%}\\ \text{ROIC} & \text{ } & \text{7.5\\\%}\\ \text{TIE} & \text{ } & \text{3.0 }{\times}\\ \text{Debt/Total capital} & \text{ } & \text{47.0\\\%}\\ \end{matrix}

Question

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:$ $$ \begin{matrix} \text{Industry Average Ratios}\\ \text{Current ratio} & \text{3 }{\times} & \text{Fixed assets turnover} & \text{6 }{\times}\\ \text{Debt-to-capital ratio} & \text{20\\%} & \text{Total assets turnover} & \text{3 }{\3 times}\\ \text{Times interest earned} & \text{7 }{\times} & \text{Profit margin} & \text{3\\%}\\ \text{EBITDA coverage} & \text{9 }{\times} & \text{Return on total assets} & \text{9\\%}\\ \text{Inventory turnover} & \text{10}{\times} & \text{Return on common equity} & \text{12.86\\%}\\ \text{Days sales outstanding} & \text{24 days} & \text{Return on invested capital} & \text{11.50\\%}\\ \end{matrix} $$ $$ $\begin{matrix} \text{Balance Sheet as of December 31, 2016 (millions of Dollars)}\\ \text{Cash and equivalents} & \text{\$ 78} & \text{Accounts payable} & \text{\$ 45}\\ \text{Accounts receivable} & \text{66} & \text{Other current liabilities} & \text{11}\\ \text{Inventories} & \text{159} & \text{Notes payable} & \text{29}\\ \text{Total current assets} & \text{\$ 303} & \text{Total current liabilities} & \text{\$ 85}\\ \text{ } & \text{ } & \text{Long-term debt} & \text{50}\\ \text{ } & \text{ } & \text{Total liabilities} & \text{\$ 135}\\ \text{Gross fixed assets} & \text{225} & \text{Common stock} & \text{114}\\ \text{Less depreciation} & \text{78} & \text{Retained earnings} & \text{201}\\ \text{Net fixed assets} & \text{\$ 147} & \text{Total stockholders' equity} & \text{\$ 315}\\ \text{Total assets} & \text{\$ 450} & \text{Total liabilities and equity} & \text{\$ 450}\\ \end{matrix} $$ $$ \begin{matrix} \text{Income Statements for Year Ended December 31, 2016 (millions of dollars)}\\ \text{Net sales} & \text{\$ 795.0}\\ \text{Cost of goods sold} & \text{660.0}\\ \text{Gross profit} & \text{\$ 135.0}\\ \text{Selling expenses} & \text{73.5}\\ \text{EBITDA} & \text{\$ 61.5}\\ \text{Depreciation expense} & \text{12.0}\\ \text{Earnings before interest and taxes (EBIT)} & \text{\$ 49.5}\\ \text{Interest expense} & \text{4.5}\\ \text{Earnings before taxes (EBT)} & \text{\$ 45.0}\\ \text{Taxes (40\\%)} & \text{18.0}\\ \text{Net income} & \text{\$ 27.0}\\ \end{matrix} $$ 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?

Solution

Verified
Answered 1 year ago
Answered 1 year ago
Step 1
1 of 6

In this exercise, we will compute the company ratios.

Create a free account to view solutions

Create a free account to view solutions

Recommended textbook solutions

Fundamentals of Corporate Finance 7th Edition by Alan J. Marcus, Richard A. Brealey, Stewart C. Myers

Fundamentals of Corporate Finance

7th EditionISBN: 9780078034640 (2 more)Alan J. Marcus, Richard A. Brealey, Stewart C. Myers
807 solutions
Corporate Finance 4th Edition by Jonathan B. Berk, Peter DeMarzo

Corporate Finance

4th EditionISBN: 9780134202914Jonathan B. Berk, Peter DeMarzo
1,224 solutions
Corporate Finance 4th Edition by Jonathan B. Berk, Peter DeMarzo

Corporate Finance

4th EditionISBN: 9780134409276Jonathan B. Berk, Peter DeMarzo
1,224 solutions
Fundamentals of Financial Management, Concise Edition 9th Edition by Eugene F. Brigham, Joel F Houston

Fundamentals of Financial Management, Concise Edition

9th EditionISBN: 9781305635937 (1 more)Eugene F. Brigham, Joel F Houston
1,421 solutions

More related questions

1/4

1/7