Docstoc

Cash Report

Document Sample
Cash Report Powered By Docstoc
					                                                 Sheet1
                                                   CASH REPORT

DATE:

CASHIER:


                                                      RECEIPTS

                  Receipt #    Payment Method                   Description       Currency
              1                                                                   USD
              2                                                                   USD
              3                                                                   USD
              4                                                                   USD
              5                                                                   USD
              6                                                                   USD
              7                                                                   USD
              8                                                                   USD
              9                                                                   USD
             10                                                                   USD

                                                                                  TOTAL:

                                                      SUMMARY

                               Total Receipts                                 0
                               Cash                                           0
                               Check                                          0
                               Credit Card                                    0
                               Other                                          0

                               Last Reported Receipt Number:


                  I confirm receiving the above amounts and clearing the cashier custody for the day:

NAME:                                                                             DATE:



SIGNATURE:




                                                 Page 1
                            Sheet1




            Amount
                 $0.00
                 $0.00
                 $0.00
                 $0.00
                 $0.00
                 $0.00
                 $0.00
                 $0.00
                 $0.00
                 $0.00

                    $0.00




r custody for the day:




                            Page 2
          Customer 2                   0            0             0              0
                                  Customer 3              12,752       14,027        14,027         13,389
Subsidies                                                      0            0             0              0
Additional loan                                                0            0             0              0
VAT Receivables                                           38,413       29,718        38,663         36,093
Other payments                                                 0            0             0              0 Debts VWM from week 34 + extra claims to end of 2005
Cash inflow (positive amounts)                           503,681      339,888       408,463        404,462
Ending cash balance                                         -174       -17,502      -19,468         -6,896
Credit limit (current bank accounts)

Financial payables (loans)
B.B.V.A. Bancomer                 usage                   22,872       22,872        15,248         15,248
Loan                              limit                   22,872       22,872        15,248         15,248
                                  interest rate
                                  maturity date
HQ                                usage                       0.0          0.0          0.0            0.0
                                  limit                       0.0          0.0          0.0            0.0
                                  interest rate
                                  maturity date
GmbH                              usage                  104,943      104,943       104,943        104,943
                                  limit                  104,943      104,943       104,943        104,943
                                  interest rate
                                  maturity date
Bank / Outside Financing          usage
                                  limit
                                  interest rate
                                  maturity date

Cash account after interest and tax (forecast)           -127,989     -145,317     -139,659       -127,086
Cash account after interest and tax (PlanXI/01)          -127,989     -145,317     -139,659       -127,086
Automoitve                                                                                                   Ending Cash Balance is result of 30 days payment term USD!!
k MXP                                      5/11/2010
                                                       forecast1    forecast2    forecast3     forecast4
cash flow (current bank accounts)                      30/04/09     31/05/09     00/01/00      31/07/09
                            ex. rate to EURO:             13.1144      13.1144      13.1144       13.1144                                   Comments
                             ex. rate to USD:             10.8914      10.8914      10.8914       10.8914
                              ex. rate to JPY:             0.0927       0.0927       0.0927         0.0927
Starting cash balance                                      40,531       16,210        -5,209       -24,385
Payments to                       suppliers, 3rd
                                  Supplier 1
                                  Supplier 2
                                  Supplier 3
Payroll / social security / tax                            -3,986       -4,110       -4,110        -4,115
Investments                                                   -50          -50          -50           -50
Interest payments
Loan refund
VAT Payables                                              -50,557      -38,413      -29,718       -38,663
Other payments                                             -8,142       -8,564       -8,728        -8,498 Including consumables and pre-logistics costs
Cash outflow (negative amounts)                           -62,734      -51,138      -93,932       -51,326
Payments from                     customer, 3rd
                                  Customer 1
                                  Customer 2
                                  Customer 3
Subsidies
Additional loan
VAT Receivables                                           38,413       29,718        38,663        36,093
Other payments
Cash inflow (positive amounts)                            38,413       29,718        74,756        36,093
Ending cash balance                                       16,210        -5,209      -24,385       -39,618
Credit limit (current bank accounts)

Financial payables (loans)
B.B.V.A. Bancomer                 usage
Loan                              limit
                                  interest rate
                                  maturity date
HQ                                usage
                                  limit
                                  interest rate
                                  maturity date
GmbH                              usage
                                  limit
                                  interest rate
                                  maturity date
Bank / Outside Financing          usage
                                  limit
                                  interest rate
                                  maturity date

Cash account after interest and tax (forecast)            16,210        -5,209      -24,385       -39,618
Cash account after interest and tax (PlanXI/01)           16,210        -5,209      -24,385       -39,618
Automotive                                                                                                 Ending Cash Balance is result of 30 days payment term USD!!
k USD                                      5/11/2010
                                                       forecast1    forecast2    forecast3    forecast4
cash flow (current bank accounts)                      30/04/09     31/05/09     30/06/09     31/07/09
                            ex. rate to EURO:             13.1144      13.1144      13.1144      13.1144                                  Comments
                             ex. rate to USD:             10.8914      10.8914      10.8914      10.8914
                              ex. rate to JPY:             0.0927       0.0927       0.0927       0.0927
Starting cash balance                                       1,236        1,968        3,216        3,751
Payments to                       suppliers, 3rd          -37,876      -23,094      -26,837      -25,991
                                  Supplier 1
                                  Supplier 2
                                  Supplier 3
Payroll / social security / tax
Investments
Interest payments                                             -40          -40         -53           -53
Loan refund                                                                           -700                 Lum Sum Payback in Jun 06 to BBVA
VAT Payables
Other payments
Cash outflow (negative amounts)                           -37,916      -23,134      -27,590      -26,044
Payments from                     customer, 3rd           37,477       23,094       26,837       25,991
                                  Customer 1
                                  Customer 2
                                  Customer 3               1,171        1,288        1,288        1,229
Subsidies
Additional loan
VAT Receivables
Other payments
Cash inflow (positive amounts)                            38,648       24,382       28,125       27,221
Ending cash balance                                        1,968        3,216        3,751        4,927
Credit limit (current bank accounts)

Financial payables (loans)
B.B.V.A. Bancomer                 usage                     2,100        2,100        1,400        1,400
Loan                              limit                     2,100        2,100        1,400        1,400
                                  interest rate            5.00%        5.00%        5.00%        5.00%
                                  maturity date
HQ                                usage
                                  limit
                                  interest rate
                                  maturity date
GmbH                              usage                     9,635        9,635        9,635        9,635
                                  limit                     9,635        9,635        9,635        9,635
                                  interest rate            5.00%        5.00%        5.00%        5.00%
                                  maturity date
Bank / Outside Financing          usage
                                  limit
                                  interest rate
                                  maturity date

Cash account after interest and tax (forecast)             -9,767       -8,519       -7,284       -6,108
Cash account after interest and tax (PlanXI/01)            -9,767       -8,519       -7,284       -6,108
Automotive                                                                                                     Ending Cash Balance is result of 30 days payment term USD!!
k EUR                                      5/11/2010
                                                       forecast1     forecast2     forecast3     forecast4
cash flow (current bank accounts)                      30/04/09      31/05/09      30/06/09      31/07/09
                            ex. rate to EURO:             13.1144       13.1144       13.1144       13.1144                                  Comments
                             ex. rate to USD:             10.8914       10.8914       10.8914       10.8914
                              ex. rate to JPY:             0.0927        0.0927        0.0927        0.0927
Starting cash balance                                           77        -2,884        -3,608        -3,902
Payments to                       suppliers, 3rd           -6,342        -4,126        -5,134        -4,339 Including due payments (15 days stock in EUR)
                                  Supplier 1
                                  Supplier 2
                                  Supplier 3
Payroll / social security / tax
Investments
Interest payments
Loan refund
VAT Payables
Other payments
Cash outflow (negative amounts)                            -6,342        -4,126        -5,134        -4,339
Payments from                     customer, 3rd             3,381         3,402         4,840         5,482
                                  Customer 1
                                  Customer 2
                                  Customer 3
Subsidies
Additional loan
VAT Receivables
Other payments
Cash inflow (positive amounts)                              3,381         3,402         4,840         5,482
Ending cash balance                                        -2,884        -3,608        -3,902        -2,759
Credit limit (current bank accounts)

Financial payables (loans)
B.B.V.A. Bancomer                 usage
Loan                              limit
                                  interest rate
                                  maturity date
HQ                                usage
                                  limit
                                  interest rate
                                  maturity date
GmbH                              usage
                                  limit
                                  interest rate
                                  maturity date
Bank / Outside Financing          usage
                                  limit
                                  interest rate
                                  maturity date

Cash account after interest and tax (forecast)             -2,884        -3,608        -3,902        -2,759
Cash account after interest and tax (PlanXI/01)            -2,884        -3,608        -3,902        -2,759
Automotive Mexico                                                                                             Ending Cash Balance is result of 30 days payment term USD!!
k JPY                                      5/11/2010
                                                       forecast1    forecast2     forecast3     forecast4
cash flow (current bank accounts)                      30/04/09     31/05/09      30/06/09      31/07/09
                            ex. rate to EURO:             13.1144      13.1144       13.1144       13.1144                                Comments
                             ex. rate to USD:             10.8914      10.8914       10.8914       10.8914
                              ex. rate to JPY:             0.0927       0.0927        0.0927        0.0927
Starting cash balance                                                         0             0             0
Payments to                       suppliers, 3rd
                                  Supplier 1
                                  Supplier 2
                                  Supplier 3
Payroll / social security / tax
Investments
Interest payments
Loan refund
VAT Payables
Other payments
Cash outflow (negative amounts)                                0             0             0             0
Payments from                     customer, 3rd
                                  Customer 1
                                  Customer 2
                                  Customer 3
Subsidies
Additional loan
VAT Receivables
Other payments
Cash inflow (positive amounts)                                 0             0             0             0
Ending cash balance                                            0             0             0             0
Credit limit (current bank accounts)

Financial payables (loans)
B.B.V.A. Bancomer                 usage
Loan                              limit
                                  interest rate
                                  maturity date
HQ                                usage
                                  limit
                                  interest rate
                                  maturity date
GmbH                              usage
                                  limit
                                  interest rate
                                  maturity date
Bank / Outside Financing          usage
                                  limit
                                  interest rate
                                  maturity date

Cash account after interest and tax (forecast)                 0             0             0             0
Cash account after interest and tax (PlanXI/01)                0             0             0             0
                                             W43


   BMBEJK
OVERFLOW     VALOR01         BOWACD               CASH-OUTFLOWS
                                                     Apr09           Mai09           Jun09

    200609      698,296.68   EUR                     418,978.01
    200610      526,165.41   EUR                     945,143.42
    200611    1,340,151.62   EUR                   2,285,295.04
    200612      606,136.24   EUR                   2,891,431.27
    200613      524,990.60   EUR                   3,416,421.88
    200614      930,951.16   EUR                                     930,951.16
    200615    1,027,576.84   EUR                                   1,958,528.00
    200616    1,160,418.96   EUR                                   3,118,946.96
    200617    1,007,528.47   EUR                                   4,126,475.43
    200618    1,043,770.82   EUR                                                   1,043,770.82
    200619      601,084.51   EUR                                                   1,644,855.34
    200620    1,435,591.32   EUR                                                   3,080,446.65
    200621    1,323,809.46   EUR                                                   4,404,256.11
    200622    1,216,160.28   EUR                                                   5,133,952.28
    200623    1,506,823.55   EUR
    200624      996,503.82   EUR
    200625      349,410.87   EUR
    200626    1,000,000.00   EUR
         0   17,295,370.61   EUR
    200609                   USD                   6,864,215.72
    200610                   USD                  13,473,500.95
    200611      731,979.31   USD                  16,130,762.52
    200612    3,311,255.63   USD                  19,442,018.15
    200613    4,752,029.65   USD                                   4,752,029.65
    200614    4,008,969.42   USD                                   8,760,999.07
    200615      585,152.49   USD                                   9,346,151.56
    200616    4,747,744.85   USD                                  14,093,896.41
    200617    4,583,349.80   USD                                                   4,583,349.80
    200618    2,018,548.04   USD                                                   6,601,897.84
    200619    2,598,446.37   USD                                                   9,200,344.21
    200620    4,396,627.01   USD                                                  13,596,971.23
    200621    4,240,259.61   USD                                                  17,837,230.83
    200622    4,169,109.40   USD
    200623    4,057,507.36   USD
    200624    3,588,085.15   USD
    200625    3,676,605.82   USD
         0   51,465,669.92   USD



                               ALCOA estimated 10,500,000.00       9,000,000.00    9,000,000.00

                                      Total EUR    3,416,421.88    4,126,475.43    5,133,952.28

                                      Total USD 19,442,018.15     14,093,896.41   17,837,230.83

                                      Total YEN

                                      VAT EUR ver banco+SBI         507,144.31      510,334.44


                                            Page 6
      W43


VAT USD ver banco+SBI   2,916,302.72   2,114,084.46
VAT YEN ver banco+SBI            -              -




     Page 7
                                                 W43


                             SBI                CASH-INFLOWS
   Jul09                           Apr09           Mai09            Jun09           Jul09

                               2,854,796.68
                               3,380,962.09
                                                  1,340,151.62
                                                  1,946,287.86
                                                  2,471,278.46
                                                  3,402,229.62
                                                                  1,027,576.84
                                                                  2,187,995.80
                                                                  3,195,524.28
                                                                  4,239,295.10
                                                                  4,840,379.61
                                                                                  1,435,591.32
                                                                                  2,759,400.77
   486,464.11                                                                     3,975,561.05
 1,993,287.66                                                                     5,482,384.60
 2,989,791.48
 3,339,202.35
 4,339,202.35

                               6,864,215.72
                              13,473,500.95
                              16,130,762.52
                              19,442,018.15
                                                  4,752,029.65
                                                  8,760,999.07
                                                  9,346,151.56
                                                 14,093,896.41
                                                                  4,583,349.80
                                                                  6,601,897.84
                                                                  9,200,344.21
                                                                 13,596,971.23
                                                                 17,837,230.83
 4,169,109.40                                                                     4,169,109.40
 8,226,616.76                                                                     8,226,616.76
11,814,701.92                                                                    11,814,701.92
15,491,307.74                                                                    15,491,307.74




10,500,000.00 ALCOA estimated 10,500,000.00       9,000,000.00    9,000,000.00   10,500,000.00

 4,339,202.35 Total EUR        3,380,962.09       3,402,229.62    4,840,379.61    5,482,384.60

15,491,307.74 Total USD       19,442,018.15      14,093,896.41   17,837,230.83   15,491,307.74

                Total YEN

  726,056.94 VAT EUR               507,144.31       510,334.44     726,056.94      822,357.69


                                                Page 8
                                       W43


2,675,584.62 VAT USD   2,916,302.72     2,114,084.46    2,675,584.62   2,323,696.16
         -   VAT YEN            -                -               -              -

            VAT EUR                          3,190.13     215,722.50      96,300.75
            VAT USD                       -802,218.26     561,500.16    -351,888.46
            VAT YEN                              0.00           0.00           0.00




                                      Page 9
Automotive System
SUMMARY

Date                                           27.03.2009
Key Date                                       27.03.2009
User                                           I678R
Log de Materiales:                             MATNR_XX.TXT
Log de Facturas VW:                            FACT_XX.TXT


SAP CODE      NAME                                    date VW
                                               CURRENCY            SUBTOTAL

     600001   Panasonic INC                    USD    30.03.2009        151,982.71
     600006   Linde Pullmann de Queretaro      USD    30.03.2009         90,381.82
     600008   Lunkomex SA                      USD    30.03.2009         81,817.52
     600013   Thyssen Krupp Presta de Mexico   USD    30.03.2009        268,504.32
     600014   Transnav INC.                    USD    30.03.2009          5,053.33
     600016   Valeo Climat Control             USD    30.03.2009        387,390.05
     600018   Benteler de Mexico               USD    30.03.2009        136,950.61
     600021   DELPHI ELECTRONICS & SAFETY      USD    30.03.2009        521,862.56
     600024   Alcoa Fujikura de Mexico         USD    30.03.2009      2,137,758.35
     600025   FTE Mexicana S.A. de C.V.        USD    30.03.2009        195,098.00
     600027   Hella KG Hueck Co.               USD    30.03.2009        144,791.21
     600028   HUF North America Automotive     USD    30.03.2009        130,426.28
     600037   Manufacturas GCI, S.A. de C.V.   USD    30.03.2009          3,990.08
     600048   AKSYS de Mexico                  USD    30.03.2009         25,525.80
     600049   Autoliv Steering Weels Mexico    USD    30.03.2009        292,070.36
     600050   Autotek Industrial de Mexico     USD    30.03.2009          2,525.41
     600057   ALPS AUTOMOTIVE, INC.            USD    30.03.2009         98,344.58
     700000   Faurecia Duroplast Mexico        USD    30.03.2009        688,963.06
     700001   Siemens VDO S.A. de C.V.         USD    30.03.2009        404,551.90
     900000   SAS Automotive Systems           USD    30.03.2009        304,445.08
     900013   PROVEEDOR NP-SAP                 USD    30.03.2009       -106,179.34
                                               USD    30.03.2009      6,253,142.52

     600001   Panasonic INC                    USD    06.04.2009        157,773.99
     600006   Linde Pullmann de Queretaro      USD    06.04.2009         89,962.19
     600008   Lunkomex SA                      USD    06.04.2009         87,684.49
     600013   Thyssen Krupp Presta de Mexico   USD    06.04.2009        260,899.94
     600014   Transnav S. A. de C.V.           USD    06.04.2009          4,912.68
     600016   Valeo Climat Control             USD    06.04.2009        785,240.33
     600018   Benteler de Mexico               USD    06.04.2009        132,825.41
     600021   DELPHI ELECTRONICS & SAFETY      USD    06.04.2009        559,241.97
     600024   Alcoa Fujikura de Mexico         USD    06.04.2009      1,799,298.02
     600025   FTE Mexicana S.A. de C.V.        USD    06.04.2009        189,769.60
     600027   Hella KG Hueck Co.               USD    06.04.2009        141,286.86
     600028   HUF North America Automotive     USD    06.04.2009        129,511.58
     600037   Manufacturas GCI, S.A. de C.V.   USD    06.04.2009          3,869.92
     600048   AKSYS de Mexico                  USD    06.04.2009         24,289.28
     600049   Autoliv Steering Weels Mexico    USD    06.04.2009        154,794.72
     600050   Autotek Industrial de Mexico     USD    06.04.2009          2,449.33
     600057   ALPS AUTOMOTIVE, INC.            USD    06.04.2009         84,866.69
700000   Faurecia Duroplast Mexico        USD   06.04.2009      671,485.87
700001   Siemens VDO S.A. de C.V.         USD   06.04.2009      385,342.56
900000   SAS Automotive Systems           USD   06.04.2009      296,726.90
900013   PROVEEDOR NP-SAP                 USD   06.04.2009        6,650.28
                                          USD   06.04.2009    5,968,882.61

600001   Panasonic INC                    USD   13.04.2009      156,674.28
600006   Linde Pullmann de Queretaro      USD   13.04.2009       88,783.03
600008   Lunkomex SA                      USD   13.04.2009       84,460.07
600013   Thyssen Krupp Presta de Mexico   USD   13.04.2009      258,352.36
600014   Transnav INC.                    USD   13.04.2009        4,868.86
600016   Valeo Climat Control             USD   13.04.2009      764,633.35
600018   Benteler de Mexico               USD   13.04.2009      131,070.01
600021   DELPHI ELECTRONICS & SAFETY      USD   13.04.2009      567,837.26
600024   Alcoa Fujikura de Mexico         USD   13.04.2009    1,778,791.30
600025   FTE Mexicana S.A. de C.V.        USD   13.04.2009      186,634.27
600027   Hella KG Hueck Co.               USD   13.04.2009      140,174.60
600028   HUF North America Automotive     USD   13.04.2009      127,938.56
600037   Manufacturas GCI, S.A. de C.V.   USD   13.04.2009        3,818.76
600048   AKSYS de Mexico                  USD   13.04.2009       24,004.13
600049   Autoliv Steering Weels Mexico    USD   13.04.2009        1,433.84
600050   Autotek Industrial de Mexico     USD   13.04.2009        2,416.97
600057   ALPS AUTOMOTIVE, INC.            USD   13.04.2009       83,904.07
700000   Faurecia Duroplast Mexico        USD   13.04.2009      664,914.33
700001   Siemens VDO S.A. de C.V.         USD   13.04.2009      376,106.40
900000   SAS Automotive Systems           USD   13.04.2009      293,405.80
900013   PROVEEDOR NP-SAP                 USD   13.04.2009        6,981.52
                                          USD   13.04.2009    5,747,203.77

600001   Panasonic INC                    USD   20.04.2009       62,317.80
600006   Linde Pullmann de Queretaro      USD   20.04.2009       36,823.67
600008   Lunkomex SA                      USD   20.04.2009       38,120.35
600013   Thyssen Krupp Presta de Mexico   USD   20.04.2009      110,271.14
600014   Transnav S. A. de C.V.           USD   20.04.2009        2,083.36
600016   Valeo Climat Control             USD   20.04.2009      321,821.79
600018   Benteler de Mexico               USD   20.04.2009       55,470.70
600021   DELPHI ELECTRONICS & SAFETY      USD   20.04.2009      220,888.32
600024   Alcoa Fujikura de Mexico         USD   20.04.2009      727,024.58
600025   FTE Mexicana S.A. de C.V.        USD   20.04.2009       79,075.23
600027   Hella KG Hueck Co.               USD   20.04.2009       59,622.95
600028   HUF North America Automotive     USD   20.04.2009       54,810.02
600037   Manufacturas GCI, S.A. de C.V.   USD   20.04.2009        1,616.16
600048   AKSYS de Mexico                  USD   20.04.2009       10,052.02
600050   Autotek Industrial de Mexico     USD   20.04.2009        1,022.89
600057   ALPS AUTOMOTIVE, INC.            USD   20.04.2009       39,723.50
700000   Faurecia Duroplast Mexico        USD   20.04.2009      283,363.58
700001   Siemens VDO S.A. de C.V.         USD   20.04.2009       78,369.56
900000   SAS Automotive Systems           USD   20.04.2009      124,795.46
900013   PROVEEDOR NP-SAP                 USD   20.04.2009        3,388.84
                                          USD   20.04.2009    2,310,661.92

                                          USD                20,283,876.85
USD   20283876.85
VAT              TOTAL

  22,797.41     174,780.12
  13,557.27     103,939.09
  12,272.63      94,090.14
  40,275.65     308,779.97
     758.00       5,811.33
  58,108.51     445,498.56
  20,542.59     157,493.20
  78,279.38     600,141.94
 320,663.75   2,458,422.11
  29,264.70     224,362.70
  21,718.68     166,509.89
  19,563.94     149,990.22
     598.51       4,588.59
   3,828.87      29,354.67
  43,810.55     335,880.91
     378.81       2,904.22
  14,751.69     113,096.27
 103,344.46     792,307.52
  60,682.79     465,234.69
  45,666.76     350,111.84
 -15,926.90    -122,106.24
 937,972.21   6,861,191.75

  23,666.07     181,440.06
  13,494.32     103,456.51
  13,152.67     100,837.16
  39,135.00     300,034.94
     736.92       5,649.60
 117,786.09     903,026.42
  19,923.82     152,749.23
  83,886.30     643,128.27
 269,895.26   2,069,193.28
  28,465.44     218,235.04
  21,193.03     162,479.89
  19,426.76     148,938.34
     580.48       4,450.40
   3,643.40      27,932.68
  23,219.22     178,013.94
     367.40       2,816.73
  12,730.00      97,596.69
 100,722.96      772208.83
  57,801.38     443,143.94
  44,509.05     341,235.95
     997.54        7,647.82
 895,333.11   6,864,215.72

  23,501.14     180,175.42
  13,317.44     102,100.47
  12,669.04      97,129.11
  38,752.86     297,105.22
     730.35       5,599.21
 114,695.03     879,328.38
  19,660.49     150,730.50
  85,175.60     653,012.86
 266,819.39   2,045,610.69
  27,995.14     214,629.41
  21,026.19     161,200.79
  19,190.83     147,129.39
     572.84       4,391.60
   3,600.62      27,604.75
     215.08       1,648.92
     362.54       2,779.51
  12,585.59      96,489.66
  99,737.22     764,651.55
  56,415.96     432,522.36
  44,010.88     337,416.68
   1,047.23       8,028.75
 862,081.46   6,609,285.23

   9,347.68       71,665.48
   5,523.57       42,347.24
   5,718.05       43,838.40
  16,540.67     126,811.81
     312.51        2,395.87
  48,273.28     370,095.07
   8,320.60       63,791.30
  33,133.24     254,021.56
 109,054.02     836,078.60
  11,861.28       90,936.51
   8,943.46       68,566.41
   8,221.52       63,031.54
     242.42        1,858.58
   1,507.80       11,559.82
     153.43        1,176.32
   5,958.52       45,682.02
  42,504.54     325,868.12
  11,755.41       90,124.97
  18,719.32      143514.78
     508.33        3,897.17
 346,599.65   2,657,261.57

3,042,584.35 23,326,461.20
3042584.35   23326461.2
   Plan payments



                                                Payment estimated date   Amount          Beneficiary
   230,000 usd Flights Alps Kostal                     31.03.09           $230,000.00

   70,000 usd Flights Novem                            20.04.09            $70,000.00

   1,053,000 usd Alcoa (PC7)                           06.04.09          $1,053,000.00     Supplier

   400,000 usd No94     (PC7)                          06.04.09           $400,000.00      Supplier

   12,000 usd PVS flights                              20.04.09            $12,000.00

   6,000,000 Alcoa Retroactives To release by          20.04.09          $6,000,000.00     Supplier

                                                                         $7,765,000.00




94b1bd2b-35ee-450c-a1ea-66c19b469876.xls                                                               16 / 38
                        CUENTAS PENDIENTES DE PAGO AL 24 DE MARZO
   Mon.             NOTA       Vencimiento              Proveedor             Total
USD             PAGO 31 MZO 06   1/14/2006 AKSYS de Mexico             -       984.40
                                  3/4/2006 Hella KG Hueck Co.          -     5,099.40
                                  3/5/2006 Hella KG Hueck Co.          -     5,340.60
                                 3/12/2006 Hella KG Hueck Co.          -   124,721.17
                                 3/18/2006 Hella KG Hueck Co.          -   117,400.21
                                 3/21/2006 Benteler de Mexico          -    20,219.62
                                 3/24/2006 Benteler de Mexico          -    30,329.44
                                           FTE Mexicana S.A. de C.V.   -    16,284.35
                                           Lunkomex SA                 -    21,920.27
                                           Thyssen Krupp Presta        -   138,407.36
Total general                                                          -   480,706.82
                         CUENTAS PENDIENTES DE PAGO AL 24 DE MARZO
   Mon.             NOTA       Vencimiento                 Proveedor
EUR             PAGO 31 MZO 06     3/24/2006 A Raymond Loerrach
                                             AB Elektronik Sachsen GmbH
                                             Agrati GmbH
                                             Alcan Automotive
                                             Behr Hella Thermocontrol GmbH
                                             Conti Temic Microelectronic Gm
                                             Eduard Hartmann GmbH Co.KG
                                             Electromecanica Portuguesa Pre
                                             ETM
                                             Fontana GmbH
                                             FTE Automotive GmbH & Co. KG
                                             Gustav Rudolph
                                             Hella Fahrzeugkomponenten GmbH
                                             Hella KG Hueck Co.
                                             Hellerman Tyton, GmbH
                                             Kamax-Werke
                                             KKP Rapid GmbH
                                             Knipping Espanola SA
                                             Kostal
                                             KWD Automotive Group GmbH & Co
                                             Nedschroef Altena GmbH
                                             Northern
                                             Novem Car Interior Design GmbH
                                             Panel Fijaciones S. Coop.
                                             Peiker Acustic Gmbh & Co.
                                             Polytec Thermoplast
                                             Robert Bosch GmbH
                                             Sarnatech Paulmann Cronne GmbH
                                             SAS Autosystemetchnik Gmbh
                                             Scherer & Trier GmbH & Co.
                                             Seeber Systemetechnik
                                             Siemens VDO Automotive
                                             Siemens VDO S.A. de C.V.
                                             Stanztech Treuenbrietzen Blech
                                             STEEB Plastique
                                             TRW Automotive Safety Systems
                                             TRW Fahrzeugelektrik Gmbh & Co
                                             Witte-Velbert GmbH & Co KG
Total general
RZO
            Total
      -     8,780.90
      -    21,775.70
      -    13,442.10
      -    77,482.78
      - 433,597.71
      - 223,017.00
      -     8,340.00
      -    14,246.40
      -     5,843.25
      -    11,586.85
      -       681.64
      -        65.87
      -    21,085.67
      - 173,386.41
      -       572.56
      -     2,225.48
      -       918.00
      -     2,712.00
      -    77,994.83
      -    82,669.95
      -     5,355.00
      -     2,508.26
      -    59,195.37
      -     7,953.00
      -     5,839.20
      -     1,306.26
      - 1,484,628.54
      -    23,800.62
      -        29.23
      -    15,783.70
      -     1,844.50
      -    12,173.12
              748.42
      -    79,443.17
      -     3,609.00
      -       966.00
      -    13,789.44
      -    27,494.16
      - 2,925,395.25
Mexico
SAP Code
 ICL2004164MX   GmbH   Automotive Mexico    600,000.00 USD
 ICL2004165MX   GmbH   Automotive Mexico    250,000.00 USD
  ICL200514MX   GmbH   Automotive Mexico    850,000.00 USD
  ICL200524MX   GmbH   Automotive Mexico    500,000.00 USD
  ICL200537MX   GmbH   Automotive Mexico    500,000.00 USD
  ICL200542MX   GmbH   Automotive Mexico    500,000.00 USD
  ICL200541MX   GmbH   Automotive Mexico    500,000.00 USD
  ICL200544MX   GmbH   Automotive Mexico    850,000.00 USD
  ICL200548MX   GmbH   Automotive Mexico   1,200,000.00 USD
  ICL200564MX   GmbH   Automotive Mexico    500,000.00 USD
  ICL200565MX   GmbH   Automotive Mexico   1,850,000.00 USD
  ICL200584MX   GmbH   Automotive Mexico   1,000,000.00 USD
  ICL200585MX   GmbH   Automotive Mexico   1,350,000.00 USD
  ICL200586MX   GmbH   Automotive Mexico   3,500,000.00 USD
  ICL200592MX   GmbH   Automotive Mexico   1,200,000.00 USD
  ICL200593MX   GmbH   Automotive Mexico   3,500,000.00 USD
  ICL200599MX   GmbH   Automotive Mexico   1,000,000.00 USD
 ICL2005109MX   GmbH   Automotive Mexico   7,050,000.00 USD
 ICL2005110MX   GmbH   Automotive Mexico   9,600,000.00 USD
 ICL2005111MX   GmbH   Automotive Mexico     35,395.61 USD
                       Total               9,635,395.61 USD
12/2/2009   2/25/2009    -280    3.000%     -14,000.00 USD
12/2/2009   2/25/2009    -280    3.000%      -5,833.33 USD
12/2/2009   2/25/2009    -280    3.000%     -19,833.33 USD
12/2/2009   2/25/2009    -280    3.000%     -11,666.67 USD
12/2/2009   2/25/2009    -280    3.000%     -11,666.67 USD
12/2/2009   2/25/2009    -280    3.250%     -12,638.89 USD
12/2/2009   2/25/2009    -280    3.250%     -12,638.89 USD
12/2/2009   2/25/2009    -280    3.250%     -21,486.11 USD
12/2/2009   2/25/2009    -280    3.250%     -30,333.33 USD
12/2/2009   2/25/2009    -280    3.750%     -14,583.33 USD
12/2/2009   2/25/2009    -280    3.750%     -53,958.33 USD
12/2/2009   2/25/2009    -280    5.000%     -38,888.89 USD
12/2/2009   2/25/2009    -280    5.000%     -52,500.00 USD
12/2/2009   2/25/2009    -280    5.000%    -136,111.11 USD
12/2/2009   2/25/2009    -280    3.750%     -35,000.00 USD
12/2/2009   2/25/2009    -280    5.000%    -136,111.11 USD
12/2/2009   2/25/2009    -280    5.000%     -38,888.89 USD
12/2/2009   2/25/2009    -280    5.000%    -274,166.67 USD
12/2/2009   6/30/2006   -1,251   5.000%   ###############
12/2/2009   3/30/2006   -1,343   5.000%      -6,602.26 USD
Bank Debit Local Banks
Automotive



                                       Date       USD                                Fechas de Pago del Principal
ACREEDORES BANCARIOS                                         6/30/2009     10/25/2009 12/31/2009     6/30/2009      12/31/2009   6/30/2009

             BANCOMER   SA   DE   CV          1,000,000.00   200,000.00                  200,000.00   200,000.00    200,000.00   200,000.00
             BANCOMER   SA   DE   CV          1,000,000.00   200,000.00                  200,000.00   200,000.00    200,000.00   200,000.00
             BANCOMER   SA   DE   CV            700,000.00   140,000.00                  140,000.00   140,000.00    140,000.00   140,000.00
             BANCOMER   SA   DE   CV            800,000.00   160,000.00                  160,000.00   160,000.00    160,000.00   160,000.00
             BANCOMER   SA   DE   CV          3,500,000.00                3,500,000.00

                                                             700,000.00   3,500,000.00   700,000.00   700,000.00    700,000.00   700,000.00
Other Debits
Automotive                                                       Pagados (Alredy Paid)
INTEGRACIÓN DE PRESTAMOS BANCARIOS                               Estimados (Estimated - to be


                              Date     USD                                                 P
ACREEDORES BANCARIOS
                                                    30/12/2009       30/06/2010
    BANCOMER   SA   DE   CV          1,000,000.00   19,910.72
    BANCOMER   SA   DE   CV            800,000.00                    32,942.37
    BANCOMER   SA   DE   CV            600,000.00
    BANCOMER   SA   DE   CV            400,000.00
    BANCOMER   SA   DE   CV            200,000.00
    BANCOMER   SA   DE   CV                   -



                                                    19,910.72       32,942.37




                              Date     USD                                                 P
ACREEDORES BANCARIOS
                                                    30/12/2009       30/06/2010
    BANCOMER   SA   DE   CV          1,000,000.00   20,313.20
    BANCOMER   SA   DE   CV            800,000.00                    24,164.20
    BANCOMER   SA   DE   CV            600,000.00
    BANCOMER   SA   DE   CV            400,000.00
    BANCOMER   SA   DE   CV            200,000.00
    BANCOMER   SA   DE   CV                   -



                                                    20,313.20       24,164.20



                              Date     USD                                                 P
ACREEDORES BANCARIOS
                                                    30/12/2009       30/06/2010
    BANCOMER   SA   DE   CV           700,000.00    14,850.88
    BANCOMER   SA   DE   CV           560,000.00                     14,420.76
    BANCOMER   SA   DE   CV           420,000.00
    BANCOMER   SA   DE   CV           280,000.00
    BANCOMER   SA   DE   CV           140,000.00
    BANCOMER   SA   DE   CV                  -
                                                    14,850.88     14,420.76




                              Date     USD                                     P
ACREEDORES BANCARIOS
                                                    30/12/2009    30/06/2010
    BANCOMER   SA   DE   CV           800,000.00    15,646.44
    BANCOMER   SA   DE   CV           640,000.00                   8,384.00
    BANCOMER   SA   DE   CV           480,000.00
    BANCOMER   SA   DE   CV           320,000.00
    BANCOMER   SA   DE   CV           160,000.00
    BANCOMER   SA   DE   CV                  -



                                                    15,646.44      8,384.00




                              Date     USD               Payment date
ACREEDORES BANCARIOS
                                                    25/04/2009    22/10/2009
    BANCOMER SA DE CV                3,500,000.00   70,246.94     74,375.00
    BANCOMER SA DE CV                         -



                                                    70,246.94     74,375.00
dos (Alredy Paid)
 ados (Estimated - to be paid)


                       Payment date

                 30/12/2010      30/06/2011   30/12/2011   30/06/2012



                 17,000.00
                                 12,750.00
                                               8,500.00
                                                            4,250.00



                17,000.00        12,750.00    8,500.00     4,250.00




                       Payment date

                 30/12/2010      30/06/2011   30/12/2011   30/06/2012



                 17,000.00
                                 12,750.00
                                               8,500.00
                                                            4,250.00



                17,000.00        12,750.00    8,500.00     4,250.00



                       Payment date

                 30/12/2010      30/06/2011   30/12/2011   30/06/2012



                 11,900.00
                                  8,925.00
                                               5,950.00
                                                            2,975.00
11,900.00      8,925.00    5,950.00     2,975.00




     Payment date

30/12/2010    30/06/2011   30/12/2011   30/06/2012



13,600.00
              10,200.00
                            6,800.00
                                         3,400.00



13,600.00     10,200.00    6,800.00     3,400.00
95,353.09




86,977.40
 59,021.64




 58,030.44




144,621.94



444,004.51


  5,536.33
x rates

Used exchange rates at the 11.05.2010




             EUR               13.1144

             USD               10.8914

             JPY                0.0927
                     Balance Marzo 2010   Balance Marzo 2010



Bancomer 88964 USD                                        726,856.94
Bancomer 8891 MXN - INVERSION                          40,341,376.68
Bancomer 4062 MXN                                         189,656.05
Bankof America EUR                                         76,891.13
Bankof America USD                                        279,449.41
Non register payments



                        230,000.00
Budgetbook Ver. 1
Automotive Mexico
Plan XI 2010                                                                                                                                 Plan XI 05:             PLAN VII 05 for 2006:       Costs Assy / veh (Plan XI 05)   Costs Assy / veh (Plan VII 05)
                             Rem. projecttime (in years)       5.00       credit        2.0%          EUR        14.00                 k MXP:            5,885      k MXP:           18,150          Vol:           232,000.0       Vol:              264,000.0
                                      Income tax (local)     35.0%         debit        3.0%          USD        11.00                 k EUR:             420       k EUR:           1,210         k MXP:          -101,833.8     k MXP:             -107,554.4
                                                                                                                                                                                                  MXP/veh:           -438.94     MXP/veh:              -407.4
                                                                                                                                                                                                  USD/veh:            -39.90     USD/veh:               -37.0

                                                            B/F                                                                                                                                                                                    PLAN XI 05      PLAN VII 05
Line no.                                                   2005       Jan-06       Feb-06       Mar-06       Apr-06       May-06       Jun-06           Jul-06      Aug-06          Sep-06        Oct-06            Nov-06       Dec-06              2006             2006
                         Price/part for assembly/JIS
1                        A5 Jetta                                        293.26       293.26       293.26       293.26       293.26       293.26           293.26      293.26           293.26         293.26           293.26       293.26               293.26         326.0
2                        A5 Bora
3                           c
4                           d
5                           e
                    Consumption / part industr. costs                                                                                                                                                                                                                     -26.4
6                                            A5 Jetta
7                                            A5 Bora
8                                                   c
9                                                   d
10                                                  e

                           Price/part for prelogistics
11                                            A5 Jetta                   408.98       408.98       408.98       408.98       408.98       408.98           408.98      408.98           408.98         408.98           408.98       408.98               408.98         338.3
12                                            A5 Bora
13                                                   c
14                                                   d
15                                                   e
                       Consumption / part prelogistic                   -237.94      -237.94      -237.94      -237.94      -237.94      -237.94          -237.94     -237.94          -237.94        -237.94          -237.94       -237.94             -237.94         -188.1
16                                            A5 Jetta
17                                            A5 Bora
18                                                   c
19                                                   d
20                                                   e

                            Price / part for material
21                                           A5 Jetta                 18,005.02    18,005.02    18,005.02    18,005.02    18,005.02    18,005.02        18,005.02   18,005.02       18,005.02      18,005.02         18,005.02    18,005.02            18,005.02       19,953.6
22                                           A5 Bora
23                                                  c
24                                                  d
25                                                  e
                      Consumption / part for material                 -18,005.02   -18,005.02   -18,005.02   -18,005.02   -18,005.02   -18,005.02      -18,005.02   -18,005.02      -18,005.02    -18,005.02        -18,005.02   -18,005.02           -18,005.02      -19,953.6
26                                           A5 Jetta
27                                           A5 Bora
28                                                  c
29                                                  d
30                                                  e

                    Price/part for Systems integration
31                                             A5 Jetta
32                                             A5 Bora
33                                                    c
34                                                    d
35                                Faurecia Development
                            Consumption SI (Material)
36                                             A5 Jetta
37                                             A5 Bora
38                                                    c
39                                                    d
40                                                    e
                    Consumption Systems integration
41                                             A5 Jetta
42                                             A5 Bora
43                                                    c
44                                                    d
45                                                    e

                                         Cars per day
46                                            A5 Jetta
47                                            A5 Bora
48                                                   c
49                                                   d
50                                                   e
51                                    Sum cars per day
Budgetbook Ver. 1
Automotive Mexico
Plan XI 2010                                                                                                                                    Plan XI 05:              PLAN VII 05 for 2006:       Costs Assy / veh (Plan XI 05)    Costs Assy / veh (Plan VII 05)
                            Rem. projecttime (in years)           5.00       credit        2.0%          EUR        14.00                 k MXP:            5,885       k MXP:           18,150          Vol:           232,000.0        Vol:              264,000.0
                                     Income tax (local)         35.0%         debit        3.0%          USD        11.00                 k EUR:             420        k EUR:           1,210         k MXP:          -101,833.8      k MXP:             -107,554.4
                                                                                                                                                                                                      MXP/veh:           -438.94      MXP/veh:              -407.4
                                                                                                                                                                                                      USD/veh:            -39.90      USD/veh:               -37.0

                                                              B/F                                                                                                                                                                                       PLAN XI 05      PLAN VII 05
Line no.                                                     2005        Jan-06       Feb-06       Mar-06       Apr-06       May-06       Jun-06           Jul-06       Aug-06          Sep-06        Oct-06            Nov-06        Dec-06              2006             2006
52                                      Working days            253.00        22.0         21.0         23.0         20.0         22.0         22.0              21.0        23.0            19.0          22.0              22.0          16.0               253.0           250.0
53                                     Number of cars       192,033.00      20,174       19,257       21,091       18,340       20,174       20,174            19,257      21,091          17,423        20,174            20,174        14,672           232,000.0       264,000.0
                                                                                                                                                                                                                                                            232,000
54                                          A5 Jetta                        5,916.2      5,647.3      6,185.1      5,378.4      5,916.2      5,916.2          5,647.3      6,185.1         5,109.4        5,916.2          5,916.2        4,302.7          68,036.3        60,954.8
55                                          A5 Bora                                                                                                                                                                                                                        25,099.0
56                                                 c
57                                                 d
58                                                 e
59                              Sales assembly/JIS           57,763.58      5,916.2      5,647.3      6,185.1      5,378.4      5,916.2      5,916.2          5,647.3      6,185.1         5,109.4        5,916.2          5,916.2        4,302.7            68,036.3      86,053.8
60                         Consumpt. Industr. costs          -2,655.61       -300.0       -300.0       -300.0       -300.0       -300.0       -300.0           -300.0       -300.0          -300.0         -300.0           -300.0         -300.0            -3,600.0      -4,462.0
61                        Consumpt. JIS / ass. other         -3,045.05       -168.3       -168.3       -168.3       -168.3       -168.3       -168.3           -168.3       -168.3          -168.3         -168.3           -168.3         -168.3            -2,020.0      -2,508.0
62                       Gross Margin assembly/JIS            52,062.9      5,447.9      5,179.0      5,716.8      4,910.0      5,447.9      5,447.9          5,179.0      5,716.8         4,641.1        5,447.9          5,447.9        3,834.4            62,416.3      79,084.1

63                          Direct labour assembly/JIS       -9,113.39       -859.5       -859.5       -859.5       -859.5       -897.0       -897.0           -897.0       -897.0          -897.0         -897.0           -897.0         -897.0           -10,614.3      -9,659.1
64                        Indirect labour assembly/JIS       -8,060.07       -763.3       -763.3       -763.3       -763.3       -797.2       -797.2           -797.2       -797.2          -797.2         -797.2           -797.2         -797.2            -9,430.5      -7,302.5
65                         Direct Energy assembly/JIS        -1,009.88        -86.4        -86.4        -86.4        -86.4        -86.4        -86.4            -86.4        -86.4           -86.4          -86.4            -86.4          -86.4            -1,036.4      -1,250.0
66                   Direct Depreciation assembly/JIS        -7,828.84       -815.1       -815.1       -815.1       -815.1       -815.1       -815.1           -815.1       -815.1          -815.1         -815.1           -815.1         -815.1            -9,781.6      -8,737.1
67                   Contribution before fixed costs          26,050.7      2,923.6      2,654.6      3,192.5      2,385.7      2,852.2      2,852.2          2,583.3      3,121.1         2,045.4        2,852.2          2,852.2        1,238.7            31,553.6      52,135.4

68                                          A5 Jetta                        8,250.7      7,875.7      8,625.8      7,500.7      8,250.7      8,250.7          7,875.7      8,625.8         7,125.6        8,250.7          8,250.7        6,000.5            94,883.4      63,260.2
69                                          A5 Bora                                                                                                                                                                                                                        26,048.3
70                                                 c
71                                                 d
72                                                 e
73                                Sales prelogistics         68,204.52      8,250.7      7,875.7      8,625.8      7,500.7      8,250.7      8,250.7          7,875.7      8,625.8         7,125.6        8,250.7          8,250.7        6,000.5            94,883.4       89,308.5
74                         Consumption prelogistics         -57,059.59     -4,800.1     -4,581.9     -5,018.3     -4,363.7     -4,800.1     -4,800.1         -4,581.9     -5,018.3        -4,145.5       -4,800.1         -4,800.1       -3,491.0           -55,201.2      -49,658.4
75                         Gross Margin prelogistics          11,144.9      3,450.6      3,293.8      3,607.5      3,136.9      3,450.6      3,450.6          3,293.8      3,607.5         2,980.1        3,450.6          3,450.6        2,509.5            39,682.2       39,650.1

76                             Direct labour prelogistic
77                          Indirect labour prelogistics
78                           Direct Energy prelogistics
79                     Direct Depreciation prelogistics
80                   Contribution before fixed costs          11,144.9      3,450.6      3,293.8      3,607.5      3,136.9      3,450.6      3,450.6          3,293.8      3,607.5         2,980.1        3,450.6          3,450.6        2,509.5            39,682.2      39,650.1

81                                            A5 Jetta                   363,231.7    346,721.2    379,742.2    330,210.6    363,231.7    363,231.7        346,721.2    379,742.2       313,700.1      363,231.7         363,231.7     264,168.5          4,177,164.6    3,731,329.8
82                                            A5 Bora                                                                                                                                                                                                                    1,536,429.9
83                                                    c
84                                                    d
85                                                    e
86                                     Sales material 3,332,309.97        363,231.7    346,721.2    379,742.2    330,210.6    363,231.7    363,231.7       346,721.2     379,742.2       313,700.1     363,231.7         363,231.7     264,168.5          4,177,164.6    5,267,759.7
87                               Material consumption -3,337,405.92      -363,231.7   -346,721.2   -379,742.2   -330,210.6   -363,231.7   -363,231.7      -346,721.2    -379,742.2      -313,700.1    -363,231.7        -363,231.7    -264,168.5         -4,177,164.6   -5,267,759.7
88                             Loss of material (scrap)                       -80.0        -80.0        -80.0        -80.0        -80.0        -80.0           -80.0         -80.0           -80.0         -80.0             -80.0         -80.0               -960.0       -5,267.8
89                             Consumption material -3,337,405.9         -363,311.7   -346,801.2   -379,822.2   -330,290.6   -363,311.7   -363,311.7      -346,801.2    -379,822.2      -313,780.1    -363,311.7        -363,311.7    -264,248.5         -4,178,124.6   -5,273,027.5
90                             Gross margin material       -5,096.0           -80.0        -80.0        -80.0        -80.0        -80.0        -80.0           -80.0         -80.0           -80.0         -80.0             -80.0         -80.0               -960.0       -5,267.8

91                   Contribution before fixed costs          -5,096.0        -80.0        -80.0        -80.0        -80.0        -80.0        -80.0            -80.0        -80.0           -80.0          -80.0             -80.0         -80.0              -960.0       -5,267.8

92                                              A5 Jetta
93                                              A5 Bora
94                                                     c
95                                                     d
96
97                       Sales systems integration
98            Material Cons. (Pre-Series/Prototype)
99               Consumption systems integration
100              Gross Margin systems integration

101         Direct/Indirect labour (pre-series/prototype)
102                   Direct Energy systems integration
103             Direct Depreciation systems integration
104                   Contribution before fixed costs

105                                     Sales others         32,876.35
106                              Consumption others         -17,134.15
107                              Gross Margin others          15,742.2

108                               Direct labour Others
109                              Indirect labour others
109                               Direct Energy others
110                         Direct Depreciation others
111                  Contribution before fixed costs          15,742.2

112                          Sales inside Co.-group
113                   Consumption inside Co.-group
114                   Gross Margin inside Co.-group
Budgetbook Ver. 1
Automotive Mexico
Plan XI 2010                                                                                                                                              Plan XI 05:              PLAN VII 05 for 2006:       Costs Assy / veh (Plan XI 05)    Costs Assy / veh (Plan VII 05)
                               Rem. projecttime (in years)             5.00        credit        2.0%           EUR          14.00                  k MXP:            5,885       k MXP:           18,150          Vol:           232,000.0        Vol:              264,000.0
                                        Income tax (local)           35.0%          debit        3.0%           USD          11.00                  k EUR:             420        k EUR:           1,210         k MXP:          -101,833.8      k MXP:             -107,554.4
                                                                                                                                                                                                                MXP/veh:           -438.94      MXP/veh:              -407.4
                                                                                                                                                                                                                USD/veh:            -39.90      USD/veh:               -37.0

                                                                   B/F                                                                                                                                                                                            PLAN XI 05      PLAN VII 05
Line no.                                                          2005        Jan-06        Feb-06        Mar-06        Apr-06        May-06        Jun-06           Jul-06       Aug-06          Sep-06        Oct-06            Nov-06        Dec-06              2006             2006



115                                            Total sales     3,491,154.42    377,398.6     360,244.2     394,553.1     343,089.7     377,398.6     377,398.6       360,244.2     394,553.1      325,935.2      377,398.6         377,398.6     274,471.7          4,340,084.3    5,443,122.1
116                                  Total consumption -3,419,344.92           -368,580.1    -351,851.4    -385,308.9    -335,122.7    -368,580.1    -368,580.1      -351,851.4    -385,308.9     -318,394.0     -368,580.1       -368,580.1     -268,207.8        -4,238,945.8    -5,329,655.6
117                         Thereof material consumption -3,337,405.92        -363,231.7    -346,721.2    -379,742.2    -330,210.6    -363,231.7    -363,231.7      -346,721.2    -379,742.2     -313,700.1     -363,231.7       -363,231.7     -264,168.5        -4,177,164.6    -5,267,759.7
118                                   Total Gross Margin          71,809.5       8,818.5       8,392.7       9,244.3       7,967.0       8,818.5       8,818.5          8,392.7      9,244.3         7,541.2        8,818.5          8,818.5        6,263.9           101,138.5      113,466.5


119                                   Total Direct labour         -9,113.39       -859.5        -859.5        -859.5        -859.5        -897.0        -897.0           -897.0       -897.0          -897.0         -897.0            -897.0        -897.0           -10,614.3       -9,659.1
120                                  Total Indirect labour        -8,060.07       -763.3        -763.3        -763.3        -763.3        -797.2        -797.2           -797.2       -797.2          -797.2         -797.2            -797.2        -797.2            -9,430.5       -7,302.5
121                                   Total Direct Energy         -1,009.88        -86.4         -86.4         -86.4         -86.4         -86.4         -86.4            -86.4        -86.4           -86.4          -86.4             -86.4         -86.4            -1,036.4       -1,250.0
122                             Total Direct Depreciation         -7,828.84       -815.1        -815.1        -815.1        -815.1        -815.1        -815.1           -815.1       -815.1         -815.13         -815.1            -815.1        -815.1            -9,781.6       -8,737.1
123                Total Contribution before fixed costs          45,797.3       6,294.2       5,868.4       6,720.0       5,442.7       6,222.8       6,222.8          5,797.0      6,648.6         4,945.5        6,222.8          6,222.8        3,668.2            70,275.7       86,517.7

124                                          added value          73,287.9       8,818.5       8,392.7       9,244.3       7,967.0       8,818.5       8,818.5         8,392.7       9,244.3         7,541.2       8,818.5           8,818.5       6,263.9           101,138.5      113,466.5


125                                           Salary-costs       -22,510.59     -1,969.9      -2,212.6      -1,876.1      -1,876.1      -1,954.1      -1,954.1         -1,954.1     -2,290.6        -1,954.1       -1,954.1         -1,954.1       -1,954.1           -23,904.4      -27,070.0
126                           Leased personnel resources            -923.67       -155.9        -155.9        -155.9        -155.9        -155.9        -155.9           -155.9       -155.9          -155.9         -155.9            -155.9        -155.9            -1,870.2
127                          Indirect Depreciation Goodwill
128                                 Other personnel costs         -5,413.76       -290.7        -290.7        -710.3        -330.7        -305.7        -305.7           -310.7       -305.7          -290.7         -295.7            -300.7        -535.7            -4,273.2       -4,840.0
129                                           Maintenance         -2,440.10       -269.4        -214.4        -234.3        -253.9        -214.4        -214.4           -257.4       -214.4          -214.4         -253.9            -217.8        -214.4            -2,773.1       -1,320.0
130                                                   Rent        -6,892.79       -595.4        -595.4        -595.4        -595.4        -595.4        -595.4           -595.4       -595.4          -595.4         -595.4            -595.4        -595.4            -7,144.5       -7,380.0
131                                                Leasing        -4,162.42       -306.1        -396.1        -306.1        -306.1        -306.1        -306.1           -306.1       -306.1          -306.1         -306.1            -306.1        -306.1            -3,762.8       -4,200.0
132                       Telephone-/Communicationcosts           -2,822.56       -121.7        -121.7        -121.7        -123.7        -121.7        -121.7           -121.7       -121.7          -121.7         -121.7            -121.7        -121.7            -1,462.7       -2,160.0
133                                    Travelling expenses        -1,859.24        -89.8         -89.8         -89.8         -89.8         -89.8         -89.8            -89.8        -89.8           -89.8          -89.8             -89.8         -89.8            -1,078.0       -1,254.0
134                                     External audit fees         -406.57        -40.8         -40.8         -40.8         -40.8         -40.8         -40.8            -40.8        -40.8           -40.8          -40.8             -40.8         -40.8              -490.0         -500.0
135                                External consulting fees       -1,120.49        -89.5         -85.5         -85.5         -85.5         -85.5        -155.5            -89.5        -85.5           -85.5          -85.5            -120.5         -85.5            -1,139.3       -2,040.0
136                                      External services        -4,131.32       -305.2        -245.6        -278.6        -272.2        -278.6        -245.6           -305.2       -245.6          -278.6         -272.2            -278.6        -245.6            -3,251.4       -3,960.0
137                              Other operationel income
138                                Other operationel costs        -4,646.03       -325.5        -173.0        -173.0        -173.0        -173.0        -173.0           -173.0       -322.3          -173.0         -173.0            -173.0        -173.0            -2,377.9       -3,000.0
139                                             Taxes / toll        -860.13        -15.0         -15.0         -15.0         -15.0         -15.0         -15.0            -15.0        -15.0           -15.0          -15.0             -15.0         -15.0              -180.0         -100.0
140                                   Insurance expenses          -5,257.75        -40.0                                                   -21.6        -148.3           -100.0                                                         -79.7                            -389.6         -995.0
                                         Interest expenses                        -424.3        -338.4        -335.6        -332.5        -332.5        -332.5           -328.6       -324.7          -322.0         -318.9            -296.2        -118.0            -3,804.4       -4,659.5
141                                      Interest earnings           227.62                                                                                                                                                                                                            2,063.9
142                                  Exchange differences         -2,500.00
143              Sub-Total I Fixed-Costs before Distrib.          -65,719.8     -5,039.3      -4,974.9      -5,018.2      -4,650.7      -4,690.2      -4,853.8         -4,843.3     -5,113.5        -4,643.0       -4,678.1         -4,745.3       -4,651.0           -57,901.3      -61,414.6
144                    Distributed income inside Co.-group          119.96       3,641.0       3,886.2       3,970.1       3,546.3       3,697.2       3,697.2          3,697.2      4,037.0         3,697.2        3,697.2          3,697.2        3,697.2            44,960.9
145                     Distributed costs inside Co.-group        -4,535.86     -3,761.9      -4,007.0      -4,090.9      -3,667.1      -3,818.0      -3,818.0         -3,818.0     -4,157.9        -3,818.0       -3,818.0         -3,818.0       -3,818.0           -46,410.7       -1,553.3
146                    Distrib. SI income inside Co.-group
147                   Distributed SI costs inside Co.-group
148                  Reallocated income inside legal entity
149                   Reallocated costs inside legal entity
150               Sub-Total II Fixed-Costs after Distrib.         -70,135.7     -5,160.2      -5,095.7      -5,139.0      -4,771.5      -4,811.0      -4,974.6         -4,964.1     -5,234.4        -4,763.8       -4,798.9         -4,866.1       -4,771.8           -59,351.1      -62,967.9
151                                Increase of SI-Inventory
152                          Increase of Start-up-Inventory         1,478.4
153                                  Management Result            -22,859.9      1,134.0         772.7       1,580.9         671.1       1,411.8       1,248.2            833.0      1,414.2           181.7        1,423.9          1,356.6       -1,103.6            10,924.7       23,549.8


154          Variation exchange-rate-differences-provision
155                               Exceptional depreciation
156                                      Exceptional costs         -2,106.1
157                                    Exceptional income
158                                           Subventions
159                                      Gestion expenses          -3,973.3       -420.0        -420.0        -420.0        -420.0        -420.0        -420.0           -420.0       -420.0          -420.0         -420.0            -420.0        -420.0            -5,040.0       -5,400.0
160        Distributed expenses for indust-costs inside Co.        -3,742.9
161              Increase of ind-costs-stocks non operativ           422.3
162                           Reallocated exp. / inc. of HQ
163                    Net accounting Result before tax           -32,259.9        714.0         352.7       1,160.9         251.1         991.8         828.2            413.0        994.2          -238.3        1,003.9            936.6       -1,523.6             5,884.7       18,149.8


164                                          tax on income
165                  theoretical net acc. Result after tax        -32,259.9        714.0         352.7       1,160.9         251.1         991.8         828.2            413.0        994.2          -238.3        1,003.9            936.6       -1,523.6             5,884.7       18,149.8


166                                                 EBIT          -26,774.5        754.0         352.7       1,160.9         251.1       1,013.5         976.5            513.0        994.2          -238.3        1,003.9          1,016.3       -1,523.6             6,274.2       20,745.5
167                                            EBITDA             -18,022.0      1,725.0       1,323.7       2,131.9       1,222.1       1,984.4       1,947.4          1,483.9      1,965.2           732.7        1,974.9          1,987.3         -552.6            17,926.0       29,482.6
Budgetbook Ver. 1
Automotive Mexico
Plan XI 2010                                                                                                                                 Plan XI 05:                 PLAN VII 05 for 2006:       Costs Assy / veh (Plan XI 05)    Costs Assy / veh (Plan VII 05)
                             Rem. projecttime (in years)           5.00       credit       2.0%         EUR        14.00               k MXP:            5,885          k MXP:           18,150          Vol:           232,000.0        Vol:              264,000.0
                                      Income tax (local)         35.0%         debit       3.0%         USD        11.00               k EUR:             420           k EUR:           1,210         k MXP:          -101,833.8      k MXP:             -107,554.4
                                                                                                                                                                                                      MXP/veh:           -438.94      MXP/veh:              -407.4
                                                                                                                                                                                                      USD/veh:            -39.90      USD/veh:               -37.0

                                                               B/F                                                                                                                                                                                      PLAN XI 05      PLAN VII 05
Line no.                                                      2005        Jan-06       Feb-06      Mar-06      Apr-06      May-06      Jun-06           Jul-06          Aug-06          Sep-06        Oct-06            Nov-06        Dec-06              2006             2006

                                           Investments
168                      New investments Assembly/JIS          15,311.9     1,246.3                                                                                                                                                                           1,246.3        4,000.0
169                 Low value investments Assembly/JIS            125.0        50.0         50.0        50.0        50.0        50.0         50.0                50.0         50.0            50.0           50.0              50.0          50.0               600.0
170                         New investments Prelogistic
171                    Low value investments Prelogistic
172                                 New investments SI
173                            Low value investments SI
174                              New investments Other
175                        Low value investments Other
176                       New investments Headquarter
177                  Low value investments Headquarter
178                                   Total investments        15,436.9     1,296.3         50.0        50.0        50.0        50.0         50.0                50.0         50.0            50.0           50.0              50.0          50.0             1,846.3

                                              Inventories
179                           Inventories of raw material     79,479.30    82,552.7     82,552.7    82,552.7    82,552.7    82,552.7    82,552.7         82,552.7        82,552.7         82,552.7       82,552.7         82,552.7      82,552.7                            84,284.2
180                                  Stock range in days           3.00         5.0          5.0         5.0         5.0         5.0         5.0              5.0             5.0              5.0            5.0              5.0           5.0
181                   Inventories of capitalized SI-Costs
182             Inventories of capitalized start up-costs     24,903.11    24,603.1     24,303.1    24,003.1    23,703.1    23,403.1    23,103.1         22,803.1        22,503.1        22,203.1       21,903.1          21,603.1      21,303.1                            19,534.9
183          Total inventories of capitalized order-costs    104,387.41   107,155.8    106,855.8   106,555.8   106,255.8   105,955.8   105,655.8        105,355.8       105,055.8       104,755.8      104,455.8         104,155.8     103,855.8            210,643.2

                              Headcount by function
184                  Gross direct worker assembly/JIS                                                                                                                                                                                                                         170.0
185                     Gross direct worker Prelogistic
186                         Gross direct worker Other
187              Full yearly costs per direct employee

188               Gross indirect worker assembly/JIS                                                                                                                                                                                                                           82.0
189                  Gross indirect worker prelogistics
190                      Gross indirect worker others
191             Full yearl costs per indirect employee

192                         Structure staff (Fixed Costs)                                                                                                                                                                                                                      34.0
193                                   Structure staff (SI)
194                  Full yearly costs per salary earner

195                                            Manager                                                                                                                                                                                                                           1.0
196                      Full yearly costs per manager

197                                  Non active staff
198                                     staff on loan
199                       Sum employees by function

                              Employees by contract
200                               Permanent contract            312.00
201                               Fixed term contract
202                               Temporary contract
203                       Sum employees by contract             312.00


217                                          Receivables     413,173.84   437,782.4    417,883.2   457,681.6   397,984.0   437,782.4   437,782.4        417,883.2       457,681.6       378,084.8      437,782.4         437,782.4     318,387.2            318,387.2     782,448.8
                                               Factoring
218                                            Payables      473,623.87   522,644.7    495,255.7   545,685.2   475,747.1   522,587.2   522,215.2        499,004.1       545,897.3       452,032.6      522,686.6         522,361.1     382,068.8            382,068.8     784,896.2

                                                 Cash
219             Cash Flow before interest single month         8,388.12       4,158        3,671       4,477       3,564       4,398        4,361            3,893          4,370            3,135          4,374            4,364          1,646               1,646       33,932.3
220                       Cashbalance before interest         -6,142.41      43,230       -3,869      15,058      -6,727      11,389        3,939              531         11,415          -11,183         15,281            3,989        -19,301             -19,301        6,751.4
221                      Cash account before interest
222                Cash account after interest and tax       -59,874.27     -76,558      -80,427     -65,369     -72,096     -60,728     -56,938          -56,506         -45,091          -56,274        -40,993          -37,084        -56,385             -56,385       49,575.3
,427     -65,369     -72,096     -60,728     -56,938          -56,506         -45,091          -56,274        -40,993          -37,084        -56,385             -56,385       49,575.3
Budgetbook Ver. 1
Automotive Mexico
Plan XI 2010                                                                                                                                                     Plan XI 05:                PLAN VII 05 for 2006:          Costs Assy / veh (Plan XI 05)     Costs Assy / veh (Plan VII 05)
                                     Rem. projecttime (in years)         5.00        credit         2.0%            EUR           14.00                    k MXP:            5,885         k MXP:           18,150             Vol:           232,000.0         Vol:              264,000.0
                                              Income tax (local)       35.0%          debit         3.0%            USD           11.00                    k EUR:             420          k EUR:           1,210            k MXP:          -101,833.8       k MXP:             -107,554.4
                                                                                                                                                                                                                            MXP/veh:           -438.94       MXP/veh:              -407.4
                                                                                                                                                                                                                            USD/veh:            -39.90       USD/veh:               -37.0

                                                                     B/F                                                                                                                                                                                                       PLAN XI 05       PLAN VII 05
Line no.                                                            2005         Jan-06         Feb-06         Mar-06         Apr-06         May-06        Jun-06           Jul-06         Aug-06          Sep-06           Oct-06            Nov-06         Dec-06              2006              2006

Balance sheet

       ASSETS

       Intangeable and tangeable assets
223    Goodwill (gross)
224    Depriciation on Goodwill
                                                                       47,229       47,710          46,945         46,180         45,415         44,650        43,884           43,119         42,354           41,589            40,824           40,059          39,294              39,294
225    Gross                                                        56,083.37       57,380          57,430         57,480         57,530         57,580        57,630           57,680         57,730           57,780            57,830           57,880          57,930              57,930
226    Depreciation                                                 -8,854.40       -9,670         -10,485        -11,300        -12,115        -12,930       -13,745          -14,560        -15,375          -16,191           -17,006          -17,821         -18,636             -18,636
                                                                       47,229       47,710          46,945         46,180         45,415         44,650        43,884           43,119         42,354           41,589            40,824           40,059          39,294              39,294
       Financial assets

227    Shares in group companies                                           50              50             50             50             50            50             50               50             50               50              50                50             50
228    Shares in associated companies
                                                                           50              50             50             50             50            50             50               50             50               50              50                50             50

       Current assets

       Inventory

229    Material on stock (net)                                      79,479.30       82,553         82,553         82,553         82,553         82,553         82,553           82,553         82,553           82,553           82,553            82,553         82,553               82,553
230    SI inventories (net)
231    Start-up inventories (net)                                   24,903.11       24,603         24,303         24,003         23,703         23,403         23,103           22,803         22,503          22,203            21,903            21,603         21,303               21,303
                                                                      104,382      107,156        106,856        106,556        106,256        105,956        105,656          105,356        105,056         104,756           104,456           104,156        103,856              103,856

       Receivables and other assets

       Receivables third party                                        413,174      437,782        417,883        457,682        397,984        437,782        437,782          417,883        457,682         378,085           437,782           437,782        318,387              318,387
232    Gross                                                       413,173.84      437,782        417,883        457,682        397,984        437,782        437,782          417,883        457,682         378,085           437,782           437,782        318,387              318,387
233    Fatoring Selling of AR
234    Receivables inside Co.-group                                  6,870.28        6,686          7,138          7,266          6,384          6,649          6,612            6,576          7,215           6,499             6,462             6,426          6,389
235    Other assets                                                 91,496.00       96,132         90,090        102,977         94,083        103,211         97,063           95,259        104,443          91,032           104,087           105,794         76,768               76,768
                                                                      511,540      540,600        515,111        567,925        498,450        547,643        541,457          519,718        569,340         475,616           548,332           550,002        401,545              395,155

236    Cash and cash equivalents

                                                                      663,202      695,516        668,962        720,711        650,171        698,298        691,048          668,243        716,800         622,011           693,662           694,267        544,744              538,305



       LIABILITIES



       Equity

237    Share capital                                                  100.00              100            100            100            100         100              100              100            100              100             100               100            100                 100

238    Additional paid in capital                                    7,559.56        7,560          7,560          7,560          7,560          7,560          7,560            7,560          7,560            7,560             7,560            7,560          7,560                7,560

       Retained earnings/reserve

239    Legal reserve (out of net result)

240    Balance brought forward                                     -32,104.25       -64,733        -64,733        -64,733        -64,733        -64,733       -64,733          -64,733        -64,733          -64,733           -64,733          -64,733         -64,733             -64,733

241    Net result of the year                                      -32,628.59             714       1,067          2,228          2,479          3,471          4,299            4,712          5,706            5,468             6,472            7,408          5,885                5,885


                                                                       -57,073      -56,359        -56,007        -54,846        -54,594        -53,603       -52,774          -52,361        -51,367          -51,606           -50,602          -49,665         -51,189             -51,189

       Provisions

242    Provision for project risk
243    Provision for warranty risk
244    Other provision                                                                     30             60             90            120         150              180              210            240              270             300               330            360
                                                                                           30             60             90            120         150              180              210            240              270             300               330            360

       Other Liabilities

245    Loan from banks/financial institutions                       25,227.90       23,100         23,100         23,100         23,100         23,100         15,400           15,400         15,400          15,400            15,400            15,400          7,700                7,700
246    Loan from Co.                                               112,097.78      111,988        112,194        112,239        111,780        111,894        111,858          111,821        112,121         111,745           111,708           111,671        111,635               56,385
247    Payables third party due to deliveries and services         488,761.88      522,645        495,256        545,685        475,747        522,587        522,215          499,004        545,897         452,033           522,687           522,361        382,069              382,069
248    Payables inside Co.-group                                     3,715.11        3,641          3,886          3,970          3,546          3,697          3,697            3,697          4,037           3,697             3,697             3,697          3,697                3,697
249    Other liabilities                                            90,000.00       90,000         90,000         90,000         90,000         90,000         90,000           90,000         90,000          90,000            90,000            90,000         90,000
                                                                      719,803      751,373        724,436        774,994        704,173        751,279        743,170          719,922        767,455         672,874           743,492           743,130        595,101              449,851

                                                                      662,729      695,044        668,490        720,239        649,699        697,826        690,576          667,771        716,328         621,539           693,190           693,795        544,272              398,663

				
DOCUMENT INFO
Description: This Cash Report sets forth a template worksheet to help a company record cash received during a given day. This worksheet is designed for businesses that deal primarily with cash, check, and credit card transactions, for example restaurants, retail, hospitality, etc. This template spreadsheet should be used to determine how much cash a cashier received throughout the day. Company managers should sign this form when cashing out each register at the end of the employee's shift or the end of the work day.
This document is also part of a package Cash Management for Your Business 6 Documents Included