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
Videos
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 solution
Students have asked these similar questions
(Compute Income Measures) Presented below is information related to Viel Company at December 31, 2017, the end of its first year of operations.
Sales revenue
$310,000
Cost of goods sold
140,000
Selling and administrative expenses
50,000
Gain on sale of plant assets
30,000
Unrealized gain on available-for-sale investments
10,000
Interest expense
6,000
Loss on discontinued operations
12,000
Dividends declared and paid
5,000
InstructionsCompute the following: (a) income from operations, (b) net income, (c) comprehensive income, and (d) retained earnings balance at December 31, 2017. (Ignore income tax effects.)
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…
Financial information for Kurzen INC. is presented below.
December 31, 2017
December 31, 2016
Current assets
$125,000
$100,000
Plant assets (net)
396,000
330,000
Current liabilities
91,000
70,000
Long - term liabilities
133,000
95,000
Common stock, $1 par
161,000
115,000
Retained earnings
136,000
150,000
Instructions:
Prepare a schedule showing a horizontal analysis for 2017 using 2016 as the base year?
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
- The comparative balance sheet of Prime Sports Gear, Inc., at December 31, the end of the fiscal year, is as follows: Additional data obtained from the records of Prime Sports Gear are as follows: a. Net income for 2013 was 121,610. b. Depreciation reported on income statement for 2013 was 46,500. c. Purchased 165,000 of new equipment, putting 90,000 cash down and issuing 75,000 of bonds for the balance. d. Old equipment originally costing 19,500, with accumulated depreciation of 7,950, was sold for 8,000. e. Retired 60,000 of bonds. f. Declared cash dividends of 64,000. g. Issued 1,500 shares of common stock at 27 cash per share. Open the file CASHFLOW from the website for this book at cengagebrain.com. First, enter the formulas. Then, complete the worksheet in the manner described next. According to the problem, cash increased from 39,600 to 67,210 during the year. This is a 27,610 increase. To record this increase on the worksheet, move to row 17. Since this is the first account you are analyzing, enter the letter a in column C. Then enter 27610 in column D (a debit since cash increased). This brings the year-end balance (column G) to 67,210, its proper balance. Now move to the bottom part of the statement where you see the categories Operating Activities, Investing Activities, and so on. The credit side of the entry has to be entered here. The proper space for this cash entry is on row 59. Enter the letter a in cell E59 and 27610 in cell F59. Notice the totals at the bottom of the page (row 60) now agree. The next account balance that changed is accounts receivable. It increased by 9,035. To enter this change on the worksheet, enter the letter b in cell C18 and 9035 in cell D18 (again, a debit since accounts receivable increased). This brings the year-end balance in column G to 121,250, its proper balance. The change in accounts receivable balance is an operating activity adjustment (as explained in your textbook). Enter the credit side of this entry in cells E34 and F34, and enter the explanation Increase in accounts receivable in cell A34. Note: Your textbook probably shows Net income as the first item under Operating Activities. We will get to that later. The sequence in which you enter items on this worksheet is not important. All other balance sheet accounts must be analyzed in the same manner, placing appropriate debit or credit entries in the top part of the worksheet to obtain the proper balances in column G, and then entering the second side of the entry in the appropriate row on the bottom part of the worksheet. You should use letter references to identify all entries. Also, you must enter a description of the entry in column A under the appropriate activity category. Although a sequence of analyzing the balance sheet from top to bottom is suggested here, this order is not necessary. As mentioned earlier, your textbook may specify a different sequence. Also, note that some accounts may have both debit and credit adjustments to them. The worksheet is not a substitute for a statement of cash flows, but it does provide you with all the numbers you need to properly prepare one. You will be done with your analysis when: a. The individual account balances at December 31, 2013, as shown on the worksheet (column G) equal those shown in the given problem data. b. The transaction column totals are equal (cells D60 and F60). c. The sum of the operating, investing, and financing activities (cell G59) equals the change in cash (cell D59 or F59). When you are finished, enter your name in cell A1. Save your completed file as CASHFLOW2. Print the worksheet when done. Also print your formulas. Check figure: Total credits at 12/31/2013 (cell G31), 860,460.arrow_forwardThe comparative balance sheet of Prime Sports Gear, Inc., at December 31, the end of the fiscal year, is as follows: Additional data obtained from the records of Prime Sports Gear are as follows: a. Net income for 2013 was 121,610. b. Depreciation reported on income statement for 2013 was 46,500. c. Purchased 165,000 of new equipment, putting 90,000 cash down and issuing 75,000 of bonds for the balance. d. Old equipment originally costing 19,500, with accumulated depreciation of 7,950, was sold for 8,000. e. Retired 60,000 of bonds. f. Declared cash dividends of 64,000. g. Issued 1,500 shares of common stock at 27 cash per share. You have been asked to prepare a statement of cash flows for Prime Sports Gear for 2013. Review the worksheet called CASHFLOW that has been provided to assist you in preparing the statement. The worksheet has been designed so that as you make entries in columns D and F, column G will be automatically updated. For example, FORMULA1 should be entered as =B17+D17F17. Columns C and E are to be used to enter letter references for each of the debit and credit entries on the worksheet.arrow_forwardCALCULATING THE WACC Here is the condensed 2016 balance sheet for Skye Computer Company (in thousands of dollars): 2016 Current assets 2,000 Net fixed assets 3,000 Total assets 5,000 Accounts payable and accruals 900 Short-term debt 100 Long-term debt 1,100 Preferred stock (10,000 shares) 250 Common stock (50,000 shares) 1.300 Retained earnings 1,350 Total common equity 52,650 Total liabilities and equity 5,000 Skyes earnings per share last year were 3.20. The common stock sells for 55.00, Last year's dividend (Do) was 2.10, and a flotation cost of 10% would be required to sell new common stock. Security analysts are projecting that the common dividend will grow at an annual rate of 9%. Skye's preferred stock pays a dividend of 3.30 per share, and its preferred stock sells for 30.00 per share. The firm's before-tax cost of debt is 10%, and its marginal tax rate is 35%. The firms currently outstanding 10% annual coupon rate, long-term debt sells at par value. The market risk premium is 5%, the risk-free rate is 6%, and Skyes beta is 1.516. The firms total debt, which is the sum of the companys short-term debt and Long-term debt, equals 1.2 million. a. Calculate the cost of each capital component, that is, the after-tax cost of debt, the cost of preferred stock, the cost of equity from retained earnings, and the cost of newly issued common stock. Use the DCF method to find the cost of common equity. b. Now calculate the cost of common equity from retained earnings, using the CAPM method. c. What is the cost of new common stock based on the CAPM? (Hint: Find the difference between rc and rs. as determined by the DCF method, and add that differential to the CAPM value for rs) d. If Skye continues to use the same market-value capital structure, what is the firms WACC assuming that (1) it uses only retained earnings for equity? (2) If it expands so rapidly that it must issue new common stock?arrow_forward
- The plant assets section of the comparative balance sheets of Anders Company is reported below. ANDERS COMPANY Comparative Balance Sheets 2017 2016 Plant assets Equipment $ 180,000 $ 270,000 Accum. Depr.—Equipment (100,000 ) (210,000 ) Equipment, net $ 80,000 $ 60,000 Buildings $ 380,000 $ 400,000 Accum. Depr.—Buildings (100,000 ) (285,000 ) Buildings, net $ 280,000 $ 115,000 During 2017, a building with a book value of $70,000 and an original cost of $300,000 was sold at a gain of $60,000. 1. How much cash did Anders receive from the sale of the building?2. How much depreciation expense was recorded on buildings during 2017?3. What was the cost of buildings purchased by Anders during 2017?arrow_forwardOperating data for Navarro Corporation are presented below: 2017 2016 Net sales $750,000 $600,000 Cost of goods sold 465,000 390,000 Selling expenses 105,000 66,000 Administrative expenses 60,000 54,000 Income tax expense 36,000 27,000 Net income 84,000 63,000 Instructions: Prepare a schedule showing a vertical analysis for 2017 and 2016?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_forward
- In its 2017 annual report, Campbell Soup Company reports beginning-of-the-year total assets of $7,837 million, end-of-the-year total assets of $7,726 million, total sales of $7,890 million, and net income of $887 million. (a) Compute Campbell’s asset turnover. (b) Compute Campbell’s profit margin on sales. (c) Compute Campbell’s return on assets using (1) asset turnover and profit margin and (2) net income. (Round to two decimal places.)arrow_forwardThe condensed financial statements of Marks Company for the years 2017-2018 are presented below: Marks CompanyComparative Balance SheetsAs of December 31, 2017 and 2018 2018 2017 Cash $404,000 $155,000 Accounts receivable (net) 356,000 300,000 Inventories 375,000 339,000 Plant and equipment 1,830,000 1,121,000 Accumulated depreciation (260,000 ) (193,000 ) $2,705,000 $1,722,000 Accounts payable $339,000 $164,000 Dividends payable -0- 45,000 Bonds payable 405,000 -0- Common stock ($10 par) 1,521,000 1,230,000 Retained earnings 440,000 283,000 $2,705,000 $1,722,000 Additional data: Market value of stock at 12/31/18 is $80 per share. Marks sold 30,000 shares of common stock at par on July 1, 2018. Marks CompanyCondensed…arrow_forwardFollowing are selected balance sheet accounts of Del Conte Corp. at December 31, 2018 and 2017, and the increases or decreases in each account from 2017 to 2018. Also presented is selected income statement information for the year ended December 31, 2018, and additional information. Selected Balance Sheet Accounts 2018 2017 Increase(Decrease) Assets Accounts receivable $ 54,000 $ 34,000 $ 20,000 Property, plant, and equipment 297,000 257,000 40,000 Accumulated depreciation (198,000 ) (177,000 ) 21,000 Liabilities and Stockholders’ Equity Bonds payable 79,000 66,000 13,000 Dividends payable 13,000 9,000 4,000 Common stock, $1 par 42,000 29,000 13,000 Additional paid-in capital 14,000 7,000 7,000 Retained earnings 124,000 101,000 23,000 Selected Income Statement Information for the Year Ended December 31, 2018 Sales…arrow_forward
- Samuel Corp. has provided the following information for the year ended December 31, 2018. Samuel Corp Comparative Balance Sheet December 31, 2018 and 2017 2018 2017 Inc/(dec) Current Assets: Cash $33,000 $13,000 $20,000 Accounts Receiveable 29,000 36,000 (7,000) Inventory 56,000 29,000 27,000 Plant Assets, net 126,000 92,000 34,000 Total Assets $244,000 $170,000 $74,000 Accounts Payable $9,000 $13,000 $(4,000) Accrued Liabilities 7,000 3,000 4,000 Long-Term Notes Payable 70,000 79,000 (9,000) Total Liabilities 86,000 95,000 (9,000) Common Stock $55,000 $3,000 $52,000 Retained Earnings 115,000 78,000 37,000 Treasury Stock (12,000) (6,000) (6,000) Total Stockholders' Equity $158,000 $75,000 $83,000 Total Liabilities and Stockholders Equity $244,000 $170,000 $74,000 Samuel Corp Income…arrow_forwardThe comparative statement of financial position for Cullumber Corporation shows the following noncash current asset and liability accounts at March 31: 2018 2017 Accounts receivable $61,000 $43,000 Inventory 70,000 64,000 Accounts payable 35,000 43,000 Dividends payable 1,400 2,300 Cullumber’s income statement reported the following selected information for the year ended March 31, 2018: net income was $280,000, depreciation expense was $60,000, and a loss on the disposal of land was $18,000. Cullumber uses a perpetual inventory system. Calculate net cash provided (used) by operating activities using the indirect method. (Show amounts that decrease cash flow with either a - sign e.g. -15,000 or in parenthesis e.g. (15,000).) CULLUMBER CORPORATIONStatement of Cash Flows (Partial)-Indirect Method Operating activities…arrow_forwardCardinal Industries had the following operating results for 2018: Sales = $34,318; Cost of goods sold = $24,212; Depreciation expense = $5,997; Interest expense = $2,710; Dividends paid = $1,996. At the beginning of the year, net fixed assets were $19,940, current assets were $7,054, and current liabilities were $3,992. At the end of the year, net fixed assets were $24,502, current assets were $8,684, and current liabilities were $4,673. The tax rate for 2018 was 22 percent. 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-1. If no new debt was issued during the year, what is the cash flow to creditors? (Do not round intermediate calculations.) d-2. If no new debt was issued during the year, what is the cash flow…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 Learning
EBK CONTEMPORARY FINANCIAL MANAGEMENTFinanceISBN:9781337514835Author:MOYERPublisher:CENGAGE LEARNING - CONSIGNMENT
Financial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage Learning
Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning
Fundamentals of Financial Management, Concise Edi...FinanceISBN:9781305635937Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage Learning
Financial Accounting
Accounting
ISBN:9781305088436
Author:Carl Warren, Jim Reeve, Jonathan Duchac
Publisher:Cengage Learning
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:9781337514835
Author:MOYER
Publisher:CENGAGE LEARNING - CONSIGNMENT
Financial Accounting: The Impact on Decision Make...
Accounting
ISBN:9781305654174
Author:Gary A. Porter, Curtis L. Norton
Publisher:Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Fundamentals of Financial Management, Concise Edi...
Finance
ISBN:9781305635937
Author:Eugene F. Brigham, Joel F. Houston
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