Income statements for Rundle Company for Year 3 and Year 4 follow:RUNDLE COMPANYIncome StatementaSalesCost of gooda soldSelling expensesAdministrative expensesInterent expenseTotal expensesIncome before taxesIncome taxes expenseYear 4$201,100142,00021,20012,9003,000$179,10022,0006,900$15,100Year 3$181,100*120,00019,20014,9005,000$159, 10022,0003,100$ 18,900Net incomeRequireda. 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 ARequired B RUNDLE COMPANYHorizontal Analysis of Income StatementsPercentage Changeover Year 3Sales%Cost of goods soldSelling expensesAdministrative expensesInterest expenseTotal expensesIncome before taxesIncome taxes expenseNet income (loss)%RUNDLE COMPANYVertical Analysis of Income StatementsPercentage ofSales Year 4Percentage ofSales Year 3Sales%%Cost of goods soldSelling expensesAdministrative expensesInterest expenseTotal expensesIncome before taxesIncome taxes expenseNet incomeResulrad ABenuired B

Name: Income statements for Rundle Company for Year 3 and Year 4 follow:RUN
Uploaded: 2024-03-20T06:32:37.000Z
Channel: Bartleby
Description: Income statements for Rundle Company for Year 3 and Year 4 follow:RUNDLE COMPANYIncome StatementaSalesCost of gooda soldSelling expensesAdministrative expensesInterent expenseTotal expensesIncome before taxesIncome taxes expenseYear 4$201,100142,000

Comparative financial statements are used to compare two or more financial statements. These are the…

Business

Accounting

Income statemepts for Rundle Company for Year 3 and Year 4 follow. RUNDLE COMPANY Income Statementa Year 4 Sales Cost of goods sold Selling expenses Administrative expenses Interest expense Total expenses Income before taxes $201,100 142,000 21,200 12,900 3,000 $179,100 22,000 6,900 $ 15,100 Year 3 $181,100 *120.000 19,200 14,900 5,000 $159,100 22,000 3,100 $ 18,900 Income taxes expense Net income Required a. Perform a horizontal analysis, showing the percentage change in each income statement component between Year 3 and Year b. Perform a vertical analysis, showing each income statement component as a percentage of sales for each year,

Income statemepts for Rundle Company for Year 3 and Year 4 follow. RUNDLE COMPANY Income Statementa Year 4 Sales Cost of goods sold Selling expenses Administrative expenses Interest expense Total expenses Income before taxes $201,100 142,000 21,200 12,900 3,000 $179,100 22,000 6,900 $ 15,100 Year 3 $181,100 *120.000 19,200 14,900 5,000 $159,100 22,000 3,100 $ 18,900 Income taxes expense Net income Required a. Perform a horizontal analysis, showing the percentage change in each income statement component between Year 3 and Year b. Perform a vertical analysis, showing each income statement component as a percentage of sales for each year,

Managerial Accounting: The Cornerstone of Business Decision-Making

7th Edition

ISBN:9781337115773

Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger

Publisher:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger

Chapter15: Financial Statement Analysis

Section: Chapter Questions

Problem 19BEA

See similar textbooks

Similar questions

The following are the financial statement JNC Ltd. for the year ended 31 March 2020: JNC Ltd. Income statement For the year ended 31 March 2020 $”M” Revenue 1276.50 Cost of sales (907.00) 369.50 Distribution costs (62.50) Administrative expenses (132.00) 175.00 Interest received 12.50 Interest paid (37.50) 150.00 Tax (70.00) Profit after tax 80.00 JNC Ltd. Statement of financial position as at 31 March 2020 2019 $”M” $”M” ASSETS: Non- current assets: Property, plant and equipment 190 152.5 Intangible assets 125 100 Investments 12.5 Current assets: Inventories 75 51 Receivables 195 157.5 Short-term investment 25 Cash in hand 1 0.5 Total assets 611 474 Equity and liabilities: Equity: Share capital (10 million ordinary shares of $ 10 per value) 100 75 Share premium 80 75 Revolution reserve 50 45.5 Retained earnings 130 90 Non-current liabilities: Loan 85 25…
The following are the financial statement Quick Ltd. for the year ended 31st December 2020: Quick Ltd. Income statement For year ended 31st December 2020 $”000” Revenue 1276.50 Cost of sales (907.00) 369.50 Distribution costs (62.50) Administrative expenses (132.00) 175.00 Interest received 12.50 Interest paid (37.50) Profit before tax 150.00 Tax (70.00) Profit after tax 80.00 Quick Ltd. Statement of financial position as at 31 December 2020 2019 $”000” $”000d” ASSETS: Non- current assets: Property, plant and equipment 190 152.5 Intangible assets 125 100 Investments 12.5 Current assets: Inventories 75 51 Receivables 195 157.5 Short-term investment 25 Cash in hand 1 0.5 Total assets 611 474 Equity and liabilities: Equity: Share capital 100 75 Share premium 80 75 Revolution reserve 50 45.5 Retained earnings 130 90 Non-current liabilities: Loan 85 25…
Do the calculations in excel, attach excel screenshots and explain the steps and formulas used for solving the problem. Following are the particulars available
Assume a company's Income Statement for Year 9 is as follows: Year 9 (in 000s) Income Statement Data Total Revenues Cost of Goods Sold Delivery Costs Marketing Costs Administrative Expenses Operating Profit (Loss) Other Income (Expense) Interest Income (Expense) Pre-tax Profit (Loss) Income Taxes Net Profit (Loss) $ 650,000 380,000 45,000 53,000 11,000 161,000 -2,600 -10,800 147,600 44,280 $ 103,320 Based on the above income statement data, the company's interest coverage ratio and its operating profit margin are 14.91 and 24.8%. 17.22 and 24.6%. 19.29 and 21.4%. 16.71 and 23.3%. 13.67 and 15.9%.
Dela Rosa Company Company The income statement for the year ended December 31, 2020, for Dela Rosa Company Comnany contains the following condensed information. Dela Rosa Company Company Income Statement For the Year Ended December 31, 2X20 Sales revenue Cost of goods sold Operating expenses (excluding depreciation) Depreciation expense Loss on disposal of plant assets Income before income taxes Income tax expense Net income P6,583,000 P2,810,000 2,086,000 880,000 24.000 5,800.000 783,000 353,000 P430,000 The P24,000 loss resulted from selling equipment for P270,000 cash. The equipment was purchased at a cost of P750,000. The following balances are reported on Dela Rosa's comparative balance sheets at December 31, Dela Rosa Company Company Comparative Balance Sheets Cash Accounts receivable Inventory Accounts payable 2X20 P672,000 775,000 834,000 521,000 2X19 P130,000 610,000 867,000 501,000 Income tax expense of P353,000 represents the amount paid in 2020. Dividends declared and paid…
The financial data of Mammoth corporation for the year ended 31st December,2020 is as followsParticulars Variable expense as percentage of sales 66.67Interest Expense ($) 200DOL 5DFL 3Income tax rate 0.35Requirement:a) Prepare income statement for company.
The statement of income for Pembina Ltd. is shown below: Sales Cost of goods sold Gross profit PEMBINA LTD. Statement of Income Year Ended December 31 (in millions) Operating expenses Income from operations Interest expense Income before income tax Income tax expense Net income 2021 $1,610 908 702 525 177 80 97 25 $72 2020 $1,410 744 PEMBINA LTD. Horizontal Analysis of Statement of Income (% of base-year amount) Year Ended December 31 666 407 259 50 209 52 $157 2019 $1,194 598 596 397 199 40 159 40 $119 Using horizontal analysis, calculate the horizontal percentage of a base-year amount, assuming 2019 is the base year. (Round answers to 1 decimal place, e.g. 5.2%. Enter negative amounts using either a negative sign preceding the number e.g. -45.1% or parentheses e.g. (45.1)%.)
Below is Rodrigues Ltd's income statement and two balance sheets: Rodrigues Ltd Income Statement for year ending 30th June 2021 Sales COGS Operating expense Depreciation Interest expense Income before tax Tax at 30% Net income $m 600 240 100 40 10 210 63 147 Assets Current assets PPE Cost Accumul. depr. Carrying amount Total assets Rodrigues Ltd Balance Sheet as at 30th June Liabilities Current liabilities Non-current liabilities Owners' equity Retained earnings Contributed equity Total L and OE 2021 $m 98 800 140 660 758 60 130 80 488 758 2020 $m 73 920 100 820 893 50 120 100 623 893 Which of the following statements about the financial year from 30 June 2020 to 30 June 2021 is NOT correct? O a. The increase in net working capital (ANWC) was $15m. O b. Net capital expenditure was negative because in net terms, more property, plant and equipment (PPE) was bought rather than sold. O c. The increase in net working capital was positive largely because in net terms, more inventory was…
Prepare the Pro-Forma Statement of Financial Position for the year ending 31 December 2023 INFORMATIONSibiya ProjectsStatement of Comprehensive Income for the year ended 31 December 2022 RSales 10 000 000Cost of sales (5 750 000)Gross profit 4 250 000Variable, selling and administrative costs (1 500 000)Fixed selling and administrative costs (500 000)Net profit 2 250 000 Statement of Financial Position for the year ended 31 December 2022ASSETS RNon-current assets 800 000Property, plant and equipment 800 000 Current assets 3 400 000Inventories 1 600 000Accounts receivable 600 000Cash 1 200 000TOTAL ASSETS 4 200 000 EQUITY AND LIABILITIESEquity 3 760 000 Current liabilities 440 000Accounts payable 440 000TOTAL ASSETS AND LIABILITIES 4 200 000 Additional informationA. The sales budget for 2023 is as follows:First Quarter Second Quarter Third Quarter Fourth QuarterR2 625 000 R2 750 000 R2 875 000 R2 750 000 B. 90% of sales is collected in the quarter of the sale and 10% in the quarter…
Selected comparative financial statements of Korbin Company follow. KORBIN COMPANY Comparative Income Statements For Years Ended December 31. 2020 $ 487,179 $ 373,219 2021 293,282 236,621 193,897 69,179 43,846 113,025 Sales Cost of goods sold Gross profit Selling expenses Administrative expenses Total expenses Income before taxes Income tax expense Net income Assets Current assets 84,347 80,872 52,251 15,042 10,711 $ 65,830 $ 41,540 KORBIN COMPANY Comparative Balance Sheets December 31 Long-term investments Plant assets, net Total assets Liabilities and Equity Current liabilities. Common stock Other paid-in capital Retained earnings Total liabilities and equity 136,598 51,504 32,843 2021 2020 2019 $ 259,000 165,760 93,240 34,188 21,497 55,685 37,555 7,624 $ 29,931 $ 64,678 116,492 0 $ 43,289 900 106,308 $ 181,170 $ 150,497 $ 26,451 66,000 8,250 80,469 $ 22,424 66,000 8,250 53,823 $ 181,170 $ 150,497 2019 $ 57,867 4,860 61,960 $ 124,687 $ 21,820 48,000 5,333 49,534 $ 124,687
Selected comparative financial statements of Korbin Company follow. Comparative Income Statements For Years Ended December 31 Sales Cost of goods sold Gross profit Selling expenses Administrative expenses Total expenses Income before taxes Income tax expense Net income KORBIN COMPANY Assets Current assets Long-term investments Plant assets, net Total assets KORBIN COMPANY Comparative Balance Sheets Liabilities and Equity Current liabilities Assets Current assets Long-term investments Plant assets, net Total assets 2021 2020 2019 $ 483,981 $ 370,769 $ 257,300 291,357 234,326 164,672 192,624 136,443 92,628 68,725 33,964 43,558 21,356 112,283 80,341 14,943 $ 65,398 $ 41,856 Liabilities and Equity Current liabilities Common stock Other paid-in capital Retained earnings Total liabilities and equity December 31 2021 $ 57,843 0 51,166 32,628 83,794 52,649 10,793 $ 23,890 66,000 $ 20,253 Common stock 66,000 Other paid-in capital 8,250 Retained earnings 41,423 Total liabilities and equity $…
Here are simplified financial statements for Watervan Corporation: INCOME STATEΜΕNT (Figures in $ millions) Net sales $884.00 Cost of goods sold Depreciation Earnings before interest and taxes (EBIT) Interest expense 744.00 34.00 $106.00 15.00 Income before tax $ 91.00 Тахes 19.11 Net income $ 71.89 BALANCE SHEET (Figures in $ millions) End of Start Year of Year Assets Current assets $ 372 $ 318 Long-term assets 264 225 Total assets $ 636 $ 543 Liabilities and shareholders' equity Current liabilities $ 197 $ 160 Long-term debt Shareholders' equity 111 124 328 259 Total liabilities and shareholders' equity $ 636 $ 543 The company's cost of capital is 8.5%. a. Calculate Watervan's economic value added (EVA). (Do not round intermediate calculations. Enter your answer in millions rounded to 2 decimal places.) b. What is the company's return on capital? (Use start-of-year rather than average capital.) (Do not round intermediate calculations. Enter your answer as a percent rounded to 2…