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

Chapter5: The Income Statement And The Statement Of Cash Flows

Section: Chapter Questions

Problem 2MC: The following information is available for Cooke Company for the current year: The gross margin is...

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?
rr
please provide correct option
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…
Required information ($ thousands) Net sales Cost of goods sold Current Year $ 885,182 396,513 Current Year: Prior Year: Determine the Prior Year and Current Year trend percents for net sales using the Prior Year as the base year. (Enter the answers in thousands of dollars.) Prior Year $ 456,779 137,643 Numerator: Trend Percent for Net Sales: Denominator: Trend Percent 0% 0%
Prepare a Vertical Analysis.
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.
Targee Inc. has the following income statement (in mulons). Targee, INC. Income Statement For the Year Ended December 31, 2020 Net Sales $3,300 Cost of Goods Sold 2.280 Gross Profit 1,950 Operating Expenses 45 Net Income $1.905 Using vertical analysis, what percentage is assigned to Cost of Goods Sold? a. 70% b. 6996 c. 100% d. None of these