Question

1. Prepare an income statement in comparative form, stating each item for both years as a...

1. Prepare an income statement in comparative form, stating each item for both years as a percent of sales. Round your percentages to one decimal place. Enter all amounts as positive numbers. Question not attempted. Score: 0/76 Indigo Company Comparative Income Statement For the Years Ended December 31, 2016 and 2015 1 2016 2016 2015 2015 2 Amount Percent Amount Percent 3 Sales $890,000.00 $600,000.00 4 Cost of goods sold 320,400.00 228,000.00 5 Gross profit $569,600.00 $372,000.00 6 Selling expenses $142,400.00 $84,000.00 7 Administrative expenses 62,300.00 54,000.00 8 Total operating expenses $204,700.00 $138,000.00 9 Income from operations $364,900.00 $234,000.00 10 Other income 80,100.00 54,000.00 11 Income before income tax $445,000.00 $288,000.00 12 Income tax expense 231,400.00 156,000.00 13 Net income $213,600.00 $132,000.00

Homework Answers

Answer #1

Indigo Company

Comparative Income Statement

For the Years Ended December 31, 2016 and 2015

2016

2015

Amount

%

Amount

%

Sales

890000

100.0%

600000

100.0%

Cost of goods Sold

320400

36.0%

228000

38.0%

Gross profit

569600

64.0%

372000

62.0%

Selling expenses

142400

16.0%

84000

14.0%

Administrative expenses

62300

7.0%

54000

9.0%

Total operating expenses

204700

23.0%

138000

23.0%

Income from operations

364900

41.0%

234000

39.0%

Other income

80100

9.0%

54000

9.0%

Income before income tax

445000

50.0%

288000

48.0%

To calculate percentage, the amount of each item of respective is year is divided by the sales of respective year

For example

Percentage of gross profit in 2016 = gross profit in 2016 / sales in 2016 = 569600/890000 = 64.0%

Percentage of gross profit in 2015 = gross profit in 2015 / sales in 2015 = 372000/600000 = 62.0%

In the same way it is calculated for all items for both years.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
For 2016, Indigo Company initiated a sales promotion campaign that included the expenditure of an additional...
For 2016, Indigo Company initiated a sales promotion campaign that included the expenditure of an additional $39,000 for advertising. At the end of the year, Lumi Neer, the president, is presented with the following condensed comparative income statement: Indigo Company Comparative Income Statement For the Years Ended December 31, 2016 and 2015 1 2016 2015 2 Sales $940,000.00 $540,000.00 3 Cost of goods sold 338,400.00 205,200.00 4 Gross profit $601,600.00 $334,800.00 5 Selling expenses $159,800.00 $81,000.00 6 Administrative expenses 47,000.00...
Vertical Analysis of Income Statement Revenue and expense data for Rogan Technologies Co. are as follows:...
Vertical Analysis of Income Statement Revenue and expense data for Rogan Technologies Co. are as follows: 20Y8 20Y7 Sales $599,000 $539,000 Cost of goods sold 353,410 291,060 Selling expenses 95,840 97,020 Administrative expenses 107,820 118,580 Income tax expense 23,960 10,780 a. Prepare an income statement in comparative form, stating each item for both 20Y8 and 20Y7 as a percent of sales. If required, round percentages to one decimal place. Enter all amounts as a positive number. Rogan Technologies Co. Comparative...
Vertical Analysis of Income Statement Revenue and expense data for Innovation Quarter Inc. for two recent...
Vertical Analysis of Income Statement Revenue and expense data for Innovation Quarter Inc. for two recent years are as follows:        Current Year        Previous Year Sales $435,000 $396,000 Cost of goods sold 269,700 221,760 Selling expenses 65,250 71,280 Administrative expenses 73,950 59,400 Income tax expense 8,700 15,840 a. Prepare an income statement in comparative form, stating each item for both years as a percent of sales. If required, round percentages to one decimal place. Enter all amounts as positive numbers. (For...
Here are the comparative income statements of Ayayai Corp.. AYAYAI CORP. Comparative Income Statement For the...
Here are the comparative income statements of Ayayai Corp.. AYAYAI CORP. Comparative Income Statement For the Years Ended December 31 2017 2016 Net sales $600,000 $500,000 Cost of goods sold 445,000 400,000 Gross Profit 155,000 100,000 Operating expenses 70,000 40,000 Net income $ 85,000 $ 60,000 (a) Prepare a horizontal analysis of the income statement data for Ayayai Corp., using 2016 as a base. (If amount and percentage are a decrease show the numbers as negative, e.g. -55,000, -20% or...
Question 1 Prepare a horizontal analysis of the following comparative income statement for Westwind Corporation. Round...
Question 1 Prepare a horizontal analysis of the following comparative income statement for Westwind Corporation. Round percentage changes to the nearest one-tenth percent. Westwind Corporation Comparative Income Statement For the Years Ended December 31, 2016 and 2015 2016 2015 Total revenue $1,400,000 $1,250,000 Expenses:    Cost of goods sold 925,000 $830,000    Operating expenses 313,000 280,000    Interest expense 14,000 12,000    Income tax expense 48,300 38,000 Total expenses $1,300,300 $1,160,000 Net Income $99,700 $90,000
Here are the comparative income statements of Ayayai Corp.. AYAYAI CORP. Comparative Income Statement For the...
Here are the comparative income statements of Ayayai Corp.. AYAYAI CORP. Comparative Income Statement For the Years Ended December 31 2017 2016 Net sales $600,000 $500,000 Cost of goods sold 445,000 400,000 Gross Profit 155,000 100,000 Operating expenses 70,000 40,000 Net income $ 85,000 $ 60,000 (a) Prepare a horizontal analysis of the income statement data for Ayayai Corp., using 2016 as a base. (If amount and percentage are a decrease show the numbers as negative, e.g. -55,000, -20% or...
                         Fishing Experiences Comparative             &nbsp
                         Fishing Experiences Comparative                               Income Statement For the Years Ended Decemeber 31, 2014 and 2013           20Y6                          Percent                  20Y5            Percent Sales                      200,000              ?          1 ,000,000                      ? Costs of goods sold   -624,000                ?        -558,000                      ? Gross profit               576,000                   ?         442,000                      ? Selling expenses     -120,000                      ?        -75,000                      ? Administrative expenses -50,000                   ? -50,000            ? Total operating expenses -170,000                 ?              -125,000          ? Income from operations       406,000              ?            317,000              ? Other...
Vertical Analysis of Income Statement Revenue and expense data for Innovation Quarter Inc. for two recent...
Vertical Analysis of Income Statement Revenue and expense data for Innovation Quarter Inc. for two recent years are as follows:        Current Year        Previous Year Sales $583,000 $531,000 Cost of goods sold 332,310 276,120 Selling expenses 99,110 100,890 Administrative expenses 110,770 90,270 Income tax expense 17,490 26,550 a. Prepare an income statement in comparative form, stating each item for both years as a percent of sales. If required, round percentages to one decimal place. Enter all amounts as positive numbers. Innovation...
Vertical Analysis of Income Statement For 20Y2, Tri-Comic Company initiated a sales promotion campaign that included...
Vertical Analysis of Income Statement For 20Y2, Tri-Comic Company initiated a sales promotion campaign that included the expenditure of an additional $23,000 for advertising. At the end of the year, Lumi Neer, the president, is presented with the following condensed comparative income statement: Tri-Comic Company Comparative Income Statement For the Years Ended December 31, 20Y2 and 20Y1 20Y2 20Y1 Sales $812,000 $698,000 Cost of goods sold 365,400 349,000 Gross profit $446,600 $349,000 Selling expenses $162,400 $132,620 Administrative expenses 89,320 90,740...
please show example through Excel Vertical Analysis of Income Statement For 2014, Othere Technology Company initiated...
please show example through Excel Vertical Analysis of Income Statement For 2014, Othere Technology Company initiated a sales promotion campaign that included the expenditure of an additional $15,000 for advertising. At the end of the year, George Wallace, the president, is presented with the following condensed comparative income statement: Othere Technology Company Comparative Income Statement For the Years Ended December 31, 2014 and 2013 2014 2013 Sales $529,240 $455,510 Sales returns and allowances 5,240 4,510 Net sales $524,000 $451,000 Cost...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT