Create horizontal analysis of the balance sheet data

Question

Problem:

The comparative condensed balance sheets of Conard Corporation are presented below.

CONARD CORPORATION

Comparative Condensed Balance Sheets
December 31
2012    2011
Assets
Current assets                                 $ 74,380    $ 80,020
Property, plant, and equipment (net)    98,620    90,090
Intangibles                                         27,080    40,450
Total assets                                     $200,080   $210,560

Liabilities and stockholders' equity
Current liabilities                                   $ 42,170     $ 47,920
Long-term liabilities                                 142,940     150,570
Stockholders' equity                                  14,970       12,070
Total liabilities and stockholders' equity    $200,080    $210,560

Prepare a horizontal analysis of the balance sheet data for Conard Corporation using 2011 as a base. (If amount is a decrease, use either a negative sign preceding the number and/or percentage eg -45 or parentheses eg (45). Round percentages to 1 decimal place, e.g. 10.5%.)

Prepare a vertical analysis of the balance sheet data for Conard Corporation in columnar form for 2012. (Round percentages to 1 decimal place, e.g. 10.5%.)