Managerial Accounting (5th Edition)
5th Edition
ISBN: 9780134128528
Author: Karen W. Braun, Wendy M. Tietz
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Question
Chapter 14, Problem 14.1SE
To determine
To prepare: Horizontal analysis of revenues and gross profit in dollar amounts and in percentages for the year 2017 and 2016.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
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
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…
(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
Similar questions
- (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_forward(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: Evaluate liquidity using the quick [acid-test] ratio and days’sales in receivables) Northern Products reported the following amounts in its 2019 financialstatements. The 2018 amounts are given for comparison.2019 2018Current assets:Cash............................................ $ 9,500Short-term investments................ 7,000Accounts receivable..................... $70,100Less: Allowance foruncollectibles.......................$86,500(7,500) (5,500) 64,600Inventory..................................... 190,000Prepaid insurance ........................ 2,200Total current assets..................... 273,300Total current liabilities.................... 106,000Net sales (all on account) ................$ 9,50010,50079,000189,0002,200290,20099,0001,077,000 734,000Requirements1. Compute Northern’s quick (acid-test) ratio at the end of 2019. Round to two decimalplaces. How does the quick ratio compare with the industry average of 0.92?2. Compare days’ sales…arrow_forward
- Given the income statement for the MLC (Table 4–7) and balance sheet(Table 4–4), answer the following:a. Calculate the following ratios for 2012: operating profit margin, net profitmargin, operating return on assets, net return on assets, and return onequity.b. In a written explanation, describe what each ratio means.c. In a brief paragraph, describe the overall profitability of the MLC.arrow_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_forwardCompute the following for year 20171. Gross Margin Ratio2. Operating Profit Margin3. Net Profit Margin or Return on Sales4. Return on Equity5. Return on Assetsarrow_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_forward(Learning Objective 4: Construct the financial statements) Suppose Robin SportingGoods Company reported the following data at July 31, 2018, with amounts in thousands:Cost of goods sold................. $136,800Cash...................................... 50,000Property and equipment, net ... 19,400Common stock...................... 26,000Inventories ............................ 36,000Long-term liabilities.............. 11,700Dividends.............................. 0Retained earnings,July 31, 2017 ............ $ 31,500Accounts receivable....... 34,000Net revenues ................. 191,000Total current liabilities.. 80,000All other expenses......... 29,000Other current assets ...... 5,000Other assets................... 30,000Use these data to prepare Robin Sporting Goods Company’s single-step income statement forthe year ended July 31, 2018; statement of retained earnings for the year ended July 31, 2018;and classified balance sheet at July 31, 2018. Use the report format for the balance…arrow_forwardFind in Amount ($) and Percentage(%) for Year 2 over Year 1: Income Statement - (a) Sales Revenue (b) Cost of sales (c) Gross Marginarrow_forward
- GIVE THE COMPARATIVE INCOME STATEMENT HORIZONTAL AND VERTICAL ANALYSIS FROM THE FOLLOWING INCOME STATEMENT BELOW JOLLIBEE INCOME STATEMENT ITEM 2016 2017 2018 2019 2020 Sales/Revenue 113.81B 133.61B 161.17B 179.63B 129.31B Sales Growth - 17.40% 20.62% 11.45% -28.01% Cost of Goods Sold (COGS) incl. D&A - - 132.96B 150.88B 115.39B COGS Growth - - - 13.47% -23.52% COGS excluding D&A 89.27B 105.39B 121.08B 137.38B 100.82B Depreciation & Amortization Expense 4B 4.75B 11.89B 13.5B 14.57B Depreciation 3.93B 4.66B 11.73B 13.34B 14.32B Amortization of Intangibles 68.99M 78.95M 151.82M 145.42M 245.23M Gross Income 20.54B 23.48B 28.21B 28.75B 13.92B Gross Income Growth - 14.30% 20.12% 1.93% -51.57% Gross Profit Margin - - - - 10.77% SG&A Expense - - 17.64B 20.21B 20.42B SGA Growth - - -…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_forwardPlease see attachment for the data Question : Determine the gross profit to be reported for 2014 Thanks in advancearrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage Learning
Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning