Question
Vertical analysis of income statement For 20Y2, Fielder Industries Inc. initiated a sales promotion campaign that included the expenditure of an additional $40,000 for advertising.
Vertical analysis of income statement
For 20Y2, Fielder Industries Inc. initiated a sales promotion campaign that included the expenditure of an additional $40,000 for advertising. At the end of the year, Leif Grando, the president, is presented with the following condensed comparative income statement:
Line Item Description | 20Y2 | 20Y1 |
---|---|---|
Sales | $1,300,000 | $1,180,000 |
Cost of goods sold | (682,500) | (613,600) |
Gross profit | $617,500 | $566,400 |
Selling expenses | $(260,000) | $(188,800) |
Administrative expenses | (169,000) | (177,000) |
Total operating expenses | $(429,000) | $(365,800) |
Operating income | $188,500 | $200,600 |
Other revenue | 78,000 | 70,800 |
Income before income tax expense | $266,500 | $271,400 |
Income tax expense | (117,000) | (106,200) |
Net income | $149,500 | $165,200 |
Required:
Question Content Area
1. Prepare a comparative income statement for the two-year period, presenting an analysis of each item in relationship to sales for each of the years. Round to one decimal place. For those boxes in which you must enter subtracted or negative numbers use a minus sign.
Line Item Description | 20Y2 Amount | 20Y2 Percent | 20Y1 Amount | 20Y1 Percent |
---|---|---|---|---|
Sales | $1,300,000 | % | $1,180,000 | % |
Cost of goods sold | (682,500) | % | (613,600) | % |
Gross profit | $617,500 | % | $566,400 | % |
Selling expenses | $(260,000) | % | (188,800) | % |
Administrative expenses | (169,000) | % | (177,000) | % |
Total operating expenses | $(429,000) | % | $(365,800) | % |
Operating income | $188,500 | % | $200,600 | % |
Other revenue | 78,000 | % | 70,800 | % |
Income before income tax expense | $266,500 | % | $271,400 | % |
Income tax expense | (117,000) | % | (106,200) | % |
Net income | $149,500 | % | $165,200 | % |
2. The net income as a percent of sales has increased or decreased. All the costs and expenses, other than selling expenses, have maintained their approximate cost as a percent of sales relationship between 20Y1 and 20Y2. Selling expenses as a percent of sales, however, have increased or decreased. Apparently, the new advertising campaign has or has not been successful. The increased expense has or has not produced sufficient sales to maintain relative profitability. Thus, selling expenses as a percent of sales have increased or decreased.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started