Docstoc

Financial Statements Template

Document Sample
Financial Statements Template Powered By Docstoc
					COMPANY NAME                                MX                Reporting Period :                             Results 2009 - 2014
Income Statement                                                                                      2009 - 2014 T US Dollars
                                            2009      % Tp    % Pp    2010      % Tp    % Pp    2011   % Tp % Pp     2012    % Tp        % Pp     2013     % Tp    % Pp    2014      % Tp    % Pp
  1   Sales external                        93,429    100.0   100.0   94,453    100.0   100.0   95,344 100.0 100.0   95,980 96.7         100.0   102,446   100.0   100.0   83,972    100.0   100.0
  2   Sales intercompany                         0      0.0     0.0        0      0.0     0.0        0   0.0   0.0        0    0.0         0.0         0     0.0     0.0        0      0.0     0.0
  3   Sales intracompany                         0      0.0     0.0        0      0.0     0.0        0   0.0   0.0        0    0.0         0.0         0     0.0     0.0        0      0.0     0.0
  4   Sales dispositives                         0      0.0     0.0        0      0.0     0.0        0   0.0   0.0    3,247    3.3         3.4         0     0.0     0.0        0      0.0     0.0
  5   Merchandise                                0      0.0     0.0        0      0.0     0.0        0   0.0   0.0        0    0.0         0.0         0     0.0     0.0        0      0.0     0.0
  6   Other sales                                0      0.0     0.0        0      0.0     0.0        0   0.0   0.0        0    0.0         0.0         0     0.0     0.0        0      0.0     0.0
  7   Gross sales                           93,429    100.0   100.0   94,453    100.0   100.0   95,344 100.0 100.0   99,227 100.0        103.4   102,446   100.0   100.0   83,972    100.0   100.0
  8   Sales deductions                           0      0.0     0.0        0      0.0     0.0        0   0.0   0.0        0    0.0         0.0         0     0.0     0.0        0      0.0     0.0
  9   Net sales                             93,429    100.0   100.0   94,453    100.0   100.0   95,344 100.0 100.0   99,227 100.0        103.4   102,446   100.0   100.0   83,972    100.0   100.0
 10   Increase(+)/decrease(-) in goods           0      0.0     0.0        0      0.0     0.0        0   0.0   0.0        0    0.0         0.0         0     0.0     0.0        0      0.0     0.0
 11   Increase(+)/decrease(-) in tools           0      0.0     0.0        0      0.0     0.0        0   0.0   0.0        0    0.0         0.0         0     0.0     0.0        0      0.0     0.0
 12   Own work capitalized                       0      0.0     0.0        0      0.0     0.0        0   0.0   0.0        0    0.0         0.0         0     0.0     0.0        0      0.0     0.0
 13   Total performance                     93,429    100.0   100.0   94,453    100.0   100.0   95,344 100.0 100.0   99,227 100.0        103.4   102,446   100.0   100.0   83,972    100.0   100.0
 14   Production performance                93,429    100.0   100.0   94,453    100.0   100.0   95,344 100.0 100.0   95,980 96.7         100.0   102,446   100.0   100.0   83,972    100.0   100.0

 15   Cost of raw materials                 42,487             45.5   41,942             44.4   43,072           45.2   40,623            42.3    43,450            42.4   33,913             40.4
 16   Direct labor                           3,852              4.1    3,563              3.8    3,624            3.8    4,166             4.3     4,714             4.6    4,080              4.9
 17   Energy                                 2,746              2.9    2,701              2.9    3,145            3.3    3,069             3.2     3,277             3.2    2,737              3.3
 18   Freight out                            4,207              4.5    4,298              4.6    4,450            4.7    2,589             2.7     2,881             2.8    2,353              2.8
 19   Direct manufacturing cost             53,292             57.0   52,504             55.6   54,291           56.9   50,447            52.6    54,322            53.0   43,083             51.3
 20   Cost of dispositives                      32                         7                         6                      26                        14                      112
 21   Cost of merchandise                        0                         0                         0                       0                         0                        0
 22   Other variable cost                    3,752              4.0    3,740              4.0    3,991            4.2    3,076             3.2       678             0.7    2,022              2.4
 23   Marginal contribution                 36,353     38.9    38.9   38,202     40.4    40.4   37,056    38.9   38.9   45,678    46.0    47.6    47,432    46.3    46.3   38,755     46.2    46.2

 24 Manufacturing overhead                   2,197      2.4     2.4    2,268      2.4     2.4    2,476     2.6    2.6    1,524     1.5     1.6     1,369     1.3     1.3    1,259      1.5     1.5
 25 Other operating exp.(-) / inc.(+) PTU   -1,647     -1.8    -1.8   -1,814     -1.9    -1.9   -2,000    -2.1   -2.1   -2,783    -2.8    -2.9    -2,764    -2.7    -2.7   -2,519     -3.0    -3.0
 26 Gross margin plant                      32,509     34.8    34.8   34,120     36.1    36.1   32,580    34.2   34.2   41,371    41.7    43.1    43,299    42.3    42.3   34,977     41.7    41.7

 27   Administrative expenses                2,224      2.4     2.4    2,178      2.3     2.3    2,383     2.5    2.5    3,358     3.4     3.5     3,481     3.4     3.4    3,022      3.6     3.6
 28   Selling expenses                       1,099      1.2     1.2    1,180      1.2     1.2    1,227     1.3    1.3    1,271     1.3     1.3     1,536     1.5     1.5    1,259      1.5     1.5
 29   Research and development exp.          1,171      1.3     1.3      817      0.9     0.9        0     0.0    0.0        0     0.0     0.0         0     0.0     0.0        0      0.0     0.0
 30   Group fees                             1,922      2.1     2.1    1,947      2.1     2.1    1,905     2.0    2.0    3,117     3.1     3.2     3,071     3.0     3.0    2,520      3.0     3.0
 31   Company overhead                       6,416      6.9     6.9    6,122      6.5     6.5    5,515     5.8    5.8    7,746     7.8     8.1     8,088     7.9     7.9    6,801      8.1     8.1
 32   Operating result                      26,093     27.9    27.9   27,998     29.6    29.6   27,065    28.4   28.4   33,625    33.9    35.0    35,211    34.4    34.4   28,176     33.6    33.6

 33   Other non-operating exp. (-)                0     0.0     0.0         0     0.0     0.0         0   0.0   0.0           0   0.0   0.0            0   0.0   0.0             0   0.0   0.0
 34   Other non-operating income (+)              0     0.0     0.0         0     0.0     0.0         0   0.0   0.0           0   0.0   0.0            0   0.0   0.0             0   0.0   0.0
 35   Exchange rate losses (-)               -4,385    -4.7    -4.7    -6,272    -6.6    -6.6   -10,285 -10.8 -10.8     -16,749 -16.9 -17.5      -16,915 -16.5 -16.5        -8,977 -10.7 -10.7
 36   Exchange rate profits (+)               4,024     4.3     4.3     4,384     4.6     4.6    10,933 11.5 11.5        15,036 15.2 15.7         13,343 13.0 13.0           5,556   6.6   6.6
 37   Other result                             -361    -0.4    -0.4    -1,888    -2.0    -2.0       648   0.7   0.7      -1,713 -1.7 -1.8         -3,572 -3.5 -3.5          -3,421 -4.1 -4.1

 38   Interest income external (+)             639      0.7     0.7    1,183      1.3     1.3    2,381     2.5    2.5    3,533     3.6     3.7     4,015     3.9     3.9    3,358      4.0     4.0
 39   Interest income internal (+)               0      0.0     0.0        0      0.0     0.0        0     0.0    0.0        0     0.0     0.0         0     0.0     0.0        0      0.0     0.0
 40   Interest expenses external (-)             0      0.0     0.0        0      0.0     0.0        0     0.0    0.0        0     0.0     0.0         0     0.0     0.0        0      0.0     0.0
 41   Interest expenses internal (-)             0      0.0     0.0        0      0.0     0.0        0     0.0    0.0        0     0.0     0.0         0     0.0     0.0        0      0.0     0.0
 42   Income from participations (+/-)           0      0.0     0.0        0      0.0     0.0        0     0.0    0.0        0     0.0     0.0         0     0.0     0.0        0      0.0     0.0
 43   Financial result                         639      0.7     0.7    1,183      1.3     1.3    2,381     2.5    2.5    3,533     3.6     3.7     4,015     3.9     3.9    3,358      4.0     4.0

 44 Extraordinary expenses (-)                    0     0.0     0.0         0     0.0     0.0         0    0.0    0.0         0    0.0     0.0         0     0.0     0.0         0     0.0     0.0
 45 Extraordinary income (+)                      0     0.0     0.0         0     0.0     0.0         0    0.0    0.0         0    0.0     0.0         0     0.0     0.0         0     0.0     0.0
 46 Extraordinary result                          0     0.0     0.0         0     0.0     0.0         0    0.0    0.0         0    0.0     0.0         0     0.0     0.0         0     0.0     0.0

 47 Net income before taxes                 26,371     28.2    28.2   27,293     28.9    28.9   30,094    31.6   31.6   35,445    35.7    36.9    35,654    34.8    34.8   28,113     33.5    33.5

      Profit Distribution                         0                         0                         0                       0                        0                         0

 48 Local income tax (-)                    -10,860 -11.6 -11.6       -10,274 -10.9 -10.9       -11,121 -11.7 -11.7      -9,893 -10.0 -10.3       -9,195    -9.0    -9.0   -10,045 -12.0 -12.0
 49 Corporate income tax (-)                      0   0.0   0.0             0   0.0   0.0             0   0.0   0.0           0   0.0   0.0            0     0.0     0.0         0   0.0   0.0
 50 Total income tax                        -10,860 -11.6 -11.6       -10,274 -10.9 -10.9       -11,121 -11.7 -11.7      -9,893 -10.0 -10.3       -9,195    -9.0    -9.0   -10,045 -12.0 -12.0

 52 Net income third parties                      0     0.0     0.0         0     0.0     0.0         0    0.0    0.0         0    0.0     0.0         0     0.0     0.0         0     0.0     0.0

 53 Net income after taxes                  15,511     16.6    16.6   17,019     18.0    18.0   18,973    19.9   19.9   25,552    25.8    26.6    26,459    25.8    25.8   18,068     21.5    21.5

      EBIT                                   25,732    27.5    27.5    26,110    27.6    27.6    27,713   29.1   29.1    31,912   32.2    33.2    31,639    30.9    30.9    24,755    29.5    29.5
      EBITA                                  25,732    27.5    27.5    26,110    27.6    27.6    27,713   29.1   29.1    31,912   32.2    33.2    31,639    30.9    30.9    24,755    29.5    29.5
      EBITDA                                 26,630    28.5    28.5    27,001    28.6    28.6    28,670   30.1   30.1    32,801   33.1    34.2    32,109    31.3    31.3    25,421    30.3    30.3
COMPANY NAME                                                                 MX        Reporting Period :         Results 2009 - 2014
PROFIT & LOSS ACCOUNT                                                                               2009 - 2014 T US Dollars
                                                                             2009        2010          2011         2012       2013      2014
 1   Sales                                                                    93,429      94,453         95,344      99,227    102,446    83,972
 2   Increase/decrease finished goods, inventories, wip                            0           0              0            0         0         0
 3   Own work capitalized                                                          0           0              0            0         0         0
 4   Other operating income                                                        0           0              0            0         0         0
 5   Total positions                                                    
				
DOCUMENT INFO
Description: This Financial Statements Template provides template spreadsheets for a company's income statement, profits and loss account, balance sheet, cash flow statement, a worksheet of all company employees, and worksheet of all company capital expenditures. Each of these items is an essential tool for management to remain informed about the current state of the company. The financial documents can be used to calculate various financial ratios, which are metrics of how a company is currently performing and can also help predict future performance. Management should use these worksheets to maintain a complete picture of current company performance, assets, and employees.
This document is also part of a package Financial Statements and Projections 22 Documents Included