Using the base case, calculate the composite effects of a 5 percent increase in Sales, a 2 percent decrease in Gross Margin, and a 5 percent increase is SG&A as percent of Sales. Colossal Chemical Corporation Year Ended December 31, 2021 ($000,000 omitted) Base Case Combined Sales $2,110 2215.50 Cost of goods sold 1,245 1351.46 Selling, general, and 401 531.72 administrative expense Depreciation 121 121 Research and development 108 112.99 Total costs and expenses $ 1,875 $ 1996.17 Operating Income 235 219.33 Interest expense 34 34 Earnings before Income Taxes $201 $ 185.33 Provision for Income Taxes 40 Net Income 37.07 $161 $ 148.26 For the base case in this question, as a percentage of sales, COGS=59 percent, SGA = 19 percent, R&D = 5.1 percent. Depreciation, Interest expense are fixed as stated. Tax Rate is 20 percent.

Using the base case, calculate the composite effects of a 5 percent increase in Sales, a 2 percent decrease in Gross Margin, and a 5 percent increase is SG&A as percent of Sales. Colossal Chemical Corporation Year Ended December 31, 2021 ($000,000 omitted) Base Case Combined Sales $2,110 2215.50 Cost of goods sold 1,245 1351.46 Selling, general, and 401 531.72 administrative expense Depreciation 121 121 Research and development 108 112.99 Total costs and expenses $ 1,875 $ 1996.17 Operating Income 235 219.33 Interest expense 34 34 Earnings before Income Taxes $201 $ 185.33 Provision for Income Taxes 40 Net Income 37.07 $161 $ 148.26 For the base case in this question, as a percentage of sales, COGS=59 percent, SGA = 19 percent, R&D = 5.1 percent. Depreciation, Interest expense are fixed as stated. Tax Rate is 20 percent.

Intermediate Accounting: Reporting And Analysis

3rd Edition

ISBN:9781337788281

Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach

Publisher:James M. Wahlen, Jefferson P. Jones, Donald Pagach

Chapter22: Accounting For Changes And Errors.

Section: Chapter Questions

Problem 4RE: Refer to RE22-2. Assume Heller Company had sales revenue of 510,000 in 2019 and 650,000 in 2020....

See similar textbooks

Similar questions

Refer to RE22-2. Assume Heller Company had sales revenue of 510,000 in 2019 and 650,000 in 2020. Prepare Hellers partial income statements (through gross profit) for 2019 and 2020. RE22-2 Heller Company began operations in 2019 and used the LIFO method to compute its 300,000 cost of goods sold for that year. At the beginning of 2020, Heller changed to the FIFO method. Heller determined that its cost of goods sold under FIFO would have been 250,000 in 2019. For 2020, Hellers cost of goods sold under FIFO was 360,000, while it would have been 410,000 under LIFO. Heller is subject to a 21% income tax rate. Compute the cumulative effect of the retrospective adjustment on prior years income (net of taxes) that Heller would report on its retained earnings statement for 2020.
The following is select account information for Sunrise Motors. Sales: $256,400; Sales Returns and Allowances: $34,890; COGS: $120,470; Sales Discounts: $44,760. Given this information, what is the Gross Profit Margin Ratio for Sunrise Motors? (Round to the nearest whole percentage.)
Income Statement for Year Ended December 31, 2018 (Millions of Dollars) Net sales 795.0 Cost of goods sold 660.0 Gross profit 135.0 Selling expenses 73.5 EBITDA 61.5 Depreciation expenses 12.0 Earnings before interest and taxes (EBIT) 49.5 Interest expenses 4.5 Earnings before taxes (EBT) 45.0 Taxes (40%) 18.0 Net income 27.0 a. Calculate the ratios you think would be useful in this analysis. b. Construct a DuPont equation, and compare the companys ratios to the industry average ratios. c. Do the balance-sheet accounts or the income statement figures seem to be primarily responsible for the low profits? d. Which specific accounts seem to be most out of line relative to other firms in the industry? e. If the firm had a pronounced seasonal sales pattern or if it grew rapidly during the year, how might that affect the validity of your ratio analysis? How might you correct for such potential problems?
Subject:
What is the estimated cost of goods sold for the current year? Problem 13-3 (AICPA Adapted) The following information is available for the current year: Wecent history, the entity had a gross profit of 25% on sales. Beginning inventory Purchases Purchase returns Sales Sales returns Sales allowances Uhat is the estimated cost of goods sold for the current year? 520,000 4,120,000 60,000 5,600,000 400,000 100,000 a. 3,360,000 b. 3,830,000 c. 3,900,000 d. 3,825,000
salamagundi, inc. has the following income statement: For the year ended December 31, 2021 net sales: $160 Cost of goods sold: $100 gross profit: $60 Operating expenses: $40 Net income: $20 Using vertical analysis, what percentage is assigned to operating expenses? a. 25% b. 40% c. 66.7% d. 200%
The data shown below were obtained from the financial records of the BST Corporation for the year ended December 31, 2020. Sound Break CorporationIncome and Retained Earnings StatementFor the year Ended December 31, 2020Net Sales P1,000,000Cost of Goods Sold:Inventory, Dec. 31, 2019 P250,000Purchases 720,000Total Goods Available P970,000Inventory 220,000 750,000Gross Margin on Sales P 250,000Selling and Administrative (including Depreciation of P20,000) 125,000Net Income before Tax P 125,000Provision for Income Tax 35,000Net Income for the Year P 90,000Retained Earnings, beginning 130,000Total P 220,000Dividends Paid 30,000Retained Earnings, December 31, 2020 P 190,000 Sound Break CorporationBALANCE SHEETDecember 31, 2019 and 2020 ASSETS 2019 2020Current Assets:Cash P 75,000 P 85,000Marketable Securities 25,000 25,000Trade Receivables, net 185,000 245,000Inventory, at cost 250,000 220,000Prepaid Expenses 15,000 10,000Total Current Assets P550,000 P585,000Property and Other…
1. Selected data for ABC Co. for 2020 are as follows: Decrease in merchandise inventory: P20,000 increase in accounts payable: P50,000 Disbursements for purchases of merchandise: P580,000. How much is the 2020 Cost of goods sold? * a.P510,000 b.P550,000 c.P610,000 d.P650,000 e. answer not given 2. The following expenses were recognized by CBA Co., a retailer, during 2020: Interest expense: P120,000 Telephone expense: P95,000 Loss on sale of store equipment: P47,000 Legal fees: P74,000 Officers’ salaries: P115,000. How much should CBA Co. report as general and administrative expenses for 2020? * a.P210,000 b.P284,000 c.P330,000 d.P404,000 e. answer not given 3.Positivity Company provided the following information on December 31, 2020 ( in their normal balances): Accounts Receivable- 350,000; Accounts payable - 200,000; Accrued Expenses - 150,000; Building in progress - 500,000; Cash in bank - 200,000; Cash surrender value - 150,000; Merchandise Inventory - 580,000; Office equipment…
Prepare a Vertical Analysis.
Alfiya trading Company announces annual Sales of OMR 30000, Carriage inwards of OMR 2000, Sales Discount of OMR 2000 and sales return of OMR 3000. Calculate net sales? a. OMR 23000 b. OMR 21000 c. OMR 30000 d. OMR 25000
Vertical analysis (common-size) percentages for Cullumber Company’s sales revenue, cost of goods sold, and expenses are listed here. Vertical Analysis 2022 2021 2020 Sales revenue 100.0 % 100.0 % 100.0 % Cost of goods sold 60.0 64.2 65.6 Expenses 24.7 27.1 29.5 Calculate Cullumber’s net income as a percent of sales. (Round answers to 1 decimal place, e.g. 5.2.) 2022 2021 2020 Net income Enter percentages rounded to 1 decimal place. Enter percentages rounded to 1 decimal place. Enter percentages rounded to 1 decimal place. Did Cullumber’s net income as a percent of sales increase, decrease, or remain unchanged over the 3-year period? Cullumber’s net income as a percent of sales Choose the correct answer increaseddecreasedremained unchanged
Compete the comparative income statement and balance sheet for logic company. Note: all input numbers are positive except decrease answers that should be a minus sign. Your the percent to the nearest hundredth percent.