Financial Accounting
4th Edition
ISBN: 9780134125053
Author: Kemp, Robert S., Waybright, Jeffrey.
Publisher: Pearson Education,
expand_more
expand_more
format_list_bulleted
Textbook Question
Chapter 12, Problem 13AE
Horizontal analysis (Learning Objective 2) 15-20 min.
Below are net sales and net income data for a five-year period.
Year 5 | Year 4 | Year 3 | Year 2 | Year 1 | |
Net Sales................. | $313,700 | $293,300 | $270,300 | $252,500 | $255,000 |
Net Income............. | 76,200 | 71,100 | 65,300 | 62,100 | 64,000 |
Requirements
- 1. Compute trend percentages for net sales and net income for the five-year period, using year 1 as the base year. Round to the nearest percent.
- 2. Which grew faster during the period: net sales or net income?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these 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?
(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…
(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.
Chapter 12 Solutions
Financial Accounting
Ch. 12 - Prob. 1DQCh. 12 - Which amount is the base amount for vertical...Ch. 12 - Prob. 3DQCh. 12 - Prob. 4DQCh. 12 - Prob. 5DQCh. 12 - Prob. 6DQCh. 12 - Prob. 7DQCh. 12 - How would you expect a recession to affect asset...Ch. 12 - Prob. 9DQCh. 12 - Prob. 10DQ
Ch. 12 - Prob. 1SCCh. 12 - Prob. 2SCCh. 12 - Prob. 3SCCh. 12 - Prob. 4SCCh. 12 - Prob. 5SCCh. 12 - Prob. 6SCCh. 12 - Prob. 7SCCh. 12 - Prob. 8SCCh. 12 - Prob. 9SCCh. 12 - Prob. 10SCCh. 12 - Prob. 11SCCh. 12 - Prob. 12SCCh. 12 - Prob. 1SECh. 12 - Prob. 2SECh. 12 - Prob. 3SECh. 12 - Prob. 4SECh. 12 - Prob. 5SECh. 12 - Prob. 6SECh. 12 - Prob. 7SECh. 12 - Prob. 8SECh. 12 - Prob. 9SECh. 12 - Prob. 10SECh. 12 - Prob. 11AECh. 12 - Prob. 12AECh. 12 - Horizontal analysis(Learning Objective 2)15-20...Ch. 12 - Prob. 14AECh. 12 - Prob. 15AECh. 12 - Prob. 16AECh. 12 - Prob. 17AECh. 12 - Prob. 18AECh. 12 - Prob. 19AECh. 12 - Prob. 20AECh. 12 - Horizontal analysis(Learning Objective 2)15-20...Ch. 12 - Prob. 22BECh. 12 - Prob. 23BECh. 12 - Prob. 24BECh. 12 - Prob. 25BECh. 12 - Prob. 26BECh. 12 - Prob. 27BECh. 12 - Prob. 28BECh. 12 - Prob. 29BECh. 12 - Prob. 30BECh. 12 - Prob. 31APCh. 12 - Prob. 32APCh. 12 - Prob. 33APCh. 12 - Prob. 34APCh. 12 - Prob. 35APCh. 12 - Prob. 36APCh. 12 - Prob. 37BPCh. 12 - Prob. 38BPCh. 12 - Prob. 39BPCh. 12 - Prob. 40BPCh. 12 - Prob. 41BPCh. 12 - Prob. 42BPCh. 12 - Prob. 1CECh. 12 - Prob. 1CPCh. 12 - Prob. 1EIACh. 12 - Prob. 2EIACh. 12 - Prob. 1FACh. 12 - Prob. 1IACh. 12 - Prob. 1SBACh. 12 - Prob. 1WC
Additional Business Textbook Solutions
Find more solutions based on key concepts
Calculate retained earnings balance. (LO 5). Suppose Hillard Company started the year with a balance of $450,00...
Financial Accounting
Sutherland Manufacturing makes carrying cases for portable electronic devices. Its costing records yield the fo...
Horngren's Financial & Managerial Accounting, The Managerial Chapters (6th Edition)
The accounting assumption that governs given situation.
Financial Accounting (11th Edition)
Discussion Questions 1. What characteristics of the product or manufacturing process would lead a company to us...
Managerial Accounting (4th Edition)
Prepare income statements (Learning Objective 5) Part One: In 2015, Fran Lexa opened Frans Flowers, a small sho...
Managerial Accounting (5th Edition)
Queen Industries uses a standard costing system in the manufacturing of its single product. It requires 2 hours...
Principles of Accounting Volume 2
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
- The following is an example of Segment College textbooks High school textbooks Elementary school textbooks Total revenues Oa. percentage analysis Ob. horizontal analysis Oc. product analysis Od. vertical analysis Increase (Decrease) Percent 41.8% 12.2 (13.2) 7.2 Current Year Prior Year Amount $78,000 $55,000 $23,000 129,000 115,000 14,000 105,000 121,000 (16,000) $312,000 $21,000 $291,000arrow_forward1. Using the data in the student spreadsheet file Ethan Allen Financials.xlsx forecast the 2019 income statement and balance sheet for Ethan Allen. Use the percent of sales method and the following assumptions: (1) sales in FY 2019 will be $797.3359; (2) the tax rate will be 35%; (3) each item that changes with sales will be the five-year average percentage of sales; (4) net fixed assets will increase to $300; and (5) the common dividend will be $0.75 per share. Use your judgment on all other items. a. What is the discretionary financing needed in 2019? Is this a surplus or deficit? b. Assume that the DFN will be absorbed by long-term debt and that the interest rate is 4% of LTD. Set up an iterative worksheet to eliminate it.arrow_forwardComplete the problems. Chelk 3. Dabney Washington is paid a weekly comm1ssI Sales of the week? or Lesson Practice Use the following commission schedule to find the total graduated commission in Problems 5–8. 5% on First 8% on Next 10% on sales Total Sales Amount $5,000 $10,000 Over $15,000 Commission 5. $4,000 b. С. d. а. 6. 8,000 а. b. d. 7. 18,000 b. d. а. 8. 27,500 b. a. d. $7,500 or on in of Last week less and 3.0% on in of Nate's 9. Mary Robertson sells tires Dabney's was of her sales for 4. Nate a of on sales of orarrow_forward
- The graph below charts the past five years of returns for two different assets. Percentage Return 15% 10% 5% 0% -5% -10% -15% 1 2 3 Year It can be stated that the two assets demonstrate: Select one: O a. perfectly positive correlation O b. perfectly negative correlation O c. negatively correlated O d. positively correlated 5arrow_forwardMultiple Choice Quiz: If a company had $15,000 in net income for the year, and its sales were $300,000 for the same year, what is its profit margin? a. 20% c. $285,000 e. 5% b. 2,000% d. $315,000.arrow_forwardAnswer the following 2 questions based on the information in the spreadsheet you created below: Year 1 Year 2 Year 3 Year 4 $ % $ % $ % $ % Net Sales $ 500,000.00 100.00% $ 540,000.00 100.00% $ 577,800.00 100.00% $ 612,468.00 100.00% Cost of goods 265,000.00 53.00% $ 283,500.00 52.50% $ 300,456.00 52.00% $ 321,545.70 52.50% Gross Margin 235,000.00 47.00% $ 256,500.00 47.50% $ 277,344.00 48.00% $ 290,922.30 47.50% Operating expenses 210,000.00 42.00% $ 226,800.00 42.00% $ 245,565.00 42.50% $ 257,236.56 42.00% Operating proft 25,000.00 5.00% $ 29,700.00 5.50% $ 31,779.00 5.50% $ 33,685.74 5.50% 1. What can Mr. Ptolemy do to achieve the gross margin percentage goal set for the third and fourth years? Hint: What factors and elements of a P & L statement affect gross margin %?(List at least 2 things) 2. What efforts should Mr. Ptolemy make in the third and…arrow_forward
- Profit Center Responsibility Reporting Championship Sports Inc. operates two divisions-the Winter Sports Division and the Summer Sports Division. The following income and expense accounts were provided from the trial balance as of December 31, 20Y9, the end of the fiscal year, after all adjustments, including those for inventories, were recorded and posted: Sales-Winter Sports Division Sales-Summer Sports Division Cost of Goods Sold-Winter Sports Division Cost of Goods Sold-Summer Sports Division Sales Expense-Winter Sports Division Sales Expense-Summer Sports Division Administrative Expense-Winter Sports Division Administrative Expense-Summer Sports Division Advertising Expense Transportation Expense $28,350,000 31,320,000 17,010,000 18,090,000 4,860,000 4,320,000 2,835,000 2,781,000 990,000 524,800 252,000 2,700,000 Accounts Receivable Collection Expense Warehouse Expense The bases to be used in allocating expenses, together with other information, are as follows: a. Advertising…arrow_forwardquestion O C. Work in Progress Finished Product 48 Given the following data; TOTAL SALES OMR 250000 CASH SALES OMR 125000 SALES RETURN OMR 5000 OPENING SUNDRY DEBTORS OMR 20000 CLOSING SUNDRY DEBTORS OMR 10000 What will be the average debtors? ut of O a. OMR 15000 uestion O b. OMR 7500 O c. OMR 30000 O d. OMR 10000 pe here to search Pa lenovoarrow_forwardOBJECTIVE: 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…arrow_forward
- E1-23A. (Learning Objective 4: Identify financial statement by type of information) ButlerTech, Inc., is expanding into India. The company must decide where to locate and how tofinance the expansion. Identify the financial statement where these decision makers can findthe following information about Butler Tech, Inc. In some cases, more than one statement willreport the needed data.a. Revenueb. Common stockc. Current liabilitiesd. Long-term debte. Dividendsf. Ending cash balanceg. Adjustments to reconcile net income tonet cash provided by operationsh. Cash spent to acquire the buildingi. Income tax expensej. Ending balance of retained earningsk. Selling, general, and administrativeexpensel. Total assetsm. Net incomen. Income tax payablearrow_forward5. Revenue and expense data for Young Technologies Inc. are as follows: Year 2 Year 1 Sales $500,000 $440,000 Cost of goods sold 325,000 242,000 Selling expenses 70,000 79,200 Administrative expenses 75,000 70,400 Income tax expense 10,500 16,400 Required: a. Prepare an income statement in comparative form, stating each item for both years as an amount and as a percent of sales. Round percentage amounts to nearest whole percent. ... b. Complete the following regarding the significant changes disclosed by the comparative income statement. The vertical analysis indicates that the cost of goods sold as a percent of sales (increased/decreased) between the two years. Selling and administrative expenses as a percentage of sales (increased/decreased) and income tax expense (increased/decreased). Overall, net income as a percent of sales (increased/decreased).arrow_forwardBusiness Studies / Business Math / Semester 2, 2020/2021 / BUSINESS MATH M Cost of an item is OMR 335, If the markup is 28% on the cost, find the selling price; ed O a. OMR 93.8 rked out of 1.00 O b. OMR 126 O. OMR 241.2 Next page 2g question O d. OMR 429 Course Orientation Business Math Jump to... TOSHIBAarrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education
Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON
Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:9781259726705
Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:McGraw-Hill Education
Economic Value Added EVA - ACCA APM Revision Lecture; Author: OpenTuition;https://www.youtube.com/watch?v=_3hpcMFHPIU;License: Standard Youtube License