Financial Accounting, Student Value Edition Plus MyLab Accounting with Pearson eText -- Access Card Package (5th Edition)
5th Edition
ISBN: 9780134833170
Author: Robert Kemp, Jeffrey Waybright
Publisher: PEARSON
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: 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…
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,000
1. 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.
Chapter 12 Solutions
Financial Accounting, Student Value Edition Plus MyLab Accounting with Pearson eText -- Access Card Package (5th Edition)
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 - Horizontal analysis(Learning Objective 2)15-20 min...Ch. 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 - Horizontal analysis(Learning Objective 2)15-20...Ch. 12 - Prob. 26BECh. 12 - Prob. 27BECh. 12 - Prob. 28BECh. 12 - Prob. 29BECh. 12 - Prob. 30BECh. 12 - Trend percentages and return on assets (Learning...Ch. 12 - Common-size financial statements and profitability...Ch. 12 - Current ratio, debt ratio, EPS (Learning Objective...Ch. 12 - Calculating various ratios for analysis (Learning...Ch. 12 - Prob. 35APCh. 12 - Prob. 36APCh. 12 - Trend percentages and return on assets (Learning...Ch. 12 - Common-size financial statements and profitability...Ch. 12 - Prob. 39BPCh. 12 - Calculating various ratios for analysis(Learning...Ch. 12 - Calculating various ratios for analysis (Learning...Ch. 12 - Prob. 42BPCh. 12 - Prob. 1CECh. 12 - Prob. 1CPCh. 12 - Prob. 1EIACh. 12 - Prob. 2EIACh. 12 - Prob. 1FACh. 12 - Industry Analysis Purpose: To help you understand...Ch. 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
- < + .. + Sheet1 FINA310 IP TEMPLATE FOR STUDENTS Student name: Date: ACTUAL FORECAST Current Year Next Year Total Revenue 71,879 Cost of Revenue (51,125) Gross Profit 20,754 Operating Expenses: Selling, General, and Administrative (14,248) Research and Development Special Income/Other Charges S (2,194) Total Operating Expenses (16,442) Operating Income S 4,312 Net Interest Income (666) edite Pre-Tax Income 3,646 Provision for Income Tax (19.5%) (711) Net Income 2,935arrow_forwardThe 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_forward(Learning Objective 6: Analyze and evaluate liquidity and debt-paying ability) LO 6McClain Company’s condensed and adapted balance sheet at December 31, 2018, follows:(In millions)Total current assets....................................................... $15.9Property, plant, equipment, and other assets................. 16.2$32.1Total current liabilities.................................................. $ 9.6Total long-term liabilities.............................................. 5.5Total shareholders’ equity............................................. 17.0$32.1Assume that during the first quarter of the following year, 2019, McClain completed the following transactions:a. Earned revenue of $2.8 million, on account.b. Borrowed $7.0 million in long-term debt.c. Paid half of the current liabilities.d. Paid selling expense of $0.6 million.e. Accrued general expense of $0.8 million. Credit General Expense Payable, a currentliability.f. Purchased equipment for $4.6 million, paying cash…arrow_forward
- E-17 Computing working capital changesarrow_forwardPlease assist with 3.2arrow_forwardProblem Solving. Raymar Alison Trading has the following transactions during the fiscal year 2021. Cash sales 100,0000. Credit Sales 200,000. Total Sales 300,000. Cost of Goods Sold 150,000. Gross Margin 150,000. Beg. Accounts Receivable 25,000. End. Accounts Receivable 15,000. Beg. Inventory 35,000. End. Inventory 25,000. Total Expenses 50,000. 27. What is Days Sales Outstanding? (360 days) * 18 24 36 72arrow_forward
- Please refer to screenshots for questionarrow_forwardProblem Solving. Raymar Alison Trading has the following transactions during the fiscal year 2021. Cash sales 100,0000. Credit Sales 200,000. Total Sales 300,000. Cost of Goods Sold 150,000. Gross Margin 150,000. Beg. Accounts Receivable 25,000. End. Accounts Receivable 15,000. Beg. Inventory 35,000. End. Inventory 25,000. Total Expenses 50,000. 29. What is Days Inventory Outstanding? (360 days) 18 24 36 72arrow_forwardDiaz Fresh discloses the following annual data. For Year Ended December 31 2020 2021 Sales revenue. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . $160,000 $240,000 Cost of goods sold . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 80,000 120,000 Its cost of goods sold is based on inventories valued at cost. Assume for each year that all of the beginning inven- tory is sold by year end. Additional information regarding its inventories follows. Inventory LIFO Cost Market January 1, 2020 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . $12,000 $16,000 December 31, 2020 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20,000 18,000 December 31, 2021 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 26,000 20,000 Required a. Prepare the entries to apply the lower-of-cost-or-market rule at December 31, 2020, and 2021. Use an allow- ance account to reduce…arrow_forward
- a. Date formats b. Profit & Loss Standard report c. % of Income d. QuickZoom e. Without Cents f. Divided by 1000 g. Previous Period $ Change h. Previous Period % Change i. To date ________ The end of the reporting period. ________ When selected in the Modify Report window, this check box requires QuickBooks Accountant to report amounts in thousands. ________ Adds a subcolumn to a Profit & Loss report that calculates the relative percentage change in each item from a previous period. ________ The beginning of the reporting period. ________ A financial statement reporting the revenues and expenses of a business for a specific accounting period. ________ Adds a subcolumn to a Profit & Loss report that calculates the amount of change in each item from a previous period. ________ A preference option that specifies whether years in date fields are shown as two digits or four digits. ________ A feature in QuickBooks Accountant that allows you to view the transaction details…arrow_forwardEnrichment Activity 7-2. Horizontal Analysis Complete the horizontal analysis and interpretation of Financial Performance of Robero Sumaleng's Merchandising: (Use percentages in two decimal places.) Rober Sumaleng's Merchandising Statement of Comprehensive Income For the years ended December 31 2021 2020 Inc/(Dec) Amount Percent Sales 942,500 40,750 901,750 508,200 393,550 875,400 42,221 833,179 421,900 411,279 Less: Sales Discounts Net Sales P Less: Cost of Goods Sold Gross Profit Less: Operating Expenses Distribution Costs 92,450 108,200 200,650 192,900 57,870 135,030 115,320 118,300 Administrative Expenses Total Operating Expenses P Net Inconme before Tax 233,620 177,659 53,298 124,361 P Less: Income Tax Net Income after Tax P Write your interpretation and analysis in no less than four sentences.arrow_forwardIncome Statement Bob's Bistro produces party-sized hoagie sandwiches. For next year, Bob's Bistro predicts that 53,000 units will be produced with the following total costs: Direct materials Direct labor Variable overhead Fixed overhead Beginning Ending ? Next year, Bob's Bistro expects to purchase $126,000 of direct materials. Projected beginning and ending inventories for direct materials and work in process are as follows: Direct materials Inventory $5,000 $4,900 $73,000 27,000 230,000 Work-in-Process Inventory $13,700 $15,700 Next year, Bob's Bistro expects to produce 53,000 units and sell 52,300 units at a price of $13.00 each. Beginning inventory of finished goods is $47,500, and ending inventory of finished goods is expected to be $39,000. Total selling expense is projected at $22,000, and total administrative expense is projected at $117,500. Required: 1. Prepare an income statement in good form. Round the percent to four decimal places before converting to a percentage. For…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Pfin (with Mindtap, 1 Term Printed Access Card) (...FinanceISBN:9780357033609Author:Randall Billingsley, Lawrence J. Gitman, Michael D. JoehnkPublisher:Cengage Learning
Pfin (with Mindtap, 1 Term Printed Access Card) (...
Finance
ISBN:9780357033609
Author:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk
Publisher:Cengage Learning
Economic Value Added EVA - ACCA APM Revision Lecture; Author: OpenTuition;https://www.youtube.com/watch?v=_3hpcMFHPIU;License: Standard Youtube License