Question 1 - Unit 8 Xter 9 Homework Assignment iezto.mheducation.com/ext/map/index.html?_con=con&external_browser=0&launchUrl=https%253A%252F%252Fpost.blackboard.com%252FwebapBookshelf: Survey o XIncome statements for Burch Company for Year 3 and Year 4 follow:SalesCost of goods soldSelling expensesExercise 9-3A (Static) Horizontal and vertical analysis LO 9-1Administrative expensesInterest expenseTotal expensesIncome before taxesIncome taxes expenseNet incomeBURCH COMPANYIncome StatementsRequired AEtOutlookRequired BYear 4$240,000Requireda. 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.MEXM Scholarships - Midl X Submission - Goap X G Gmail: PriYear 3$200,000180,000124,00026,00020,00012,00018,0008,0007,500$225,500$170,00014,50030,0003,0001,200$ 13,300 $ 27,000HPerform a horizontal analysis, showing the percentage change in each income statement component between Year 3 and Year4. (Negative answers should be indicated by a minus sign. Round your answers to 1 decimal place. (i.e.. 0.234 should beSaved< PrevM1 of 4WhpNext >Rain comingC er 9 Homework AssignmentISIVUTMINRequired A Required B100Complete this question by entering your answers in the tabs below.SalesCost of goods soldSelling expensesIDI. ܝAdministrative expensesInterest expenseTotal expensesIncome before taxesIncome taxes expenseNet incomeBURCH COMPANYVertical Analysis of Income StatementsPercentage ofSales Year 4YUVIE15Perform a vertical analysis, showing each income statement component as a percentage of sales for each year. (Percentagesmay not add exactly due to rounding. Round your answers to 1 decimal place. (i.e., 0.234 should be entered as 23.4).)100.0 %75.010.85.03.194.06.00.516%Percentage ofSales Year 3< Required AFIL100.0 %62.010.09.04.085.015.01.5%4444Required BPrev18Saved+1 of 4Wvinys.hp144PNext >EVE110Jusu▶11

MEANING OF HORIZONTAL ANALYSIS In this analysis Financial statement are analyzed Horizontally and…

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.

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.

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

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.
Assume the following sales data for a company:Current year$832,402 Preceding year608,082What is the percentage increase in sales from the preceding year to the current year? a.136.89% b.36.89% c.73.05% d.26.95% The relationship of $242,729 to $104,267, expressed as a ratio, is a.0.8 b.2.3 c.0.4 d.0.7
Compute common-size percents for the following comparative income statements (round percents to one decimal). Using the common-size percents, which item is most responsible for the decline in net income?
Use the following data from Burt Co., taken from the ledger after adjustment on December 31 the end of the fiscal year. Accounts Payable $97,200 Accounts Receivable 64,300 Accumulated Depreciation-Office Equipment 72,750 Accumulated Depreciation-Store Equipment 162,100 Administrative Expenses 56,500 Cash 53,000 Cost of Merchandise Sold 121,700 Interest Expense 12,000 Maeve Burt, Capital 81,750 Maeve Burt, Drawing 52,000 Merchandise Inventory 93,250 Note Payable (due in two years) 154,000 Office Equipment 149,750 Prepaid Insurance 6,500 Rent Revenue 17,500 Salaries Payable 28,700 Sales 365,500 Selling Expenses 41,500 Store Equipment 325,000 Supplies 4,000
2) Ratios Based on the information given in picture #1, complete the following ratios for the last TWO years and indicate whether the trend is favorable or unfavorable. Note percentages and times should be to one decimal place (e.g. 14.8%; 5.8x) Profitability Ratios Current Yr. Prior Yr. Fav/Unfav. Gross Margin (%) {Gross Income/Sales Revenue} Profit Margin (%) {Net income/ Sales Revenue} Return on Assets (%) {Net Income/ Average Total Assets}
Prepare common size income statements Which company earns more net income? Which companies net income has a higher percentage of its net sales revenue?
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
8
Vertical Analysis of Income Statement Revenue and expense data for Innovation Quarter Inc. for two recent years are as follows: Previous Year Sales Cost of goods sold Selling expenses Administrative expenses Income tax expense Current Year $447,000 272,670 71,520 71,520 13,410 $384,000 215,040 69,120 57,600 15,360
Express the following comparative income statements in common-size percents. Using the common-size percents, which item is most responsible for the decline in net income? Complete this question by entering your answers in the tabs below. Reason for Income Decline in Net Statement Income Express the following comparative income statements in common-size percents. (Round your percentage answers to 1 decimal place.) GOMEZ CORPORATION Comparative Income Statements For Years Ended December 31 Current Year $ Current Year % Prior Year $ Prior Year % Sales 2$ 750,000 $ 690,000 Cost of goods sold 560,000 288,800 Gross profit 190,000 401,200 Operating expenses 129,200 219,200 Net income $ 60,800 $ 182,000 Income Statement Reason for Decline in Net Income >
Express the following comparative income statements in common-size percents. Using the common-size percents, which item is most responsible for the decline in net income? Complete this question by entering your answers in the tabs below. Income Statement Reason for Decline in Net Income Express the following comparative income statements in common-size percents. Note: Round your percentage answers to 1 decimal place. GOMEZ CORPORATION Comparative Income Statements For Years Ended December 31 Current Year $ Current Year % Prior Year $ Prior Year % Sales $ 725,000 100.0 $ 665,000 Cost of goods sold 562,700 1.0 291,000 Gross profit 162,300 0.4 374,000 Operating expenses 129,200 268,400 Net income 33,100 $ 105,600 Income Statement Reason for Decline in Net Income >
List five ratios that are automatically provided by the vertical analysis of income statements.