Question

In: Accounting

Cuneo Company’s income statements for the last 3 years are as follows: Cuneo Company Income Statements...

Cuneo Company’s income statements for the last 3 years are as follows: Cuneo Company Income Statements For the Years 1, 2, and 3 1 Year 1 Year 2 Year 3 2 Sales $1,000,000.00 $1,200,000.00 $1,700,000.00 3 Less: Cost of goods sold (700,000.00) (700,000.00) (1,000,000.00) 4 Gross margin $300,000.00 $500,000.00 $700,000.00 5 Less operating expenses: 6 Selling expenses (150,000.00) (220,000.00) (250,000.00) 7 Administrative expenses (50,000.00) (60,000.00) (120,000.00) 8 Operating income $100,000.00 $220,000.00 $330,000.00 9 Less: 10 Interest expense (25,000.00) (25,000.00) (25,000.00) 11 Income before taxes $75,000.00 $195,000.00 $305,000.00 Required: 1. Prepare a common-size income statement for Year 1 by expressing each line item as a percentage of sales revenue. (Note: Round percentages to the nearest tenth of a percent.) 2. Prepare a common-size income statement for Year 2 by expressing each line item as a percentage of sales revenue. (Note: Round percentages to the nearest tenth of a percent.) 3. Prepare a common-size income statement for Year 3 by expressing each line item as a percentage of sales revenue. (Note: Round percentages to the nearest tenth of a percent.) Refer to the list below for the exact wording of an account title within your income statement. Labels Add Add operating expenses Less Less operating expenses Amount Descriptions Administrative expenses Contribution margin Cost of goods sold Gross margin Income after taxes Income before taxes Interest expense Operating income Sales Selling expenses Total 1. Prepare a common-size income statement for Year 1 by expressing each line item as a percentage of sales revenue. (Note: Enter all amounts as positive numbers. Round answers to the nearest tenth of a percent. Refer to the Labels and Amount Descriptions list provided for the exact wording of the answer choices for text entries.) Cuneo Company Income Statement For Year 1 1 Year 1 Percent of Sales in Year 1 2 3 4 5 (Label) 6 7 8 9 (Label) 10 11 2. Prepare a common-size income statement for Year 2 by expressing each line item as a percentage of sales revenue. (Note: Enter all amounts as positive numbers. Round answers to the nearest tenth of a percent. Refer to the Labels and Amount Descriptions list provided for the exact wording of the answer choices for text entries.) Cuneo Company Income Statement For Year 2 1 Year 2 Percent of Sales in Year 2 2 3 4 5 (Label) 6 7 8 9 (Label) 10 11 3. Prepare a common-size income statement for Year 3 by expressing each line item as a percentage of sales revenue. (Note: Enter all amounts as positive numbers. Round answers to the nearest tenth of a percent. Refer to the Labels and Amount Descriptions list provided for the exact wording of the answer choices for text entries.) Cuneo Company Income Statement For Year 3 1 Year 3 Percent of Sales in Year 3 2 3 4 5 (Label) 6 7 8 9 (Label) 10 11

Solutions

Expert Solution

Cuneo Company
Statement of Income
For the Year 2
Year-2 Year-1
Sales $12,00,000 83.3% $10,00,000
Less: Cost of goods sold -$7,00,000 100.0% -$7,00,000
Gross margin $5,00,000 60.0% $3,00,000
Less: Operating Expenses:
Selling Expenses -$2,20,000 68.2% -$1,50,000
Administrative expeses -$60,000 83.3% -$50,000
Operating Income $2,20,000 45.5% $1,00,000
Less:
Interest Expense -$25,000 100.0% -$25,000
Income before taxes $1,95,000 38.5% $75,000
Cuneo Company
Statement of Income
For the Year 2
Year-3 Year-1
Sales $17,00,000 58.8% $10,00,000
Less: Cost of goods sold -$10,00,000 70.0% -$7,00,000
Gross margin $7,00,000 42.9% $3,00,000
Less: Operating Expenses:
Selling Expenses -$2,50,000 60.0% -$1,50,000
Administrative expeses -$1,20,000 41.7% -$50,000
Operating Income $3,30,000 30.3% $1,00,000
Less:
Interest Expense -$25,000 100.0% -$25,000
Income before taxes $3,05,000 24.6% $75,000

Related Solutions

Cuneo Company’s income statements for the last 3 years are as follows: Cuneo Company Income Statements...
Cuneo Company’s income statements for the last 3 years are as follows: Cuneo Company Income Statements For the Years 1, 2, and 3 1 Year 1 Year 2 Year 3 2 Sales $1,000,000.00 $1,200,000.00 $1,700,000.00 3 Less: Cost of goods sold (700,000.00) (700,000.00) (1,000,000.00) 4 Gross margin $300,000.00 $500,000.00 $700,000.00 5 Less operating expenses: 6 Selling expenses (150,000.00) (220,000.00) (250,000.00) 7 Administrative expenses (50,000.00) (60,000.00) (120,000.00) 8 Operating income $100,000.00 $220,000.00 $330,000.00 9 Less: 10 Interest expense (25,000.00) (25,000.00) (25,000.00)...
Cuneo Company’s income statements for the last 3 years are as follows: Cuneo Company Income Statements...
Cuneo Company’s income statements for the last 3 years are as follows: Cuneo Company Income Statements For the Years 1, 2, and 3 1 Year 1 Year 2 Year 3 2 Sales $1,000,000.00 $1,200,000.00 $1,700,000.00 3 Less: Cost of goods sold (700,000.00) (700,000.00) (1,000,000.00) 4 Gross margin $300,000.00 $500,000.00 $700,000.00 5 Less operating expenses: 6 Selling expenses (150,000.00) (220,000.00) (250,000.00) 7 Administrative expenses (50,000.00) (60,000.00) (120,000.00) 8 Operating income $100,000.00 $220,000.00 $330,000.00 9 Less: 10 Interest expense (25,000.00) (25,000.00) (25,000.00)...
Scherer Company provided the following income statements for its first 3 years of operation: Scherer Company...
Scherer Company provided the following income statements for its first 3 years of operation: Scherer Company Income Statements Years of Operation 1 Year 1 Year 2 Year 3 2 Net sales $960,000.00 $1,056,000.00 $1,248,000.00 3 Less: Cost of goods sold 295,000.00 324,000.00 363,000.00 4 Gross margin $665,000.00 $732,000.00 $885,000.00 5 Less: 6 Operating expenses 425,000.00 484,000.00 595,500.00 7 Income taxes 109,600.00 121,200.00 136,600.00 8 Net income $130,400.00 $126,800.00 $152,900.00 Required: Prepare common-size income statements by using net sales as the...
The Harding Company manufactures skates. The company’s income statement for 20X1 is as follows: HARDING COMPANY...
The Harding Company manufactures skates. The company’s income statement for 20X1 is as follows: HARDING COMPANY Income Statement For the Year Ended December 31, 20X1 Sales (11,100 skates @ $72 each) $ 799,200 Variable costs (11,100 skates at $31) 344,100 Fixed costs 260,000 Earnings before interest and taxes (EBIT) $ 195,100 Interest expense 65,500 Earnings before taxes (EBT) $ 129,600 Income tax expense (30%) 38,880 Earnings after taxes (EAT) $ 90,720 a. Compute the degree of operating leverage. (Round your...
The Sterling Tire Company’s income statement for 20XX is as follows:    STERLING TIRE COMPANY Income Statement...
The Sterling Tire Company’s income statement for 20XX is as follows:    STERLING TIRE COMPANY Income Statement Year ended December 31, 20XX   Sales (20,000 tires at $60 each) $ 1,200,000       Less: Variable costs (20,000 tires at $30) 600,000   Contribution margin 600,000       Less: Fixed costs 400,000   Earnings before interest and taxes (EBIT) 200,000   Interest expense 50,000   Earnings before taxes (EBT) 150,000   Income tax expense (34%) 51,000      Earnings after taxes (EAT) $ 99,000 Given this income statement, compute the following:...
Vulcan Company’s contribution format income statement for June is as follows: Vulcan Company Income Statement For...
Vulcan Company’s contribution format income statement for June is as follows: Vulcan Company Income Statement For the Month Ended June 30 Sales $ 900,000 Variable expenses 300,000 Contribution margin 600,000 Fixed expenses 495,000 Net operating income $ 105,000 Management is disappointed with the company’s performance and is wondering what can be done to improve profits. By examining sales and cost records, you have determined the following: The company is divided into two sales territories—Northern and Southern. The Northern Territory recorded...
Vulcan Company’s contribution format income statement for June is as follows: Vulcan Company Income Statement For...
Vulcan Company’s contribution format income statement for June is as follows: Vulcan Company Income Statement For the Month Ended June 30 Sales $ 900,000 Variable expenses 400,000 Contribution margin 500,000 Fixed expenses 470,000 Net operating income $ 30,000 Management is disappointed with the company’s performance and is wondering what can be done to improve profits. By examining sales and cost records, you have determined the following: The company is divided into two sales territories—Northern and Southern. The Northern Territory recorded...
The Sterling Tire Company’s income statement for 20XX is as follows:    STERLING TIRE COMPANY Income Statement...
The Sterling Tire Company’s income statement for 20XX is as follows:    STERLING TIRE COMPANY Income Statement Year ended December 31, 20XX   Sales (35,000 tires at $50 each) $ 1,750,000       Less: Variable costs (35,000 tires at $20) 700,000   Contribution margin 1,050,000       Less: Fixed costs 750,000   Earnings before interest and taxes (EBIT) 300,000   Interest expense 75,000   Earnings before taxes (EBT) 225,000   Income tax expense (30%) 67,500      Earnings after taxes (EAT) $ 157,500 Given this income statement, compute the following:...
Vulcan Company’s contribution format income statement for June is as follows: Vulcan Company Income Statement For...
Vulcan Company’s contribution format income statement for June is as follows: Vulcan Company Income Statement For the Month Ended June 30 Sales   $   900,000 Variable expenses      408,000 Contribution margin      492,000 Fixed expenses      465,000 Net operating income   $   27,000 Management is disappointed with the company’s performance and is wondering what can be done to improve profits. By examining sales and cost records, you have determined the following: The company is divided into two sales territories—Northern and Southern. The...
Vulcan Company’s contribution format income statement for June is as follows: Vulcan Company Income Statement For...
Vulcan Company’s contribution format income statement for June is as follows: Vulcan Company Income Statement For the Month Ended June 30 Sales $ 800,000 Variable expenses 308,000 Contribution margin 492,000 Fixed expenses 465,000 Net operating income $ 27,000 Management is disappointed with the company’s performance and is wondering what can be done to improve profits. By examining sales and cost records, you have determined the following: The company is divided into two sales territories—Northern and Southern. The Northern Territory recorded...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT