Managerial Accounting (5th Edition)
5th Edition
ISBN: 9780134128528
Author: Karen W. Braun, Wendy M. Tietz
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Question
Chapter 14, Problem 14.30BE
To determine
To compute: Six ratios that measure firm TC’s ability to earn profits.
To conclude: Company’s operating performance improves or deteriorates during 2017.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
OBJECTIVE: To enable learners to utilize financial ratios as a mechanism to evaluate the firm's financial
performance and identify areas for making decisions for improvement
REQUIREMENT: Financial Statement Analysis
Question
Refer to the following financial statements of Delima Corporation for 2019 and 2020:
Delima Corporation
Income Statements
For the year ended 31 December (in millions)
2020
$13,198
7,750
2019
$12,397
7,108
Net sales
Cost of goods sold
Gross profit
Selling and administrative expenses
Income from operations
5,448
5,289
3,472
3,299
1,976
1,990
Interest expense
233
248
Other (income) expense, net
11
1,732
503
1,229
Income before income taxes
1,742
Income tax expense
502
Net income
1,240
Delima Corporation
Balance Sheets
31 December (in millions)
2020
2019
Assets
Current assets
Cash
$460
$444
Accounts receivables (net)
1,188
1,132
1,190
1,056
225
2,915
3,128
Inventories
Other current assets
247
Total current assets
3,027
3,281
Property (net)
5,593
$11,901
Other assets…
E12-24B Vertical analysis (Learning Objective 2) 15-20 min.
Simpson Painting, Inc., requested that you perform a vertical analysis
of its balance sheet to determine the component percentages of its
assets, liabilities, and stockholders' equity. Round to the nearest tenth
of a percent.
P. Donnelly, Inc.
Comparative Income Statement
Years Ended December 31, 2018 and 2017
Revenue
Expenses:
Cost of Goods Sold
Selling and General Expenses
Interest Expense
Income Tax Expense
Total Expenses
Net Income
2018
$500,000
$245,000
111,000
10,000
54,700
420,700
$ 79,300
2017
$439,500
$236,000
103,500
6,500
44,400
390,400
$ 49,100
(Learning Objective 2: Analyze accounts payable turnover) Barnacle Sales, Inc.’s,comparative income statements and balance sheets show the following selected information for2017 and 2018:2018$2,850,000$ 800,000$ 600,000$ 305,0002017$2,700,000$ 600,000$ 400,000$ 255,000Cost of goods sold.......................................................Ending inventory.........................................................Beginning inventory ....................................................Average accounts payable ...........................................Requirements1. Calculate the company’s accounts payable turnover and days’ payable outstanding (DPO)for 2017 and 2018.2. On the basis of this computation alone, has the company’s liquidity position improved ordeteriorated during 2018?
Chapter 14 Solutions
Managerial Accounting (5th Edition)
Ch. 14 - (Learning Objective 1) Which of the following...Ch. 14 - Prob. 2QCCh. 14 - Prob. 3QCCh. 14 - Prob. 4QCCh. 14 - (Learning Objective 3) Which of the following is...Ch. 14 - (Learning Objective 4) Working capital is defined...Ch. 14 - Prob. 7QCCh. 14 - Prob. 8QCCh. 14 - Prob. 9QCCh. 14 - Prob. 10QC
Ch. 14 - Prob. 14.1SECh. 14 - Find trend percentages (Learning Objective 1)...Ch. 14 - Prob. 14.3SECh. 14 - Prepare common-size income statements (Learning...Ch. 14 - Analyze common-size income statements (Learning...Ch. 14 - Cartwrights Data Set used for S14-6 through...Ch. 14 - Cartwrights Data Set used for S14-6 through...Ch. 14 - Cartwrights Data Set used for S14-6 through...Ch. 14 - Prob. 14.9SECh. 14 - Prob. 14.10SECh. 14 - Prob. 14.11SECh. 14 - Prob. 14.12AECh. 14 - Prob. 14.13AECh. 14 - Prob. 14.14AECh. 14 - Prob. 14.15AECh. 14 - Prob. 14.16AECh. 14 - Calculate ratios (Learning Objective 4) Kelleher...Ch. 14 - Prob. 14.18AECh. 14 - Prob. 14.19AECh. 14 - Prob. 14.20AECh. 14 - Prob. 14.21AECh. 14 - Classify company sustainability measurements into...Ch. 14 - Prob. 14.23BECh. 14 - Prob. 14.24BECh. 14 - Prob. 14.25BECh. 14 - Prob. 14.26BECh. 14 - Prob. 14.27BECh. 14 - Calculate ratios (Learning Objective 4) Ponderosa...Ch. 14 - Prob. 14.29BECh. 14 - Prob. 14.30BECh. 14 - Prob. 14.31BECh. 14 - Calculate ratios (Learning Objective 4) Thornton...Ch. 14 - Prob. 14.33BECh. 14 - Prob. 14.34APCh. 14 - Comprehensive analysis (Learning Objectives 2, 3, ...Ch. 14 - Prob. 14.36APCh. 14 - Ratio analysis over two years (Learning Objective...Ch. 14 - Prob. 14.38APCh. 14 - Prob. 14.39BPCh. 14 - Prob. 14.40BPCh. 14 - Prob. 14.41BPCh. 14 - Ratio analysis over two years (Learning Objective...Ch. 14 - Make an investment decision (Learning Objective 4)...Ch. 14 - Prob. 14.44SCCh. 14 - Discussion Questions 1. Describe horizontal...Ch. 14 - Prob. 14.47ACTCh. 14 - Using financial statement ratios to analyze...
Knowledge Booster
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
- (Learning Objective 7: Calculate return on assets) Handley Grocery Corporationreported the following information in its comparative financial statements for the fiscal yearended January 31, 2018:January 31,2018January 31,2017Net sales....................................Net earnings..............................Average total assets...................$50,000$ 2,200$40,000$48,350$ 2,100$39,300Requirements1. Compute the net profit margin ratio for the years ended January 31, 2018, and 2017. Did itimprove or worsen in 2018?2. Compute asset turnover for the years ended January 31, 2018, and 2017. Did it improve orworsen in 2018?3. Compute return on assets for the years ended January 31, 2018, and 2017. Did it improveor worsen in 2018? Which component—net profit margin ratio or asset turnover—wasmostly responsible for the change in the company’s return on assets?arrow_forward(Learning Objective 7: Calculate return on assets) Hometown Supply Companyreported the following information in its comparative financial statements for the fiscal yearended January 31, 2018:January 31,2018January 31,2017Net sales....................................Net earnings..............................Average total assets...................$84,000$ 4,200$70,000$82,600$ 4,050$69,450Requirements1. Compute the net profit margin ratio for the years ended January 31, 2018, and 2017. Did itimprove or worsen in 2018?2. Compute asset turnover for the years ended January 31, 2018, and 2017. Did it improve orworsen in 2018?3. Compute return on assets for the years ended January 31, 2018, and 2017. Did it improveor worsen in 2018? Which component—net profit margin ratio or asset turnover—wasmostly responsible for the change in the company’s return on assets?arrow_forwardComputing and Interpreting Financial Statement Ratios Following are selected ratios of Norfolk Southern for 2018 and 2017. Return on Assets (ROA) Component 2018 2017 Profitability (Net income/Sales) 24.3% 52.2% Productivity (Sales/Average assets) 0.328 0.309 a. Was the company profitable in 2018?AnswerYesNo b. Was the company more profitable in 2018 or 2017?Answer20172018 c. Is the change in productivity a positive or negative development?AnswerPositiveNegative d. Compute the company’s ROA for 2018 and for 2017.Note: Round answers to one decimal places (example: 10.4%). ROA 2018 Answer 2017 Answerarrow_forward
- Case Study Questions What was the total postpaid revenue in 2017? What was the total net profit in 2017? Identify examples of strategies adopted by MAXIS in that year. How were the above strategies related to their Customer Relationship Management (CRM) and future sale?arrow_forward! Required information [The following information applies to the questions displayed below.] Use the following data to graph the sales revenue and net income for Walmart from 2012-2017 in Excel. Data: Problem 6-3 Data.xlsx. (Students can download this data file solve this Problem.) Year 2012 2013 2014 2015 2016 2017 Sales Revenue $468,651,000,000 $476,294,000,000 $ 485,651,000,000 $482,130,000,000 $485,873,000,000 $500,343,000,000 Net Income $17,756,000,000 $16,695,000,000 $17,099,000,000 $15,080,000,000 $14,293,000,000 $10,523,000,000 Create a bar graph for sales revenue and create a line graph for net income, formatting the x- and y- axes with year and numbers and inserting appropriate chart titles. Upload the Spreadsheet containing your Problem using the button below.arrow_forwardComputing and Interpreting Financial Statement Ratios Following are selected ratios of Norfolk Southern for 2018 and 2017. Return on Assets (ROA) Component 2018 2017 Profitability (Net income/Sales) 25.3% 53.2% Productivity (Sales/Average assets) 0.338 0.319 a. Was the company profitable in 2018?Answer b. Was the company more profitable in 2018 or 2017?Answer c. Is the change in productivity a positive or negative development?Answer d. Compute the company’s ROA for 2018 and for 2017. Note: Round answers to one decimal places (example: 10.4%). ROA 2018 Answer 2017 Answer e. From the information provided, which of the following best explains the change in ROA during 2018? Answerarrow_forward
- A company’s data of year wise profit is provided; you have to find out how much profit the company should earn in year 2022 to get total profit of 25000? Use goal seek to solve this problem. Show all formulas used in Excel Take the screen shot of the goal seek window when display result. Year Profit 2019 5000 2000 6000 2021 7000 2022 Total Profit 18000arrow_forward(Learning Objective 7: Calculate return on assets) Oscar Optical Corporation providesa full line of designer eyewear to consumers. Oscar reported the following information for 2018and 2017:2018 2017Sales revenue ...............................Net income..................................Average total assets.....................$500,000$ 43,700$230,000$410,000$ 34,650$210,000Compute return on assets (ROA) for 2018 and 2017. Using the DuPont model, identify thecomponents and state whether each improved or worsened from 2017 to 2018.arrow_forwardProblem 1: Viance Queen Company Required: Compute for the company’s profitability and operating efficiency ratios for 2019 Compute for the financial health ratios of the company for 2019 A.Profitability ratio a.Gross Profit Ratio b. Operating income margin c. Net profit margin d. Return on Assets: ROA (NI/Total Assets) ROA (NI/Average Assets) ROA (EBIT/Total Assets) ROA (EBIT/Average Assets) ROE (NI/Capital) ROE (NI/Average Capital B.Operating Efficiency a. Asset Turnover b. Fixed Asset Turnover c. Inventory Turnover d. Days in Inventory e. AR Turnover f. Days in AR C.Financial Health/ (Solvency and Liquidity) Solvency ratio: a. Debt to equity ratio b. Debt Ratio c. Equity Ratio d. Interest Coverage Ratio Liquidity ratio: a. Current Ratio b. Quick Ratioarrow_forward
- Problem 1: Viance Queen Company Required: Compute for the company’s profitability and operating efficiency ratios for 2019 Compute for the financial health ratios of the company for 2019 A.Profitability ratio a. Return on Assets: ROA (NI/Total Assets) ROA (NI/Average Assets) ROA (EBIT/Total Assets) ROA (EBIT/Average Assets) ROE (NI/Capital) ROE (NI/Average Capitalarrow_forwardRequired: Compute the DuPont ratlos (profit margin, asset turnover, and financial leverage ratlos) for Amazon and Kroger given these numbers for 2012-2017. Check your numbers to make sure that Profit margin x Asset turnover Financial leverage = Return on equity. (Negative amounts should be entered with a minus sign. Round your answers to 4 decimal places.) Data: Problem 6-2 Data.xlsx. (Students can download this data file solve this problem.) AMZN KR Year 2017 2016 2015 2014 2013 2012 Year 2017 2016 2015 2014 2013 2012 2017 2016 2015 2014 2013 2012 2017 2016 2015 2014 2013 2012 Year Year Sales Revenue $177,866,000,000 $135,987,000,000 $107,006,000,000 $ 596,000,000 $ 88,988,000,000 $ (241,000,000) $54,505,000,000 $ 74,452,000,000 $ 274,000,000 $ 40,159,000,000 $ 61,093,000,000 $ (39,000,000) $32,555,000,000 Sales Revenue $122,662,000,000 $115,337,000,000 $109,830,000,000 $108,465,000,000 $ 98,375,000,000 $ 96,619,000,000 Net Income Assets $131,310,000,000 $ 3,033,000,000 $…arrow_forwardProblem 1: Viance Queen Company Required: Compute for the company’s profitability and operating efficiency ratios for 2019 Compute for the financial health ratios of the company for 2019 A.Profitability ratio Return on Assets: ROA (EBIT/Average Assets) ROE (NI/Capital) ROE (NI/Average Capitalarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Financial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage Learning
Financial Accounting: The Impact on Decision Make...
Accounting
ISBN:9781305654174
Author:Gary A. Porter, Curtis L. Norton
Publisher:Cengage Learning
The KEY to Understanding Financial Statements; Author: Accounting Stuff;https://www.youtube.com/watch?v=_F6a0ddbjtI;License: Standard Youtube License