Question
Solve the following problem. Solve the follwing problem. Horizontal analysis of income statement For 20Y2, McDade Company reported a decline in net income. At the
Solve the following problem.
Solve the follwing problem.
Horizontal analysis of income statement
For 20Y2, McDade Company reported a decline in net income. At the end of the year, T. Burrows, the president, is presented with the following condensed comparative income statement:
McDade Company |
Comparative Income Statement |
For the Years Ended December 31, 20Y2 and 20Y1 |
1 | 20Y2 | 20Y1 | |
2 | Sales | $6,787,200.00 | $6,060,000.00 |
3 | Cost of goods sold | 2,444,200.00 | 2,020,000.00 |
4 | Gross profit | $4,343,000.00 | $4,040,000.00 |
5 | Selling expenses | $1,125,000.00 | $900,000.00 |
6 | Administrative expenses | 711,200.00 | 560,000.00 |
7 | Total operating expenses | $1,836,200.00 | $1,460,000.00 |
8 | Income from operations | $2,506,800.00 | $2,580,000.00 |
9 | Other income | 165,000.00 | 150,000.00 |
10 | Income before income tax | $2,671,800.00 | $2,730,000.00 |
11 | Income tax expense | 60,000.00 | 50,000.00 |
12 | Net income | $2,611,800.00 | $2,680,000.00 |
1. | Prepare a comparative income statement with horizontal analysis for the two-year period, using 20Y1 as the base year. Use the minus sign to indicate an amount or percent decrease. If required, round percentages to one decimal place. |
2. | To the extent the data permit, comment on the significant relationships revealed by the horizontal analysis prepared in (1). |
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