Exercise 6-12 Cause-of-change analysis (L06-1) Following are income statements for Hossa Corporation for 20X1 and 20x2. Percentage of sales amounts are also shown for each operating expense item. Hossa's income tax rate was 22% in 20X1 and 24% in 20X2 of sales % of sales 45% ($ in millions) Sales Cost of sales Other operating expenses Operating income Provision for income taxes Net income Income tax rate 2ex1 $ in millions $ 5,500.0 (2,475.0) (825.0) 2,200.0 484.0 $ 1,716.0 22% 15% 20x2 $ in millions $ 6,500.0 (3,055.0) (1,040.0) 2,405. (577.2) $ 1,827.8 24% 47% 16% 5 Hossa's management was pleased that 20x2 net income was up 6.5% from the prior year. Although you are also happy with the increase in net income, you are not so sure the news is all positive. You have modeled Hossa's income as follows: NET INCOME - SALES (1 - COGS% - OPEX%) * (1 - TAX RATE) Using this model, net income in 20x1 is computed as $5,500 - (1 - 45% -15%)*(1 - 22%) = 51716.0. Net income in 20X2 is computed as $6,500 * (1 - 47% -16%) * (1 - 24%) = $1,8278 Required: 1. Prepare a cause-of-change analysis to show the extent to which each of the following items contributed to the $111.8 million increase in Hossa's net income from 20x1 to 20X2: (Do not round intermediate calculations. Enter your answers in millions rounded to 1 decimal place. Negative amounts should be indicated by a minus sign.) Increase in sales (SALES) Increase in cost of sales as a percent of sales (COGS%) Increase in other operating expenses as a percent of sales (OPEX%) Increase in income tax rate (TAX RATE) Cause of Change Analysis (5 in millions) Net income-20X1 Efect of increase in sales Effect of increase in COGS perawang unne Provision for income taxes Net income Income tax rate 2,400.0 (484.0) $ 1,716.0 22% 2,3.0 (577.2) $ 1,827.8 24% Hossa's management was pleased that 20x2 net income was up 6.5% from the prior year. Although you are also happy with the increase in net income, you are not so sure the news is all positive. You have modeled Hossa's income as follows: NET INCOME = SALES * (1 - COGS% - OPEX%)*(1 - TAX RATE) Using this model, net income in 20X1 is computed as $5,500 (1 - 45%-15%) * (1 - 22%) = $1,716.0. Net income in 20X2 is computed as $6,500 * (1 - 47% -16%) * (1 - 24%) = $1,8278. Required: 1. Prepare a cause-of-change analysis to show the extent to which each of the following items contributed to the $11.8 million increase in Hossa's net income from 20x1 to 20X2: (Do not round intermediate calculations. Enter your answers in millions rounded to 1 decimal place. Negative amounts should be indicated by a minus sign.) Increase in sales (SALES) Increase in cost of sales as a percent of sales (COGS%) Increase in other operating expenses as a percent of sales (OPEX%) Increase in income tax rate (TAX RATE) Cause of Change Analysis (s in millions) Net Income - 20X1 Effect of increase in sales Effect of increase in COGS Effect of increase in OPEX Effect of increase in tax rate Increase in net income Net Income - 20X2 0.0