A comparative income statement is given below for McKenzie Sales, Ltd., of Toronto: |
McKenzie Sales, Ltd. Comparative Income Statement |
||||||
This Year | Last Year | |||||
Sales | $ | 7,370,000 | $ | 5,601,200 | ||
Cost of goods sold | 4,700,000 | 3,508,500 | ||||
Gross margin | 2,670,000 | 2,092,700 | ||||
Selling and administrative expenses: | ||||||
Selling expenses | 1,396,000 | 1,079,000 | ||||
Administrative expenses | 706,000 | 616,000 | ||||
Total expenses | 2,102,000 | 1,695,000 | ||||
Net operating income | 568,000 | 397,700 | ||||
Interest expense | 105,000 | 88,000 | ||||
Net income before taxes | $ | 463,000 | $ | 309,700 | ||
Members of the company’s board of directors are surprised to see that net income increased by only $153,300 when sales increased by $1,768,800. |
Required: | |
1. |
Express each year's income statement in common-size percentages. (Round your percentage answers to 1 decimal place (i.e., 0.1234 should be entered as 12.3).) |
An income statement in which each account is expressed as a percentage of the value of sales
C | P | C-P | common-size percentages | ||
This Year | Last Year | Growth | This Year | Last Year | |
Sales | 7370000 | 5601200 | 1768800 | 100.0% | 100.0% |
Cost of goods sold | 4700000 | 3508500 | 1191500 | 63.8% | 62.6% |
Gross margin | 2670000 | 2092700 | 577300 | 36.2% | 37.4% |
Selling and administrative expenses: | |||||
Selling expenses | 1396000 | 1079000 | 317000 | 18.9% | 19.3% |
Administrative expenses | 706000 | 616000 | 90000 | 9.6% | 11.0% |
Total expenses | 2102000 | 1695000 | 407000 | 28.5% | 30.3% |
Net operating income | 568000 | 397700 | 170300 | 7.7% | 7.1% |
Interest expense | 105000 | 88000 | 17000 | 1.4% | 1.6% |
Net income before taxes | 4,63,000 | 309700 | 153300 | 6.3% | 5.5% |
This shows that Company has improved on Profit margin compared to last year ie Sales increaed in actual, Expenses in % of sales have decreased however Gross Margin has decreased with Cost of good sold % going up
A comparative income statement is given below for McKenzie Sales, Ltd., of Toronto: McKenzie Sales, Ltd....
A comparative income statement is given below for McKenzie Sales, Ltd., of Toronto: Last Year $5,578,400 3,508,000 2,070,400 McKenzie Sales, Ltd. Comparative Income Statement This Year Sales $ 7,340,000 Cost of goods sold 4,700,000 Gross margin 2,640,000 Selling and administrative expenses: Selling expenses 1,396,000 Administrative expenses 705,500 Total expenses 2,101,500 Net operating income 538,500 Interest expense 101,000 Net income before taxes $ 437,500 1,079,000 611,000 1,690,000 380,400 87,000 293,400 $ Members of the company's board of directors are surprised to...
A comparative income statement is given below for McKenzie Sales, Ltd., of Toronto: McKenzie Sales, Ltd. Comparative Income Statement This Year $7,330,000 4,630,000 Sales Cost of goods sold Last Year $5,570,800 3,509,500 Gross margin 2,700,000 2,061,300 Selling and administrative expenses: Selling expenses Administrative expenses 1,396,000 711,500 1,073,500 616,000 Total expenses 2,107,500 1,689,500 Net operating income Interest expense 592,500 104,000 371,800 90,000 Net income before taxes $ 488,500 $ 281,800 Members of the company's board of directors are surprised to see...
A comparative income statement is given below for McKenzie Sales, Ltd., of Toronto: McKenzie Sales, Ltd. Comparative Income Statement This Year Last Year Sales $ 7,300,000 $ 5,548,000 Cost of goods sold 4,670,000 3,513,000 Gross margin 2,630,000 2,035,000 Selling and administrative expenses: Selling expenses 1,379,000 1,077,500 Administrative expenses 704,000 616,000 Total expenses 2,083,000 1,693,500 Net operating income 547,000 341,500 Interest expense 104,000 85,000 Net income before taxes $ 443,000 $ 256,500 Members of the company’s board of directors are surprised...
A comparative income statement is given below for McKenzie Sales, Ltd., of Toronto: McKenzie Sales, Ltd. Comparative Income Statement This Year Last Year Sales $ 7,310,000 $ 5,555,600 Cost of goods sold 4,780,000 3,507,500 Gross margin 2,530,000 2,048,100 Selling and administrative expenses: Selling expenses 1,378,000 1,078,500 Administrative expenses 709,000 616,500 Total expenses 2,087,000 1,695,000 Net operating income 443,000 353,100 Interest expense 97,000 88,000 Net income before taxes $ 346,000 $ 265,100 Members of the company’s board of directors are surprised...
A comparative income statement is given below for McKenzie Sales, Ltd., of Toronto: McKenzie Sales, Ltd Comparative Income Statement This Year $7,320,000 4,650,000 Last Year $5,563 200 3,515,000 Sales Cost of goods sold Gross margin 2,670,000 2,048,200 Selling and administrative expenses Selling expenses Administrative expenses 1.396,000 707.500 1,074,500 614,500 Total expenses 2.103,500 1,689,000 Net operating income Interest expense 566.500 100,000 359,200 85,000 Net income before taxes 466,500 $274,200 Members of the company's board of directors are surprised to see that...
A comparative income statement is given below for McKenzie Sales, Ltd., of Toronto: McKenzie Sales, Ltd. Comparative Income Statement This Year Last Year Sales $ 7,350,000 $ 5,586,000 Cost of goods sold 4,740,000 3,515,500 Gross margin 2,610,000 2,070,500 Selling and administrative expenses: Selling expenses 1,383,000 1,075,000 Administrative expenses 703,000 612,000 Total expenses 2,086,000 1,687,000 Net operating income 524,000 383,500 Interest expense 99,000 88,000 Net income before taxes $ 425,000 $ 295,500 Members of the company’s board of directors are surprised...
A comparative income statement is given below for McKenzie Sales, Ltd., of Toronto: McKenzie Sales, Ltd. Comparative Income Statement This Year Last Year Sales $ 7,360,000 $ 5,593,600 Cost of goods sold 4,650,000 3,506,000 Gross margin 2,710,000 2,087,600 Selling and administrative expenses: Selling expenses 1,377,000 1,074,500 Administrative expenses 703,500 616,500 Total expenses 2,080,500 1,691,000 Net operating income 629,500 396,600 Interest expense 96,000 89,000 Net income before taxes $ 533,500 $ 307,600 Members of the company’s board of directors are surprised...
A comparative income statement is given below for McKenzie Sales, Ltd., of Toronto: McKenzie Sales, Ltd. Comparative Income Statement This Year Last Year Sales $ 7,390,000 $ 5,616,400 Cost of goods sold 4,650,000 3,507,500 Gross margin 2,740,000 2,108,900 Selling and administrative expenses: Selling expenses 1,370,000 1,080,000 Administrative expenses 708,500 617,000 Total expenses 2,078,500 1,697,000 Net operating income 661,500 411,900 Interest expense 99,000 88,000 Net income before taxes $ 562,500 $ 323,900 Members of the company’s board of directors are surprised...
A comparative income statement is given below for McKenzie Sales, Ltd., of Toronto: McKenzie Sales, Ltd. Comparative Income Statement This Year Last Year Sales $ 7,370,000 $ 5,601,200 Cost of goods sold 4,660,000 3,511,500 Gross margin 2,710,000 2,089,700 Selling and administrative expenses: Selling expenses 1,387,000 1,082,000 Administrative expenses 704,000 610,500 Total expenses 2,091,000 1,692,500 Net operating income 619,000 397,200 Interest expense 100,000 89,000 Net income before taxes $ 519,000 $ 308,200 Members of the company’s board of directors are surprised...
A comparative income statement is given below for McKenzie Sales, Ltd., of Toronto: McKenzie Sales, Ltd. Comparative Income Statement This Year Last Year $5,570,800 3,516,000 2,054,800 $7,330,000 4,590,000 2,740,000 Sales Cost of goods sold Gross margin Selling and administrative expenses: Selling expenses Administrative expenses 1,074,500 611,000 1,381,000 710,500 2,091,500 648,500 1,685,500 369,300 84,000 Total expenses Net operating income Interest expense 102,000 $ $ 285,300 546,500 Net income before taxes Members of the company's board of directors are surprised to see...