eBook
Show Me How
Calculator
Horizontal analysis of income statement
2012
For 2012, 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 2041
2011
Sales
$ 16,800,000 $ 15,000,000
Cost of goods sold
(11,500,000) (10,000,000)
Gross profit
$5,300,000 $5,000,000
Selling expenses
$ (1,770,000) $ (1,500,000)
Administrative expenses
(1,220,000) (1,000,000)
Total operating expenses
$ (2,990,000) $ (2,500,000)
Operating income
$ 2,310,000 $ 2,500,000
Other revenue
256,950
225,000
Income before income tax expense
$ 2,566,950 $ 2,725,000
Income tax expense
(1,413,000) (1,500,000)
Net income
$1,153,950 $1,225,000
1. Prepare a comparative income statement with horizontal analysis for the two-year period, using 2011 as the base year. Round percentages to one
decimal place. For those boxes in which you must enter subtracted or negative numbers use a minus sign.
McDade Company
What’s the difference

Respuesta :

Answer:

                            McDade Company

                  Comparative Income Statement

       For the Years Ended December 31, 2012 and 2011

                                       2012              2011              Change          %

Sales                      $16,800,000   $15,000,000      $1,800,000      12%

COGS                   ($11,500,000)  ($10,000,000)     $1,500,000      15%

Gross profit             $5,300,000     $5,000,000        $300,000       6%

Selling expenses    ($1,770,000)    ($1,500,000)        $270,000      18%

Adm. expenses      ($1,220,000)    ($1,000,000)        $220,000     22%

Operating exp.     ($2,990,000)   ($2,500,000)        $490,000   19.6%

Operating income   $2,310,000     $2,500,000        ($190,000)    -7.6%

Other revenue           $256,950         $225,000            $31,950    14.2%

EBT                          $2,566,950     $2,725,000        ($158,050)   -5.8%

Income taxes           ($1,413,000)    ($1,500,000)        ($87,000)   -5.8%

Net income                $1,153,950      $1,225,000        ($71,050)   -5.8%