MyLab Finance with Pearson eText -- Access Card -- for Principles of Managerial Finance
15th Edition
ISBN: 9780134479903
Author: Chad J. Zutter, Scott B. Smart
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Textbook Question
Chapter 3, Problem 3.23P
Learning Goal 6
P3-23 Cross-sectional ratio analysis Use the accompanying financial statements for Fox Manufacturing Company for the year ended December 31, 2019, along with the industry average ratios below, to do the following:
- a. Prepare and interpret a complete ratio analysis of the firm’s 2019 operations.
- b. Summarize your findings and make recommendations.
Fox Manufacturing Company Income Statement for the Year Ended December 31 2019
Sales revenue | $600,000 |
Less: Cost of goods sold | 460,000 |
Gross profits | $140,000 |
Less: Operating expenses | |
General and administrative expenses | $ 30,000 |
30,000 | |
Total operating expense | $60,000 |
Operating profits | $80,000 |
Less: Interest expense | 10,000 |
Net profits before taxes | $70,000 |
Less: Taxes | 27,100 |
Net profits after taxes (Hint: Earnings available for common stockholders as there are no preferred stockholders) | $42.900 |
Earnings per share (EPS) | $2.15 |
Ratio | Industry average, 2019 |
Current ratio | 2.35 |
Quick ratio | 0.87 |
Inventory turnover | 4.55 |
Average collection period | 35.8 days |
Total asset turnover | 1.09 |
Debt ratio | 0.300 |
Times interest earned ratio | 12.3 |
Gross profit margin | 0.202 |
Operating profit margin | 0.135 |
Net profit margin | 0.091 |
0.099 | |
0.167 | |
Earnings per share (EPS) | $3.10 |
Based on a 365-day year and on end-of-year figures. |
Fox Manufacturing Company
Assets | |
Cash | $ 15,000 |
Marketable securities | 7,200 |
Accounts receivable | 34, 100 |
Inventories | 82,000 |
Total current assets | $138,300 |
Net fixed assets | 270,000 |
Total assets | $408,300 |
Liabilities and |
|
Accounts payable | $ 57,000 |
Notes payable | 13,000 |
Accruals | 5,000 |
Total current liabilities | $ 75,000 |
Long-term debt | $150,000 |
Common stock equity (20,000 shares outstanding) | $110,200 |
73,100 | |
Total stockholders’ equity | $183,300 |
Total liabilities and stockholders’ equity | $408,300 |
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
please help me with the answer and steps to solve it
From the data, how to calculate net profit margin for hwa tai industries in year 2018 and 2019?
interpret and analyze the ratios
Chapter 3 Solutions
MyLab Finance with Pearson eText -- Access Card -- for Principles of Managerial Finance
Ch. 3.1 - Prob. 3.1RQCh. 3.1 - Describe the purpose of each of the four major...Ch. 3.1 - Prob. 3.3RQCh. 3.1 - Prob. 3.4RQCh. 3.2 - With regard to financial ratio analysis, how do...Ch. 3.2 - What is the difference between cross-sectional and...Ch. 3.2 - Prob. 3.7RQCh. 3.2 - Prob. 3.8RQCh. 3.3 - Under what circumstances would the current ratio...Ch. 3.3 - In Table 3.5, most of the specific firms listed...
Ch. 3.4 - To assess the firms average collection period and...Ch. 3.5 - What is financial leverage?Ch. 3.5 - What ratio measures the firms degree of...Ch. 3.6 - What three ratios of profitability appear on a...Ch. 3.6 - Prob. 3.15RQCh. 3.6 - Prob. 3.16RQCh. 3.7 - What do the price/earnings (P/E) ratio and the...Ch. 3.8 - Financial ratio analysis is often divided into...Ch. 3.8 - Prob. 3.19RQCh. 3.8 - What three areas of analysis are combined in the...Ch. 3 - For the quarter ended January 28, 2017, Kroger...Ch. 3 - Learning Goals 3, 4, 5 ST3-1 Ratio formulas and...Ch. 3 - Prob. 3.2STPCh. 3 - Prob. 3.1WUECh. 3 - Learning Goal 1 E3-2 Explain why the income...Ch. 3 - Prob. 3.3WUECh. 3 - Learning Goal 3 E3-4 Bluestone Metals Inc. is a...Ch. 3 - Learning Goal 6 E3-5 If we know that a firm has a...Ch. 3 - Financial statement account identification Mark...Ch. 3 - Learning Goal 1 P3-2 1ncome statement preparation...Ch. 3 - Prob. 3.3PCh. 3 - Learning Goal 1 P3-4 Calculation of EPS and...Ch. 3 - Prob. 3.5PCh. 3 - Prob. 3.6PCh. 3 - Learning Goals 1 P3-7 Initial sale price of common...Ch. 3 - Prob. 3.8PCh. 3 - Learning Goal 1 P3-9 Changes In stockholders...Ch. 3 - Learning Goals 2, 3, 4, 5 P3-10 Ratio comparisons...Ch. 3 - Learning Goal 3 P3-11 Liquidity management Bauman...Ch. 3 - Prob. 3.12PCh. 3 - Inventory management Three companies that compete...Ch. 3 - Accounts receivable management The table below...Ch. 3 - Prob. 3.15PCh. 3 - Learning Goal 4 P3-16 Debt analysis Springfield...Ch. 3 - Prob. 3.17PCh. 3 - Learning Goals 2, 3, 4 P3-18 Using Tables 3.1,...Ch. 3 - Learning Goals 5 P3-19 Common-size statement...Ch. 3 - The relationship between financial leverage and...Ch. 3 - Learning Goal 4 P3-21 Analysis of debt ratios...Ch. 3 - Learning Goal 6 P3-22 Ratio proficiency McDougal...Ch. 3 - Learning Goal 6 P3-23 Cross-sectional ratio...Ch. 3 - Learning Goal 6 P3-24 Financial statement analysis...Ch. 3 - Learning Goals 6 P3- 25 Integrative: Complete...Ch. 3 - Learning Goal 6 P3-26 DuPont system of analysis...Ch. 3 - Learning Goal 6 P3-27 Complete ratio analysis,...Ch. 3 - Spreadsheet Exercise The income statement and...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.Similar questions
- Assignment COMPARATIVE STATEMENTS Sikat Manufacturing Corporation Income Statement For the year ended Dec. 31, 2020 and 202019 2020 2019 P 5,150,000 -150,000 5,000,000 3,200,000 1,800,000 Sales 4,250,000 na 250.000 4,000,000 2.600,000 1,400,000 Less: Sales Returns and Allowances Net Sales Less: Cost of Sales Gross Profit Less: Operating Expenses Selling Expenses General and Administrative Expenses Total Operating Expenses Operating Income Less: Interest expense Net Income before tax Less: Income tax.(32% ) Net Income 720,000 780,000 1,500,000 300,000 60,000 240,000 76,800 P 163.200 600,000 600,000 1,200,000 200,000 40,000 160,000 51,200 P 108,800 Sikat Manufacturing Corporation Balance Sheet Dec. 31, 2020 and 2019 2020 2019 ASSETS P 225,000 150,000 240,000 260,000 120,000 150,000 70,000 550,000 P1.765.000 P 1,520,000 Cash P140.000 125,000 180,000 160,000 145,000 170,000 80,000 520,000 Marketable Securities Accounts Receivable Inventories: Finished Goods Work-in-Process Raw Materials…arrow_forwardcomparative income statements of Arab Manufacturing Company are shown below. 2019 $38,610 $32,175 $25,740 2020 2018 Net sales 25,100 19,950 S13,510 S12,225 $10,340 7,700 4,270 Cost of sales 15,400 Gross profit Selling expenses 6,565 5,148 Administrative 4.175 3,861 expenses Total operating S11,970 $10,740 $9.009 expenses Operating S 1,540 S1,485 $1,331 income Interest expense 115 95 100 Net income S 1,425 S 1,390 $1,231 before tax 655 645 S 770 S 745 541 $ 690 Income taxes Net income Required: a. Perform a vertical, common size analysis of the income statement data for Arab Manufacturing Company in columnar form, using sales as the base. b. Comment briefly on significant trends and relationships revealed by the computations. :52 PMarrow_forwardProblem 13-02A (Video) The comparative statements of Cullumber Company are presented here: Cullumber CompanyIncome StatementsFor the Years Ended December 31 2020 2019 Net sales $1,891,640 $1,751,600 Cost of goods sold 1,059,640 1,007,100 Gross profit 832,000 744,500 Selling and administrative expenses 501,100 480,100 Income from operations 330,900 264,400 Other expenses and losses Interest expense 23,700 21,700 Income before income taxes 307,200 242,700 Income tax expense 93,700 74,700 Net income $213,500 $168,000 Cullumber CompanyBalance SheetsDecember 31 Assets 2020 2019 Current assets Cash $60,100 $64,200 Debt investments (short-term) 74,000 50,000 Accounts receivable 118,900 103,900 Inventory 127,700 117,200 Total current assets 380,700 335,300 Plant assets (net)…arrow_forward
- 6. The following is the adjusted trial balance data for Nino's Pizzenia as of December 31, 2019. NINO'S PIZZERIA Adjusted Trlal Balance Year Ended December 31,2019 Debit Credit S 775,984 45,688 200,460 135,624 Cash Accounts Receivable Buildings Merchandise Inventory Accounts Payable Common Stock Sales Interest Revenue Rent Revenue Sales Salaries Expense office Supplies Expense Sales Discounts Interest Expense Sales Returns and Allowances, Cost of goods sold Rent Expense Depreciation Expense: Office Equipment Insurance Expense Advertising Expense Totals $437,880 410,542 555,696 84,652 86,900 24,500 6,270 102,890 4,577 105.854 122,853 20.000 10.555 2,780 17:635 $1,575,670 $1,575,670arrow_forwardData for Lozano Chip Company and its industry averages follow. Calculate the indicated ratios for Lozano. Construct the extended DuPont equation for both Lozano and the industry. Outline Lozano’s strengths and weaknesses as revealed by your analysis. Lozano Chip Company: Balance Sheet as of December 31, 2019 (Thousands of Dollars) Lozano Chip Company: Income Statement for Year Ended December 31, 2019 (Thousands of Dollars)arrow_forwardThe following select account data is taken from the records of Reese Industries for 2019. A. Use the data provided to compute net sales for 2019. B. Prepare a simple income statement for the year ended December 31, 2019. C. Compute the gross margin for 2019. D. Prepare a multi-step income statement for the year ended December 31, 2019.arrow_forward
- Sales transactions Using transactions listed in P4-2, indicate the effects of each transaction on the liquidity metric working capital and profitability metric gross profit percent. Indicate the gross profit percent for each sale (rounding to one decimal place) in parentheses next to the effect of the sale on the company’s ability to attain an overall gross profit percent of 30%.arrow_forwardThe following items were taken from the financial statements of Kramer Manufacturing, Inc., over a 3-year period: Item 2021 2020 2019 Net sales $226,000 $212,000 $200,000 Cost of goods sold 150,000 140,000 125,000 Gross profit $ 76,000 $ 72,000 $ 75,000 Instructions Using horizontal analysis and 2019 as the base year, compute the trend percentages for net sales, cost of goods sold, and gross profit. Item 2021 2020 2019 Net sales % % 100% Cost of goods sold % % 100% Gross profit % % 100% Explain whether the trends are favorable or unfavorable for each…arrow_forwarda,b, and c pleasearrow_forward
- 9 - The income statement of a Business for the period 2019 is as follows: 31.12.2019 % Gross sales 45.200 TL 102.72 Discounts From Sales 1.200 TL 2.72 Net Sales 44,000 TL 100.00 Cost of sales 12.500 TL 28.41 Gross Profit on Sales 31,500 TL 71.59 This table was prepared according to which of the following analysis methods? a) Technical analysis B) Analysis with Vertical Percentage Method NS) Ratio Analysis D) Comparative Tables Analysis TO) Trend Percentages Analysisarrow_forwardhorizontal analysisarrow_forwardB. Below is the Statement of Comprehensive Income of Q & A Trading Company: Percentage 2020 P1,939,500 900,000 1,039,500 445,500 37,575 P 556,425 2019 Percentage Revenue Cost of Goods Sold Gross Profit Selling and General Experses Other Experses Net Income P1,674,675 843,975 830,700 409,725 30,825 P 390,150 Requirements: Prepare a vertical aralysis for Q & A Trading Compary.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage LearningSurvey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage Learning
- Principles of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax College
Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning
Survey of Accounting (Accounting I)
Accounting
ISBN:9781305961883
Author:Carl Warren
Publisher:Cengage Learning
Principles of Accounting Volume 1
Accounting
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax College
Financial ratio analysis; Author: The Finance Storyteller;https://www.youtube.com/watch?v=MTq7HuvoGck;License: Standard Youtube License