Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Need help with parts B and C FIAEV Total assets $300,000 Total liabilities and equity Cost of goods sold Sales 4-23 RATIO ANALYSIS Data for

image text in transcribedimage text in transcribed

Need help with parts B and C

FIAEV Total assets $300,000 Total liabilities and equity Cost of goods sold Sales 4-23 RATIO ANALYSIS Data for Barry Computer Co. and its industry averages follow. The firm's debt is priced at par, so the market value of its debt equals its book value. Since de lars are in thousands, number of shares are shown in thousands too. 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 2019. How would that information affect the validity of your ratio analysis? (Hint: Think about averages and the effects of rapid growth on ratios if averages are not used. No calculations are needed.) Barry Computer Company: Balance Sheet as of December 31, 2019 (in Thousands) Cash $ 77,500 Accounts payable Receivables 336,000 Other current liabilities Inventories 241,500 Notes payable to bank Total current assets $ 655,000 Total current liabilities Long-term debt Net fixed assets 292,500 Common equity (36,100 shares) Total assets $947,500 Total liabilities and equity $129,000 117,000 84,000 $330,000 256,500 361,000 $947,500 Chapter 4 Analysis of Financial Statements 141 Barry Computer Company: Income Statement for Year Ended December 31, 2019 (in Thousands) Sales Cost of goods sold $1,607,500 Materials $717,000 Labor 453,000 Heat, light, and power 68,000 Indirect labor 113,000 Depreciation 41,500 1,392,500 Gross profit $ 215,000 Selling expenses 115,000 General and administrative expenses 30,000 Earnings before interest and taxes (EBIT) 70,000 Interest expense 21,000 Earnings before taxes (EBT) 49,000 Federal and state income taxes (25%) 12,250 Net income $ 36,750 Earnings per share Price per share on December 31, 2019 $ $ 1.018 12.00 Barry Ratio Current Quick Industry Average 2.0X 1.3x 35 days 6.7X Days sales outstanding 3.0X 1.6% Inventory turnover Total assets turnover Profit margin ROA ROE ROIC TIE Debt/Total capital M/B 4.8% 12.1% 9.4% 3.5X 47.0% 4.22X 13.27 9.14 P/E EV/EBITDA Calculation is based on a 365-day year. 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: FIAEV Total assets $300,000 Total liabilities and equity Cost of goods sold Sales 4-23 RATIO ANALYSIS Data for Barry Computer Co. and its industry averages follow. The firm's debt is priced at par, so the market value of its debt equals its book value. Since de lars are in thousands, number of shares are shown in thousands too. 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 2019. How would that information affect the validity of your ratio analysis? (Hint: Think about averages and the effects of rapid growth on ratios if averages are not used. No calculations are needed.) Barry Computer Company: Balance Sheet as of December 31, 2019 (in Thousands) Cash $ 77,500 Accounts payable Receivables 336,000 Other current liabilities Inventories 241,500 Notes payable to bank Total current assets $ 655,000 Total current liabilities Long-term debt Net fixed assets 292,500 Common equity (36,100 shares) Total assets $947,500 Total liabilities and equity $129,000 117,000 84,000 $330,000 256,500 361,000 $947,500 Chapter 4 Analysis of Financial Statements 141 Barry Computer Company: Income Statement for Year Ended December 31, 2019 (in Thousands) Sales Cost of goods sold $1,607,500 Materials $717,000 Labor 453,000 Heat, light, and power 68,000 Indirect labor 113,000 Depreciation 41,500 1,392,500 Gross profit $ 215,000 Selling expenses 115,000 General and administrative expenses 30,000 Earnings before interest and taxes (EBIT) 70,000 Interest expense 21,000 Earnings before taxes (EBT) 49,000 Federal and state income taxes (25%) 12,250 Net income $ 36,750 Earnings per share Price per share on December 31, 2019 $ $ 1.018 12.00 Barry Ratio Current Quick Industry Average 2.0X 1.3x 35 days 6.7X Days sales outstanding 3.0X 1.6% Inventory turnover Total assets turnover Profit margin ROA ROE ROIC TIE Debt/Total capital M/B 4.8% 12.1% 9.4% 3.5X 47.0% 4.22X 13.27 9.14 P/E EV/EBITDA Calculation is based on a 365-day year. 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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial management theory and practice

Authors: Eugene F. Brigham and Michael C. Ehrhardt

12th Edition

978-0030243998, 30243998, 324422695, 978-0324422696

More Books

Students also viewed these Finance questions