Managerial Accounting: Tools for Business Decision Making
7th Edition
ISBN: 9781118334331
Author: Jerry J. Weygandt, Paul D. Kimmel, Donald E. Kieso
Publisher: WILEY
expand_more
expand_more
format_list_bulleted
Question
Chapter 14, Problem 14.1DI
To determine
Horizontal Analysis: Horizontal analysis is a tool for financial analysis. It reports the amount and percentage change in financial data for different years.
To prepare: Horizontal analysis for Company W.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
The 2017 Annual Report of Tootsie Roll Industries contains the following information.
(in millions)
December 31, 2017
December 31, 2016
Total assets
$930.9
$920.1
Total liabilities
197.1
208.6
Net sales
515.7
517.4
Net income
80.7
67.2
Compute the following ratios for Tootsie Roll for 2017.
(a)
Asset turnover (Round answer to 3 decimal places, e.g. 0.851 times.)
enter the asset turnover rounded to 4 decimal places
times
(b)
Return on assets (Round answer to 2 decimal places, e.g. 4.87%.)
enter the return on assets in percentages rounded to 2 decimal places
%
(c)
Profit margin on sales (Round answer to 2 decimal places, e.g. 4.87%.)
enter the profit margin on sales in percentages rounded to 3 decimal places
%
The 2017 annual report of Tootsie Roll Industries contains the following information.
(in millions)
December 31, 2017
0000
December 31, 2016
Total assets
$930.9
$920.1
Total liabilities
197.1
208.6
Net sales
515.7
517.4
Net income
80.7
67.2
Instructions
Compute the following ratios for Tootsie Roll for 2017.
a. Asset turnover.
b. Return on assets.
c. Profit margin on sales.
d. How can the asset turnover be used to compute the return on assets?
Financial information for Powell Panther Corporation is shown below:
Powell Panther Corporation: Income Statements for Year Ending December 31 (Millions of Dollars)
2018
Sales
$
1,625.0
$
2017
1,300.0
Operating costs excluding depreciation and amortization
1,300.0
1,105.0
EBITDA
$
325.0
$
195.0
Depreciation and amortization
39.0
31.0
Earnings before interest and taxes (EBIT)
$
286.0
$
164.0
Interest
36.0
29.0
Earnings before taxes (EBT)
$
250.0
$
135.0
Taxes (40%)
100.0
54.0
Net income
$
150.0
$
81.0
Common dividends
$
135.0
$
65.0
Powell Panther Corporation: Balance Sheets as of December 31 (Millions of Dollars)
2018
Assets
Cash and equivalents
$
23.0
$
2017
18.0
Accounts receivable
164.0
143.0
Inventories
343.0
312.0
Total current assets
$
530.0
$
473.0
Net plant and equipment
390.0
312.0
Total assets
$
920.0
$
785.0
Liabilities and Equity…
Chapter 14 Solutions
Managerial Accounting: Tools for Business Decision Making
Ch. 14 - (a) Jose Ramirez believes that the analysis of...Ch. 14 - (a) Distinguish among the following bases of...Ch. 14 - Prob. 3QCh. 14 - Prob. 4QCh. 14 - Prob. 5QCh. 14 - Prob. 6QCh. 14 - Prob. 7QCh. 14 - What do the following classes of ratios measure?...Ch. 14 - What is the difference between the current ratio...Ch. 14 - Hizar Company, a retail store, has an accounts...
Ch. 14 - Which ratios should be used to help answer the...Ch. 14 - The price-earnings ratio of General Motors...Ch. 14 - What is the formula for computing the payout...Ch. 14 - Holding all other factors constant, indicate...Ch. 14 - Prob. 15QCh. 14 - Prob. 16QCh. 14 - Prob. 17QCh. 14 - Prob. 18QCh. 14 - Prob. 19QCh. 14 - Why is it important to report discontinued...Ch. 14 - You are considering investing in Wingert...Ch. 14 - Prob. 22QCh. 14 - Prob. 23QCh. 14 - You recently received a letter from your Uncle...Ch. 14 - Prob. 14.2BECh. 14 - Using the following data from the comparative...Ch. 14 - Using the same data presented above in BE14-3 for...Ch. 14 - Net income was 500,000 in 2016, 450,000 in 2017,...Ch. 14 - Prob. 14.6BECh. 14 - Prob. 14.7BECh. 14 - Prob. 14.8BECh. 14 - Prob. 14.9BECh. 14 - Prob. 14.10BECh. 14 - The following data are taken from the financial...Ch. 14 - Prob. 14.12BECh. 14 - Prob. 14.13BECh. 14 - Prob. 14.14BECh. 14 - On June 30. Holloway Corporation discontinued its...Ch. 14 - Prob. 14.1DICh. 14 - Prob. 14.2DICh. 14 - In its proposed 2017 income statement. Hrabik...Ch. 14 - Financial information for Kurzen Inc. is presented...Ch. 14 - Operating data for Navarro Corporation are...Ch. 14 - The comparative condensed balance sheets of Gurley...Ch. 14 - The comparative condensed income statements of...Ch. 14 - Suppose Nordstrom, Inc., which operates department...Ch. 14 - Keener Incorporated had the following transactions...Ch. 14 - Frizell Company has the following comparative...Ch. 14 - Prob. 14.8ECh. 14 - Prob. 14.9ECh. 14 - Prob. 14.10ECh. 14 - Wiemers Corporations comparative balance sheets...Ch. 14 - Prob. 14.12ECh. 14 - Prob. 14.13ECh. 14 - Comparative statement data for Farris Company and...Ch. 14 - The comparative statements of Painter Tool Company...Ch. 14 - Prob. 14.3APCh. 14 - Financial information for Messersmith Company is...Ch. 14 - Prob. 14.5APCh. 14 - Prob. 14.6APCh. 14 - Prob. 14.7APCh. 14 - Prob. 14.8APCh. 14 - Prob. 14.9APCh. 14 - Financial Reporting Problem: Apple Inc. Your...Ch. 14 - PepsiCos financial statements are presented at...Ch. 14 - Prob. 14.3BYPCh. 14 - As the CPA for Gandara Manufacturing Inc., you...Ch. 14 - The Management Discussion and Analysis section of...Ch. 14 - Prob. 14.6BYPCh. 14 - Dave Schonhardt, president of Schonhardt...
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
- Summary financial information for Gandaulf Company is as follows. Compute the amount and percentage changes in 2022 using horizontal analysis, assuming 2024 is the base year. (Enter negative amounts and percentages using either a negative sign preceding the number e.g. -45,-45% or parentheses e.g. (45), (45%). Round percentages to 2 decimal places, e.g. 1.25%.) Current Assets Dec. 31, 2022 Dec. 31, 2024 $191,100 $210,000 $ Plant Assets 1,058,600 790,000 Total assets $1,249,700 $1,000,000 $ Increase (Decrease) in 2022 Amount Percent % % %arrow_forwardFinancial information for Sarfaraz Co. is presented below December 31. 2018 December 31, 2017 Current Assets RS. 128,000 Rs. 100,000 Plant Assets 396,000 330,000 Current Liabilities 91,000 70,000 Long- Term Liabilities 138,700 95,000 CommonStockRs.1 par 159,000 115,000 Retained Earning 135,300 150,000 Required: Prepare a schedule showing a horizontal analysis 2018 using 2017 as the base yeararrow_forwardUsing the information below calculate the ROC of the company Years Revenue ($M) Net Income ($M) 2012 221.8 2.9 2013 473.8 20.2 2014 627.7 36.4 2015 947.8 45.0 2016 1,015.5 50.3 2017 1,046.2 64.9 2018 1,293.2 90.4 Years Total Assets ($M) Fixed Assets ($M) Current Assets ($M) Total Equity ($M) Retained Earnings ($M) 2012 430 286 144 293 12.8 2013 956 501 455 558 33.0 2014 922 668 324 620 69.4 2015 1103 796 307 665 114.4 2016 1120 835 285 729 164.7 2017 1294 738 556 805 229.6 2018 2053 703 1350 934 320arrow_forward
- Selected information about income statement accounts for the Reed Company is presented below (the company's fiscal year ends on December 31): 2018 2017 Sales $ 4,550,000 $ 3,650,000 Cost of goods sold 2,890,000 2,030,000 Administrative expenses 830,000 705,000 Selling expenses 390,000 342,000 Interest revenue 153,000 143,000 Interest expense 206,000 206,000 Loss on sale of assets of discontinued component 62,000 — On July 1, 2018, the company adopted a plan to discontinue a division that qualifies as a component of an entity as defined by GAAP. The assets of the component were sold on September 30, 2018, for $62,000 less than their book value. Results of operations for the component (included in the above account balances) were as follows: 1/1/18-9/30/18 2017 Sales $ 430,000 $ 530,000 Cost of goods sold (305,000 ) (338,000 ) Administrative expenses (53,000 ) (43,000 ) Selling…arrow_forwardOperating data for Flounder Corp. are presented below. 2017 2016 Sales revenue $825,400 $628,400 Cost of goods sold 527,300 412,700 Selling expenses 125,600 76,800 Administrative expenses 75,500 52,800 Income tax expense 36,700 29,200 Net income 60,300 56,900 Prepare a schedule showing a vertical analysis for 2017 and 2016. (Round percentages to 1 decimal place, e.g. 12.1%.)arrow_forwardČardinal Industries had the following operating results for 2018: Sales = $34,621; Cost of goods sold Dividends paid = $2,023. At the beginning of the year, net fixed assets were $19,970, current assets were $7,075, and current liabilities were $4,01O. At the end of the year, net fixed assets were $24,529, current assets were $8,702, and current liabilities were $4,700. The tax rate for 2018 was 25 percent. $24,359; Depreciation expense = $6,027; Interest expense $2,725; %3D a. What is net income for 2018? (Do not round intermediate calculations.) b. What is the operating cash flow for 2018? (Do not round intermediate calculations.) c. What is the cash flow from assets for 2018? (Do not round intermediate calculations. A negative answer should be indicated by a minus sign.) d- If no new debt was issued during the year, what is the cash flow to creditors? (Do not 1. round intermediate calculations.) d- If no new debt was issued during the year, what is the cash flow to stockholders? (Do…arrow_forward
- The balance sheet of Huan Corporation reported net fixed assets of $332,000 at the end of 2018. The fixed- asset turnover ratio for 2018 was 4.0, and sales for the year totaled $1,540,000. Net fixed assets at the end of 2017 were: A. $491,000. B. $385,000. C. $438,000 D. $408,000arrow_forwardPohio Corp. reported total assets of $500000, $400000, $370000 in the year 2016, 2015 and 2014 respectively. If 2015 is the base year, what is the percentage change for 2016? 45% 25% 35% 15%arrow_forwardUse the following tables to answer the question: LOGIC COMPANY Income Statement For years ended December 31, 2016 and 2017 (values in $) 2016 2017 Gross sales 19,800 15,600 Sales returns and allowances 900 100 Net sales 18,900 15,500 COGS 11,800 8,800 Gross profit 7,100 6,700 Depreciation 780 640 Selling and administrative expenses 2,800 2,400 Research 630 540 Miscellaneous 440 340 Total operating expenses 4,650 3,920 Income before interest and taxes 2,450 2,780 Interest expense 640 540 Income before taxes 1,810 2,240 Provision for taxes 724 896 LOGIC COMPANY Balance Sheet For years ended December 31, 2016 and 2017 (values in $) 2016 2017 Current assets 12,300 9,400 Accounts receivable 16,900 12,900 Merchandise inventory 8,900 14,400 Prepaid expenses 24,400 10,400 Total current assets 62,500 47,100 Building (net) 14,900 11,400 Land 13,900 9,400 Total plant and equipment 28,800 20,800 Total assets 91,300 67,900 Accounts payable 13,400 7,400 Salaries payable 7,500 5,400 Total current…arrow_forward
- Suppose in its 2017 annual report that McDonald's Corporation reports beginning total assets of $29.90 billion, ending total assets of $32.25 billion, net sales of $22.60 billion, and net income of $4.80 billion. (a) Compute McDonald's return on assets. (Round return on assets to 2 decimal places, e.g. 5.12%.) McDonald's return on assets % (b) Compute McDonald's asset turnover. (Round asset turnover to 2 decimal places, e.g. 5.12.) McDonald's asset turnover timesarrow_forward3. Complete the below table to calculate the balance sheet data in trend percents with 2017 as base year. (Round your percentage answers to 2 decimal places.) KORBIN COMPANY Balance Sheet Data in Trend Percents December 31, 2019, 2018 and 2017 2019 2018 2017 Assets Current assets % % 100.00 % Long-term investments 100.00 Plant assets, net 100.00 Total assets % % 100.00 % Liabilities and Equity Current liabilities % % 100.00 % Common stock 100.00 Other paid-in capital 100.00 Retained earnings 100.00 Total liabilities and equity % % 100.00 % see picturesarrow_forwardThe income statement of a corporation shows the following balance in Sales Revenue for the years 2017, 2016, and 2015. 2017: $676,000 2016: $625,000 2015: $610,000 Performing horizontal analysis on Sales Revenue would result in what percentage change for 2017? (Round to two decimal places.) 8% 108% 2% 11%arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Financial AccountingAccountingISBN:9781305088436Author:Carl Warren, Jim Reeve, Jonathan DuchacPublisher:Cengage LearningCornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage Learning
Financial Accounting
Accounting
ISBN:9781305088436
Author:Carl Warren, Jim Reeve, Jonathan Duchac
Publisher:Cengage Learning
Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning
IAS 29 Financial Reporting in Hyperinflationary Economies: Summary 2021; Author: Silvia of CPDbox;https://www.youtube.com/watch?v=55luVuTYLY8;License: Standard Youtube License