(a) Notes receivable (b) Accounts receivable (c) Retained earnings (d) Sales (e) Operating expenses (f) Income taxes payable a. b. Using horizontal analysis, show the percentage change and direction (increase or decrease) from Year 1 to Year 2 with Year 1 as the base year. If an item is impossible to compute, enter a "0" in the percentage box and select "No possible to compute" in the narrative box. C. d. e. f. X % X% X % X % X % Year 2 $25,500 106,200 77,000 654,000 160,000 28,000 X % Decrease Increase Increase Increase Decrease Year 1 Increase $30,000 90,000 70,000 600,000 200,000 20,000 ✓ ✓ ✓ ✓

(a) Notes receivable (b) Accounts receivable (c) Retained earnings (d) Sales (e) Operating expenses (f) Income taxes payable a. b. Using horizontal analysis, show the percentage change and direction (increase or decrease) from Year 1 to Year 2 with Year 1 as the base year. If an item is impossible to compute, enter a "0" in the percentage box and select "No possible to compute" in the narrative box. C. d. e. f. X % X% X % X % X % Year 2 $25,500 106,200 77,000 654,000 160,000 28,000 X % Decrease Increase Increase Increase Decrease Year 1 Increase $30,000 90,000 70,000 600,000 200,000 20,000 ✓ ✓ ✓ ✓

Managerial Accounting

15th Edition

ISBN:9781337912020

Author:Carl Warren, Ph.d. Cma William B. Tayler

Publisher:Carl Warren, Ph.d. Cma William B. Tayler

Chapter16: Financial Statement Analysis

Section: Chapter Questions

Problem 9BE

See similar textbooks

Similar questions

A. Prepare a comparative income statement with horizontal analysis, indicating the increase (decrease) for the current year when compared with the previous year. Round percentages to one decimal place. B. What conclusions can be drawn from the horizontal analysis? Round the answers to one decimal place.
Indicate the effect of the transactions listed in the following table on total current assets, current ration, and net income. Use (+) to indicate an increase, (-) to indicate a decrease, and (0) to indicate either no effect or an indeterminate effect. Be prepared to state any necessary assumptions and assume an initial current ratio of more than 1.0. Federal income tax due for the previous year is paid.
Income statements for Campbell Company for Year 3 and Year 4 follow: CAMPBELL COMPANY Income Statements Year 4 Year 3 $180,800 120,400 19,900 14,500 Sales $200,800 Cost of goods sold Selling expenses Administrative expenses Interest expense Total expenses 142,400 21,900 12,500 3,900 $180,700 5,900 $160,700 20,100 3,700 Income before taxes 20,100 Income taxes expense 6,500 Net income $ 13,600 $ 16,400 Required a. Perform a horizontal analysis, showing the percentage change in each income statement component between Year 3 and Year 4. b. Perform a vertical analysis, showing each income statement component as a percentage of sales for each year. Complete this question by entering your answers in the tabs below. Required A Required B Perform a horizontal analysis, showing the percentage change in each income statement component between Year 3 and Year 4. (Negative answers should be indicated by a minus sign. Round your percentage answers to 1 decimal place. (i.e., 0.234 should be entered…
= The current year financial statements for Blue Water Company and Prime Fish Company are presented below. Prime Fish Balance sheet Cash Accounts receivable (net) Inventory Property & equipment (net) Other assets Total assets Current liabilities Long-term debt (interest rate: 15%) Capital stock ($10 par value) Additional paid-in capital Retained earnings Total liabilities and stockholders' equity Income statement Sales revenue (1/2 on credit) Cost of goods sold Operating expenses Net income Other data Per share stock price at end of current year Blue Water $ 42,300 44,500 92,500 159,500 85,300 $ 424,100 $ 92,500 74,100 157,100 30,300 70,100 $ 424,100 $ 427,500 (234,500) (163,600) $ 29,400 $ 23.3 45% $ 19,700 34,900 47,800 416,600 318,000 $ 34,300 $ 837,000 $ 68,500 62,600 525,000 107,300 73,600 $ 837,000 $ 789,000 (401,300) (312,300) $ 75,400 $28 45% Average income tax rate Dividends declared and paid in current year Both companies are in the fish catching and manufacturing business.…
When performing a horizontal analysis on an income statement, the percentage change inany individual item is calculated by dividing the dollar amount of the change from the baseperiod to the current period bya. the base period amount.b. the current period amount.c. the amount estimated for the future period.d. the average of the base and the current period amounts.
Required: 1. Complete the following columns for each item in the comparative financial statements (Negative answers shoul be indicated by a minus sign. Round percentage answers to 2 decimal places, i.e., 0.1243 should be entered as 12.43.): Increase (Decrease) Year 2 over Year 1 Amount Percentage Statement of earnings: Sales revenue Cost of sales Gross margin Operating expenses and interest expense Earnings before income taxes Income tax expense Net earnings $ 45,770 38,650 7,120 4,020 3,100 1,050 $ 2,050 Statement of financial position: Cash (4,720) Accounts receivable (net) (4,220) Inventory 6,200 Property, plant, and equipment (net) 6,380 $ 3,640 Current liabilities (3,840) Long-term debt 3,530 Common shares 0 Retained earnings 3,950 $ 3,640
Suppose that you are doing a financial statement analysis. Assume you took a financial statement and divided every entry amount in the statement by the amount of total assets. The resulting statement is commonly called a? current ratio common base year income statement common size balance sheet common size income statement common base year balance sheet .DO NOT GIVE PLAGRIZED ANSWER
Prepare a vertical analysis of both the balance sheets and income statements for Year 4 and Year 3. Complete this question by entering your answers in the tabs below. Analysis Analysis Bal Sheet Inc Stmt Prepare a vertical analysis of an income statements for Year 4 and Year 3. (Percentages may not add exactly due to rounding. Round your answers to 2 decimal places. (i.e., .2345 should be entered as 23.45).) Revenues Sales (net) Other revenues Total revenues RUNDLE COMPANY Vertical Analysis of Income Statements Year 4 Expenses Cost of goods sold Selling, general, and administrative expense Net income Interest expense Income tax expense Total expenses Amount $ 230,300 8,900 239,200 Percentage of Total 119,400 54,300 6,700 22,100 202,500 $ 36,700 Show less
a. Prepare a comparative income statement with horizontal analysis, indicating the increase (decrease) for the current year when compared with the previous year. If required, round to one decimal place.
In horizontal analysis, each item is expressed as a percentage of the a. latest year figure. b. net income figure. c. total assets. O d. earliest year figure.
Required: Compute the following: (For Requirements 1 to 4, enter your percentage answers rounded to 2 decimal places (i.e., 0.1234 should be entered as 12.34).) 1. Gross margin percentage. 2. Net profit margin percentage. 3. Return on total assets. 4. Return on equity. 5. Was financial leverage positive or negative for the year? 1. Gross margin percentage % 2. Net profit margin percentage % 3. Return on total assets % 4. Return on equity % 5. Financial Leverage
Find in Amount ($) and Percentage(%) for Year 2 over Year 1: Income Statement - (a) Operating Expense and interest expense (b) Earnings before income taxes (c) Income tax expenses